204
204
SELECT * FROM t1;
208
# Bug#41348: INSERT INTO tbl SELECT * FROM temp_tbl overwrites locking type of temp table
212
DROP TABLE IF EXISTS t1,t2;
213
DROP FUNCTION IF EXISTS f1;
216
CREATE TEMPORARY TABLE t1 (a INT);
217
CREATE TEMPORARY TABLE t2 LIKE t1;
220
CREATE FUNCTION f1() RETURNS INT
226
INSERT INTO t2 SELECT * FROM t1;
227
INSERT INTO t1 SELECT f1();
229
CREATE TABLE t3 SELECT * FROM t1;
230
INSERT INTO t1 SELECT f1();
232
UPDATE t1,t2 SET t1.a = t2.a;
233
INSERT INTO t2 SELECT f1();
207
238
--echo End of 5.1 tests