1DROP TABLE IF EXISTS t1,t2,t3; 2CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT); 3INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 4CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 TINYINT, new1 TINYINT, old2 TINYINT, new2 TINYINT); 5CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT); 6INSERT INTO t3 VALUES(1,0); 7CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 8INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 9UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 10END// 11ERROR HY000: There is no OLD row in on INSERT trigger 12DROP TABLE t1,t2,t3; 13CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT); 14INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 15CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT); 16CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT); 17INSERT INTO t3 VALUES(1,0); 18CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 19INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 20UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 21END// 22ERROR HY000: There is no OLD row in on INSERT trigger 23DROP TABLE t1,t2,t3; 24CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT); 25INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 26CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT); 27CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT); 28INSERT INTO t3 VALUES(1,0); 29CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 30INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 31UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 32END// 33ERROR HY000: There is no OLD row in on INSERT trigger 34DROP TABLE t1,t2,t3; 35CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT); 36INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 37CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT); 38CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT); 39INSERT INTO t3 VALUES(1,0); 40CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 41INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 42UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 43END// 44ERROR HY000: There is no OLD row in on INSERT trigger 45DROP TABLE t1,t2,t3; 46CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER); 47INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 48CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER); 49CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER); 50INSERT INTO t3 VALUES(1,0); 51CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 52INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 53UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 54END// 55ERROR HY000: There is no OLD row in on INSERT trigger 56DROP TABLE t1,t2,t3; 57CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT); 58INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 59CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT); 60CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT); 61INSERT INTO t3 VALUES(1,0); 62CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 63INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 64UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 65END// 66ERROR HY000: There is no OLD row in on INSERT trigger 67DROP TABLE t1,t2,t3; 68CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL); 69INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 70CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL); 71CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL); 72INSERT INTO t3 VALUES(1,0); 73CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 74INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 75UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 76END// 77ERROR HY000: There is no OLD row in on INSERT trigger 78DROP TABLE t1,t2,t3; 79CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE); 80INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 81CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE); 82CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE); 83INSERT INTO t3 VALUES(1,0); 84CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 85INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 86UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 87END// 88ERROR HY000: There is no OLD row in on INSERT trigger 89DROP TABLE t1,t2,t3; 90CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT); 91INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 92CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT); 93CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT); 94INSERT INTO t3 VALUES(1,0); 95CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 96INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 97UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 98END// 99ERROR HY000: There is no OLD row in on INSERT trigger 100DROP TABLE t1,t2,t3; 101CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL); 102INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 103CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL); 104CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL); 105INSERT INTO t3 VALUES(1,0); 106CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 107INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 108UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 109END// 110ERROR HY000: There is no OLD row in on INSERT trigger 111DROP TABLE t1,t2,t3; 112CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC); 113INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 114CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC); 115CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC); 116INSERT INTO t3 VALUES(1,0); 117CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN 118INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 119UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 120END// 121ERROR HY000: There is no OLD row in on INSERT trigger 122DROP TABLE t1,t2,t3; 123CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT); 124INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 125CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 TINYINT, new1 TINYINT, old2 TINYINT, new2 TINYINT); 126CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT); 127INSERT INTO t3 VALUES(1,0); 128CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 129INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 130UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 131END// 132ERROR HY000: There is no OLD row in on INSERT trigger 133DROP TABLE t1,t2,t3; 134CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT); 135INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 136CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT); 137CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT); 138INSERT INTO t3 VALUES(1,0); 139CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 140INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 141UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 142END// 143ERROR HY000: There is no OLD row in on INSERT trigger 144DROP TABLE t1,t2,t3; 145CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT); 146INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 147CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT); 148CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT); 149INSERT INTO t3 VALUES(1,0); 150CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 151INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 152UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 153END// 154ERROR HY000: There is no OLD row in on INSERT trigger 155DROP TABLE t1,t2,t3; 156CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT); 157INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 158CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT); 159CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT); 160INSERT INTO t3 VALUES(1,0); 161CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 162INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 163UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 164END// 165ERROR HY000: There is no OLD row in on INSERT trigger 166DROP TABLE t1,t2,t3; 167CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER); 168INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 169CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER); 170CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER); 171INSERT INTO t3 VALUES(1,0); 172CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 173INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 174UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 175END// 176ERROR HY000: There is no OLD row in on INSERT trigger 177DROP TABLE t1,t2,t3; 178CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT); 179INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 180CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT); 181CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT); 182INSERT INTO t3 VALUES(1,0); 183CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 184INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 185UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 186END// 187ERROR HY000: There is no OLD row in on INSERT trigger 188DROP TABLE t1,t2,t3; 189CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL); 190INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 191CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL); 192CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL); 193INSERT INTO t3 VALUES(1,0); 194CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 195INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 196UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 197END// 198ERROR HY000: There is no OLD row in on INSERT trigger 199DROP TABLE t1,t2,t3; 200CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE); 201INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 202CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE); 203CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE); 204INSERT INTO t3 VALUES(1,0); 205CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 206INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 207UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 208END// 209ERROR HY000: There is no OLD row in on INSERT trigger 210DROP TABLE t1,t2,t3; 211CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT); 212INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 213CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT); 214CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT); 215INSERT INTO t3 VALUES(1,0); 216CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 217INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 218UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 219END// 220ERROR HY000: There is no OLD row in on INSERT trigger 221DROP TABLE t1,t2,t3; 222CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL); 223INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 224CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL); 225CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL); 226INSERT INTO t3 VALUES(1,0); 227CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 228INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 229UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 230END// 231ERROR HY000: There is no OLD row in on INSERT trigger 232DROP TABLE t1,t2,t3; 233CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC); 234INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 235CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC); 236CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC); 237INSERT INTO t3 VALUES(1,0); 238CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN 239INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c1,NEW.c2); 240UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 241END// 242ERROR HY000: There is no OLD row in on INSERT trigger 243DROP TABLE t1,t2,t3; 244