Changeset: 1f73c34ec67f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1f73c34ec67f Added Files: sql/test/quantiles/Tests/All sql/test/quantiles/Tests/quantiles.sql sql/test/quantiles/Tests/quantiles.stable.err sql/test/quantiles/Tests/quantiles.stable.out Branch: default Log Message:
Quantile test case and approved output diffs (truncated from 10303 to 300 lines): diff --git a/sql/test/quantiles/Tests/All b/sql/test/quantiles/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/quantiles/Tests/All @@ -0,0 +1,1 @@ +quantiles \ No newline at end of file diff --git a/sql/test/quantiles/Tests/quantiles.sql b/sql/test/quantiles/Tests/quantiles.sql new file mode 100644 --- /dev/null +++ b/sql/test/quantiles/Tests/quantiles.sql @@ -0,0 +1,10039 @@ +-- msqldump dump table lit Mon Nov 18 10:34:01 2013 +-- MonetDB v11.16.0 (unreleased), 'testdb' +CREATE TABLE "sys"."lit" ( + "l_extendedprice" DECIMAL(15,2), + "l_returnflag" VARCHAR(1) +); +COPY 10000 RECORDS INTO "sys"."lit" FROM stdin USING DELIMITERS '\t','\n','"'; +21168.23 "N" +45983.16 "N" +13309.60 "N" +28955.64 "N" +22824.48 "N" +49620.16 "N" +44694.46 "N" +54058.05 "R" +46796.47 "R" +39890.88 "A" +2618.76 "A" +32986.52 "R" +28733.64 "A" +30690.90 "N" +23678.55 "R" +50723.92 "R" +73426.50 "A" +61998.31 "A" +13608.60 "N" +11594.16 "N" +81639.88 "N" +31809.96 "N" +73943.82 "N" +43058.75 "N" +6476.15 "N" +47227.60 "N" +64605.44 "N" +2210.32 "N" +6582.96 "N" +79059.64 "N" +9159.66 "N" +40217.23 "A" +47344.32 "A" +7532.30 "A" +75928.31 "R" +17554.68 "N" +30875.02 "N" +9681.24 "N" +32410.80 "N" +68065.96 "N" +13418.23 "N" +29004.25 "N" +65854.94 "N" +47397.28 "N" +75043.92 "N" +62105.20 "A" +70542.42 "A" +78083.70 "A" +84252.52 "N" +53782.08 "N" +43383.08 "N" +82746.18 "N" +48338.88 "N" +63360.93 "N" +54494.40 "N" +40675.95 "R" +42995.94 "A" +39353.82 "N" +27076.98 "N" +35126.41 "R" +64061.68 "A" +6230.52 "N" +13358.28 "N" +8368.00 "N" +66066.44 "N" +35733.03 "N" +40144.70 "N" +2925.18 "N" +57738.28 "N" +88089.08 "N" +34454.40 "N" +47000.25 "N" +46906.80 "N" +52735.84 "N" +58761.60 "A" +37893.76 "A" +22172.42 "A" +4318.50 "R" +44606.94 "R" +32717.50 "A" +8736.96 "R" +16277.95 "A" +1888.80 "R" +18477.03 "A" +39520.81 "R" +30602.35 "A" +47323.25 "N" +5645.73 "N" +61489.35 "N" +54174.12 "N" +49071.75 "N" +58841.42 "N" +25278.61 "A" +42761.70 "R" +19454.11 "R" +56149.72 "A" +31857.11 "R" +32373.88 "A" +1752.74 "A" +23109.80 "A" +12471.80 "A" +11011.10 "A" +8948.80 "R" +46875.36 "A" +48467.88 "A" +27748.56 "N" +43889.34 "N" +50422.90 "N" +13468.28 "N" +51519.91 "N" +63713.72 "N" +50303.88 "N" +17476.92 "N" +70407.67 "N" +44445.82 "N" +35083.00 "N" +16787.25 "N" +10515.90 "N" +49447.54 "N" +31266.89 "N" +30432.64 "N" +69723.16 "A" +81413.56 "R" +44969.76 "A" +45653.52 "A" +39852.42 "R" +31304.88 "A" +22595.10 "R" +1637.56 "R" +25827.34 "A" +78755.04 "R" +31893.48 "A" +21458.19 "R" +34073.03 "R" +70762.50 "R" +59962.50 "A" +4440.08 "A" +26809.92 "R" +46098.15 "R" +45869.12 "A" +23231.84 "A" +38756.61 "N" +16263.24 "N" +39653.15 "N" +20293.35 "N" +32374.44 "A" +59837.40 "A" +34846.50 "A" +49162.00 "A" +13286.04 "A" +13633.20 "A" +57020.40 "N" +30289.14 "N" +51727.83 "N" +33048.00 "N" +25684.80 "N" +13195.00 "N" +61192.08 "N" +30104.36 "N" +34002.72 "N" +34443.39 "A" +2754.56 "N" +69339.22 "N" +22395.10 "N" +47379.87 "N" +8673.20 "N" +13393.08 "N" +38316.40 "N" +33807.80 "A" +33755.52 "R" +58311.00 "R" +46192.64 "R" +66757.50 "R" +51432.03 "R" +21620.69 "A" +3324.51 "R" +72610.66 "R" +22177.80 "R" +60230.31 "A" +30755.16 "R" +68556.56 "N" +18620.68 "N" +67717.65 "N" +7776.16 "N" +32820.76 "R" +43916.85 "R" +23322.23 "N" +28587.20 "N" +18933.75 "N" +2992.80 "N" +47447.75 "N" +46980.00 "N" +14675.67 "A" +30119.25 "R" +43053.01 "A" +25442.03 "R" +1606.52 "R" +25479.87 "A" +42881.04 "R" +9057.36 "R" +32527.68 "A" +39812.22 "R" +9447.54 "A" +75474.44 "A" +48668.96 "R" +58525.04 "R" +20653.95 "R" +26427.75 "A" +58207.11 "N" +9440.80 "A" +32041.94 "N" +46348.25 "N" +19704.44 "R" +1885.88 "N" +33562.98 "N" +22884.40 "N" +16590.75 "N" +44847.95 "N" +64480.35 "N" +55203.50 "N" +60959.70 "N" +18577.76 "A" +54998.40 "R" +84335.36 "A" +17320.44 "R" +83288.25 "R" +3840.04 "R" +7987.68 "N" +4786.68 "N" +58959.45 "N" +26809.68 "N" +46393.98 "N" +22401.96 "A" +56066.12 "N" +7623.60 "R" +84630.80 "A" +43620.50 "A" +70813.35 "R" +3947.90 "R" +92156.64 "A" +27705.44 "R" +26606.27 "N" +28226.40 "N" +2829.09 "A" +31271.60 "R" +56054.10 "A" +42126.56 "R" +6074.82 "R" +40760.94 "R" +40553.31 "R" +89647.56 "R" +12017.40 "A" +1274.36 "R" +47219.04 "R" +14735.36 "R" +14887.36 "R" +22629.60 "R" +61748.10 "R" +61106.00 "A" +53219.56 "A" +26867.06 "R" +56695.60 "A" +51304.95 "R" +8926.54 "N" +9601.52 "R" +48604.40 "A" +82069.20 "R" +60292.21 "A" +47373.75 "A" +54484.56 "A" +24888.78 "A" +28615.72 "R" +60375.42 "R" +4290.99 "R" +7759.20 "R" +97144.00 "N" +47286.98 "N" +31406.94 "N" +36027.57 "N" +56376.32 "N" +42511.56 "R" _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list