diff options
| author | unknown <jimw@mysql.com> | 2006-04-20 20:41:12 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2006-04-20 20:41:12 -0700 |
| commit | a4b042c1e6aa2dfe9a1be2e4181e7de19a34ce52 (patch) | |
| tree | 1596bd30e34ea3e71fb21ff24027ed99e375e850 /mysql-test/r/variables.result | |
| parent | d8df724af26fc3cd1d6aa5567173402102cf8493 (diff) | |
| download | mariadb-git-a4b042c1e6aa2dfe9a1be2e4181e7de19a34ce52.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.
mysql-test/r/variables.result:
Add new results
mysql-test/t/variables.test:
Add new regression test
sql/set_var.cc:
Fix display of sql_notes and sql_warnings in SHOW VARIABLES.
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 |