DROP DATABASE IF EXISTS mcs60_db;
CREATE DATABASE mcs60_db;
USE mcs60_db;
DROP DATABASE IF EXISTS mcs60_db;
CREATE DATABASE mcs60_db;
USE mcs60_db;
CREATE TABLE t1 (i INT, j INT) ENGINE=Columnstore;
CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW 
BEGIN
IF NEW.j > 10 THEN
SET NEW.j := 10;
END IF;
END|
INSERT INTO t1 VALUES (1,2),(2,3),(3,14);
SELECT * FROM t1 ORDER BY i;
i	j
1	2
2	3
3	10
DROP DATABASE mcs60_db;