Changeset: 7b65100603c1 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7b65100603c1
Modified Files:
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.sql.in
Branch: Jul2015
Log Message:
Double backslashes in COPY INTO queries.
diffs (128 lines):
diff --git
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
---
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
+++
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
);
-COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
+COPY 1025 RECORDS INTO t0 FROM
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
---
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
+++
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
);
-COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
+COPY 1025 RECORDS INTO t0 FROM
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
---
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
+++
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
);
-COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
+COPY 1025 RECORDS INTO t0 FROM
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
---
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
+++
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
);
-COPY 1024 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
+COPY 1024 RECORDS INTO t0 FROM
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
---
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
+++
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
);
-COPY 1025 RECORDS INTO t0 FROM
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
+COPY 1025 RECORDS INTO t0 FROM
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING DELIMITERS
'\t';
select count(*) from t0;
INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git
a/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
b/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
--- a/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
+++ b/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
@@ -2,7 +2,7 @@ start transaction;
create table test3351 (i integer);
-copy into test3351 from '$TSTSRCDIR/test3351.csv.bz2';
+copy into test3351 from '$QTSTSRCDIR/test3351.csv.bz2';
select * from test3351;
delete from test3351;
diff --git
a/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
b/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
--- a/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
+++ b/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
@@ -2,7 +2,7 @@ start transaction;
create table test3351 (i integer);
-copy into test3351 from '$TSTSRCDIR/test3351.csv.gz';
+copy into test3351 from '$QTSTSRCDIR/test3351.csv.gz';
select * from test3351;
delete from test3351;
diff --git
a/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
b/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
--- a/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
+++ b/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
@@ -2,7 +2,7 @@ start transaction;
create table test3351 (i integer);
-copy into test3351 from '$TSTSRCDIR/test3351.csv';
+copy into test3351 from '$QTSTSRCDIR/test3351.csv';
select * from test3351;
delete from test3351;
diff --git
a/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
b/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
--- a/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
+++ b/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
@@ -1,5 +1,5 @@
create table t3225 ("eId" BIGINT, "timeInsert" TIMESTAMP, "uId" BIGINT);
-copy into t3225 from '$TSTSRCDIR/segfault_in_aggregation.Bug-3225.data' USING
DELIMITERS '\t','\n';
+copy into t3225 from '$QTSTSRCDIR/segfault_in_aggregation.Bug-3225.data' USING
DELIMITERS '\t','\n';
select "eId", count(*) from t3225 where "uId" = 312459 group by "eId";
select "eId", min("timeInsert"), max("timeInsert"), count(*) from t3225 where
"uId" = 312459 and "eId" = 1000761 group by "eId";
select "eId", min("timeInsert"), max("timeInsert"), count(*) from t3225 where
"uId" = 312459 and "eId" = 1000763 group by "eId";
diff --git a/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
b/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
--- a/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
+++ b/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
@@ -1,7 +1,7 @@
START TRANSACTION;
CREATE TABLE bug3813 ("playerID" STRING, "yearID" INTEGER, stint INTEGER,
"teamID" STRING, "lgID" STRING, "G" INTEGER, "AB" INTEGER, "R" INTEGER, "H"
INTEGER, "X2B" INTEGER, "X3B" INTEGER, "HR" INTEGER, "RBI" INTEGER, "SB"
INTEGER, "CS" INTEGER, "BB" INTEGER, "SO" INTEGER, "IBB" INTEGER, "HBP"
INTEGER, "SH" INTEGER, "SF" INTEGER, "GIDP" INTEGER);
-COPY INTO bug3813 FROM '$TSTSRCDIR/batting.csv.gz' USING DELIMITERS
',','\n','"' NULL AS '';
+COPY INTO bug3813 FROM '$QTSTSRCDIR/batting.csv.gz' USING DELIMITERS
',','\n','"' NULL AS '';
SELECT COUNT(*) FROM bug3813;
ROLLBACK;
diff --git
a/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.sql.in
b/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.sql.in
---
a/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.sql.in
+++
b/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.sql.in
@@ -1,5 +1,5 @@
CREATE TABLE test (c UUID);
-COPY 200000 RECORDS INTO test FROM '$TSTSRCDIR/data-uuid.csv.bz2' DELIMITERS
',';
+COPY 200000 RECORDS INTO test FROM '$QTSTSRCDIR/data-uuid.csv.bz2' DELIMITERS
',';
SELECT MIN(c) AS mn, MAX(c) AS mx FROM test;
SELECT MIN(c) AS mn, MAX(c) AS mx FROM test;
SELECT MIN(c) AS mn, MAX(c) AS mx FROM test;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
