summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/group_concat_max_len_func.result2
-rw-r--r--mysql-test/r/timestamp_func.result12
-rw-r--r--mysql-test/t/disabled.def1
-rw-r--r--mysql-test/t/group_concat_max_len_func.test4
-rw-r--r--mysql-test/t/max_allowed_packet_func.test2
-rw-r--r--mysql-test/t/timestamp_func.test10
6 files changed, 20 insertions, 11 deletions
diff --git a/mysql-test/r/group_concat_max_len_func.result b/mysql-test/r/group_concat_max_len_func.result
index 877ec025b7b..4ec07c989b7 100644
--- a/mysql-test/r/group_concat_max_len_func.result
+++ b/mysql-test/r/group_concat_max_len_func.result
@@ -1,3 +1,4 @@
+SET @save = @@global.group_concat_max_len;
drop table if exists t1;
## Creating new table t1 ##
CREATE TABLE t1
@@ -75,3 +76,4 @@ id rollno group_concat(name)
## Dropping table t1 ##
DROP table t1;
## Disconnecting both the connection ##
+SET @@group_concat_max_len = @save;
diff --git a/mysql-test/r/timestamp_func.result b/mysql-test/r/timestamp_func.result
index c41db55cae6..ed51cec4227 100644
--- a/mysql-test/r/timestamp_func.result
+++ b/mysql-test/r/timestamp_func.result
@@ -7,18 +7,18 @@
SET @ts_old = @@SESSION.timestamp;
waiting 1 sec
SET @ts_new = @@SESSION.timestamp;
-SELECT @ts_new - @ts_old AS 'Timestamp Difference';
+SELECT @ts_new - @ts_old >= 1 AS 'Timestamp Difference';
Timestamp Difference
1
-1 Expected
+1 means >=1 expected is true
** Connection con1 **
SET @ts_old = @@SESSION.timestamp;
waiting 4 sec
SET @ts_new = @@SESSION.timestamp;
-SELECT @ts_new - @ts_old AS 'Timestamp Difference';
+SELECT @ts_new - @ts_old >= 4 AS 'Timestamp Difference';
Timestamp Difference
-4
-4 Expected
+1
+1 means >=4 expected is true
'#-----------------------------FN_DYNVARS_179_02---------------------#'
SET @ts_old = @@SESSION.timestamp;
Changing time zone
@@ -27,7 +27,7 @@ SET @ts_new = @@SESSION.timestamp;
SELECT @ts_new - @ts_old >= 1 AS 'Timestamp Difference';
Timestamp Difference
1
->=1 Expected
+1 means >=1 expected is true
** Cleanup **
** Connection default **
Disconnecting Connections con0, con1
diff --git a/mysql-test/t/disabled.def b/mysql-test/t/disabled.def
index 8f85e17af43..afbccbf0af1 100644
--- a/mysql-test/t/disabled.def
+++ b/mysql-test/t/disabled.def
@@ -21,4 +21,5 @@ ps_ddl : Bug#12093 2007-12-14 pending WL#4165 / WL#4166
csv_alter_table : Bug#33696 2008-01-21 pcrews no .result file - bug allows NULL columns in CSV tables
event_scheduler_basic: BUG#35997 server seems to crash.
event_scheduler_func: BUG#35997 server seems to crash.
+thread_cache_size_func: BUG#35988 Due to not deterministic results
diff --git a/mysql-test/t/group_concat_max_len_func.test b/mysql-test/t/group_concat_max_len_func.test
index fc097e4f972..1c581d16aa3 100644
--- a/mysql-test/t/group_concat_max_len_func.test
+++ b/mysql-test/t/group_concat_max_len_func.test
@@ -19,6 +19,7 @@
# #
###############################################################################
+SET @save = @@global.group_concat_max_len;
--disable_warnings
drop table if exists t1;
@@ -124,4 +125,7 @@ DROP table t1;
DISCONNECT test_con2;
DISCONNECT test_con1;
+connection default;
+
+SET @@group_concat_max_len = @save;
diff --git a/mysql-test/t/max_allowed_packet_func.test b/mysql-test/t/max_allowed_packet_func.test
index cbedc10c808..37ca15f85f0 100644
--- a/mysql-test/t/max_allowed_packet_func.test
+++ b/mysql-test/t/max_allowed_packet_func.test
@@ -19,6 +19,8 @@
# #
###############################################################################
+#due to lost connection on win64
+--source include/not_windows.inc
let $start_global_value = `SELECT @@global.max_allowed_packet`;
--echo $start_global_value
diff --git a/mysql-test/t/timestamp_func.test b/mysql-test/t/timestamp_func.test
index 84c66441e6f..ecca3c7daeb 100644
--- a/mysql-test/t/timestamp_func.test
+++ b/mysql-test/t/timestamp_func.test
@@ -38,8 +38,8 @@ SET @ts_old = @@SESSION.timestamp;
--echo waiting 1 sec
--sleep 1
SET @ts_new = @@SESSION.timestamp;
-SELECT @ts_new - @ts_old AS 'Timestamp Difference';
---echo 1 Expected
+SELECT @ts_new - @ts_old >= 1 AS 'Timestamp Difference';
+--echo 1 means >=1 expected is true
#
@@ -51,8 +51,8 @@ SET @ts_old = @@SESSION.timestamp;
--echo waiting 4 sec
--sleep 4
SET @ts_new = @@SESSION.timestamp;
-SELECT @ts_new - @ts_old AS 'Timestamp Difference';
---echo 4 Expected
+SELECT @ts_new - @ts_old >= 4 AS 'Timestamp Difference';
+--echo 1 means >=4 expected is true
--echo '#-----------------------------FN_DYNVARS_179_02---------------------#'
#
@@ -65,7 +65,7 @@ SET @ts_old = @@SESSION.timestamp;
SET time_zone = 'MET';
SET @ts_new = @@SESSION.timestamp;
SELECT @ts_new - @ts_old >= 1 AS 'Timestamp Difference';
---echo >=1 Expected
+--echo 1 means >=1 expected is true
#
# Cleanup