Changeset: e9d0a12f7f71 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e9d0a12f7f71
Modified Files:
sql/common/sql_types.c
sql/test/subquery/Tests/subquery3.sql
Branch: Nov2019
Log Message:
We shouldn't allow internal SQL functions to be called from regular queries
diffs (33 lines):
diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -1269,7 +1269,6 @@ sql_create_funcSE(sql_allocator *sa, con
return sql_create_func_(sa, name, mod, imp, l, sres, TRUE, F_FUNC,
fix_scale);
}
-
static sql_func *
sql_create_func3(sql_allocator *sa, const char *name, const char *mod, const
char *imp, sql_type *tpe1, sql_type *tpe2, sql_type *tpe3, sql_type *res, int
fix_scale)
{
@@ -2195,4 +2194,3 @@ types_init(sql_allocator *sa, int debug)
MT_lock_unset(&funcs->ht_lock);
sqltypeinit( sa );
}
-
diff --git a/sql/test/subquery/Tests/subquery3.sql
b/sql/test/subquery/Tests/subquery3.sql
--- a/sql/test/subquery/Tests/subquery3.sql
+++ b/sql/test/subquery/Tests/subquery3.sql
@@ -119,5 +119,13 @@ GROUP BY col1; --MonetDB outputs this on
-- 2468
-- 2468
+/* We shouldn't allow the following internal functions/procedures to be called
from regular queries */
+SELECT "identity"(col1) FROM another_T;
+SELECT "rowid"(col1) FROM another_T;
+SELECT "in"(true, true) FROM another_T;
+SELECT "rotate_xor_hash"(1, 1, 1) FROM another_T;
+CALL sys_update_schemas();
+CALL sys_update_tables();
+
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
