Bug #36800 SQL_MODE IGNORE_SPACE functionality changed in 5.1
Submitted: 19 May 2008 14:07 Modified: 19 May 2008 15:00
Reporter: Tobias Asplund Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.22 OS:Any
Assigned to: CPU Architecture:Any

[19 May 2008 14:07] Tobias Asplund 
Description:
5.0:
mysql> SELECT version ();
ERROR 1046 (3D000): No database selected

5.1:
mysql> select version ();
+---------------+
| version ()    |
+---------------+
| 5.1.22-rc-log | 
+---------------+
1 row in set (0.00 sec)

regardless of SQL_MODE setting of IGNORE_SPACE.

How to repeat:
See above :)
[19 May 2008 14:08] Paul DuBois 
See http://dev.mysql.com/doc/refman/5.1/en/function-resolution.html
[19 May 2008 14:10] Paul DuBois 
See also Bug#21114
[19 May 2008 15:00] Valeriy Kravchuk 
According to http://dev.mysql.com/doc/refman/5.1/en/function-resolution.html this is NOT a bug, but intended and documented change in behaviour.