← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/t/timezone2.test

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/timezone2.test
246
246
SET GLOBAL log_bin_trust_function_creators = 0;
247
247
 
248
248
# End of 5.0 tests
 
249
 
 
250
 
 
251
#
 
252
# BUG#9953: CONVERT_TZ requires mysql.time_zone_name to be locked
 
253
# BUG#19339: CONVERT_TZ(): overly aggressive in locking time_zone_name
 
254
# table
 
255
#
 
256
--disable_warnings
 
257
DROP TABLE IF EXISTS t1;
 
258
--enable_warnings
 
259
 
 
260
CREATE TABLE t1 (t TIMESTAMP);
 
261
INSERT INTO t1 VALUES (NULL), (NULL);
 
262
 
 
263
LOCK TABLES t1 WRITE;
 
264
 
 
265
# The following two queries should not return error that time zone
 
266
# tables aren't locked.  We use IS NULL below to supress timestamp
 
267
# result.
 
268
SELECT CONVERT_TZ(NOW(), 'UTC', 'Europe/Moscow') IS NULL;
 
269
UPDATE t1 SET t = CONVERT_TZ(t, 'UTC', 'Europe/Moscow');
 
270
 
 
271
UNLOCK TABLES;
 
272
 
 
273
DROP TABLE t1;
 
274
 
 
275
 
 
276
--echo End of 5.1 tests