susumu.yata
null+****@clear*****
Wed Jul 1 19:48:55 JST 2015
susumu.yata 2015-07-01 19:48:55 +0900 (Wed, 01 Jul 2015) New Revision: 93ce8ecbca8cbb794aa648c838333b629abac741 https://github.com/mroonga/mroonga/commit/93ce8ecbca8cbb794aa648c838333b629abac741 Message: test: use "1990-00-00 00:00:00" instead of "0000-00-00 00:00:00" "0000-01-01" is not supported on 32-bit systems and this test failed. This test is aimed to check that "XXXX-00-00" is corrected to "XXXX-01-01". "0000" is not important. Modified files: mysql-test/mroonga/storage/index/multiple_column/unique/datetime/r/insert_delete_insert_invalid_value.result mysql-test/mroonga/storage/index/multiple_column/unique/datetime/t/insert_delete_insert_invalid_value.test Modified: mysql-test/mroonga/storage/index/multiple_column/unique/datetime/r/insert_delete_insert_invalid_value.result (+4 -4) =================================================================== --- mysql-test/mroonga/storage/index/multiple_column/unique/datetime/r/insert_delete_insert_invalid_value.result 2015-06-30 20:37:22 +0900 (2d502fc) +++ mysql-test/mroonga/storage/index/multiple_column/unique/datetime/r/insert_delete_insert_invalid_value.result 2015-07-01 19:48:55 +0900 (155faf8) @@ -5,17 +5,17 @@ start datetime, end datetime, UNIQUE KEY range_key(start, end) ); -INSERT INTO ranges VALUES (1, "0000-00-00 00:00:00", "2012-10-05 23:59:59"); +INSERT INTO ranges VALUES (1, "1990-00-00 00:00:00", "2012-10-05 23:59:59"); Warnings: Warning 1265 Data truncated for column 'start' at row 1 SELECT * FROM ranges; id start end -1 0000-01-01 00:00:00 2012-10-05 23:59:59 +1 1990-01-01 00:00:00 2012-10-05 23:59:59 DELETE FROM ranges WHERE id = 1; -INSERT INTO ranges VALUES (1, "0000-00-00 00:00:00", "2012-10-05 23:59:59"); +INSERT INTO ranges VALUES (1, "1990-00-00 00:00:00", "2012-10-05 23:59:59"); Warnings: Warning 1265 Data truncated for column 'start' at row 1 SELECT * FROM ranges; id start end -1 0000-01-01 00:00:00 2012-10-05 23:59:59 +1 1990-01-01 00:00:00 2012-10-05 23:59:59 DROP TABLE ranges; Modified: mysql-test/mroonga/storage/index/multiple_column/unique/datetime/t/insert_delete_insert_invalid_value.test (+2 -2) =================================================================== --- mysql-test/mroonga/storage/index/multiple_column/unique/datetime/t/insert_delete_insert_invalid_value.test 2015-06-30 20:37:22 +0900 (9ef37df) +++ mysql-test/mroonga/storage/index/multiple_column/unique/datetime/t/insert_delete_insert_invalid_value.test 2015-07-01 19:48:55 +0900 (e8b1955) @@ -27,11 +27,11 @@ CREATE TABLE ranges ( UNIQUE KEY range_key(start, end) ); -INSERT INTO ranges VALUES (1, "0000-00-00 00:00:00", "2012-10-05 23:59:59"); +INSERT INTO ranges VALUES (1, "1990-00-00 00:00:00", "2012-10-05 23:59:59"); SELECT * FROM ranges; DELETE FROM ranges WHERE id = 1; -INSERT INTO ranges VALUES (1, "0000-00-00 00:00:00", "2012-10-05 23:59:59"); +INSERT INTO ranges VALUES (1, "1990-00-00 00:00:00", "2012-10-05 23:59:59"); SELECT * FROM ranges; DROP TABLE ranges; -------------- next part -------------- HTML����������������������������...Download