--disable_warnings   
DROP TABLE IF EXISTS t1;
--enable_warnings   

CREATE TABLE t1 (C1 INT, C2 NUMERIC(5,3), C3 NUMERIC(5,3));

COMMIT WORK;

--enable_info
INSERT INTO t1 VALUES (1, 1, 1);
-- PASS:0582 If 1 row is inserted?
--disable_info

SELECT C1, C2, C3 FROM t1;
-- PASS:0582 If 1 row is selected with C1 = 1, C2 = 1 and C3 = 1 ?

#### Easy Update
--enable_info
UPDATE t1 SET C1 = 2, C2 = 2, C3 = 2;
-- PASS:0582 If 1 row is updated?

#### Update, value for C3 has too much precision
# Correct row count, but the layout of the "--enable_info" stuff changes
# from       info: Rows matched: <n>  Changed: <n>  Warnings: <n>
# to         affected rows: <n>
# Why ?? 
--enable_info
UPDATE t1 SET C1 = 1, C2 = 5, C3 = 1.1111;
-- PASS:0582 If 1 row is updated?
--disable_info

#### Update, value for C2, C3 has too much precision
# Why do I get affected rows: 2  instead of 1 ???
--enable_info
UPDATE t1 SET C1 = 1, C2 = 4.4444, C3 = 4.4444;
-- PASS:0582 If 1 row is updated?
--disable_info
## The same type of Update, but the warnings are switched off
--enable_info
--disable_warnings
UPDATE t1 SET C1 = 1, C2 = 5.5555, C3 = 5.5555;
-- PASS:0582 If 1 row is updated?
--enable_warnings
--disable_info