| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Fahad <Fahad(dot)Gilani(at)anusf(dot)anu(dot)edu(dot)au> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present |
| Date: | 2005-01-14 09:20:15 |
| Message-ID: | 20050114092015.GC97871@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Jan 12, 2005 at 11:08:55PM +0000, Fahad wrote:
> PostgreSQL version: 8.0.0rc2
8.0.0rc5 is the latest -- it would be best to test with that to get
the most recent bug fixes.
> In an empty table, if I do this:
>
> "SELECT some_field WHERE some_field = 45 ORDER BY time";
ERROR: column "some_field" does not exist
This isn't a valid query.
> This returns instantly with no results. However, doing the following takes
> forever to return:
>
> "SELECT some_field WHERE some_field = 45 ORDER BY time LIMIT 1";
This isn't a valid query either. Please post an actual test case --
the exact series of steps we can take to reproduce the problem.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-01-14 14:03:14 | Re: Bug Report |
| Previous Message | Michael Fuhr | 2005-01-14 09:12:36 | Re: BUG #1392: could not select filter an entry from copied data table |