diff options
Diffstat (limited to 'myisam/ftbench/Ecreate.pl')
-rwxr-xr-x | myisam/ftbench/Ecreate.pl | 44 |
1 files changed, 0 insertions, 44 deletions
diff --git a/myisam/ftbench/Ecreate.pl b/myisam/ftbench/Ecreate.pl deleted file mode 100755 index d90a6f7a0ad..00000000000 --- a/myisam/ftbench/Ecreate.pl +++ /dev/null @@ -1,44 +0,0 @@ -#!/usr/bin/perl - -$test=shift || die "Usage $0 testname [option]"; -$option=shift; - -open(D, "<data/$test.d") || die "Cannot open(<data/$test.d): $!"; -open(Q, "<data/$test.q") || die "Cannot open(<data/$test.q): $!"; - -$N=0; - -print <<__HEADER__; -DROP TABLE IF EXISTS $test; -CREATE TABLE $test ( - id int(10) unsigned NOT NULL, - text text NOT NULL, - FULLTEXT KEY text (text) -) TYPE=MyISAM CHARSET=latin1; - -ALTER TABLE $test DISABLE KEYS; -__HEADER__ - -while (<D>) { chomp; - s/'/\\'/g; ++$N; - print "INSERT $test VALUES ($N, '$_');\n"; -} - -print <<__PREP__; -ALTER TABLE $test ENABLE KEYS; -SELECT $N; -__PREP__ - -$N=0; - -while (<Q>) { chomp; - s/'/\\'/g; ++$N; - $_="MATCH text AGAINST ('$_' $option)"; - print "SELECT $N, id, $_ FROM $test WHERE $_;\n"; -} - -print <<__FOOTER__; -DROP TABLE $test; -__FOOTER__ - - |