1--source include/have_rocksdb.inc
2
3#
4# CHAR column types
5#
6
7--source type_char.inc
8
9# Issue #226
10CREATE TABLE t1(c1 CHAR(0) NOT NULL);
11INSERT INTO t1 VALUES('a');
12SELECT * FROM t1;
13DROP TABLE t1;
14
15# Issue #259
16CREATE TABLE t1(a char(10) character set utf8 collate utf8_bin primary key);
17INSERT INTO t1 VALUES ('one'),('two'),('three'),('four'),('five');
18(SELECT * FROM t1 LIMIT 1) UNION (SELECT * FROM t1);
19DROP TABLE t1;
20