diff options
| author | unknown <bar@mysql.com> | 2007-04-09 17:58:56 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2007-04-09 17:58:56 +0500 |
| commit | 8e2b68c3cdf44b899b71829b90f4cb1a3fec53bd (patch) | |
| tree | 31816e79a42b952d779c0c0b31704e23a4947170 /mysql-test/t/variables.test | |
| parent | 0c6731fdfa2438d20a027099b1038d0bea12a010 (diff) | |
| download | mariadb-git-8e2b68c3cdf44b899b71829b90f4cb1a3fec53bd.tar.gz | |
Bug#22648 LC_TIME_NAMES: Setting GLOBAL has no effect
Problem: setting/displaying @@LC_TIME_NAMES didn't distinguish between
GLOBAL and SESSION variable types - always SESSION variable
was set/shonw.
Fix: set either global or session value.
Also, "mysqld --lc-time-names" was added to set "global default" value.
mysql-test/r/variables.result:
Adding test cases
mysql-test/t/variables.test:
Adding test cases
sql/mysql_priv.h:
Declaring variable for global default.
sql/mysqld.cc:
Adding --lc-time-names
sql/set_var.cc:
Distinguish between GLOBAL and SESSION variables.
sql/sql_class.cc:
Don't initialize to en_US, use global_system_variables value instead.
Diffstat (limited to 'mysql-test/t/variables.test')
| -rw-r--r-- | mysql-test/t/variables.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index 697e55945ef..0ad85a32568 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -505,6 +505,30 @@ set lc_time_names=0; select @@lc_time_names; # +# Bug #22648 LC_TIME_NAMES: Setting GLOBAL has no effect +# +select @@global.lc_time_names, @@lc_time_names; +set @@global.lc_time_names=fr_FR; +select @@global.lc_time_names, @@lc_time_names; +--echo New connection +connect (con1,localhost,root,,); +connection con1; +select @@global.lc_time_names, @@lc_time_names; +set @@lc_time_names=ru_RU; +select @@global.lc_time_names, @@lc_time_names; +disconnect con1; +connection default; +--echo Returnung to default connection +select @@global.lc_time_names, @@lc_time_names; +set lc_time_names=default; +select @@global.lc_time_names, @@lc_time_names; +set @@global.lc_time_names=default; +select @@global.lc_time_names, @@lc_time_names; +set @@lc_time_names=default; +select @@global.lc_time_names, @@lc_time_names; + + +# # Bug #13334: query_prealloc_size default less than minimum # set @test = @@query_prealloc_size; |