null+****@clear*****
null+****@clear*****
2012年 3月 7日 (水) 10:10:56 JST
Kouhei Sutou 2012-03-07 10:10:56 +0900 (Wed, 07 Mar 2012)
New Revision: 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;