http://bugs.mysql.com/bug.php?id=68759
DROP TABLE IF EXISTS t_inno;
CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB;
INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21');
SELECT * FROM t_inno WHERE t < 'z';
SELECT pk FROM t_inno WHERE t_key < 'z';
SELECT * FROM t_inno WHERE t_key < 'z';
MySQL [test]> DROP TABLE IF EXISTS t_inno;
Query OK, 0 rows affected (0.20 sec)
MySQL [test]> CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB;
Query OK, 0 rows affected (1.20 sec)
MySQL [test]> INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21');
Query OK, 2 rows affected (0.07 sec)
Records: 2 Duplicates: 0 Warnings: 0
MySQL [test]>
MySQL [test]> SELECT * FROM t_inno WHERE t < 'z';
--------------------
--------------------
1 |
12:12:12 |
12:12:12 |
2 |
21:21:21 |
21:21:21 |
--------------------
2 rows in set, 1 warning (0.00 sec)
MySQL [test]> SELECT pk FROM t_inno WHERE t_key < 'z';
----
----
----
2 rows in set, 2 warnings (0.00 sec)
MySQL [test]> SELECT * FROM t_inno WHERE t_key < 'z';
Empty set, 2 warnings (0.00 sec)
http://bugs.mysql.com/bug.php?id=68759
DROP TABLE IF EXISTS t_inno;
CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB;
INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21');
SELECT * FROM t_inno WHERE t < 'z';
SELECT pk FROM t_inno WHERE t_key < 'z';
SELECT * FROM t_inno WHERE t_key < 'z';
MySQL [test]> DROP TABLE IF EXISTS t_inno;
Query OK, 0 rows affected (0.20 sec)
MySQL [test]> CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB;
Query OK, 0 rows affected (1.20 sec)
MySQL [test]> INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21');
Query OK, 2 rows affected (0.07 sec)
Records: 2 Duplicates: 0 Warnings: 0
MySQL [test]>
MySQL [test]> SELECT * FROM t_inno WHERE t < 'z';
---
--------------------
--------------------
-----------------2 rows in set, 1 warning (0.00 sec)
MySQL [test]> SELECT pk FROM t_inno WHERE t_key < 'z';
----
----
----
2 rows in set, 2 warnings (0.00 sec)
MySQL [test]> SELECT * FROM t_inno WHERE t_key < 'z';
Empty set, 2 warnings (0.00 sec)