[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-bugs
Subject:    Re: mysql 4.0.15-log limit syntax bug
From:       Dan Si <weirdan () ukr ! net>
Date:       2003-09-30 11:05:14
[Download RAW message or body]

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 weirdan@ukr.net.
  
  WBR, D.S. AKA Weirdan                         mailto:weirdan@ukr.net


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/bugs?unsub=mysql-bugs@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]