Changeset: a8c03c54cc45 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a8c03c54cc45 Added Files: sql/test/scripts/Tests/copy-into-lz4.test.in sql/test/scripts/Tests/fsum.test sql/test/scripts/Tests/lz4-dump.test Modified Files: testing/SQLogicConvertNotes Branch: mtest Log Message:
add tests for scripts diffs (truncated from 3286 to 300 lines): diff --git a/sql/test/scripts/Tests/copy-into-lz4.test.in b/sql/test/scripts/Tests/copy-into-lz4.test.in new file mode 100644 --- /dev/null +++ b/sql/test/scripts/Tests/copy-into-lz4.test.in @@ -0,0 +1,15 @@ +statement ok +START TRANSACTION + +statement ok +CREATE TABLE testlz4 (a bigint, b real, c clob, d varchar(64)) + +statement error +COPY INTO testlz4 FROM E'$QTSTSRCDIR/testlz4.lz4' USING DELIMITERS ',',E'\n','"' NULL AS '' + +statement error +SELECT a, b, c, d FROM testlz4 limit 1024 + +statement ok +ROLLBACK + diff --git a/sql/test/scripts/Tests/fsum.test b/sql/test/scripts/Tests/fsum.test new file mode 100644 --- /dev/null +++ b/sql/test/scripts/Tests/fsum.test @@ -0,0 +1,3213 @@ +statement ok +create table t (val double, gid int) + +statement ok +copy 3131 records into t from stdin using delimiters ' ',E'\n' null as 'nan' + +statement error +-1.7976931348623157E+308 23 +9007199254740992.0 9 +-5e-324 38 +-8.98846567431158e+307 35 +8.988465674311579e+307 12 +8.98846567431158e+307 26 +8.98846567431158e+307 40 +8.98846567431158e+307 7 +9.076030935533344e+279 39 +-8.98846567431158e+307 37 +1.7976931348623157E+308 22 +8.98846567431158e+307 28 +-8.98846567431158e+307 36 +0.7 17 +8.98846567431158e+307 26 +1e+308 5 +-1e+308 5 +0.0 1 +9007199254741002.0 10 +8.98846567431158e+307 29 +1.0 15 +8.988465674311579e+307 25 +8.98846567431158e+307 7 +-1.0 16 +-8.98846567431158e+307 30 +-8.98846567431158e+307 37 +0.5 15 +1.7976931348623157E+308 21 +8.98846567431158e+307 40 +8.98846567431158e+307 32 +0.5 16 +1.7976931348623157E+308 18 +8.988465674311579e+307 24 +nan 19 +-1e+307 40 +-1.7976931348623157E+308 22 +-8.98846567431158e+307 36 +-1.0 12 +1.0 10 +8.98846567431158e+307 12 +1.0 9 +1.7976931348623157E+308 20 +1.7976931348623157E+308 21 +9007199254740992.0 8 +1e+308 5 +8.98846567431158e+307 7 +8.98846567431158e+307 32 +-0.3333333333333333 16 +8.98846567431158e+307 27 +8.98846567431158e+307 29 +1e+308 3 +1e+308 3 +8.98846567431158e+307 7 +8.98846567431158e+307 31 +-1.7976931348623157E+308 18 +9.9792015476736e+291 36 +0.0 24 +-8.98846567431158e+307 7 +1e+100 2 +1.99584030953472e+292 35 +0.3333333333333333 15 +-9.9792015476736e+291 32 +7.888609052210118e-31 9 +-8.98846567431158e+307 38 +-1.0218702384817765e+295 39 +1e+308 23 +8.98846567431158e+307 34 +0.25 16 +0.25 15 +1.1899999999999997 17 +7.888609052210118e-31 10 +nan 20 +-1e+308 4 +8.98846567431158e+307 28 +1e+308 4 +1e+308 4 +9007199254740988.0 11 +8.98846567431158e+307 6 +-1e+308 3 +8.98846567431158e+307 29 +1e+308 23 +8.98846567431158e+307 31 +1.7976931348623157E+308 19 +-1.7976931348623157E+308 23 +1e+16 41 +8.98846567431158e+307 34 +8.98846567431158e+307 29 +-8.98846567431158e+307 30 +1.0 2 +-9.9792015476736e+291 33 +-8.98846567431158e+307 30 +-8.98846567431158e+307 29 +-8.98846567431158e+307 38 +-9.9792015476736e+291 34 +-1.7976931348623157E+308 19 +-8.98846567431158e+307 7 +8.98846567431158e+307 29 +-1e+100 2 +5e-324 34 +1.0 25 +-8.98846567431158e+307 7 +-8.98846567431158e+307 30 +9.9792015476736e+291 38 +1e-100 2 +8.98846567431158e+307 25 +0.2 15 +9.9792015476736e+291 37 +8.98846567431158e+307 27 +5e-324 37 +8.98846567431158e+307 39 +1.7976931348623157e+308 13 +1e+50 2 +1.7976931348623157E+308 20 +8.98846567431158e+307 39 +nan 18 +8.98846567431158e+307 6 +0.16666666666666666 15 +1.7976931348623157e+308 14 +1.0 41 +2.0229999999999997 17 +-1.0 2 +3.439099999999999 17 +-1.0 27 +-1.99584030953472e+292 31 +1.9958403095347196e+292 14 +-0.2 16 +8.98846567431158e+307 39 +8.98846567431158e+307 33 +8.98846567431158e+307 33 +5.84647 17 +0.16666666666666666 16 +0.14285714285714285 15 +0.5 11 +0.125 15 +-1.0715086071862673e+301 6 +0.1111111111111111 15 +-8.98846567431158e+307 39 +9.938998999999997 17 +8.98846567431158e+307 28 +5.551115123125783e-17 11 +0.1 15 +16.896298299999994 17 +-0.5 8 +-0.14285714285714285 16 +0.09090909090909091 15 +-1e+50 2 +1e-16 41 +0.08333333333333333 15 +8.98846567431158e+307 28 +-5e-324 33 +8.98846567431158e+307 24 +0.125 16 +-8.98846567431158e+307 28 +-8.98846567431158e+307 35 +-8.98846567431158e+307 28 +-5.551115123125783e-17 8 +9.979201547673598e+291 13 +0.07692307692307693 15 +0.07142857142857142 15 +28.72370711 17 +48.83030208699998 17 +83.01151354789997 17 +0.06666666666666667 15 +0.0625 15 +141.11957303142995 17 +-0.1111111111111111 16 +0.058823529411764705 15 +0.1 16 +-0.09090909090909091 16 +0.05555555555555555 15 +0.08333333333333333 16 +0.05263157894736842 15 +-0.07692307692307693 16 +239.9032741534309 17 +407.83556606083255 17 +0.05 15 +0.07142857142857142 16 +0.047619047619047616 15 +0.045454545454545456 15 +693.3204623034153 17 +1178.644785915806 17 +2003.6961360568698 17 +3406.283431296679 17 +5790.681833204355 17 +-0.06666666666666667 16 +0.043478260869565216 15 +0.041666666666666664 15 +0.0625 16 +9844.159116447403 17 +0.04 15 +0.038461538461538464 15 +16735.07049796058 17 +-0.058823529411764705 16 +28449.619846532987 17 +0.05555555555555555 16 +48364.353739106096 17 +82219.40135648035 17 +-0.05263157894736842 16 +139772.98230601655 17 +0.037037037037037035 15 +0.05 16 +0.03571428571428571 15 +0.034482758620689655 15 +237614.0699202282 17 +403943.9188643879 17 +686704.6620694593 17 +0.03333333333333333 15 +1167397.9255180808 17 +0.03225806451612903 15 +-0.047619047619047616 16 +0.03125 15 +0.045454545454545456 16 +0.030303030303030304 15 +-0.043478260869565216 16 +0.041666666666666664 16 +0.029411764705882353 15 +1984576.473380738 17 +-0.04 16 +0.038461538461538464 16 +0.02857142857142857 15 +0.027777777777777776 15 +-0.037037037037037035 16 +0.03571428571428571 16 +-0.034482758620689655 16 +0.03333333333333333 16 +3373780.004747253 17 +-0.03225806451612903 16 +0.02702702702702703 15 +5735426.008070332 17 +9750224.213719562 17 +16575381.163323257 17 +0.03125 16 +0.02631578947368421 15 +28178147.97764954 17 +-0.030303030303030304 16 +0.029411764705882353 16 +47902851.56200419 17 +0.02564102564102564 15 +0.025 15 +81434847.65540715 17 +0.024390243902439025 15 +138439241.01419216 17 +-0.02857142857142857 16 +235346709.72412664 17 +0.023809523809523808 15 +0.027777777777777776 16 +0.023255813953488372 15 +-0.02702702702702703 16 +400089406.5310153 17 +680151991.102726 17 +1156258384.874634 17 +1965639254.2868786 17 +0.022727272727272728 15 +0.02631578947368421 16 +0.022222222222222223 15 +-0.02564102564102564 16 +0.021739130434782608 15 +3341586732.287692 17 +0.02127659574468085 15 +5680697444.889077 17 +0.025 16 +0.020833333333333332 15 +0.02040816326530612 15 +0.02 15 +0.0196078431372549 15 +0.019230769230769232 15 +9657185656.311432 17 +16417215615.729427 17 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
