Bug #7005 Common ANSI options should be the defaults
Submitted: 4 Dec 2004 10:30 Modified: 23 Dec 2004 11:57
Reporter: [ name withheld ] Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to: CPU Architecture:Any

[4 Dec 2004 10:30] [ name withheld ] 
Description:
Following the ANSI standard is important, but it's especially important for those parts of the standard which are implemented by all or nearly all other databases.
For example, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE should be the defaults. Somebody who does not want them should have to specify NON_ANSI_PIPES, NON_ANSI_QUOTES, and NON_ANSI_SPACES (or something like that).

How to repeat:
Not applicable, this is a feature request.
[4 Dec 2004 16:24] Paul DuBois 
You can start the server with the --sql-mode option to
turn on any modes that you want to be enabled by
default.
[23 Dec 2004 11:57] Hartmut Holzgraefe 
Won't happen by default due to backward compatibility issues