Changeset: 5e655386ffe8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5e655386ffe8
Modified Files:
sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
Branch: default
Log Message:
Add test for issue #7289 (date type)
diffs (34 lines):
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
@@ -8,13 +8,18 @@ statement ok rowcount 1
INSERT INTO date_table VALUES (cast('2000-10-10' AS DATE))
statement ok
-CREATE FUNCTION pyapi_date(d DATE) RETURNS STRING LANGUAGE PYTHON { return d; }
+CREATE FUNCTION pyapi_date(d DATE) RETURNS DATE LANGUAGE PYTHON { return d; }
query T rowsort
SELECT pyapi_date(d) FROM date_table
----
2000-10-10
+query T rowsort
+SELECT pyapi_date(cast('2000-10-10' AS DATE))
+----
+2000-10-10
+
statement ok
CREATE TABLE time_table(d TIME)
@@ -61,8 +66,9 @@ statement ok
CREATE FUNCTION pyapi_ret_date() RETURNS TABLE(d DATE)
LANGUAGE PYTHON
{
+ import datetime
result = dict()
- result['d'] = '2000-10-10'
+ result['d'] = datetime.date(2000, 10, 10)
return result
}
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
