Update of /cvsroot/monetdb/MonetDB5/src/mal/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv5179/src/mal/Tests
Modified Files:
tst049.mal tst049.stable.out tst285.mal tst285.stable.out
tst450.stable.out tst960.mal tst960.stable.out
Log Message:
(re)introduced module batstr (as opt_remap needs simple translation from
single value at a time module into bluk version module name). Example
str.trim into batstr.trim. This make a lot of functions in sql a lot faster.
Fixed a couple of variable atom referencing bugs in batstr.mx
added a mal function for the new rangejoin to algebra.mx
opt_mergetable got lots of fixes
Index: tst960.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/tst960.stable.out,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -d -r1.14 -r1.15
--- tst960.stable.out 9 Feb 2007 23:08:05 -0000 1.14
+++ tst960.stable.out 21 Dec 2007 15:29:35 -0000 1.15
@@ -59,31 +59,31 @@
bat.append(S,"new"); # 5 BKCappend_val_wrap
(_9:void)<-(S:bat[:oid,:str])(_10:str)
bat.append(S,"world"); # 6 BKCappend_val_wrap
(_11:void)<-(S:bat[:oid,:str])(_12:str)
io.print(S); # 7 IOprint_val (_13:void)<-(S:bat[:oid,:str])
- L := batcalc.length(S); # 8 STRbatLength
(L:bat[:oid,:int])<-(S:bat[:oid,:str])
+ L := batstr.length(S); # 8 STRbatLength
(L:bat[:oid,:int])<-(S:bat[:oid,:str])
io.print(L); # 9 IOprint_val (_15:void)<-(L:bat[:oid,:int])
- L := batcalc.nbytes(S); # 10 STRbatBytes
(L:bat[:oid,:int])<-(S:bat[:oid,:str])
+ L := batstr.nbytes(S); # 10 STRbatBytes
(L:bat[:oid,:int])<-(S:bat[:oid,:str])
io.print(L); # 11 IOprint_val (_16:void)<-(L:bat[:oid,:int])
B := batcalc.==(S,"hello"); # 12 STRbatEqualCst
(B:bat[:oid,:bit])<-(S:bat[:oid,:str])(_6:str)
io.print(B); # 13 IOprint_val (_18:void)<-(B:bat[:oid,:bit])
- B := batcalc.match(S,"hello"); # 14 STRbatmatchCst
(B:bat[:oid,:bit])<-(S:bat[:oid,:str])(_6:str)
- io.print(B); # 15 IOprint_val (_19:void)<-(B:bat[:oid,:bit])
- U := batcalc.toUpper(S); # 16 STRbatUpper
(U:bat[:oid,:str])<-(S:bat[:oid,:str])
- io.print(U); # 17 IOprint_val (_21:void)<-(U:bat[:oid,:str])
- l := batcalc.toLower(U); # 18 STRbatLower
(l:bat[:oid,:str])<-(U:bat[:oid,:str])
- io.print(l); # 19 IOprint_val (_23:void)<-(l:bat[:oid,:str])
- trim := batcalc.trim(S); # 20 STRbatStrip
(trim:bat[:oid,:str])<-(S:bat[:oid,:str])
- io.print(trim); # 21 IOprint_val (_25:void)<-(trim:bat[:oid,:str])
- ltrim := batcalc.ltrim(S); # 22 STRbatLtrim
(ltrim:bat[:oid,:str])<-(S:bat[:oid,:str])
- io.print(ltrim); # 23 IOprint_val (_27:void)<-(ltrim:bat[:oid,:str])
- rtrim := batcalc.rtrim(S); # 24 STRbatRtrim
(rtrim:bat[:oid,:str])<-(S:bat[:oid,:str])
- io.print(rtrim); # 25 IOprint_val (_29:void)<-(rtrim:bat[:oid,:str])
- io.print("Start searches"); # 26 IOprint_val (_30:void)<-(_31:str)
- srch := batcalc.search(S,"hello"); # 27 STRbatstrSearchcst
(srch:bat[:oid,:int])<-(S:bat[:oid,:str])(_6:str)
- io.print(srch); # 28 IOprint_val (_33:void)<-(srch:bat[:oid,:int])
- srch := batcalc.search(S,S); # 29 STRbatstrSearch
(srch:bat[:oid,:int])<-(S:bat[:oid,:str])(S:bat[:oid,:str])
- io.print(srch); # 30 IOprint_val (_34:void)<-(srch:bat[:oid,:int])
+ C := batstr.like(S,"hello"); # 14 STRbatlike2
(C:bat[:oid,:oid])<-(S:bat[:oid,:str])(_6:str)
+ io.print(C); # 15 IOprint_val (_20:void)<-(C:bat[:oid,:oid])
+ U := batstr.toUpper(S); # 16 STRbatUpper
(U:bat[:oid,:str])<-(S:bat[:oid,:str])
+ io.print(U); # 17 IOprint_val (_22:void)<-(U:bat[:oid,:str])
+ l := batstr.toLower(U); # 18 STRbatLower
(l:bat[:oid,:str])<-(U:bat[:oid,:str])
+ io.print(l); # 19 IOprint_val (_24:void)<-(l:bat[:oid,:str])
+ trim := batstr.trim(S); # 20 STRbatStrip
(trim:bat[:oid,:str])<-(S:bat[:oid,:str])
+ io.print(trim); # 21 IOprint_val (_26:void)<-(trim:bat[:oid,:str])
+ ltrim := batstr.ltrim(S); # 22 STRbatLtrim
(ltrim:bat[:oid,:str])<-(S:bat[:oid,:str])
+ io.print(ltrim); # 23 IOprint_val (_28:void)<-(ltrim:bat[:oid,:str])
+ rtrim := batstr.rtrim(S); # 24 STRbatRtrim
(rtrim:bat[:oid,:str])<-(S:bat[:oid,:str])
+ io.print(rtrim); # 25 IOprint_val (_30:void)<-(rtrim:bat[:oid,:str])
+ io.print("Start searches"); # 26 IOprint_val (_31:void)<-(_32:str)
+ srch := batstr.search(S,"hello"); # 27 STRbatstrSearchcst
(srch:bat[:oid,:int])<-(S:bat[:oid,:str])(_6:str)
+ io.print(srch); # 28 IOprint_val (_34:void)<-(srch:bat[:oid,:int])
+ srch := batstr.search(S,S); # 29 STRbatstrSearch
(srch:bat[:oid,:int])<-(S:bat[:oid,:str])(S:bat[:oid,:str])
+ io.print(srch); # 30 IOprint_val (_35:void)<-(srch:bat[:oid,:int])
plus := batcalc.+(S,S); # 31 STRbatConcat
(plus:bat[:oid,:str])<-(S:bat[:oid,:str])(S:bat[:oid,:str])
- io.print(plus); # 32 IOprint_val (_36:void)<-(plus:bat[:oid,:str])
+ io.print(plus); # 32 IOprint_val (_37:void)<-(plus:bat[:oid,:str])
end main; # 33
#-------------------------#
# h tmp_13 # name
@@ -121,10 +121,7 @@
# h tmp_16 # name
# oid bit # type
#-----------------#
-[ [EMAIL PROTECTED], true ]
-[ [EMAIL PROTECTED], false ]
-[ [EMAIL PROTECTED], false ]
-[ [EMAIL PROTECTED], false ]
+[ [EMAIL PROTECTED], nil ]
#-------------------------#
# h tmp_14 # name
# void str # type
Index: tst285.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/tst285.stable.out,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -d -r1.13 -r1.14
--- tst285.stable.out 28 Dec 2006 22:16:11 -0000 1.13
+++ tst285.stable.out 21 Dec 2007 15:29:34 -0000 1.14
@@ -26,23 +26,22 @@
b := bat.new(:oid,:str); # 1 CMDBATnew
(b:bat[:oid,:str])<-(_2:oid)(_3:str)
bat.append(b,"hello"); # 2 BKCappend_val_wrap
(_4:void)<-(b:bat[:oid,:str])(_5:str)
bat.append(b,"goodbye"); # 3 BKCappend_val_wrap
(_6:void)<-(b:bat[:oid,:str])(_7:str)
- z1 := batcalc.match(b,"hel"); # 4 STRbatmatchCst
(z1:bat[:oid,:bit])<-(b:bat[:oid,:str])(_9:str)
- io.print(z1); # 5 IOprint_val (_10:void)<-(z1:bat[:oid,:bit])
- z2 := batcalc.match(b,".*[ly].*"); # 6 STRbatmatchCst
(z2:bat[:oid,:bit])<-(b:bat[:oid,:str])(_12:str)
- io.print(z2); # 7 IOprint_val (_13:void)<-(z2:bat[:oid,:bit])
+ z1 := batstr.like(b,"%hel%"); # 4 STRbatlike2
(z1:bat[:oid,:oid])<-(b:bat[:oid,:str])(_9:str)
+ io.print(z1); # 5 IOprint_val (_10:void)<-(z1:bat[:oid,:oid])
+ z2 := pcre.uselect(".*[ly].*",b); # 6 PCREuselect
(z2:bat[:oid,:void])<-(_12:str)(b:bat[:oid,:str])
+ io.print(z2); # 7 IOprint_val (_13:void)<-(z2:bat[:oid,:void])
end main; # 8
#-----------------#
# h tmp_5 # name
# int bit # type
#-----------------#
-[ [EMAIL PROTECTED], true ]
-[ [EMAIL PROTECTED], false ]
+[ [EMAIL PROTECTED], nil ]
#-----------------#
# h tmp_6 # name
# int bit # type
#-----------------#
-[ [EMAIL PROTECTED], true ]
-[ [EMAIL PROTECTED], true ]
+[ [EMAIL PROTECTED], nil ]
+[ [EMAIL PROTECTED], nil ]
# 08:01:12 >
# 08:01:12 > Done.
Index: tst049.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/tst049.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- tst049.stable.out 28 Dec 2006 22:16:10 -0000 1.6
+++ tst049.stable.out 21 Dec 2007 15:29:34 -0000 1.7
@@ -123,49 +123,49 @@
io.print(i); # 27 IOprint_val (_53:void)<-(i:bit)
i := str.like("trx","t_"); # 28 STRlikewrap2 (i:bit)<-(_54:str)(_52:str)
io.print(i); # 29 IOprint_val (_55:void)<-(i:bit)
- z := batcalc.like(b,"t_"); # 30 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_52:str)
+ z := batstr.like(b,"t_"); # 30 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_52:str)
io.print(z); # 31 IOprint_val (_57:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%math%"); # 32 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_58:str)
+ z := batstr.like(b,"%math%"); # 32 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_58:str)
io.print(z); # 33 IOprint_val (_59:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%m_th_a%t"); # 34 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_60:str)
+ z := batstr.like(b,"%m_th_a%t"); # 34 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_60:str)
io.print(z); # 35 IOprint_val (_61:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%at%_!"); # 36 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_62:str)
+ z := batstr.like(b,"%at%_!"); # 36 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_62:str)
io.print(z); # 37 IOprint_val (_63:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"1%"); # 38 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_64:str)
+ z := batstr.like(b,"1%"); # 38 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_64:str)
io.print(z); # 39 IOprint_val (_65:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"3%"); # 40 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_66:str)
+ z := batstr.like(b,"3%"); # 40 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_66:str)
io.print(z); # 41 IOprint_val (_67:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%1"); # 42 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_68:str)
+ z := batstr.like(b,"%1"); # 42 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_68:str)
io.print(z); # 43 IOprint_val (_69:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%3"); # 44 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_70:str)
+ z := batstr.like(b,"%3"); # 44 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_70:str)
io.print(z); # 45 IOprint_val (_71:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%1%"); # 46 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_72:str)
+ z := batstr.like(b,"%1%"); # 46 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_72:str)
io.print(z); # 47 IOprint_val (_73:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%12%"); # 48 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_74:str)
+ z := batstr.like(b,"%12%"); # 48 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_74:str)
io.print(z); # 49 IOprint_val (_75:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%13%"); # 50 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_76:str)
+ z := batstr.like(b,"%13%"); # 50 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_76:str)
io.print(z); # 51 IOprint_val (_77:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%454%"); # 52 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_78:str)
+ z := batstr.like(b,"%454%"); # 52 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_78:str)
io.print(z); # 53 IOprint_val (_79:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%2%2%"); # 54 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_80:str)
+ z := batstr.like(b,"%2%2%"); # 54 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_80:str)
io.print(z); # 55 IOprint_val (_81:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"_2_3%123"); # 56 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_82:str)
+ z := batstr.like(b,"_2_3%123"); # 56 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_82:str)
io.print(z); # 57 IOprint_val (_83:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"_123%3"); # 58 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_84:str)
+ z := batstr.like(b,"_123%3"); # 58 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_84:str)
io.print(z); # 59 IOprint_val (_85:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%1_3456%"); # 60 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_86:str)
+ z := batstr.like(b,"%1_3456%"); # 60 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_86:str)
io.print(z); # 61 IOprint_val (_87:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"_3456%"); # 62 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_88:str)
+ z := batstr.like(b,"_3456%"); # 62 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_88:str)
io.print(z); # 63 IOprint_val (_89:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%23"); # 64 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_90:str)
+ z := batstr.like(b,"%23"); # 64 STRbatlike2
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_90:str)
io.print(z); # 65 IOprint_val (_91:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"%","?"); # 66 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_92:str)(_93:str)
+ z := batstr.like(b,"%","?"); # 66 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_92:str)(_93:str)
io.print(z); # 67 IOprint_val (_94:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"?%","?"); # 68 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_95:str)(_93:str)
+ z := batstr.like(b,"?%","?"); # 68 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_95:str)(_93:str)
io.print(z); # 69 IOprint_val (_96:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,".%","."); # 70 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_97:str)(_98:str)
+ z := batstr.like(b,".%","."); # 70 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_97:str)(_98:str)
io.print(z); # 71 IOprint_val (_99:void)<-(z:bat[:oid,:oid])
- z := batcalc.like(b,"tt","t"); # 72 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_100:str)(_101:str)
+ z := batstr.like(b,"tt","t"); # 72 STRbatlike
(z:bat[:oid,:oid])<-(b:bat[:oid,:str])(_100:str)(_101:str)
io.print(z); # 73 IOprint_val (_102:void)<-(z:bat[:oid,:oid])
end main; # 74
#---------------------------------#
Index: tst450.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/tst450.stable.out,v
retrieving revision 1.192
retrieving revision 1.193
diff -u -d -r1.192 -r1.193
--- tst450.stable.out 7 Nov 2007 21:18:37 -0000 1.192
+++ tst450.stable.out 21 Dec 2007 15:29:34 -0000 1.193
@@ -86,6 +86,7 @@
[ "batcolor", nil ]
[ "batmath", nil ]
[ "batmtime", nil ]
+[ "batstr", nil ]
[ "bbp", nil ]
[ "blob", nil ]
[ "box", nil ]
@@ -128,6 +129,7 @@
[ "timestamp", nil ]
[ "timezone", nil ]
[ "transaction", nil ]
+[ "txtsim", nil ]
[ "unix", nil ]
[ "url", nil ]
[ "user", nil ]
Index: tst960.mal
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/tst960.mal,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- tst960.mal 9 Feb 2007 23:08:05 -0000 1.9
+++ tst960.mal 21 Dec 2007 15:29:35 -0000 1.10
@@ -7,34 +7,34 @@
bat.append(S,"world");
io.print(S);
-L:= batcalc.length(S);
+L:= batstr.length(S);
io.print(L);
-L:= batcalc.nbytes(S);
+L:= batstr.nbytes(S);
io.print(L);
B:= batcalc.==(S,"hello");
io.print(B);
-B:= batcalc.match(S,"hello");
-io.print(B);
+C:= batstr.like(S,"hello");
+io.print(C);
-U:= batcalc.toUpper(S);
+U:= batstr.toUpper(S);
io.print(U);
-l:= batcalc.toLower(U);
+l:= batstr.toLower(U);
io.print(l);
-trim:= batcalc.trim(S);
+trim:= batstr.trim(S);
io.print(trim);
-ltrim:= batcalc.ltrim(S);
+ltrim:= batstr.ltrim(S);
io.print(ltrim);
-rtrim:= batcalc.rtrim(S);
+rtrim:= batstr.rtrim(S);
io.print(rtrim);
io.print("Start searches");
-srch:= batcalc.search(S,"hello");
+srch:= batstr.search(S,"hello");
io.print(srch);
-srch:= batcalc.search(S,S);
+srch:= batstr.search(S,S);
io.print(srch);
plus:= batcalc.+(S,S);
io.print(plus);
Index: tst285.mal
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/tst285.mal,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- tst285.mal 28 Dec 2006 22:16:11 -0000 1.7
+++ tst285.mal 21 Dec 2007 15:29:34 -0000 1.8
@@ -2,8 +2,8 @@
bat.append(b,"hello");
bat.append(b,"goodbye");
-z1:= batcalc.match(b,"hel");
+z1:= batstr.like(b,"%hel%");
io.print(z1);
-z2:= batcalc.match(b,".*[ly].*");
+z2:= pcre.uselect(".*[ly].*", b);
io.print(z2);
Index: tst049.mal
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/tst049.mal,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- tst049.mal 28 Dec 2006 22:16:10 -0000 1.4
+++ tst049.mal 21 Dec 2007 15:29:34 -0000 1.5
@@ -30,51 +30,51 @@
i:= str.like("trx","t_");
io.print(i);
-z:= batcalc.like(b,"t_");
+z:= batstr.like(b,"t_");
io.print(z);
-z:= batcalc.like(b,"%math%");
+z:= batstr.like(b,"%math%");
io.print(z);
-z:= batcalc.like(b,"%m_th_a%t");
+z:= batstr.like(b,"%m_th_a%t");
io.print(z);
-z:= batcalc.like(b,"%at%_!");
+z:= batstr.like(b,"%at%_!");
io.print(z);
-z:= batcalc.like(b,"1%");
+z:= batstr.like(b,"1%");
io.print(z);
-z:= batcalc.like(b,"3%");
+z:= batstr.like(b,"3%");
io.print(z);
-z:= batcalc.like(b,"%1");
+z:= batstr.like(b,"%1");
io.print(z);
-z:= batcalc.like(b,"%3");
+z:= batstr.like(b,"%3");
io.print(z);
-z:= batcalc.like(b,"%1%");
+z:= batstr.like(b,"%1%");
io.print(z);
-z:= batcalc.like(b,"%12%");
+z:= batstr.like(b,"%12%");
io.print(z);
-z:= batcalc.like(b,"%13%");
+z:= batstr.like(b,"%13%");
io.print(z);
-z:= batcalc.like(b,"%454%");
+z:= batstr.like(b,"%454%");
io.print(z);
-z:= batcalc.like(b,"%2%2%");
+z:= batstr.like(b,"%2%2%");
io.print(z);
-z:= batcalc.like(b,"_2_3%123");
+z:= batstr.like(b,"_2_3%123");
io.print(z);
-z:= batcalc.like(b,"_123%3");
+z:= batstr.like(b,"_123%3");
io.print(z);
-z:= batcalc.like(b,"%1_3456%");
+z:= batstr.like(b,"%1_3456%");
io.print(z);
-z:= batcalc.like(b,"_3456%");
+z:= batstr.like(b,"_3456%");
io.print(z);
-z:= batcalc.like(b,"%23");
+z:= batstr.like(b,"%23");
io.print(z);
-z:= batcalc.like(b,"%","?");
+z:= batstr.like(b,"%","?");
io.print(z);
-z:= batcalc.like(b,"?%","?");
+z:= batstr.like(b,"?%","?");
io.print(z);
-z:= batcalc.like(b,".%",".");
+z:= batstr.like(b,".%",".");
io.print(z);
-z:= batcalc.like(b,"tt","t");
+z:= batstr.like(b,"tt","t");
io.print(z);
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-checkins