diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/sql_mode_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/sql_mode_basic.result | 453 |
1 files changed, 453 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/sql_mode_basic.result b/mysql-test/suite/sys_vars/r/sql_mode_basic.result new file mode 100644 index 00000000000..78a9f179824 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/sql_mode_basic.result @@ -0,0 +1,453 @@ +SET @global_start_value = @@global.sql_mode; +SELECT @global_start_value; +@global_start_value + +SET @session_start_value = @@session.sql_mode; +SELECT @session_start_value; +@session_start_value + +'#--------------------FN_DYNVARS_152_01------------------------#' +SET @@global.sql_mode = ANSI; +SET @@global.sql_mode = DEFAULT; +SELECT @@global.sql_mode; +@@global.sql_mode + +SET @@session.sql_mode = ANSI; +SET @@session.sql_mode = DEFAULT; +SELECT @@session.sql_mode; +@@session.sql_mode + +'Bug# 34876: Default values for both session and global sql_mode is ""'; +'and not OFF.'; +'#---------------------FN_DYNVARS_152_02-------------------------#' +SET @@global.sql_mode = NULL; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NULL' +SET @@global.sql_mode = ''; +SELECT @@global.sql_mode; +@@global.sql_mode + +SET @@global.sql_mode = ' '; +SELECT @@global.sql_mode; +@@global.sql_mode + +SET @@session.sql_mode = NULL; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NULL' +SET @@session.sql_mode = ''; +SELECT @@session.sql_mode; +@@session.sql_mode + +SET @@session.sql_mode = ' '; +SELECT @@session.sql_mode; +@@session.sql_mode + +'#--------------------FN_DYNVARS_152_03------------------------#' +'Bug: Incomplete sql modes valid values at:'; +'http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html'; +SET @@global.sql_mode = ANSI; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI +SET @@global.sql_mode = STRICT_TRANS_TABLES; +SELECT @@global.sql_mode; +@@global.sql_mode +STRICT_TRANS_TABLES +SET @@global.sql_mode = TRADITIONAL; +SELECT @@global.sql_mode; +@@global.sql_mode +STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER +SET @@global.sql_mode = ALLOW_INVALID_DATES; +SELECT @@global.sql_mode; +@@global.sql_mode +ALLOW_INVALID_DATES +SET @@global.sql_mode = ANSI_QUOTES; +SELECT @@global.sql_mode; +@@global.sql_mode +ANSI_QUOTES +SET @@global.sql_mode = ERROR_FOR_DIVISION_BY_ZERO; +SELECT @@global.sql_mode; +@@global.sql_mode +ERROR_FOR_DIVISION_BY_ZERO +SET @@global.sql_mode = HIGH_NOT_PRECEDENCE; +SELECT @@global.sql_mode; +@@global.sql_mode +HIGH_NOT_PRECEDENCE +SET @@global.sql_mode = IGNORE_SPACE; +SELECT @@global.sql_mode; +@@global.sql_mode +IGNORE_SPACE +SET @@global.sql_mode = NO_AUTO_CREATE_USER; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_AUTO_CREATE_USER +SET @@global.sql_mode = NO_AUTO_VALUE_ON_ZERO; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_AUTO_VALUE_ON_ZERO +SET @@global.sql_mode = NO_BACKSLASH_ESCAPES; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_BACKSLASH_ESCAPES +SET @@global.sql_mode = NO_DIR_IN_CREATE; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_DIR_IN_CREATE +SET @@global.sql_mode = NO_ENGINE_SUBSTITUTION; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_ENGINE_SUBSTITUTION +SET @@global.sql_mode = NO_FIELD_OPTIONS; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_FIELD_OPTIONS +SET @@global.sql_mode = NO_KEY_OPTIONS; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_KEY_OPTIONS +SET @@global.sql_mode = NO_TABLE_OPTIONS; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_TABLE_OPTIONS +SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_UNSIGNED_SUBTRACTION +SET @@global.sql_mode = NO_ZERO_DATE; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_ZERO_DATE +SET @@global.sql_mode = NO_ZERO_IN_DATE; +SELECT @@global.sql_mode; +@@global.sql_mode +NO_ZERO_IN_DATE +SET @@global.sql_mode = ONLY_FULL_GROUP_BY; +SELECT @@global.sql_mode; +@@global.sql_mode +ONLY_FULL_GROUP_BY +SET @@global.sql_mode = PIPES_AS_CONCAT; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT +SET @@global.sql_mode = REAL_AS_FLOAT; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT +SET @@global.sql_mode = STRICT_ALL_TABLES; +SELECT @@global.sql_mode; +@@global.sql_mode +STRICT_ALL_TABLES +SET @@global.sql_mode = STRICT_TRANS_TABLES; +SELECT @@global.sql_mode; +@@global.sql_mode +STRICT_TRANS_TABLES +SET @@global.sql_mode = DB2; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,DB2,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS +SET @@global.sql_mode = MAXDB; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER +SET @@global.sql_mode = MSSQL; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS +SET @@global.sql_mode = MYSQL323; +SELECT @@global.sql_mode; +@@global.sql_mode +MYSQL323,HIGH_NOT_PRECEDENCE +SET @@global.sql_mode = MYSQL40; +SELECT @@global.sql_mode; +@@global.sql_mode +MYSQL40,HIGH_NOT_PRECEDENCE +SET @@global.sql_mode = ORACLE; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER +SET @@global.sql_mode = POSTGRESQL; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS +SET @@global.sql_mode = TRADITIONAL; +SELECT @@global.sql_mode; +@@global.sql_mode +STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER +SET @@global.sql_mode = OFF; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OFF' +'Bug: OFF is documented as an sql mode but infact it is not'; +SET @@session.sql_mode = ANSI; +SELECT @@session.sql_mode; +@@session.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI +SET @@session.sql_mode = STRICT_TRANS_TABLES; +SELECT @@session.sql_mode; +@@session.sql_mode +STRICT_TRANS_TABLES +SET @@session.sql_mode = TRADITIONAL; +SELECT @@session.sql_mode; +@@session.sql_mode +STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER +SET @@session.sql_mode = ALLOW_INVALID_DATES; +SELECT @@session.sql_mode; +@@session.sql_mode +ALLOW_INVALID_DATES +SET @@session.sql_mode = ANSI_QUOTES; +SELECT @@session.sql_mode; +@@session.sql_mode +ANSI_QUOTES +SET @@session.sql_mode = ERROR_FOR_DIVISION_BY_ZERO; +SELECT @@session.sql_mode; +@@session.sql_mode +ERROR_FOR_DIVISION_BY_ZERO +SET @@session.sql_mode = HIGH_NOT_PRECEDENCE; +SELECT @@session.sql_mode; +@@session.sql_mode +HIGH_NOT_PRECEDENCE +SET @@session.sql_mode = IGNORE_SPACE; +SELECT @@session.sql_mode; +@@session.sql_mode +IGNORE_SPACE +SET @@session.sql_mode = NO_AUTO_CREATE_USER; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_AUTO_CREATE_USER +SET @@session.sql_mode = NO_AUTO_VALUE_ON_ZERO; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_AUTO_VALUE_ON_ZERO +SET @@session.sql_mode = NO_BACKSLASH_ESCAPES; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_BACKSLASH_ESCAPES +SET @@session.sql_mode = NO_DIR_IN_CREATE; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_DIR_IN_CREATE +SET @@session.sql_mode = NO_ENGINE_SUBSTITUTION; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_ENGINE_SUBSTITUTION +SET @@session.sql_mode = NO_FIELD_OPTIONS; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_FIELD_OPTIONS +SET @@session.sql_mode = NO_KEY_OPTIONS; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_KEY_OPTIONS +SET @@session.sql_mode = NO_TABLE_OPTIONS; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_TABLE_OPTIONS +SET @@session.sql_mode = NO_UNSIGNED_SUBTRACTION; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_UNSIGNED_SUBTRACTION +SET @@session.sql_mode = NO_ZERO_DATE; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_ZERO_DATE +SET @@session.sql_mode = NO_ZERO_IN_DATE; +SELECT @@session.sql_mode; +@@session.sql_mode +NO_ZERO_IN_DATE +SET @@session.sql_mode = ONLY_FULL_GROUP_BY; +SELECT @@session.sql_mode; +@@session.sql_mode +ONLY_FULL_GROUP_BY +SET @@session.sql_mode = PIPES_AS_CONCAT; +SELECT @@session.sql_mode; +@@session.sql_mode +PIPES_AS_CONCAT +SET @@session.sql_mode = REAL_AS_FLOAT; +SELECT @@session.sql_mode; +@@session.sql_mode +REAL_AS_FLOAT +SET @@session.sql_mode = STRICT_ALL_TABLES; +SELECT @@session.sql_mode; +@@session.sql_mode +STRICT_ALL_TABLES +SET @@session.sql_mode = STRICT_TRANS_TABLES; +SELECT @@session.sql_mode; +@@session.sql_mode +STRICT_TRANS_TABLES +SET @@session.sql_mode = DB2; +SELECT @@session.sql_mode; +@@session.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,DB2,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS +SET @@session.sql_mode = MAXDB; +SELECT @@session.sql_mode; +@@session.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER +SET @@session.sql_mode = MSSQL; +SELECT @@session.sql_mode; +@@session.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS +SET @@session.sql_mode = MYSQL323; +SELECT @@session.sql_mode; +@@session.sql_mode +MYSQL323,HIGH_NOT_PRECEDENCE +SET @@session.sql_mode = MYSQL40; +SELECT @@session.sql_mode; +@@session.sql_mode +MYSQL40,HIGH_NOT_PRECEDENCE +SET @@session.sql_mode = ORACLE; +SELECT @@session.sql_mode; +@@session.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER +SET @@session.sql_mode = POSTGRESQL; +SELECT @@session.sql_mode; +@@session.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS +SET @@session.sql_mode = TRADITIONAL; +SELECT @@session.sql_mode; +@@session.sql_mode +STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER +SET @@session.sql_mode = OFF; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OFF' +SET @@global.sql_mode = '?'; +SELECT @@global.sql_mode; +@@global.sql_mode +? +SET @@session.sql_mode = '?'; +SELECT @@session.sql_mode; +@@session.sql_mode +? +'Bug# 34834: ? is acceptable as a valid sql mode.' +'#--------------------FN_DYNVARS_152_04-------------------------#' +SET @@global.sql_mode = -1; +ERROR 42000: Variable 'sql_mode' can't be set to the value of '-1' +SET @@global.sql_mode = ASCII; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ASCII' +SET @@global.sql_mode = NON_TRADITIONAL; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NON_TRADITIONAL' +SET @@global.sql_mode = 'OF'; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OF' +SET @@global.sql_mode = NONE; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NONE' +SET @@session.sql_mode = -1; +ERROR 42000: Variable 'sql_mode' can't be set to the value of '-1' +SET @@session.sql_mode = ANSI_SINGLE_QUOTES; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ANSI_SINGLE_QUOTES' +SET @@session.sql_mode = 'ON'; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'ON' +SET @@session.sql_mode = 'OF'; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'OF' +SET @@session.sql_mode = DISABLE; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'DISABLE' +'#-------------------FN_DYNVARS_152_05----------------------------#' +SELECT @@session.sql_mode = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='sql_mode'; +@@session.sql_mode = VARIABLE_VALUE +1 +'#----------------------FN_DYNVARS_152_06------------------------#' +SELECT @@global.sql_mode = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='sql_mode'; +@@global.sql_mode = VARIABLE_VALUE +1 +'#---------------------FN_DYNVARS_152_07-------------------------#' +SET @@global.sql_mode = 0; +SELECT @@global.sql_mode; +@@global.sql_mode + +SET @@global.sql_mode = 1; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT +SET @@global.sql_mode = 2; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT +SET @@global.sql_mode = 3; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT +SET @@global.sql_mode = 50000; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,?,NO_UNSIGNED_SUBTRACTION,POSTGRESQL,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER +SET @@global.sql_mode = 500000; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,POSTGRESQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,HIGH_NOT_PRECEDENCE +SET @@global.sql_mode = 4294967295; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,?,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH +SET @@global.sql_mode = 4294967296; +ERROR 42000: Variable 'sql_mode' can't be set to the value of '4294967296' +SET @@global.sql_mode = 0.4; +SELECT @@global.sql_mode; +@@global.sql_mode + +SET @@global.sql_mode = 1.0; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT +SET @@global.sql_mode = 40000.1; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_UNSIGNED_SUBTRACTION,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER +SET @@global.sql_mode = 1.5; +SELECT @@global.sql_mode; +@@global.sql_mode +PIPES_AS_CONCAT +SET @@global.sql_mode = 124567.49; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,?,NO_DIR_IN_CREATE,ORACLE,MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE +SET @@session.sql_mode = 50000000.5; +SELECT @@session.sql_mode; +@@session.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_DIR_IN_CREATE,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL40,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ALLOW_INVALID_DATES,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE +SET @@session.sql_mode = 4294967295.4; +SELECT @@session.sql_mode; +@@session.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,?,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH +'Bug: Decimal values can be used within the range [0.0-4294967295.5).'; +'Values are rounded to numeric values as evident from outcome.'; +'#---------------------FN_DYNVARS_152_08----------------------#' +SET @@global.sql_mode = TRUE; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT +SET @@global.sql_mode = FALSE; +SELECT @@global.sql_mode; +@@global.sql_mode + +'#---------------------FN_DYNVARS_152_09----------------------#' +SET sql_mode = 'ANSI'; +SET session.sql_mode = 'ANSI'; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql_mode = 'ANSI'' at line 1 +SET global.sql_mode = 'ANSI'; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql_mode = 'ANSI'' at line 1 +SET session sql_mode = 1; +SELECT @@sql_mode; +@@sql_mode +REAL_AS_FLOAT +SET global sql_mode = 0; +SELECT @@global.sql_mode; +@@global.sql_mode + +'#---------------------FN_DYNVARS_152_10----------------------#' +SET @@session.sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES,ANSI_QUOTES'; +SELECT @@session.sql_mode; +@@session.sql_mode +ANSI_QUOTES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER +SET @@global.sql_mode = 'ONLY_FULL_GROUP_BY,PIPES_AS_CONCAT,REAL_AS_FLOAT,ORACLE,POSTGRESQL'; +SELECT @@global.sql_mode; +@@global.sql_mode +REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,POSTGRESQL,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER +SET @@session.sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,HIGH_OR_PRECEDENCE, +IGNORE_SPACE'; +ERROR 42000: Variable 'sql_mode' can't be set to the value of ' +IGNORE_SPACE' +SET @@global.sql_mode = @global_start_value; +SELECT @@global.sql_mode; +@@global.sql_mode + +SET @@session.sql_mode = @session_start_value; +SELECT @@session.sql_mode; +@@session.sql_mode + |