summaryrefslogtreecommitdiff
path: root/mysql-test/t/variables.test
diff options
context:
space:
mode:
authorTatiana A. Nurnberg <azundris@mysql.com>2009-03-12 17:55:10 +0100
committerTatiana A. Nurnberg <azundris@mysql.com>2009-03-12 17:55:10 +0100
commit837024232362ed8b127885515662104d57d5567b (patch)
treef78d5a2f370c5fbfce282e2d07711fc798ffe8e3 /mysql-test/t/variables.test
parent59fbffa45cc804bde74d504129eb705cd80b3bba (diff)
parent8cbd34f0d7a08f112ca4fb900bda31aeaf0703f1 (diff)
downloadmariadb-git-837024232362ed8b127885515662104d57d5567b.tar.gz
manual merge for 40657 beautification
Diffstat (limited to 'mysql-test/t/variables.test')
-rw-r--r--mysql-test/t/variables.test16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test
index 43169b22b5e..e224d3b0244 100644
--- a/mysql-test/t/variables.test
+++ b/mysql-test/t/variables.test
@@ -1169,5 +1169,21 @@ SET GLOBAL auto_increment_offset=0;
select @@storage_engine;
--disable_metadata
+#
+# Bug#36540: CREATE EVENT and ALTER EVENT statements fail with large server_id
+#
+
+SET @old_server_id = @@GLOBAL.server_id;
+SET GLOBAL server_id = (1 << 32) - 1;
+SELECT @@GLOBAL.server_id;
+SET GLOBAL server_id = (1 << 32);
+SELECT @@GLOBAL.server_id;
+SET GLOBAL server_id = (1 << 60);
+SELECT @@GLOBAL.server_id;
+SET GLOBAL server_id = 0;
+SELECT @@GLOBAL.server_id;
+SET GLOBAL server_id = -1;
+SELECT @@GLOBAL.server_id;
+SET GLOBAL server_id = @old_server_id;
--echo End of 5.1 tests