diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2018-09-24 20:37:22 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2018-09-24 20:37:22 +0200 |
| commit | 339edd462f519573b1c505fb99fdbfc3bc765b5a (patch) | |
| tree | 98fb6fb1e14ea4a8248dbe64c53518798f93a8cd /storage/spider/mysql-test | |
| parent | dcbd51cee628d8d8fec9ff5476a6afc855b007aa (diff) | |
| download | mariadb-git-339edd462f519573b1c505fb99fdbfc3bc765b5a.tar.gz | |
fixed auto-merge gone bad
Diffstat (limited to 'storage/spider/mysql-test')
| -rw-r--r-- | storage/spider/mysql-test/spider/r/spider_fixes_part.result | 48 |
1 files changed, 0 insertions, 48 deletions
diff --git a/storage/spider/mysql-test/spider/r/spider_fixes_part.result b/storage/spider/mysql-test/spider/r/spider_fixes_part.result index d1a28d64a04..d2367af9bbd 100644 --- a/storage/spider/mysql-test/spider/r/spider_fixes_part.result +++ b/storage/spider/mysql-test/spider/r/spider_fixes_part.result @@ -263,54 +263,6 @@ a b c d e f 51ECF2C0CD3C48D99C91792E99D3C1A0 017B8A460DBC444682B791305EF75356 51041110620308 2018-08-02 13:48:29 510411 0 093B37A93A534DF883787AF5F6799674 996C7F14989D480589A553717D735E3E 51041110620302 2018-08-02 13:48:30 510411 0 -Test ORDER BY with LIMIT and OFFSET -CREATE TABLE ta_ob ( -a VARCHAR(50) NOT NULL, -b VARCHAR(50) NULL DEFAULT NULL, -c VARCHAR(100) NULL DEFAULT NULL, -d DATETIME(0) NULL DEFAULT NULL, -e INT(11) NOT NULL, -f INT(10) NULL DEFAULT NULL, -PRIMARY KEY (a, e) -) ENGINE=Spider COMMENT='database "auto_test_remote", table "ta_ob"' - PARTITION BY LIST COLUMNS (e) PARTITIONS 1 -(PARTITION pt1 values in (510411) COMMENT = 'srv "s_2_1"') -INSERT INTO ta_ob VALUES ('0B95CD65DF994BC9A09A6AABE53A2733', -'6CFED89FF6A84C7AA55C3C432663D094', -'51041110620304', '2018-08-02 13:41:13', -510411, 1); -INSERT INTO ta_ob VALUES ('15E8D55EF099443BAEE639E60A4650BD', -'879DC2A0B6AC46D9A62E8EA47E2970F2', -'51041110620301', NULL, -510411, 0); -INSERT INTO ta_ob VALUES ('51ECF2C0CD3C48D99C91792E99D3C1A0', -'017B8A460DBC444682B791305EF75356', -'51041110620308', '2018-08-02 13:48:29', -510411, 0); -INSERT INTO ta_ob VALUES ('093B37A93A534DF883787AF5F6799674', -'996C7F14989D480589A553717D735E3E', -'51041110620302', '2018-08-02 13:48:30', -510411, 0); -INSERT INTO ta_ob VALUES ('53F5266FB069499AB6234755CACA2583', -'017B8A460DBC444682B791305EF75356', -'51041110620308', '2018-08-02 13:48:28', -510411, 0); -INSERT INTO ta_ob VALUES ('56E59BC4BDC143868D4A219C2D07A24B', -'821E71E6ABB4404EBAA349BB681089F8', -'51041110620310', '2018-08-02 13:48:27', -510411, 0); -INSERT INTO ta_ob VALUES ('56B68DA68D6D4A04A08B453D09AD7B70', -'821E71E6ABB4404EBAA349BB681089F8', -'51041110620310', '2018-08-02 13:48:28', -510411, 0); -SELECT * FROM ta_ob WHERE c LIKE "%510411106%" AND e = 510411 AND f != 1 ORDER BY d,c LIMIT 5 OFFSET 1; -a b c d e f -56E59BC4BDC143868D4A219C2D07A24B 821E71E6ABB4404EBAA349BB681089F8 51041110620310 2018-08-02 13:48:27 510411 0 -53F5266FB069499AB6234755CACA2583 017B8A460DBC444682B791305EF75356 51041110620308 2018-08-02 13:48:28 510411 0 -56B68DA68D6D4A04A08B453D09AD7B70 821E71E6ABB4404EBAA349BB681089F8 51041110620310 2018-08-02 13:48:28 510411 0 -51ECF2C0CD3C48D99C91792E99D3C1A0 017B8A460DBC444682B791305EF75356 51041110620308 2018-08-02 13:48:29 510411 0 -093B37A93A534DF883787AF5F6799674 996C7F14989D480589A553717D735E3E 51041110620302 2018-08-02 13:48:30 510411 0 - deinit connection master_1; DROP DATABASE IF EXISTS auto_test_local; |