null+****@clear*****
null+****@clear*****
2012年 2月 17日 (金) 18:19:28 JST
Kouhei Sutou 2012-02-17 18:19:28 +0900 (Fri, 17 Feb 2012) New Revision: 27a4420ac223e7e419f62ad8f692b14c20ad37fd Log: test: add a test for TIMESTAMP without fractional seconds for PRIMARY KEY. Added files: test/sql/suite/mroonga_storage/r/primary_key_timestamp_without_fractional_seconds.result test/sql/suite/mroonga_storage/t/primary_key_timestamp_without_fractional_seconds.test Added: test/sql/suite/mroonga_storage/r/primary_key_timestamp_without_fractional_seconds.result (+26 -0) 100644 =================================================================== --- /dev/null +++ test/sql/suite/mroonga_storage/r/primary_key_timestamp_without_fractional_seconds.result 2012-02-17 18:19:28 +0900 (e581735) @@ -0,0 +1,26 @@ +DROP TABLE IF EXISTS diaries; +CREATE TABLE diaries ( +time TIMESTAMP PRIMARY KEY, +title TEXT +) DEFAULT CHARSET UTF8; +SHOW CREATE TABLE diaries; +Table Create Table +diaries CREATE TABLE `diaries` ( + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `title` text, + PRIMARY KEY (`time`) +) ENGINE=mroonga DEFAULT CHARSET=utf8 +INSERT INTO diaries (time, title) VALUES ("2012-01-29 21:51:01", "clear day"); +INSERT INTO diaries (time, title) VALUES ("2012-01-30 01:23:45", "rainy day"); +INSERT INTO diaries (time, title) VALUES ("2012-01-31 08:32:10", "cloudy day"); +SELECT * FROM diaries; +time title +2012-01-29 21:51:01 clear day +2012-01-30 01:23:45 rainy day +2012-01-31 08:32:10 cloudy day +SELECT * FROM diaries +WHERE time BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00"; +time title +2012-01-29 21:51:01 clear day +2012-01-30 01:23:45 rainy day +DROP TABLE diaries; Added: test/sql/suite/mroonga_storage/t/primary_key_timestamp_without_fractional_seconds.test (+40 -0) 100644 =================================================================== --- /dev/null +++ test/sql/suite/mroonga_storage/t/primary_key_timestamp_without_fractional_seconds.test 2012-02-17 18:19:28 +0900 (1ce4034) @@ -0,0 +1,40 @@ +# Copyright(C) 2012 Kouhei Sutou <kou****@clear*****> +# +# This library is free software; you can redistribute it and/or +# modify it under the terms of the GNU Lesser General Public +# License as published by the Free Software Foundation; either +# version 2.1 of the License, or (at your option) any later version. +# +# This library is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +# Lesser General Public License for more details. +# +# You should have received a copy of the GNU Lesser General Public +# License along with this library; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/have_mroonga.inc + +--disable_warnings +DROP TABLE IF EXISTS diaries; +--enable_warnings + +CREATE TABLE diaries ( + time TIMESTAMP PRIMARY KEY, + title TEXT +) DEFAULT CHARSET UTF8; +SHOW CREATE TABLE diaries; + +INSERT INTO diaries (time, title) VALUES ("2012-01-29 21:51:01", "clear day"); +INSERT INTO diaries (time, title) VALUES ("2012-01-30 01:23:45", "rainy day"); +INSERT INTO diaries (time, title) VALUES ("2012-01-31 08:32:10", "cloudy day"); + +SELECT * FROM diaries; + +SELECT * FROM diaries + WHERE time BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00"; + +DROP TABLE diaries; + +--source include/have_mroonga_deinit.inc