Update of /cvsroot/monetdb/sql/src/test
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv29027/src/test
Modified Files:
string.sql
Log Message:
propagated changes of Tuesday Dec 11 2007 - Tuesday Dec 18 2007
from the SQL_2-20 branch to the development trunk
Index: string.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/string.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- string.sql 19 Aug 2004 17:36:57 -0000 1.2
+++ string.sql 18 Dec 2007 10:49:13 -0000 1.3
@@ -2,13 +2,15 @@
insert into test values ('', 'test');
insert into test values ('test', '');
insert into test values ('','');
-insert into test values (' test ','');
+insert into test values (' Test ','');
select * from test;
select length(str), str from test;
select substring(str from 2 for 8), str2 from test;
select substring(str, 2, 8), str2 from test;
+select substring(str from 2 for 1), str2 from test;
+select substring(str, 2, 1), str2 from test;
select substring(str from 2), str2 from test;
select substring(str, 2), str2 from test;
@@ -18,8 +20,8 @@
select ascii(str), str from test;
select code(ascii(str)), str from test;
-select left(str,4), str from test;
-select right(str,4), str from test;
+select left(str,3), str from test;
+select right(str,3), str from test;
select lower(str), str from test;
select lcase(str), str from test;
@@ -30,12 +32,19 @@
select ltrim(str), str from test;
select rtrim(str), str from test;
-select insert(str,2,4,str2) from test;
-select replace(str,str2,str) from test;
+select insert(str,2,4,str2), str, str2 from test;
+select replace(str,'t',str), str, str2 from test;
select repeat(str,4), str from test;
select ascii(4), str from test;
-select str,str2,soundex(str),soundex(str2),
editdistance2(soundex(str),soundex(str2)), difference(str,str2) from test;
+select str,str2,soundex(str),soundex(str2),
editdistance2(soundex(str),soundex(str2)),
editdistance(soundex(str),soundex(str2)), difference(str,str2) from test;
+
+insert into test values ('monetdbiscool', 'coolismonetdb');
+select levenshtein(str,str2, 1, 2, 3), str, str2 from test;
+
+insert into test values ('monetdb45is+ cool', ' 123123 123123 ');
+select qgramnormalize(str) , qgramnormalize(str2), str, str2 from test;
+
drop table test;
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
