Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2, 10.3
-
None
-
None
Description
CREATE TABLE t1 (pk int, t2 time); |
INSERT INTO t1 VALUES (95,'11:58:30'),(104,'16:21:16'); |
|
CREATE VIEW v1 AS select * from t1; |
|
SELECT * FROM v1 WHERE (v1.pk < v1.t2); |
SELECT * FROM t1 WHERE (t1.pk < t1.t2); |
10.3 4f410473ed3609636c5912 |
MariaDB [test1]> SELECT * FROM v1 WHERE (v1.pk < v1.t2);
|
+------+----------+
|
| pk | t2 |
|
+------+----------+
|
| 104 | 16:21:16 |
|
+------+----------+
|
1 row in set, 1 warning (0.00 sec)
|
Warning (Code 1292): Incorrect datetime value: '95' for column 'pk' at row 1
|
|
MariaDB [test1]> SELECT * FROM t1 WHERE (t1.pk < t1.t2);
|
+------+----------+
|
| pk | t2 |
|
+------+----------+
|
| 95 | 11:58:30 |
|
| 104 | 16:21:16 |
|
+------+----------+
|
2 rows in set, 1 warning (0.01 sec)
|
Warning (Code 1292): Incorrect datetime value: '95' for column 'pk' at row 1
|
|