Re: mysql 4.0.15-log limit syntax bug

Georg Richter <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
> hi,
>
> i found a strange bug in mysql 4.0.15-log, the server accepts queries
> with bad syntax. see example. i think for limit1 (without space)
> should come some error message. or?

Why do you think it it is a bug?

select * from yourtable limit1 is ok - limit1 is an alias for tablename

like
select limit1.* from yourtable limit1

Georg

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.