diff options
Diffstat (limited to 'mysql-test/r/blackhole.result')
| -rw-r--r-- | mysql-test/r/blackhole.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/blackhole.result b/mysql-test/r/blackhole.result index f6003eca412..20018dcb089 100644 --- a/mysql-test/r/blackhole.result +++ b/mysql-test/r/blackhole.result @@ -20,6 +20,8 @@ fld5 char(35) DEFAULT '' NOT NULL, fld6 char(4) DEFAULT '' NOT NULL, primary key (auto) ) ENGINE=blackhole; +INSERT INTO t2 VALUES (1192,068305,00,'Colombo','hardware','colicky',''); +INSERT INTO t2 VALUES (1193,000000,00,'nondecreasing','implant','thrillingly',''); select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%"; fld3 select fld3 from t2 where fld3 like "%cultivation" ; @@ -81,3 +83,4 @@ Full-text indexes are called collections Only MyISAM tables support collections select * from t1 where MATCH(a,b) AGAINST ("only"); a b +drop table if exists t1,t2; |