Update of /cvsroot/monetdb/sql/src/test/xquery/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv29913/src/test/xquery/Tests
Modified Files:
create.sql
Log Message:
approved tests for stricter copy into
removed no longer skipped whitespace
on error always report that
U create.sql
Index: create.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/xquery/Tests/create.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- create.sql 18 Feb 2008 10:52:19 -0000 1.2
+++ create.sql 9 Aug 2009 20:43:31 -0000 1.3
@@ -10,156780 +10,156780 @@
nameid integer references names(nameid),
value varchar(100));
-copy 77 RECORDS into names from stdin DELIMITERS ',', '\n', '"';
-0, "site"
-1, "regions"
-2, "africa"
-3, "item"
-4, "id"
-5, "location"
[...313520 lines suppressed...]
+156685,0,6,3,,"6"
+156684,1,5,1,67,""
+156686,0,5,3,," "
+156592,94,4,1,65,""
+156687,0,4,3,," "
+156569,118,3,1,74,""
+156688,0,3,3,," "
+138711,17977,2,1,73,""
+156689,0,2,3,," "
+1,156688,1,1,0,""
+0,156689,0,6,0,"../../document/D/D.xml"
update doc set value='auctionG.xml' where kind=6;
-create view xmldoc(pre, size, level, kind, nameid, value, name) as
- select d.pre, d.size, d.level, d.kind, d.nameid, d.value, n.name
+create view xmldoc(pre,size,level,kind,nameid,value,name) as
+ select d.pre,d.size,d.level,d.kind,d.nameid,d.value,n.name
from doc as d left outer join names as n on
(d.nameid = n.nameid);
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
