Changeset: 355c647f8d2f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/355c647f8d2f
Modified Files:
sql/test/SQLancer/Tests/sqlancer16.test
sql/test/SQLancer/Tests/sqlancer17.test
Branch: Jul2021
Log Message:
Issue to be looked on later. In some place the comparison of floating-points is
not done right, so -0 differs 0
diffs (188 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer16.test
b/sql/test/SQLancer/Tests/sqlancer16.test
--- a/sql/test/SQLancer/Tests/sqlancer16.test
+++ b/sql/test/SQLancer/Tests/sqlancer16.test
@@ -157,8 +157,8 @@ START TRANSACTION
statement ok
CREATE TABLE "t0" ("c1" VARCHAR(44))
-statement ok
-COPY 5 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+statement ok rowcount 5
+COPY 5 RECORDS INTO "t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
<COPY_INTO_DATA>
"9史"
"-1680198574"
diff --git a/sql/test/SQLancer/Tests/sqlancer17.test
b/sql/test/SQLancer/Tests/sqlancer17.test
--- a/sql/test/SQLancer/Tests/sqlancer17.test
+++ b/sql/test/SQLancer/Tests/sqlancer17.test
@@ -126,3 +126,170 @@ 9
statement ok
ROLLBACK
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t2" ("c2" REAL)
+
+statement ok rowcount 142
+COPY 142 RECORDS INTO "t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+NULL
+0.18141033
+0.10420329
+NULL
+-1.2681471e+09
+0.6239734
+NULL
+0.37928414
+0.7922281
+0.49325344
+-1.7018686e+17
+0.070922926
+4
+8.981221e+07
+0.17222267
+0.21218215
+0.58062196
+0.419161
+0.84214187
+0.29322016
+0.29322016
+-0
+0.7530656
+0
+-1
+-2.0448145e+09
+0.2540231
+0.49195638
+0.0023798633
+0.6432879
+7
+NULL
+0.61336726
+0.37398192
+-9.4684614e+08
+0.18818615
+0.5136187
+3
+0.12575655
+0.29542512
+0.7088062
+-8.094762e+08
+110847336
+0.3245087
+0.35633564
+0.311399
+0.9717446
+-8
+1
+6
+0.43797848
+1.82855e+09
+0.5382776
+0.5785479
+NULL
+0.34842148
+0.35951182
+0
+0.3906244
+0.7785596
+0.9109514
+0.38354927
+0.28305355
+1.9593509e+08
+0.89934695
+0.9522356
+0.6559638
+0.2916218
+-1.4625787e+09
+2
+0.9737825
+0.12143436
+1.9697553e+09
+4
+3.1415927
+0.18462433
+-4.500457e-09
+0.5604565
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+-8.705452e+08
+0.24377942
+-1
+1.5076613e+09
+NULL
+6
+0.7550721
+-5.3695283
+2.0706463e+09
+0.51699466
+0.53571135
+1
+-1.0872904e+09
+0.30670688
+7
+6.008104e+08
+0.5502465
+2.0706463e+09
+0.45825
+0.4935091
+0.86806786
+0.23549564
+1
+0.35711357
+0.2559728
+0
+3
+0.35711357
+1.9593509e+08
+-6
+0.7928499
+-5
+0.84033513
+0
+-7.0777914e+08
+5
+0.6435906
+0.60735834
+NULL
+0.12356741
+-4.4439933e+08
+5
+0.029250568
+4
+0.7656532
+
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT 1 as count FROM t2 JOIN
+(SELECT DISTINCT t2.c2, 3 FROM t2) AS sub0(c2,c3) on t2.c2 = sub0.c2) as res
+----
+135
+
+# the hash is not right, it's a reminder it has to return 135 rows
+query R rowsort
+SELECT sub0.c2 FROM t2 JOIN (SELECT DISTINCT t2.c2, 3 FROM t2) AS sub0(c2,c3)
on t2.c2 = sub0.c2
+----
+135 values hashing to e55d26263a0004ee5457d82440cc2577
+
+statement ok
+ROLLBACK
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
