Update of /cvsroot/monetdb/sql/src/test
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv30919
Modified Files:
like_tests.sql
Log Message:
Make it transaction independent.
U like_tests.sql
Index: like_tests.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/like_tests.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- like_tests.sql 5 Jan 2005 16:23:03 -0000 1.3
+++ like_tests.sql 6 Jun 2009 19:15:58 -0000 1.4
@@ -1,75 +1,73 @@
-START TRANSACTION;
-
-- create our table to test with
-CREATE TABLE like_test (
+CREATE TABLE liketable (
str varchar(20)
);
-- insert some dull values
-INSERT INTO like_test VALUES ('');
-INSERT INTO like_test VALUES ('t');
-INSERT INTO like_test VALUES ('ts');
-INSERT INTO like_test VALUES ('tsz');
+INSERT INTO liketable VALUES ('');
+INSERT INTO liketable VALUES ('t');
+INSERT INTO liketable VALUES ('ts');
+INSERT INTO liketable VALUES ('tsz');
-- insert some interesting values
-INSERT INTO like_test VALUES ('a math assignment');
-INSERT INTO like_test VALUES ('pathfinder is fun!');
+INSERT INTO liketable VALUES ('a math assignment');
+INSERT INTO liketable VALUES ('pathfinder is fun!');
-- insert some non-normal life values
-INSERT INTO like_test VALUES ('123123123');
-INSERT INTO like_test VALUES ('123123456123');
-INSERT INTO like_test VALUES ('199993456123');
-INSERT INTO like_test VALUES ('123456123456');
-INSERT INTO like_test VALUES ('123454321');
+INSERT INTO liketable VALUES ('123123123');
+INSERT INTO liketable VALUES ('123123456123');
+INSERT INTO liketable VALUES ('199993456123');
+INSERT INTO liketable VALUES ('123456123456');
+INSERT INTO liketable VALUES ('123454321');
-- see if everything is in the table
-SELECT * FROM like_test;
+SELECT * FROM liketable;
-- check for a string that starts with a 't' and is two chars long
-SELECT * FROM like_test WHERE str LIKE 't_';
+SELECT * FROM liketable WHERE str LIKE 't_';
-- simple, this should only match the first interesting value
-SELECT * FROM like_test WHERE str LIKE '%math%';
+SELECT * FROM liketable WHERE str LIKE '%math%';
-- more complicated; find values that match the given patterns
-SELECT * FROM like_test WHERE str LIKE 'a%math%';
-SELECT * FROM like_test WHERE str LIKE 'a_math%';
-SELECT * FROM like_test WHERE str LIKE '%m_th_a%t';
-SELECT * FROM like_test WHERE str LIKE '%at%_!';
+SELECT * FROM liketable WHERE str LIKE 'a%math%';
+SELECT * FROM liketable WHERE str LIKE 'a_math%';
+SELECT * FROM liketable WHERE str LIKE '%m_th_a%t';
+SELECT * FROM liketable WHERE str LIKE '%at%_!';
-- exhaustive?
-- head match
-SELECT * FROM like_test WHERE str LIKE '1%';
-SELECT * FROM like_test WHERE str LIKE '3%';
+SELECT * FROM liketable WHERE str LIKE '1%';
+SELECT * FROM liketable WHERE str LIKE '3%';
-- tail match
-SELECT * FROM like_test WHERE str LIKE '%1';
-SELECT * FROM like_test WHERE str LIKE '%3';
+SELECT * FROM liketable WHERE str LIKE '%1';
+SELECT * FROM liketable WHERE str LIKE '%3';
-- head/tail match
-SELECT * FROM like_test WHERE str LIKE '1%1';
-SELECT * FROM like_test WHERE str LIKE '1%3';
-SELECT * FROM like_test WHERE str LIKE '3%1';
-SELECT * FROM like_test WHERE str LIKE '3%3';
+SELECT * FROM liketable WHERE str LIKE '1%1';
+SELECT * FROM liketable WHERE str LIKE '1%3';
+SELECT * FROM liketable WHERE str LIKE '3%1';
+SELECT * FROM liketable WHERE str LIKE '3%3';
-- body match
-SELECT * FROM like_test WHERE str LIKE '%1%';
-SELECT * FROM like_test WHERE str LIKE '%12%';
-SELECT * FROM like_test WHERE str LIKE '%13%';
-SELECT * FROM like_test WHERE str LIKE '%454%';
+SELECT * FROM liketable WHERE str LIKE '%1%';
+SELECT * FROM liketable WHERE str LIKE '%12%';
+SELECT * FROM liketable WHERE str LIKE '%13%';
+SELECT * FROM liketable WHERE str LIKE '%454%';
-- float match
-SELECT * FROM like_test WHERE str LIKE '%2%2%';
+SELECT * FROM liketable WHERE str LIKE '%2%2%';
-- deeper insights, fairly specific matches
-SELECT * FROM like_test WHERE str LIKE '_2_3%123';
-SELECT * FROM like_test WHERE str LIKE '_123%3';
+SELECT * FROM liketable WHERE str LIKE '_2_3%123';
+SELECT * FROM liketable WHERE str LIKE '_123%3';
-- attention: this one should match on 123123456123, it is tricky because
-- if you match the first 1, it won't match...
-SELECT * FROM like_test WHERE str LIKE '%1_3456%';
+SELECT * FROM liketable WHERE str LIKE '%1_3456%';
-- attention: this one shows why the above like expression returns the
-- correct answer... the _ is treated as {1,*} not {1}
-SELECT * FROM like_test WHERE str LIKE '_3456%';
+SELECT * FROM liketable WHERE str LIKE '_3456%';
-- another simple way to give the like processor a hard time
-SELECT * FROM like_test WHERE str LIKE '%23';
+SELECT * FROM liketable WHERE str LIKE '%23';
-- test the ESCAPE statement
-SELECT * FROM like_test WHERE str LIKE '%' ESCAPE '?';
-SELECT * FROM like_test WHERE str LIKE '?%' ESCAPE '?';
+SELECT * FROM liketable WHERE str LIKE '%' ESCAPE '?';
+SELECT * FROM liketable WHERE str LIKE '?%' ESCAPE '?';
-- test with an ESCAPE character that has a special meaning in a reg exp
-SELECT * FROM like_test WHERE str LIKE '.%' ESCAPE '.';
-SELECT * FROM like_test WHERE str LIKE '..' ESCAPE '.';
+SELECT * FROM liketable WHERE str LIKE '.%' ESCAPE '.';
+SELECT * FROM liketable WHERE str LIKE '..' ESCAPE '.';
-- test whether escaping the ESCAPE character actually works
-SELECT * FROM like_test WHERE str LIKE 'tt' ESCAPE 't';
+SELECT * FROM liketable WHERE str LIKE 'tt' ESCAPE 't';
-- clean up mess we made
-ROLLBACK;
+drop table liketable;
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
