~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/timezone2.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
ImportĀ upstreamĀ versionĀ 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
296
296
UPDATE t1 SET t = CONVERT_TZ(t, 'UTC', 'Europe/Moscow');
297
297
UNLOCK TABLES;
298
298
DROP TABLE t1;
 
299
#
 
300
# Bug #55424: convert_tz crashes when fed invalid data
 
301
#
 
302
CREATE TABLE t1 (a SET('x') NOT NULL);
 
303
INSERT INTO t1 VALUES ('');
 
304
SELECT CONVERT_TZ(1, a, 1) FROM t1;
 
305
CONVERT_TZ(1, a, 1)
 
306
NULL
 
307
SELECT CONVERT_TZ(1, 1, a) FROM t1;
 
308
CONVERT_TZ(1, 1, a)
 
309
NULL
 
310
DROP TABLE t1;
299
311
End of 5.1 tests