summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/sys_vars/r/timestamp_func.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/r/timestamp_func.result')
-rw-r--r--mysql-test/suite/sys_vars/r/timestamp_func.result26
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/timestamp_func.result b/mysql-test/suite/sys_vars/r/timestamp_func.result
new file mode 100644
index 00000000..3394ce46
--- /dev/null
+++ b/mysql-test/suite/sys_vars/r/timestamp_func.result
@@ -0,0 +1,26 @@
+connect con1,localhost,root,,;
+SELECT date(now()) = date(sysdate());
+date(now()) = date(sysdate())
+1
+SET @@session.timestamp = 1100000000;
+SELECT date(now()) != date(sysdate());
+date(now()) != date(sysdate())
+1
+connect con0,localhost,root,,;
+SELECT @@session.timestamp != 1100000000;
+@@session.timestamp != 1100000000
+1
+SET @@session.timestamp = 1000000000;
+SELECT date(now()) != date(sysdate());
+date(now()) != date(sysdate())
+1
+connection con1;
+SELECT @@session.timestamp != 1000000000;
+@@session.timestamp != 1000000000
+1
+SELECT @@session.timestamp = 1100000000;
+@@session.timestamp = 1100000000
+1
+connection default;
+disconnect con0;
+disconnect con1;