Changeset: d4d34ca40c37 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d4d34ca40c37 Added Files: sql/test/BugTracker-2013/Tests/udf_error.Bug-3396.sql Modified Files: sql/test/BugTracker-2013/Tests/All Branch: default Log Message:
Bug in Mitosis/Mergtable optimizers diffs (42 lines): diff --git a/sql/test/BugTracker-2013/Tests/All b/sql/test/BugTracker-2013/Tests/All --- a/sql/test/BugTracker-2013/Tests/All +++ b/sql/test/BugTracker-2013/Tests/All @@ -57,3 +57,4 @@ unop_vs_aggr.Bug-3885 singleton-median.Bug-3389 Cannot_Find_Column_Type.Bug-3394 case_when.Bug-3395 +udf_error.Bug-3396 diff --git a/sql/test/BugTracker-2013/Tests/udf_error.Bug-3396.sql b/sql/test/BugTracker-2013/Tests/udf_error.Bug-3396.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2013/Tests/udf_error.Bug-3396.sql @@ -0,0 +1,29 @@ +CREATE TABLE TEST_UDF ( +x float, +y float +); + +--COPY 200000 RECORDS INTO TEST_UDF from '/home/alastair/test_data.csv' USING +--DELIMITERS ',','\n','"' NULL AS ''; +COPY 5 RECORDS INTO TEST_UDF from stdin USING DELIMITERS ',','\n','"' NULL AS ''; +0.1,0.2 +0.118605379902,0.933008230218 +0.504782158934,0.0927420819153 +0.36667111241,0.216447762367 +0.538823741129,0.794452784083 + +CREATE FUNCTION MY_UDF (x float, y float) +RETURNS float +BEGIN +DECLARE ret float; +set ret = LOG(x/y); +RETURN ret; +END; + +SELECT 'udf alone',MY_UDF(0.1,0.2); + +SELECT 'udf from table',MY_UDF(t.x,t.y) FROM TEST_UDF as t; +-- this returns NULL with 200000 records + +DROP FUNCTION MY_UDF; +DROP TABLE TEST_UDF; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
