Changeset: c9f9d96ef2ac for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c9f9d96ef2ac
Modified Files:
sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.test
sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.test
sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.test
sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.test
sql/test/BugTracker-2009/Tests/caselessthen.test
sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.test
sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.test
sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.test
sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.test
sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.test
sql/test/BugTracker-2016/Tests/split_project.Bug-6117.test
sql/test/mergetables/Tests/sqlsmith-exists.test
Branch: mtest
Log Message:
Don't leave newlines before query results delimiter
diffs (truncated from 332 to 300 lines):
diff --git a/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.test
b/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.test
--- a/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.test
+++ b/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.test
@@ -81,7 +81,6 @@ FROM
FROM x
) pass1
, x
-
----
3
2.000
@@ -95,7 +94,6 @@ FROM
FROM x
) agg
, x
-
----
3
2.000
diff --git a/sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.test
b/sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.test
--- a/sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.test
+++ b/sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.test
@@ -23,7 +23,6 @@ WHEN somecol IS NULL THEN 'NULL FOUND'
ELSE 'big'
END AS "NewColumnName"
FROM sometable
-
----
0
small
@@ -42,7 +41,6 @@ WHEN somecol > 6 AND somecol < 9 THEN '7
ELSE 'big'
END AS "NewColumnName"
FROM sometable
-
----
0
small
diff --git a/sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.test
b/sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.test
--- a/sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.test
+++ b/sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.test
@@ -10,7 +10,6 @@ select 12 as x
union
select 13 as x
) sub
-
----
10
1
@@ -33,7 +32,6 @@ select 12 as x
union
select 13 as x
) sub
-
----
10
1
@@ -56,7 +54,6 @@ select 12 as x
union
select 13 as x
) sub
-
----
10
0
@@ -79,7 +76,6 @@ select 12 as x
union
select 13 as x
) sub
-
----
10
0
@@ -102,7 +98,6 @@ select 12 as x
union
select 13 as x
) sub
-
----
10
0
diff --git
a/sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.test
b/sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.test
---
a/sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.test
+++
b/sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.test
@@ -7,7 +7,6 @@ FROM (
) sub
WHERE b IN ('y')
) sub2
-
----
NULL
@@ -21,7 +20,6 @@ FROM (
WHERE b IN ('y')
) sub2
HAVING SUM(a) IS NULL
-
----
NULL
@@ -35,7 +33,6 @@ FROM (
WHERE b IN ('y')
) sub2
HAVING SUM(a) IS NOT NULL
-
----
query I rowsort
@@ -48,7 +45,6 @@ FROM (
WHERE b IN ('y')
) sub2
HAVING SUM(a) > 0
-
----
query IT rowsort
@@ -64,7 +60,6 @@ FROM (
) sub2
) sub3
WHERE suma > 0
-
----
query IT rowsort
@@ -80,7 +75,6 @@ FROM (
) sub2
) sub3
WHERE mynull > 0
-
----
query IT rowsort
@@ -89,7 +83,6 @@ FROM (
SELECT 1 AS a, NULL AS b
) sub
WHERE b>0
-
----
query IT rowsort
@@ -98,7 +91,6 @@ FROM (
SELECT 1 AS a, NULL AS b
) sub
WHERE NOT b<=0
-
----
statement ok
@@ -176,7 +168,6 @@ SELECT
, a OR b AS "a_OR_b"
, a AND b AS "a_AND_b"
FROM dummy
-
----
99 values hashing to 322b702ce7de2998dd023b14d004e763
diff --git a/sql/test/BugTracker-2009/Tests/caselessthen.test
b/sql/test/BugTracker-2009/Tests/caselessthen.test
--- a/sql/test/BugTracker-2009/Tests/caselessthen.test
+++ b/sql/test/BugTracker-2009/Tests/caselessthen.test
@@ -25,7 +25,6 @@ from (
union
select 13 as x
) sub
-
----
10
1
diff --git
a/sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.test
b/sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.test
--- a/sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.test
+++ b/sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.test
@@ -27,7 +27,6 @@ FROM (
) as Sub
WHERE y2/y2 < 0
GROUP BY x2
-
----
statement ok
diff --git a/sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.test
b/sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.test
--- a/sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.test
+++ b/sql/test/BugTracker-2012/Tests/bart-crash.Bug-3057.test
@@ -73,7 +73,6 @@ select t.xtrsrc_id
AND r.wm_ra + alpha(r.wm_decl, im0.bmaj)
) t
where t.dist > t.dist_lim
-
----
1
@@ -92,7 +91,6 @@ SELECT r.xtrsrc_id
AND x.ra BETWEEN r.wm_ra - alpha(r.wm_decl, im0.bmaj)
AND r.wm_ra + alpha(r.wm_decl, im0.bmaj)
AND r.x * x.x + r.y * x.y + r.z * x.z > COS(RADIANS(im0.bmaj))
-
----
1
diff --git
a/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.test
b/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.test
--- a/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.test
+++ b/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.test
@@ -15,7 +15,6 @@ SELECT (SELECT COUNT(id) AS cnt1
) AS c2
FROM test1 a
ORDER BY 1, 2
-
----
query II rowsort
@@ -28,7 +27,6 @@ SELECT (SELECT COUNT(id) AS cnt1
)
FROM test1 a
ORDER BY 1, 2
-
----
query II rowsort
@@ -41,7 +39,6 @@ SELECT (SELECT COUNT(id) AS cnt1
) AS c2
FROM test1 a
ORDER BY 1, 2
-
----
query II rowsort
@@ -54,7 +51,6 @@ SELECT (SELECT COUNT(b.id) AS cnt2
) AS c1
FROM test1 a
ORDER BY 1, 2
-
----
query II rowsort
@@ -67,7 +63,6 @@ SELECT (SELECT COUNT(id) AS cnt1
) AS c2
FROM test1 a
ORDER BY 1, 2
-
----
statement ok
@@ -99,7 +94,6 @@ SELECT (SELECT COUNT(id) AS cnt1
) AS c2
FROM test1 a
ORDER BY 1, 2
-
----
3
0
@@ -118,7 +112,6 @@ SELECT (SELECT COUNT(id) AS cnt1
)
FROM test1 a
ORDER BY 1, 2
-
----
3
0
@@ -137,7 +130,6 @@ SELECT (SELECT COUNT(id) AS cnt1
) AS c2
FROM test1 a
ORDER BY 1, 2
-
----
3
0
@@ -156,7 +148,6 @@ SELECT (SELECT COUNT(b.id) AS cnt2
) AS c1
FROM test1 a
ORDER BY 1, 2
-
----
0
3
@@ -175,7 +166,6 @@ SELECT (SELECT COUNT(id) AS cnt1
) AS c2
FROM test1 a
ORDER BY 1, 2
-
----
3
0
diff --git a/sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.test
b/sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.test
--- a/sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.test
+++ b/sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.test
@@ -25,7 +25,6 @@ group by
tilex,
tiley,
intensity
-
----
0.000
0.000
diff --git a/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.test
b/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.test
--- a/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.test
+++ b/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.test
@@ -19,7 +19,6 @@ SELECT t0.id
END AS colint_sq
FROM t1
) t0
-
----
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
