mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
21 lines
420 B
Plaintext
21 lines
420 B
Plaintext
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;
|