[MDEV-19809] UPDATE which works on 10.3 causes ER_TRUNCATED_WRONG_VALUE on 10.4 Created: 2019-06-19  Updated: 2019-10-11

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Update, Data types
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Note: Quite possibly it's an expected change in behavior, but I would want to make sure.

CREATE TABLE t (f1 varchar(8), f2 varchar(8), KEY (f1) USING BTREE) ENGINE=MEMORY;
 
INSERT INTO t VALUES ('foo','a'),('bar','b');
 
UPDATE t SET f1 = 'x' WHERE f1 <> 'x' AND f2 BETWEEN 0 AND 3;
 
 
 
# Cleanup
 
DROP TABLE t;

10.3 95d783af

 
UPDATE t SET f1 = 'x' WHERE f1 <> 'x' AND f2 BETWEEN 0 AND 3;
 
Warnings:
 
Warning	1292	Truncated incorrect DOUBLE value: 'b'
 
Warning	1292	Truncated incorrect DOUBLE value: 'a'

The UPDATE above passes on 10.3 (with warnings), but fails on 10.4.

10.4 bff7cf9d

 
mysqltest: At line 3: query 'UPDATE t SET f1 = 'x' WHERE f1 <> 'x' AND f2 BETWEEN 0 AND 3' failed: 1292: Truncated incorrect DOUBLE value: 'a'

SQL_MODE is the same on both servers, STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION.
Generated at Thu Feb 08 08:54:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.