1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/t/old_basic.test b/mysql-test/suite/sys_vars/t/old_basic.test
new file mode 100644
index 00000000..f1bb5a52
--- /dev/null
+++ b/mysql-test/suite/sys_vars/t/old_basic.test
@@ -0,0 +1,15 @@
+#
+# show the global and session values;
+#
+select @@global.old;
+select @@session.old;
+show global variables like 'old';
+show session variables like 'old';
+select * from information_schema.global_variables where variable_name='old';
+select * from information_schema.session_variables where variable_name='old';
+
+set global old=1;
+set session old=1;
+select @@global.old;
+select @@session.old;
+set @@global.old=DEFAULT;