Changeset: 4ab898142bf6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4ab898142bf6
Modified Files:
sql/src/test/Tests/copy_into.sql
sql/src/test/Tests/copy_into.sql.in
Branch: Oct2010
Log Message:
COPY INTO now requires an absolute file path;
hence, we use one by renaming copy_into.sql to copy_into.sql.in
and exploiting Mtest.py's variable replacement functionality.
diffs (40 lines):
diff -r ebceb5fbf004 -r 4ab898142bf6 sql/src/test/Tests/copy_into.sql
--- a/sql/src/test/Tests/copy_into.sql Wed Dec 15 13:06:45 2010 +0100
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,16 +0,0 @@
-create table copyouttest ( str VARCHAR(20), str2 VARCHAR(20));
-insert into copyouttest values ('', 'test');
-insert into copyouttest values ('test', '');
-insert into copyouttest values ('','');
-insert into copyouttest values (' Test ','');
-select * from copyouttest;
-
-copy select * from copyouttest into 'x.dat' delimiters '[]', '\n';
-drop table copyouttest;
-
-create table copyintest ( str VARCHAR(20), str2 VARCHAR(20));
-copy into copyintest from 'x.dat' delimiters '[]', '\n', '"';
-
-select * from copyintest;
-drop table copyintest;
-
diff -r ebceb5fbf004 -r 4ab898142bf6 sql/src/test/Tests/copy_into.sql.in
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/src/test/Tests/copy_into.sql.in Wed Dec 15 13:08:32 2010 +0100
@@ -0,0 +1,16 @@
+create table copyouttest ( str VARCHAR(20), str2 VARCHAR(20));
+insert into copyouttest values ('', 'test');
+insert into copyouttest values ('test', '');
+insert into copyouttest values ('','');
+insert into copyouttest values (' Test ','');
+select * from copyouttest;
+
+copy select * from copyouttest into '$TSTTRGBASE/mTests/x.dat' delimiters
'[]', '\n';
+drop table copyouttest;
+
+create table copyintest ( str VARCHAR(20), str2 VARCHAR(20));
+copy into copyintest from '$TSTTRGBASE/mTests/x.dat' delimiters '[]', '\n',
'"';
+
+select * from copyintest;
+drop table copyintest;
+
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
