Kouhei Sutou
null+****@clear*****
Thu Oct 4 10:49:15 JST 2012
Kouhei Sutou 2012-03-07 10:10:56 +0900 (Wed, 07 Mar 2012) New Revision: c07c7a57e2e98f19493f08c56ea8d519bcd19355 https://github.com/mroonga/mroonga/commit/c07c7a57e2e98f19493f08c56ea8d519bcd19355 Log: [test][wrapper] specify also 'date' column value refs #1301 Modified files: test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_primary_key_myisam.result test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_unique_index_myisam.result test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_primary_key_myisam.test test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_unique_index_myisam.test Modified: test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_primary_key_myisam.result (+3 -2) =================================================================== --- test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_primary_key_myisam.result 2012-03-07 10:07:03 +0900 (c2bd625) +++ test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_primary_key_myisam.result 2012-03-07 10:10:56 +0900 (f781677) @@ -26,10 +26,11 @@ date title content 2012-03-05 00:00:00 rainy day Today is rainy day... INSERT INTO diaries (date, title, content) VALUES ("2012-03-04", "shopping", "I buy new shoes.") -ON DUPLICATE KEY UPDATE content = "I buy a new hat."; +ON DUPLICATE KEY UPDATE date = "2012-03-03", +content = "I buy a new hat."; SELECT * FROM diaries; date title content 2012-03-04 00:00:00 cloudy day Today is cloudy day... -2012-03-04 00:00:00 shopping I buy a new hat. +2012-03-03 00:00:00 shopping I buy a new hat. 2012-03-05 00:00:00 rainy day Today is rainy day... DROP TABLE diaries; Modified: test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_unique_index_myisam.result (+3 -2) =================================================================== --- test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_unique_index_myisam.result 2012-03-07 10:07:03 +0900 (7a0d95d) +++ test/sql/suite/mroonga_wrapper/r/insert_on_duplicate_key_multiple_column_unique_index_myisam.result 2012-03-07 10:10:56 +0900 (fd3f32f) @@ -29,10 +29,11 @@ id date title content 3 2012-03-05 00:00:00 rainy day Today is rainy day... INSERT INTO diaries (date, title, content) VALUES ("2012-03-04", "shopping", "I buy new shoes.") -ON DUPLICATE KEY UPDATE content = "I buy a new hat."; +ON DUPLICATE KEY UPDATE date = "2012-03-03", +content = "I buy a new hat."; SELECT * FROM diaries; id date title content 1 2012-03-04 00:00:00 cloudy day Today is cloudy day... -2 2012-03-04 00:00:00 shopping I buy a new hat. +2 2012-03-03 00:00:00 shopping I buy a new hat. 3 2012-03-05 00:00:00 rainy day Today is rainy day... DROP TABLE diaries; Modified: test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_primary_key_myisam.test (+2 -1) =================================================================== --- test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_primary_key_myisam.test 2012-03-07 10:07:03 +0900 (42b172c) +++ test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_primary_key_myisam.test 2012-03-07 10:10:56 +0900 (16f6860) @@ -39,7 +39,8 @@ SELECT * FROM diaries; INSERT INTO diaries (date, title, content) VALUES ("2012-03-04", "shopping", "I buy new shoes.") - ON DUPLICATE KEY UPDATE content = "I buy a new hat."; + ON DUPLICATE KEY UPDATE date = "2012-03-03", + content = "I buy a new hat."; SELECT * FROM diaries; Modified: test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_unique_index_myisam.test (+2 -1) =================================================================== --- test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_unique_index_myisam.test 2012-03-07 10:07:03 +0900 (50e8b8a) +++ test/sql/suite/mroonga_wrapper/t/insert_on_duplicate_key_multiple_column_unique_index_myisam.test 2012-03-07 10:10:56 +0900 (4887052) @@ -40,7 +40,8 @@ SELECT * FROM diaries; INSERT INTO diaries (date, title, content) VALUES ("2012-03-04", "shopping", "I buy new shoes.") - ON DUPLICATE KEY UPDATE content = "I buy a new hat."; + ON DUPLICATE KEY UPDATE date = "2012-03-03", + content = "I buy a new hat."; SELECT * FROM diaries; DROP TABLE diaries; -------------- next part -------------- HTML����������������������������...Download