diff options
Diffstat (limited to 'mysql-test/suite/pbxt/r/pbxt_assertions.result')
| -rw-r--r-- | mysql-test/suite/pbxt/r/pbxt_assertions.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/pbxt/r/pbxt_assertions.result b/mysql-test/suite/pbxt/r/pbxt_assertions.result new file mode 100644 index 00000000000..e34b83c68e7 --- /dev/null +++ b/mysql-test/suite/pbxt/r/pbxt_assertions.result @@ -0,0 +1,14 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (c1 VARCHAR(255), c2 VARCHAR(255), c3 INT); +INSERT INTO t1 VALUES (REPEAT('x', 255), REPEAT('y', 255), 1); +INSERT INTO t1 VALUES (REPEAT('x', 255), REPEAT('y', 255), 2); +INSERT INTO t1 VALUES (REPEAT('x', 255), REPEAT('y', 255), 3); +SELECT COUNT(*) FROM t1; +COUNT(*) +3 +drop table if exists t1; +create table t1 (a int, unique index indexa (a)); +insert into t1 values (-1), (-4), (-2), (NULL); +select -10 IN (select a from t1 FORCE INDEX (indexa)); +-10 IN (select a from t1 FORCE INDEX (indexa)) +NULL |