Bug #15525 | Misleading error when selecting non-existant keyword | ||
---|---|---|---|
Submitted: | 6 Dec 2005 16:05 | Modified: | 21 Dec 2005 9:32 |
Reporter: | Kolbe Kegel | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Errors | Severity: | S4 (Feature request) |
Version: | 5.0.x, 5.1.3 | OS: | Linux (Linux) |
Assigned to: | CPU Architecture: | Any |
[6 Dec 2005 16:05]
Kolbe Kegel
[20 Dec 2005 15:41]
Aleksey Kishkin
I dont think it's a feature request but rather bugreport.
[21 Dec 2005 9:32]
Valeriy Kravchuk
Thank you for a problem report. Verified just as described: mysql> select now; ERROR 1054 (42S22): Unknown column 'now' in 'field list' mysql> select current_date; +--------------+ | current_date | +--------------+ | 2005-12-21 | +--------------+ 1 row in set (0.03 sec) mysql> select something; ERROR 1054 (42S22): Unknown column 'something' in 'field list' This error message is misleading. But may be 'field' is just a name for any element in a list after SELECT statement? Why not? So, I think, it is really a feature request to distinguish these SELECTs without FROM and give some other error message in such cases.