Debian Codegraph @

mysql-test/suite/s3/clone.test

raw
1 --source include/have_s3.inc
2 --source include/have_sequence.inc
3 --source include/have_innodb.inc
4
5 --echo #
6 --echo # SELECT using ror_merged scan fails with s3 tables
7 --echo #
8
9 DROP TABLE IF EXISTS t1;
10 CREATE TABLE t1 (a INT, b INT, KEY(a), KEY(b)) ENGINE=Aria;
11 INSERT INTO t1 VALUES (0,0),(0,10),(3,10);
12 ALTER TABLE t1 ENGINE=S3;
13 SELECT * FROM t1 WHERE a = 99 OR b = 2;
14 DROP TABLE t1;