~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
#
# Bug#38999 valgrind warnings for update statement in function compare_record()
#
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 values (1),(2),(3),(4),(5);
INSERT INTO t2 values (1);
SELECT * FROM t1 WHERE a = 2;
a
2
UPDATE t1 SET t1.a = t1.a + 100 WHERE t1.a = 1;
DROP TABLE t1,t2;