Debian Codegraph @

mysql-test/suite/storage_engine/delete_ignore.test

raw
1 #
2 # DELETE IGNORE
3 #
4
5 --source have_engine.inc
6
7 --disable_warnings
8 DROP TABLE IF EXISTS t1,t2;
9 --enable_warnings
10
11 --let $create_definition = a $int_col, b $char_col
12 --source create_table.inc
13 INSERT INTO t1 (a,b) VALUES (10000,'foobar'),(1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
14 INSERT INTO t1 (a,b) SELECT a, b FROM t1;
15
16 --let $create_definition = c $char_col, d $int_col
17 --let $table_name = t2
18 --source create_table.inc
19 INSERT INTO t2 (c,d) SELECT b, a FROM t1;
20 --sorted_result
21 SELECT a,b FROM t1;
22 --sorted_result
23 SELECT c,d FROM t2;
24
25 DELETE IGNORE FROM t1 WHERE b IS NOT NULL ORDER BY a LIMIT 1;
26 if ($mysql_errname)
27 {
28 --let $functionality = DELETE IGNORE FROM ..
29 --source unexpected_result.inc
30 }
31 --sorted_result
32 SELECT a,b FROM t1;
33
34 DELETE IGNORE t1.*, t2.* FROM t1, t2 WHERE c < b OR a != ( SELECT 1 UNION SELECT 2 );
35 --sorted_result
36 SELECT a,b FROM t1;
37 --sorted_result
38 SELECT c,d FROM t2;
39
40 # Cleanup
41 DROP TABLE t1, t2;
42
43 --source cleanup_engine.inc
44