diff options
| author | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
|---|---|---|
| committer | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
| commit | 357b5009409ed6666bf1df48a80d76cd42a482c8 (patch) | |
| tree | 7a2fa9b404ffb20d1572c51a0bca7ecc64992310 /mysql-test/t/timestamp_func.test | |
| parent | ba816c14a9bc8012759da9d58f858f1e73bec708 (diff) | |
| download | mariadb-git-357b5009409ed6666bf1df48a80d76cd42a482c8.tar.gz | |
WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.
Diffstat (limited to 'mysql-test/t/timestamp_func.test')
| -rw-r--r-- | mysql-test/t/timestamp_func.test | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/mysql-test/t/timestamp_func.test b/mysql-test/t/timestamp_func.test deleted file mode 100644 index e119f1b6253..00000000000 --- a/mysql-test/t/timestamp_func.test +++ /dev/null @@ -1,50 +0,0 @@ -############# mysql-test\t\timestamp_func.test ############################# -# # -# Variable Name: timestamp # -# Scope: GLOBAL # -# Access Type: Dynamic # -# Data Type: INTEGER # -# # -# # -# Creation Date: 2008-02-25 # -# Author: Sharique Abdullah # -# # -# Modified: HHunger 2008-08-28 Reimplemented the test completely. # -# # -# Description: Test Cases of Dynamic System Variable "timestamp" # -# that checks behavior of this variable in the following ways # -# * Functionality based on different values # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/set-option.html # -# # -############################################################################ - -# Change timestamp which must have an effect on now(), but not on sysdate(). -# Use Unix epoch timestamp -# All comparisons must deliver true(1) -# Exception: --sysdate-is-now switches off this behaviour and must not be set. - ---echo ** Connecting con1 using root ** -connect (con1,localhost,root,,); -SELECT date(now()) = date(sysdate()); -SET @@session.timestamp = 1100000000; -SELECT date(now()) != date(sysdate()); - -# Assure that setting of the variable has no effect on other session. ---echo ** Connecting con0 using root ** -connect (con0,localhost,root,,); -SELECT @@session.timestamp != 1100000000; -SET @@session.timestamp = 1000000000; -SELECT date(now()) != date(sysdate()); - ---echo ** Connection con1 ** -connection con1; -SELECT @@session.timestamp != 1000000000; -SELECT @@session.timestamp = 1100000000; - ---echo ** Connection default ** -connection default; ---echo Disconnecting Connections con0, con1 -disconnect con0; -disconnect con1; - |