| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/parts/r/ |
| H A D | partition-dml-1-2-myisam.result | 22 PARTITION `p300-2999` VALUES LESS THAN (3000)
54 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
55 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
56 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
57 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
86 PARTITION `p300-2999` VALUES LESS THAN (3000)
101 DECLARE cur1 CURSOR FOR SELECT * FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-29999…
169 301 (p300-2999-)subp8
170 302 (p300-2999-)subp8
171 303 (p300-2999-)subp8
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/parts/r/ |
| H A D | partition-dml-1-2-myisam.result | 22 PARTITION `p300-2999` VALUES LESS THAN (3000)
54 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
55 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
56 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
57 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
86 PARTITION `p300-2999` VALUES LESS THAN (3000)
101 DECLARE cur1 CURSOR FOR SELECT * FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-29999…
169 301 (p300-2999-)subp8
170 302 (p300-2999-)subp8
171 303 (p300-2999-)subp8
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/parts/r/ |
| H A D | partition-dml-1-2-myisam.result | 22 PARTITION `p300-2999` VALUES LESS THAN (3000)
54 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
55 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
56 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
57 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
86 PARTITION `p300-2999` VALUES LESS THAN (3000)
101 DECLARE cur1 CURSOR FOR SELECT * FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-29999…
169 301 (p300-2999-)subp8
170 302 (p300-2999-)subp8
171 303 (p300-2999-)subp8
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/parts/r/ |
| H A D | partition-dml-1-2-myisam.result | 22 PARTITION `p300-2999` VALUES LESS THAN (3000)
54 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
55 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
56 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
57 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
86 PARTITION `p300-2999` VALUES LESS THAN (3000)
101 DECLARE cur1 CURSOR FOR SELECT * FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-29999…
169 301 (p300-2999-)subp8
170 302 (p300-2999-)subp8
171 303 (p300-2999-)subp8
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/parts/r/ |
| H A D | partition-dml-1-2-myisam.result | 22 PARTITION `p300-2999` VALUES LESS THAN (3000)
54 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
55 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
56 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
57 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
86 PARTITION `p300-2999` VALUES LESS THAN (3000)
101 DECLARE cur1 CURSOR FOR SELECT * FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-29999…
169 301 (p300-2999-)subp8
170 302 (p300-2999-)subp8
171 303 (p300-2999-)subp8
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 32 SELECT * FROM t1 PARTITION (`p300-2999`);
33 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
35 SELECT * FROM t1 PARTITION (`p300-2999`);
65 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
75 SELECT * FROM t2 PARTITION (`p300-2999`);
76 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
77 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 49 SELECT * FROM t1 PARTITION (`p300-2999`);
50 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
52 SELECT * FROM t1 PARTITION (`p300-2999`);
82 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
96 SELECT * FROM t2 PARTITION (`p300-2999`);
97 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
98 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 32 SELECT * FROM t1 PARTITION (`p300-2999`);
33 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
35 SELECT * FROM t1 PARTITION (`p300-2999`);
65 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
75 SELECT * FROM t2 PARTITION (`p300-2999`);
76 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
77 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 49 SELECT * FROM t1 PARTITION (`p300-2999`);
50 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
52 SELECT * FROM t1 PARTITION (`p300-2999`);
82 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
96 SELECT * FROM t2 PARTITION (`p300-2999`);
97 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
98 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 33 SELECT * FROM t1 PARTITION (`p300-2999`);
34 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
36 SELECT * FROM t1 PARTITION (`p300-2999`);
66 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
76 SELECT * FROM t2 PARTITION (`p300-2999`);
77 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
78 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 51 SELECT * FROM t1 PARTITION (`p300-2999`);
52 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
54 SELECT * FROM t1 PARTITION (`p300-2999`);
84 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
98 SELECT * FROM t2 PARTITION (`p300-2999`);
99 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
100 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 34 SELECT * FROM t1 PARTITION (`p300-2999`);
35 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
37 SELECT * FROM t1 PARTITION (`p300-2999`);
67 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
77 SELECT * FROM t2 PARTITION (`p300-2999`);
78 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
79 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 56 SELECT * FROM t1 PARTITION (`p300-2999`);
57 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
59 SELECT * FROM t1 PARTITION (`p300-2999`);
89 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
103 SELECT * FROM t2 PARTITION (`p300-2999`);
104 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
105 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 34 SELECT * FROM t1 PARTITION (`p300-2999`);
35 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
37 SELECT * FROM t1 PARTITION (`p300-2999`);
67 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
77 SELECT * FROM t2 PARTITION (`p300-2999`);
78 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
79 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 56 SELECT * FROM t1 PARTITION (`p300-2999`);
57 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
59 SELECT * FROM t1 PARTITION (`p300-2999`);
89 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
103 SELECT * FROM t2 PARTITION (`p300-2999`);
104 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
105 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 32 SELECT * FROM t1 PARTITION (`p300-2999`);
33 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
35 SELECT * FROM t1 PARTITION (`p300-2999`);
65 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
75 SELECT * FROM t2 PARTITION (`p300-2999`);
76 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
77 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 49 SELECT * FROM t1 PARTITION (`p300-2999`);
50 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
52 SELECT * FROM t1 PARTITION (`p300-2999`);
82 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
96 SELECT * FROM t2 PARTITION (`p300-2999`);
97 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
98 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 34 SELECT * FROM t1 PARTITION (`p300-2999`);
35 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
37 SELECT * FROM t1 PARTITION (`p300-2999`);
67 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
77 SELECT * FROM t2 PARTITION (`p300-2999`);
78 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
79 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 56 SELECT * FROM t1 PARTITION (`p300-2999`);
57 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
59 SELECT * FROM t1 PARTITION (`p300-2999`);
89 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
103 SELECT * FROM t2 PARTITION (`p300-2999`);
104 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
105 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 34 SELECT * FROM t1 PARTITION (`p300-2999`);
35 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
37 SELECT * FROM t1 PARTITION (`p300-2999`);
67 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
77 SELECT * FROM t2 PARTITION (`p300-2999`);
78 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
79 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| H A D | partition-dml-1-11.inc | 56 SELECT * FROM t1 PARTITION (`p300-2999`);
57 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
59 SELECT * FROM t1 PARTITION (`p300-2999`);
89 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
103 SELECT * FROM t2 PARTITION (`p300-2999`);
104 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
105 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 34 SELECT * FROM t1 PARTITION (`p300-2999`);
35 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
37 SELECT * FROM t1 PARTITION (`p300-2999`);
67 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
77 SELECT * FROM t2 PARTITION (`p300-2999`);
78 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
79 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 32 SELECT * FROM t1 PARTITION (`p300-2999`);
33 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
35 SELECT * FROM t1 PARTITION (`p300-2999`);
65 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
75 SELECT * FROM t2 PARTITION (`p300-2999`);
76 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
77 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 34 SELECT * FROM t1 PARTITION (`p300-2999`);
35 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
37 SELECT * FROM t1 PARTITION (`p300-2999`);
67 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
77 SELECT * FROM t2 PARTITION (`p300-2999`);
78 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
79 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/parts/inc/ |
| H A D | partition-dml-1-1.inc | 32 SELECT * FROM t1 PARTITION (`p300-2999`);
33 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
35 SELECT * FROM t1 PARTITION (`p300-2999`);
65 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
75 SELECT * FROM t2 PARTITION (`p300-2999`);
76 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
77 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
|