summaryrefslogtreecommitdiff
path: root/mysql-test/r/blackhole.result
diff options
context:
space:
mode:
authorunknown <brian@zim.(none)>2005-03-24 16:07:56 -0800
committerunknown <brian@zim.(none)>2005-03-24 16:07:56 -0800
commit5434defee5c15b729ae4abe8566dcf694bd33059 (patch)
tree85dd501587537f24095503ccdd52448b183f83c1 /mysql-test/r/blackhole.result
parent8a99997d6061ec3e2d75616422eac413868ceada (diff)
downloadmariadb-git-5434defee5c15b729ae4abe8566dcf694bd33059.tar.gz
Collection of changes per Bar and Serg.
acinclude.m4: Change in message mysql-test/r/blackhole.result: Lowered the number of inserts. mysql-test/t/blackhole.test: Lowered the number of inserts. sql/ha_blackhole.cc: Added indexes per Serg, correction of indention, added asserts per Serg. sql/ha_blackhole.h: Indention fix, added methods for index...
Diffstat (limited to 'mysql-test/r/blackhole.result')
-rw-r--r--mysql-test/r/blackhole.result3
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;