mysql 4.0.15-log limit syntax bug

Attila Soki <[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?

how to repeat:
mysql> use mysql
Database changed
mysql> select Host from user limit1;
+-----------+
| Host      |
+-----------+
| %         |
| test      |
| localhost |
| localhost |
+-----------+
4 rows in set (0.00 sec)

mysql> select Host from user limit 1; 
+------+
| Host |
+------+
| %    |
+------+
1 row in set (0.00 sec)  

-- 
best regards
Attila Soki                          mailto:[email protected]


-- 
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.