summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/variables.result
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-07-01 18:15:00 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-07-01 18:15:00 +0000
commita2a2e32c02643a0cec111511220227703fda1cd5 (patch)
tree69cc2b631234c2a8e026b9cd4d72676c61c594df /mysql-test/main/variables.result
parentReleasing progress-linux version 1:10.11.8-1~progress7.99u1. (diff)
downloadmariadb-a2a2e32c02643a0cec111511220227703fda1cd5.tar.xz
mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.zip
Merging upstream version 1:11.4.2.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/main/variables.result')
-rw-r--r--mysql-test/main/variables.result22
1 files changed, 16 insertions, 6 deletions
diff --git a/mysql-test/main/variables.result b/mysql-test/main/variables.result
index 9b54a24b..2230e5a3 100644
--- a/mysql-test/main/variables.result
+++ b/mysql-test/main/variables.result
@@ -548,7 +548,7 @@ set default_storage_engine=myisam;
set global thread_cache_size=100;
set timestamp=1, timestamp=default;
set tmp_table_size=1024;
-set tx_isolation="READ-COMMITTED";
+set transaction_isolation="READ-COMMITTED";
set wait_timeout=100;
set log_warnings=1;
set global log_warnings=1;
@@ -777,16 +777,16 @@ select @@lc_time_names;
@@lc_time_names
en_US
LC_TIME_NAMES: testing locale with the last ID:
-set lc_time_names=111;
+set lc_time_names=112;
select @@lc_time_names;
@@lc_time_names
-ka_GE
+sw_KE
LC_TIME_NAMES: testing a number beyond the valid ID range:
-set lc_time_names=112;
-ERROR HY000: Unknown locale: '112'
+set lc_time_names=113;
+ERROR HY000: Unknown locale: '113'
select @@lc_time_names;
@@lc_time_names
-ka_GE
+sw_KE
LC_TIME_NAMES: testing that 0 is en_US:
set lc_time_names=0;
select @@lc_time_names;
@@ -892,6 +892,8 @@ VARIABLE_NAME VARIABLE_VALUE
SQL_BIG_SELECTS ON
set @@sql_big_selects = @old_sql_big_selects;
set @@sql_notes = 0, @@sql_warnings = 0;
+Warnings:
+Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
show variables like 'sql_notes';
Variable_name Value
sql_notes OFF
@@ -905,6 +907,8 @@ select * from information_schema.session_variables where variable_name like 'sql
VARIABLE_NAME VARIABLE_VALUE
SQL_WARNINGS OFF
set @@sql_notes = 1, @@sql_warnings = 1;
+Warnings:
+Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
show variables like 'sql_notes';
Variable_name Value
sql_notes ON
@@ -1561,6 +1565,8 @@ End of 5.1 tests
SET @sql_notes_saved = @@sql_notes;
SET @@sql_notes = ON;
+Warnings:
+Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
SELECT @@sql_notes;
@@sql_notes
1
@@ -1572,11 +1578,15 @@ SELECT @@sql_notes;
1
SET @@sql_notes = OFF;
+Warnings:
+Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
SELECT @@sql_notes;
@@sql_notes
0
SET @@sql_notes = @sql_notes_saved;
+Warnings:
+Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
# Checking delay_key_write...
SET @delay_key_write_saved = @@delay_key_write;