Bug #2928 --sql-mode not being set correctly

• Submitted: 23 Feb 2004 10:50
• Modified: 23 Feb 2004 12:54
• Reporter: Paul DuBois
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.19
• Assigned to: Dean Ellis
• CPU Architecture: Any

[23 Feb 2004 10:50] Paul DuBois

Description:
--sql-mode=ansi does not work correctly.
The resulting variable value is:

mysql> show variables like 'sql_mode';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode      | 4     |
+---------------+-------+

4 is the numeric equivalent of MODE_ANSI_QUOTES.

I suspect what is happening is that some prefix
matching is being done that matches "ansi" to
"ANSI_QUOTES".

How to repeat:
See above.

[23 Feb 2004 12:54] Dean Ellis

The "ansi" shortcut was added in 4.1.1.