summaryrefslogtreecommitdiff
path: root/mysql-test/t/init_file.test
diff options
context:
space:
mode:
authorunknown <thek@kpdesk.mysql.com>2007-02-19 10:08:27 +0100
committerunknown <thek@kpdesk.mysql.com>2007-02-19 10:08:27 +0100
commit663b9cad825177de7c70be99a2da78116e899362 (patch)
tree7d63731d52e3eb174c9a7dbc555ea1c58c8dc4e8 /mysql-test/t/init_file.test
parenta475ed7c6b6607272afb87517ae6ab1f3a397f41 (diff)
parent114e5b8ddb26aff34f9ea8418dfe73043b912f0f (diff)
downloadmariadb-git-663b9cad825177de7c70be99a2da78116e899362.tar.gz
Merge kpdesk.mysql.com:/home/thek/dev/bug23240/my41-bug23240
into kpdesk.mysql.com:/home/thek/dev/bug23240/my50-bug23240 mysql-test/t/init_file.test: Auto merged BitKeeper/deleted/.del-init_file.result: Auto merged mysql-test/std_data/init_file.dat: Null merge sql/sql_parse.cc: Null merge
Diffstat (limited to 'mysql-test/t/init_file.test')
-rw-r--r--mysql-test/t/init_file.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/init_file.test b/mysql-test/t/init_file.test
index 31a6ef5a541..7c580afadda 100644
--- a/mysql-test/t/init_file.test
+++ b/mysql-test/t/init_file.test
@@ -6,6 +6,15 @@
# mysql-test/t/init_file-master.opt for the actual test
#
+#
+# Bug#23240 --init-file statements with NOW() reports '1970-01-01 11:00:00'as the date time
+#
+INSERT INTO init_file.startup VALUES ( NOW() );
+SELECT * INTO @X FROM init_file.startup limit 0,1;
+SELECT * INTO @Y FROM init_file.startup limit 1,1;
+SELECT YEAR(@X)-YEAR(@Y);
+DROP DATABASE init_file;
+
--echo ok
--echo end of 4.1 tests
#