EVOLUTION-MANAGER

Edit File: index_multiple_column_nullable_smallint.result

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
id INT PRIMARY KEY AUTO_INCREMENT,
c1 SMALLINT,
c2 SMALLINT,
KEY idx1(c1, c2)
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c1` smallint(6) DEFAULT NULL,
  `c2` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx1` (`c1`,`c2`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8
INSERT INTO t1 (c1, c2) VALUES
(1999, 12),
(2000, 11),
(2001, 10),
(2002, 9),
(2003, 8),
(2004, 7),
(2005, 6),
(2006, 5),
(2007, 4),
(2008, 3),
(2009, 2),
(2010, 1);
SELECT * FROM t1 WHERE c1 > 2005;
id	c1	c2
8	2006	5
9	2007	4
10	2008	3
11	2009	2
12	2010	1
SELECT * FROM t1 WHERE c1 >= 2005;
id	c1	c2
7	2005	6
8	2006	5
9	2007	4
10	2008	3
11	2009	2
12	2010	1
SELECT * FROM t1 WHERE c1 = 2005;
id	c1	c2
7	2005	6
SELECT * FROM t1 WHERE c1 <= 2005;
id	c1	c2
1	1999	12
2	2000	11
3	2001	10
4	2002	9
5	2003	8
6	2004	7
7	2005	6
SELECT * FROM t1 WHERE c1 < 2005;
id	c1	c2
1	1999	12
2	2000	11
3	2001	10
4	2002	9
5	2003	8
6	2004	7
DROP TABLE t1;