summaryrefslogtreecommitdiff
path: root/mysql-test/r/ps.result
diff options
context:
space:
mode:
authorunknown <konstantin@mysql.com>2005-07-16 13:45:32 +0400
committerunknown <konstantin@mysql.com>2005-07-16 13:45:32 +0400
commit40efb3622d9666ff23edee23678acd0b3e024476 (patch)
tree088fa24c9ce0b4e14763ddce9d9bb5106fc4a8af /mysql-test/r/ps.result
parent0789b177e50dae46863e3b37837ad684bcc44483 (diff)
parentd5b80a789e05b7dce12dfeef7393a6ac8bf17fb7 (diff)
downloadmariadb-git-40efb3622d9666ff23edee23678acd0b3e024476.tar.gz
Merge mysql.com:/opt/local/work/mysql-4.1-root
into mysql.com:/media/sda1/mysql/mysql-5.0-merge mysql-test/r/select.result: Auto merged sql/mysql_priv.h: Auto merged sql/set_var.cc: Auto merged sql/sql_select.cc: Auto merged mysql-test/r/ps.result: Manual merge (again). mysql-test/t/ps.test: Manual merge (again). mysql-test/t/select.test: Manual merge (again). sql/item_func.cc: Manual merge (again). sql/item_func.h: Manual merge (again). sql/set_var.h: Manual merge (again).
Diffstat (limited to 'mysql-test/r/ps.result')
-rw-r--r--mysql-test/r/ps.result25
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result
index 81d85306e93..0050dfc0841 100644
--- a/mysql-test/r/ps.result
+++ b/mysql-test/r/ps.result
@@ -775,3 +775,28 @@ ERROR 42000: You have an error in your SQL syntax; check the manual that corresp
select ? from t1;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? from t1' at line 1
drop table t1;
+prepare stmt from "select @@time_zone";
+execute stmt;
+@@time_zone
+SYSTEM
+set @@time_zone:='Japan';
+execute stmt;
+@@time_zone
+Japan
+prepare stmt from "select @@tx_isolation";
+execute stmt;
+@@tx_isolation
+REPEATABLE-READ
+set transaction isolation level read committed;
+execute stmt;
+@@tx_isolation
+READ-COMMITTED
+set transaction isolation level serializable;
+execute stmt;
+@@tx_isolation
+SERIALIZABLE
+set @@tx_isolation=default;
+execute stmt;
+@@tx_isolation
+REPEATABLE-READ
+deallocate prepare stmt;