BUG #5193: should "select * from ab limitkkk" cause a syntax error?

From: "" <donniehan(at)126(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5193: should "select * from ab limitkkk" cause a syntax error?
Date: 2009-11-17 01:30:14
Message-ID: 200911170130.nAH1UEjZ081049@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5193
Logged by:
Email address: donniehan(at)126(dot)com
PostgreSQL version: 8.4.1
Operating system: Windows XP
Description: should "select * from ab limitkkk" cause a syntax error?
Details:

Hi guys,

The following sql statement is not illegal

But pg can run it.

postgres=# select * from a limitkkk; ---->(seems equal "limit null")
a
---
1
1
1
1
1
(5 rows)

Should pg throws a syntax error?

Regards
-Dongni

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-11-17 01:34:40 Re: BUG #5193: should "select * from ab limitkkk" cause a syntax error?
Previous Message Thomas S. Chin 2009-11-16 22:12:39 Re: BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior