diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-09-16 14:03:17 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-09-16 14:03:17 +0200 |
| commit | 7e29c1b53968914f42300a7f628088b99601f4db (patch) | |
| tree | d9b55e33bd83a02251cd8a3fe560ef149c7b21ca /mysql-test/r/variables.result | |
| parent | 1e3e81a6c9971a56c94086227aa438d133172863 (diff) | |
| parent | 33656e042dc7e983c9612a011fdef64a8dd40aa1 (diff) | |
| download | mariadb-git-7e29c1b53968914f42300a7f628088b99601f4db.tar.gz | |
5.5 merge
Diffstat (limited to 'mysql-test/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index a93e3a210ed..a42c0c5abcb 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -1793,4 +1793,13 @@ set session rand_seed1=DEFAULT; ERROR 42000: Variable 'rand_seed1' doesn't have a default value set autocommit = values(v); ERROR 42S22: Unknown column 'v' in 'field list' +set session sql_mode=ansi_quotes; +select * from information_schema.session_variables where variable_name='sql_mode'; +VARIABLE_NAME VARIABLE_VALUE +SQL_MODE ANSI_QUOTES +show global status like 'foobar'; +Variable_name Value +select * from information_schema.session_variables where variable_name='sql_mode'; +VARIABLE_NAME VARIABLE_VALUE +SQL_MODE ANSI_QUOTES End of 5.5 tests |