EVOLUTION-MANAGER

Edit File: index_multiple_column_nullable_varchar.result

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
id INT PRIMARY KEY AUTO_INCREMENT,
c1 VARCHAR(10),
c2 VARCHAR(10),
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` varchar(10) DEFAULT NULL,
  `c2` varchar(10) 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', '09'),
('2003', '08'),
('2004', '07'),
('2005', '06'),
('2006', '05'),
('2007', '04'),
('2008', '03'),
('2009', '02'),
('2010', '01');
SELECT * FROM t1 WHERE c1 > '2005';
id	c1	c2
8	2006	05
9	2007	04
10	2008	03
11	2009	02
12	2010	01
SELECT * FROM t1 WHERE c1 >= '2005';
id	c1	c2
7	2005	06
8	2006	05
9	2007	04
10	2008	03
11	2009	02
12	2010	01
SELECT * FROM t1 WHERE c1 = '2005';
id	c1	c2
7	2005	06
SELECT * FROM t1 WHERE c1 <= '2005';
id	c1	c2
1	1999	12
2	2000	11
3	2001	10
4	2002	09
5	2003	08
6	2004	07
7	2005	06
SELECT * FROM t1 WHERE c1 < '2005';
id	c1	c2
1	1999	12
2	2000	11
3	2001	10
4	2002	09
5	2003	08
6	2004	07
DROP TABLE t1;