Update of /cvsroot/monetdb/sql/src/test/copy/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15984/src/test/copy/Tests

Modified Files:
        null_as_string_errors.stable.err.Five 
Log Message:
added support for sql/xml namespaces
fixed bug in algebra version for handling exist/not exists in exists/not exists
with correlation 

added optimizer steps for algebra version to rewrite semi/anti joins followed
by joins on the same (referenced) relation into a single semijoin
push selects through semi/anti joins

approved tests



U null_as_string_errors.stable.err.Five
Index: null_as_string_errors.stable.err.Five
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/copy/Tests/null_as_string_errors.stable.err.Five,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- null_as_string_errors.stable.err.Five       13 Jun 2008 12:49:07 -0000      
1.3
+++ null_as_string_errors.stable.err.Five       28 Oct 2008 20:05:04 -0000      
1.4
@@ -10,32 +10,32 @@
 # 18:52:45 >  mclient -lsql -umonetdb -Pmonetdb --host=koala --port=33682 
 # 18:52:45 >  
 
-MAPI  = [EMAIL PROTECTED]:31488
+MAPI  = [EMAIL PROTECTED]:35914
 QUERY = copy 1 records into null_as_string from stdin delimiters ',','\n' NULL 
as '';
 ERROR = !SQLException:sql:value 'NULL' while parsing 'NULL,NULL,NULL' from 
line 0 field 0 not inserted, expecting type int
         !SQLException:importTable:failed to import table
-MAPI  = [EMAIL PROTECTED]:31488
+MAPI  = [EMAIL PROTECTED]:35914
 QUERY = copy 1 records into null_as_string from stdin delimiters ',','\n' NULL 
as '';
 ERROR = !SQLException:sql:value 'NULL' while parsing 'NULL,zero,0' from line 0 
field 0 not inserted, expecting type int
         !SQLException:importTable:failed to import table
-MAPI  = [EMAIL PROTECTED]:31488
+MAPI  = [EMAIL PROTECTED]:35914
 QUERY = copy 1 records into null_as_string from stdin delimiters ',','\n' NULL 
as '';
 ERROR = !SQLException:sql:decimal wrong format (NULL)
         !SQLException:sql:value 'NULL' while parsing 'NULL' from line 0 field 
2 not inserted, expecting type int
         !SQLException:importTable:failed to import table
-MAPI  = [EMAIL PROTECTED]:31488
+MAPI  = [EMAIL PROTECTED]:35914
 QUERY = copy 1 records into null_as_string from stdin delimiters ',','\n';
 ERROR = !SQLException:sql:value '' while parsing ',,' from line 0 field 0 not 
inserted, expecting type int
         !SQLException:importTable:failed to import table
-MAPI  = [EMAIL PROTECTED]:31488
+MAPI  = [EMAIL PROTECTED]:35914
 QUERY = copy 1 records into null_as_string from stdin delimiters ',','\n';
 ERROR = !SQLException:sql:value '' while parsing ',zero,0' from line 0 field 0 
not inserted, expecting type int
         !SQLException:importTable:failed to import table
-MAPI  = [EMAIL PROTECTED]:31488
+MAPI  = [EMAIL PROTECTED]:35914
 QUERY = copy 1 records into null_as_string from stdin delimiters ',','\n';
-ERROR = !SQLException:sql:value '' while parsing '' from line 0 field 2 not 
inserted, expecting type int
+ERROR = !WARNING: Decimal cannot be parsed from int
+        !SQLException:sql:value '' while parsing '' from line 0 field 2 not 
inserted, expecting type int
         !SQLException:importTable:failed to import table
-        !WARNING: Decimal cannot be parsed from int
 
 # 18:52:46 >  
 # 18:52:46 >  Done.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to