|
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
|
|
|