Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.7.3
-
OS: Ubuntu-20.04 LTS
Description
/* init */ CREATE TABLE t(c1 BLOB NOT NULL, c2 TEXT); |
/* init */ INSERT IGNORE INTO t VALUES (NULL, NULL), (NULL, 'abc'); |
|
mariadb> UPDATE t SET c2 = 'test' WHERE c1; |
ERROR 1292 (22007): Truncated incorrect DOUBLE value: '' |
|
mariadb> SELECT * FROM t WHERE c1; |
Empty set, 2 warnings (0.00 sec) |
|
mariadb> DELETE FROM t WHERE c1; |
Query OK, 0 rows affected, 2 warnings (0.00 sec) |
Only UPDATE statement reports an error, while SELECT and DELETE do not report the error.
Attachments
Issue Links
- is blocked by
-
MDEV-19362 New STRICT flags for sql_mode
- Open
- relates to
-
MDEV-27480 Functions don't validate arguments properly and cast/truncate values without warnings or errors
- Stalled
-
MDEV-28069 A misleading warning message from the DELETE statement
- Open