Kenji Maruyama
null+****@clear*****
Thu Jan 16 14:48:18 JST 2014
Kenji Maruyama 2014-01-16 14:48:18 +0900 (Thu, 16 Jan 2014) New Revision: c4d43f7abd1a24c1f02b7a7501fec35ce7344375 https://github.com/mroonga/mroonga/commit/c4d43f7abd1a24c1f02b7a7501fec35ce7344375 Message: test: add a test for select all where not equal empty key refs #2215 [groonga-dev,02052] Reported by Naoya Murakami. Thanks!!! Added files: mysql-test/mroonga/storage/select/empty_key/r/where_not_equal.result mysql-test/mroonga/storage/select/empty_key/t/where_not_equal.test Added: mysql-test/mroonga/storage/select/empty_key/r/where_not_equal.result (+13 -0) 100644 =================================================================== --- /dev/null +++ mysql-test/mroonga/storage/select/empty_key/r/where_not_equal.result 2014-01-16 14:48:18 +0900 (3732cb2) @@ -0,0 +1,13 @@ +DROP TABLE IF EXISTS tags; +CREATE TABLE tags ( +name VARCHAR(16) NOT NULL, +KEY index_name (name) +); +INSERT INTO tags VALUES ('mroonga'); +INSERT INTO tags VALUES ('mysql'); +INSERT INTO tags VALUES (''); +SELECT * FROM tags WHERE name != ""; +name +mroonga +mysql +DROP TABLE tags; Added: mysql-test/mroonga/storage/select/empty_key/t/where_not_equal.test (+36 -0) 100644 =================================================================== --- /dev/null +++ mysql-test/mroonga/storage/select/empty_key/t/where_not_equal.test 2014-01-16 14:48:18 +0900 (a90ac61) @@ -0,0 +1,36 @@ +# Copyright(C) 2014 Kenji Maruyama <mmmaru777 �� gmail.com> +# +# 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/mroonga/have_mroonga.inc + +--disable_warnings +DROP TABLE IF EXISTS tags; +--enable_warnings + +CREATE TABLE tags ( + name VARCHAR(16) NOT NULL, + KEY index_name (name) +); + +INSERT INTO tags VALUES ('mroonga'); +INSERT INTO tags VALUES ('mysql'); +INSERT INTO tags VALUES (''); + +SELECT * FROM tags WHERE name != ""; + +DROP TABLE tags; + +--source ../../../../include/mroonga/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Download