From 49aebb9891f075e0a5c53bdf76aba72fc6019e52 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 19 Jun 2004 13:26:39 +0300 Subject: cleanup for Item_func_regex (Bug #4199) mysql-test/r/func_regexp.result: test of cleaning regex in PS mysql-test/t/func_regexp.test: test of cleaning regex in PS sql/item_cmpfunc.cc: cleanup for Item_func_regex sql/item_cmpfunc.h: cleanup for Item_func_regex --- mysql-test/t/func_regexp.test | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'mysql-test/t/func_regexp.test') diff --git a/mysql-test/t/func_regexp.test b/mysql-test/t/func_regexp.test index edfa9afcfa6..1a771d466fa 100644 --- a/mysql-test/t/func_regexp.test +++ b/mysql-test/t/func_regexp.test @@ -60,3 +60,16 @@ select _koi8r 0xF7 regexp _koi8r '[[:alpha:]]'; select _latin1'a' regexp _latin1'A' collate latin1_general_ci; select _latin1'a' regexp _latin1'A' collate latin1_bin; + +# +# regexp cleanup() +# +create table t1 (a varchar(40)); +insert into t1 values ('C1'),('C2'),('R1'),('C3'),('R2'),('R3'); +prepare stmt1 from 'select a from t1 where a rlike ? order by a'; +set @a="^C.*"; +execute stmt1 using @a; +set @a="^R.*"; +execute stmt1 using @a; +deallocate prepare stmt1; +drop table t1; -- cgit v1.2.1