diff options
| author | jimw@mysql.com <> | 2006-04-20 20:41:12 -0700 |
|---|---|---|
| committer | jimw@mysql.com <> | 2006-04-20 20:41:12 -0700 |
| commit | 4d392fb9f4a2cb50fb72393cb0f1512d515f05f5 (patch) | |
| tree | 1596bd30e34ea3e71fb21ff24027ed99e375e850 /mysql-test/r/variables.result | |
| parent | b57eb9e17cb9480b625f84473a80111cd3b6a649 (diff) | |
| download | mariadb-git-4d392fb9f4a2cb50fb72393cb0f1512d515f05f5.tar.gz | |
Bug #16195: SHOW VARIABLES doesn't report correctly sql_warnings and sql_notes values
SQL_WARNINGS and SQL_NOTES were being displayed with SHOW_BOOL, but they
are system variables that need SHOW_SYS to be used.
Diffstat (limited to 'mysql-test/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index 1d1c76ab3fe..b6ff60ebb34 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -584,3 +584,18 @@ set @@global.character_set_filesystem=default; select @@global.character_set_filesystem; @@global.character_set_filesystem binary +set @@sql_notes = 0, @@sql_warnings = 0; +show variables like 'sql_notes'; +Variable_name Value +sql_notes OFF +show variables like 'sql_warnings'; +Variable_name Value +sql_warnings OFF +set @@sql_notes = 1, @@sql_warnings = 1; +show variables like 'sql_notes'; +Variable_name Value +sql_notes ON +show variables like 'sql_warnings'; +Variable_name Value +sql_warnings ON +End of 5.0 tests |