EVOLUTION-MANAGER

Edit File: update_virtual_column.result

DROP TABLE IF EXISTS t1; CREATE TABLE t1 (c1 int, _id int); INSERT INTO t1 VALUES(1,null); INSERT INTO t1 VALUES(2,null); INSERT INTO t1 VALUES(3,null); SELECT * FROM t1; c1 _id 1 1 2 2 3 3 SET sql_mode=""; UPDATE t1 SET _id = 10 WHERE c1 = 1; Warnings: Warning 1265 Data truncated for column '_id' at row 1 SELECT * FROM t1; c1 _id 1 1 2 2 3 3 SET sql_mode="STRICT_ALL_TABLES"; UPDATE t1 SET _id = 11 WHERE c1 = 1; ERROR 01000: Data truncated for column '_id' at row 1 SELECT * FROM t1; c1 _id 1 1 2 2 3 3 DROP TABLE t1; SET sql_mode=DEFAULT;