Re: mysql 4.0.15-log limit syntax bug

Hello Attila,

Tuesday, September 30, 2003, 6:49:52 AM, you wrote:

AS> i  found  a  strange  bug  in mysql 4.0.15-log, the server accepts
AS> queries  with bad syntax. see example. i think for limit1 (without
AS> space) should come some error message. or?
It's not a bug actually, see below.

AS> how to repeat:
mysql>> use mysql
AS> Database changed
mysql>> select Host from user limit1;
This query is interpreted as follows:
select
 `Host`
from
 `user` as `limit1`

i.e. `limit1` now is alias to `user` table.
since `limit1` is not a reserved word in SQL, query won't fail.

-- 
To  receive my PGP public key send letter with subject "Get PGP public
key" to [email protected].
  
  WBR, D.S. AKA Weirdan                         mailto:[email protected]


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]