Masafumi Yokoyama
null+****@clear*****
Wed Jun 24 21:27:57 JST 2015
Masafumi Yokoyama 2015-06-24 21:27:57 +0900 (Wed, 24 Jun 2015) New Revision: d229a2072ac352cf0ba6cf9783383b80d0ba6a01 https://github.com/mroonga/mroonga/commit/d229a2072ac352cf0ba6cf9783383b80d0ba6a01 Message: doc: update an example in 5.04 entry TODO: confirm it by 5.04 package before upload. Modified files: doc/source/news.rst Modified: doc/source/news.rst (+13 -4) =================================================================== --- doc/source/news.rst 2015-06-24 19:31:56 +0900 (b2e65c0) +++ doc/source/news.rst 2015-06-24 21:27:57 +0900 (d91c964) @@ -65,20 +65,29 @@ Improvements * It's backward incompatible change. For example:: - -- Before + mysql> CREATE TABLE timestamps ( + -> id INT NOT NULL AUTO_INCREMENT, + -> create_dt DATETIME + -> ) ENGINE = Mroonga DEFAULT CHARSET utf8; + Query OK, 0 rows affected (0.09 sec) mysql> SET sql_mode='STRICT_TRANS_TABLES'; + Query OK, 0 rows affected (0.01 sec) + + -- Before (5.03 or earlier) mysql> INSERT INTO timestamps (create_dt) VALUES ("0000-00-00 00:00:00"); + ERROR 1265 (01000): Data truncated for column 'create_dt' at row 1 mysql> SELECT * FROM timestamps; +----+---------------------+ | id | create_dt | +----+---------------------+ - | 1 | 0000-00-00 00:00:00 | + | 1 | 0000-01-01 00:00:00 | +----+---------------------+ - -- After - mysql> SET sql_mode='STRICT_TRANS_TABLES'; + -- After (5.04 or later) mysql> INSERT INTO timestamps (create_dt) VALUES ("0000-00-00 00:00:00"); ERROR 22003: Out of range value for column 'create_dt' at row 1 + mysql> SELECT * FROM timestamps; + Empty set (0.02 sec) * Changed keyword to use custom tokenizer to "tokenizer" from "parser". -------------- next part -------------- HTML����������������������������...Download