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/t/variables.test | |
| 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/t/variables.test')
| -rw-r--r-- | mysql-test/t/variables.test | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index 8d8dc7896df..79f4675d013 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -472,4 +472,15 @@ select @@character_set_filesystem; set @@global.character_set_filesystem=default; select @@global.character_set_filesystem; -# End of 5.0 tests +# +# Bug #16195: SHOW VARIABLES doesn't report correctly sql_warnings and +# sql_notes values +# +set @@sql_notes = 0, @@sql_warnings = 0; +show variables like 'sql_notes'; +show variables like 'sql_warnings'; +set @@sql_notes = 1, @@sql_warnings = 1; +show variables like 'sql_notes'; +show variables like 'sql_warnings'; + +--echo End of 5.0 tests |