← Back to branch summary

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

« back to all changes in this revision

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

  • 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:
mysql-test/t/type_datetime.test
445
445
# show we truncate microseconds from the right
446
446
SELECT CAST(CAST('2008-07-29T10:42:51.1234567' AS DateTime) AS DECIMAL(30,7));
447
447
 
 
448
--echo # 
 
449
--echo # Bug#59173: Failure to handle DATE(TIME) values where Year, Month or
 
450
--echo # Day is ZERO 
 
451
--echo # 
 
452
CREATE TABLE t1 (dt1 DATETIME);
 
453
INSERT INTO t1 (dt1) VALUES ('0000-00-01 00:00:01');
 
454
DELETE   FROM t1 WHERE dt1 = '0000-00-01 00:00:01';
 
455
--echo # Should be empty
 
456
SELECT * FROM t1;
 
457
DROP TABLE t1;
 
458
 
448
459
--echo End of 5.1 tests