diff options
| author | Kentoku SHIBA <kentokushiba@gmail.com> | 2014-06-10 02:50:33 +0900 |
|---|---|---|
| committer | Kentoku SHIBA <kentokushiba@gmail.com> | 2014-06-10 02:50:33 +0900 |
| commit | 69a7022d596be53d040462393110d8ad852141d9 (patch) | |
| tree | a7a84fa3c2dc263937d87a2beefa3f6c725fb269 /storage/spider | |
| parent | de4441619c97b72319187dadd3fe4e7707afba41 (diff) | |
| download | mariadb-git-69a7022d596be53d040462393110d8ad852141d9.tar.gz | |
fix wrong result for Spider test
Diffstat (limited to 'storage/spider')
| -rw-r--r-- | storage/spider/mysql-test/spider/r/spider_fixes.result | 93 |
1 files changed, 44 insertions, 49 deletions
diff --git a/storage/spider/mysql-test/spider/r/spider_fixes.result b/storage/spider/mysql-test/spider/r/spider_fixes.result index c4100a5d046..6db61fa93d2 100644 --- a/storage/spider/mysql-test/spider/r/spider_fixes.result +++ b/storage/spider/mysql-test/spider/r/spider_fixes.result @@ -245,7 +245,7 @@ a b c direct order limit SHOW STATUS LIKE 'Spider_direct_order_limit'; Variable_name Value -Spider_direct_order_limit 2 +Spider_direct_order_limit 0 SELECT a, b, c FROM ta_l_int ORDER BY a LIMIT 3; a b c 1 2 4 @@ -253,7 +253,7 @@ a b c 3 4 5 SHOW STATUS LIKE 'Spider_direct_order_limit'; Variable_name Value -Spider_direct_order_limit 3 +Spider_direct_order_limit 0 2.26 lock tables @@ -297,83 +297,79 @@ PRIMARY KEY (id) INSERT INTO t1 () VALUES (); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -2 +777 SELECT MAX(id) FROM t1; MAX(id) -2 +777 INSERT INTO t1 () VALUES (); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -6 +1554 SELECT MAX(id) FROM t1; MAX(id) -6 +1554 INSERT INTO t1 (id) VALUES (null); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -10 +2331 SELECT MAX(id) FROM t1; MAX(id) -10 +2331 INSERT INTO t1 (id) VALUES (null); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -14 +3108 SELECT MAX(id) FROM t1; MAX(id) -14 +3108 INSERT INTO t1 () VALUES (),(),(),(); -Warnings: -Note 12520 Binlog's auto-inc value is probably different from linked table's auto-inc value -Note 12520 Binlog's auto-inc value is probably different from linked table's auto-inc value -Note 12520 Binlog's auto-inc value is probably different from linked table's auto-inc value SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -18 +3885 SELECT id FROM t1 ORDER BY id; id -2 -6 -10 -14 -18 -22 -26 -30 +777 +1554 +2331 +3108 +3885 +4662 +5439 +6216 SET INSERT_ID=5000; INSERT INTO t1 () VALUES (); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -34 +5000 SELECT MAX(id) FROM t1; MAX(id) -34 +6216 INSERT INTO t1 (id) VALUES (10000); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -38 +5000 SELECT MAX(id) FROM t1; MAX(id) -38 +10000 INSERT INTO t1 (id) VALUES (1000); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -42 +5000 SELECT MAX(id) FROM t1; MAX(id) -42 +10000 SELECT id FROM t1 ORDER BY id; id -2 -6 -10 -14 -18 -34 777 1000 1554 2331 +3108 +3885 +4662 +5000 +5439 +6216 10000 read only @@ -384,22 +380,22 @@ PRIMARY KEY (id) ) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_READONLY1_1 SELECT id FROM t1 ORDER BY id; id -2 -6 -10 -14 -18 -22 -26 -30 -34 -38 -42 +777 +1000 +1554 +2331 +3108 +3885 +4662 +5000 +5439 +6216 +10000 INSERT INTO t1 (id) VALUES (1); ERROR HY000: Table 'auto_test_local.t1' is read only -UPDATE t1 SET id = 4 WHERE id = 2; +UPDATE t1 SET id = 4 WHERE id = 777; ERROR HY000: Table 'auto_test_local.t1' is read only -DELETE FROM t1 WHERE id = 2; +DELETE FROM t1 WHERE id = 777; ERROR HY000: Table 'auto_test_local.t1' is read only DELETE FROM t1; ERROR HY000: Table 'auto_test_local.t1' is read only @@ -424,7 +420,6 @@ Error 1146 Table 'auto_test_remote.ter1_1' doesn't exist DELETE FROM t1; Warnings: Error 12702 Remote table 'auto_test_remote.ter1_1' is not found -Error 12702 Remote table 'auto_test_remote.ter1_1' is not found Error 1146 Table 'auto_test_remote.ter1_1' doesn't exist TRUNCATE t1; Warnings: |