diff options
| author | unknown <monty@tik.mysql.fi> | 2002-04-18 18:24:14 +0300 |
|---|---|---|
| committer | unknown <monty@tik.mysql.fi> | 2002-04-18 18:24:14 +0300 |
| commit | a0ca35c1e59799324e95e001b77487f018d2028a (patch) | |
| tree | be9c8240e5683a7b8d88b4ebcbead064be4497df /mysql-test/t/variables.test | |
| parent | 9c2c5a3636eb730fedbbeb613ee946ef15735be0 (diff) | |
| download | mariadb-git-a0ca35c1e59799324e95e001b77487f018d2028a.tar.gz | |
SHOW VARIABLES LIKE ... are now case insensitive
Fixed stack overflow checking with crash-me with gcc 3.0.4
Using @@unknown_variable doesn't hang client anymore
Added @@VERSION variable
Docs/manual.texi:
Changelog
libmysql/libmysql.c:
Fixed typo
myisam/myisampack.c:
Removed not used argument
mysql-test/r/show_check.result:
Added test of case insensitive SHOW VARIABLES LIKE
mysql-test/r/variables.result:
test of system variables
mysql-test/t/show_check.test:
Added test of case insensitive SHOW VARIABLES LIKE
mysql-test/t/variables.test:
test of system variables
sql/item_func.cc:
Fixed stack overflow checking with crash-me with gcc 3.0.4
Using @@unknown_variable doesn't hang client anymore
Added @@VERSION variable
sql/mysql_priv.h:
Fixed stack overflow checking with crash-me with gcc 3.0.4
sql/share/czech/errmsg.txt:
Fixed wrong error message
sql/share/danish/errmsg.txt:
Fixed wrong error message
sql/share/dutch/errmsg.txt:
Fixed wrong error message
sql/share/english/errmsg.txt:
Fixed wrong error message
sql/share/estonian/errmsg.txt:
Fixed wrong error message
sql/share/french/errmsg.txt:
Fixed wrong error message
sql/share/german/errmsg.txt:
Fixed wrong error message
sql/share/greek/errmsg.txt:
Fixed wrong error message
sql/share/hungarian/errmsg.txt:
Fixed wrong error message
sql/share/italian/errmsg.txt:
Fixed wrong error message
sql/share/japanese/errmsg.txt:
Fixed wrong error message
sql/share/korean/errmsg.txt:
Fixed wrong error message
sql/share/norwegian-ny/errmsg.txt:
Fixed wrong error message
sql/share/norwegian/errmsg.txt:
Fixed wrong error message
sql/share/polish/errmsg.txt:
Fixed wrong error message
sql/share/portuguese/errmsg.txt:
Fixed wrong error message
sql/share/romanian/errmsg.txt:
Fixed wrong error message
sql/share/russian/errmsg.txt:
Fixed wrong error message
sql/share/slovak/errmsg.txt:
Fixed wrong error message
BitKeeper/deleted/.del-identity.result~e41453a364242503:
not used file
BitKeeper/deleted/.del-identity.test~326f469b59105404:
not used file
sql/share/spanish/errmsg.txt:
Fixed wrong error message
sql/share/swedish/errmsg.txt:
Fixed wrong error message
sql/share/ukrainian/errmsg.txt:
Fixed wrong error message
sql/sql_show.cc:
SHOW VARIABLES LIKE ... are now case insensitive
Diffstat (limited to 'mysql-test/t/variables.test')
| -rw-r--r-- | mysql-test/t/variables.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index 0499263467c..b3127402238 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -27,3 +27,14 @@ SELECT * FROM t1 WHERE c_id=@min_cid OR c_id=@max_cid OR c_id=666; ALTER TABLE t1 DROP PRIMARY KEY; select * from t1 where c_id=@min_cid OR c_id=@max_cid; drop table t1; + +# +# Test system variables +# + +select @@VERSION=version(); +select last_insert_id(345); +select @@IDENTITY,last_insert_id(); +select @@identity; +--error 1193 +select @@unknown_variable; |