Changeset: f8d19a6c2a88 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f8d19a6c2a88
Added Files:
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out.int128
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.32bit
sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.sql
sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.err
sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.out
sql/test/pg_regress/Tests/oid.stable.err.64bit.int128
sql/test/pg_regress/Tests/oid.stable.err.64bit.oid32
Removed Files:
sql/test/pg_regress/Tests/oid.stable.err.int128
sql/test/pg_regress/Tests/oid.stable.err.oid32
Modified Files:
MonetDB.spec
clients/Tests/All
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.int128
clients/mapiclient/eventparser.c
clients/mapiclient/mclient.c
clients/mapilib/mapi.c
clients/odbc/driver/SQLBrowseConnect.c
clients/odbc/winsetup/setup.rc
debian/changelog
gdk/ChangeLog-Archive
gdk/gdk_bbp.c
gdk/gdk_join.c
gdk/gdk_logger.c
gdk/gdk_posix.c
gdk/gdk_select.c
gdk/gdk_storage.c
gdk/gdk_utils.c
geom/BugTracker/Tests/All
geom/BugTracker/Tests/X_crash.SF-1971632.stable.err
geom/lib/libgeom.c
geom/lib/libgeom.h
geom/monetdb5/geom.c
geom/monetdb5/geom.h
geom/monetdb5/geomBulk.c
geom/sql/functions/Tests/ST_LineFromText.stable.err
geom/sql/functions/Tests/ST_MLineFromText.stable.err
geom/sql/functions/Tests/ST_MPointFromText.stable.err
geom/sql/functions/Tests/ST_MPolygonFromText.stable.err
geom/sql/functions/Tests/ST_PointFromText.stable.err
geom/sql/functions/Tests/ST_PolygonFromText.stable.err
geom/sql/functions/Tests/XYZ.stable.err
java/src/main/java/nl/cwi/monetdb/jdbc/MonetDriver.java.in
java/src/main/java/nl/cwi/monetdb/util/SQLExporter.java
monetdb5/mal/mal_authorize.c
monetdb5/mal/mal_function.c
monetdb5/optimizer/opt_pipes.c
sql/server/rel_optimizer.c
sql/test/BugTracker-2016/Tests/All
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.sql
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out
sql/test/Tests/All
sql/test/Tests/systemfunctions.stable.out
sql/test/Tests/systemfunctions.stable.out.int128
sql/test/leaks/Tests/All
sql/test/leaks/Tests/check1.stable.out
sql/test/leaks/Tests/check1.stable.out.int128
sql/test/leaks/Tests/check2.stable.out
sql/test/leaks/Tests/check2.stable.out.int128
sql/test/leaks/Tests/check3.stable.out
sql/test/leaks/Tests/check3.stable.out.int128
sql/test/leaks/Tests/check4.stable.out
sql/test/leaks/Tests/check4.stable.out.int128
sql/test/leaks/Tests/check5.stable.out
sql/test/leaks/Tests/check5.stable.out.int128
sql/test/pg_regress/Tests/All
testing/Mtest.py.in
Branch: default
Log Message:
Merge with Jun2016 branch.
diffs (truncated from 13121 to 300 lines):
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -997,7 +997,7 @@ rm -f %{buildroot}%{_bindir}/Maddlog
* Mon Apr 4 2016 Sjoerd Mullender <sjo...@acm.org> - 11.21.19-20160405
- gdk: Fixed a bug that caused various instances where old data returned or
where crashes occurred. The problem was that internally data wasn't
- always marked dirty when it was being changed, causiing later processing
+ always marked dirty when it was being changed, causing later processing
to not deal with the changed data correctly.
* Thu Mar 24 2016 Sjoerd Mullender <sjo...@acm.org> - 11.21.17-20160324
diff --git a/clients/Tests/All b/clients/Tests/All
--- a/clients/Tests/All
+++ b/clients/Tests/All
@@ -1,4 +1,4 @@
exports
-HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_LIBR&!HAVE_LIDAR&HAVE_NETCDF&HAVE_SAMTOOLS&!HAVE_SHP&HAVE_SPHINXCLIENT?MAL-signatures
-!BITS32&!BITS64OID32&HAVE_FITS&HAVE_GEOM&HAVE_GSL&!HAVE_LIDAR&HAVE_NETCDF&HAVE_PCRE&!HAVE_SHP&HAVE_SAMTOOLS?SQL-dump
+HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_LIBR&!HAVE_LIDAR&HAVE_NETCDF&HAVE_SAMTOOLS&HAVE_SHP&HAVE_SPHINXCLIENT?MAL-signatures
+!BITS32&!BITS64OID32&HAVE_FITS&HAVE_GEOM&HAVE_GSL&!HAVE_LIDAR&HAVE_NETCDF&HAVE_PCRE&HAVE_SHP&HAVE_SAMTOOLS?SQL-dump
MERCURIAL?malcheck
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -40411,6 +40411,18 @@ pattern scheduler.srvpool():int
address SRVPOOLscheduler;
comment Run a program block in parallel.
+pattern shp.attach(filename:str):void
+address SHPattach;
+comment Register an ESRI Shapefile in the vault catalog
+
+pattern shp.import(fileid:int,po:wkb):void
+address SHPpartialimport;
+comment Partially import an ESRI Shapefile with given id into the vault
+
+pattern shp.import(fileid:int):void
+address SHPimport;
+comment Import an ESRI Shapefile with given id into the vault
+
function sphinx.sphinx_searchIndexLimit(q:str,i:str,l:int):bat[:lng];
function sphinx.sphinx_searchIndex(q:str,i:str):bat[:lng];
function sphinx.sphinx_search(q:str):bat[:lng];
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -51270,6 +51270,18 @@ pattern scheduler.srvpool():int
address SRVPOOLscheduler;
comment Run a program block in parallel.
+pattern shp.attach(filename:str):void
+address SHPattach;
+comment Register an ESRI Shapefile in the vault catalog
+
+pattern shp.import(fileid:int,po:wkb):void
+address SHPpartialimport;
+comment Partially import an ESRI Shapefile with given id into the vault
+
+pattern shp.import(fileid:int):void
+address SHPimport;
+comment Import an ESRI Shapefile with given id into the vault
+
function sphinx.sphinx_searchIndexLimit(q:str,i:str,l:int):bat[:lng];
function sphinx.sphinx_searchIndex(q:str,i:str):bat[:lng];
function sphinx.sphinx_search(q:str):bat[:lng];
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -239,6 +239,8 @@ Ready.
\dSf sys."setmasklen"
\dSf sys."setsession"
\dSf sys."settimeout"
+\dSf sys."shpattach"
+\dSf sys."shpload"
\dSf sys."shrink"
\dSf sys."shutdown"
\dSf sys."st_area"
@@ -633,6 +635,8 @@ SYSTEM FUNCTION sys.sessions
SYSTEM FUNCTION sys.setmasklen
SYSTEM FUNCTION sys.setsession
SYSTEM FUNCTION sys.settimeout
+SYSTEM FUNCTION sys.shpattach
+SYSTEM FUNCTION sys.shpload
SYSTEM FUNCTION sys.shrink
SYSTEM FUNCTION sys.shutdown
SYSTEM FUNCTION sys.sign
@@ -1006,6 +1010,9 @@ create function "setmasklen" (p inet, ma
create procedure sys.setsession("timeout" bigint) external name sql.setsession;
create procedure sys.settimeout("query" bigint) external name sql.settimeout;
create procedure sys.settimeout("query" bigint, "session" bigint) external
name sql.settimeout;
+create procedure shpattach(fname string) external name shp.attach;
+create procedure shpload(fid integer) external name shp.load;
+create procedure shpload(fid integer, filter geometry) external name
shp.import;
create procedure shrink(sys string, tab string) external name sql.shrink;
create procedure sys.shutdown(delay tinyint) external name sql.shutdown;
create procedure sys.shutdown(delay tinyint, force bool) external name
sql.shutdown;
@@ -2860,6 +2867,9 @@ drop function pcre_replace(string, strin
[ "sys", "setsession", "create procedure sys.setsession(\"timeout\"
bigint) external name sql.setsession;", "sql", 1, 2, true,
false, false ]
[ "sys", "settimeout", "create procedure sys.settimeout(\"query\"
bigint) external name sql.settimeout;", "sql", 1, 2, true,
false, false ]
[ "sys", "settimeout", "create procedure sys.settimeout(\"query\"
bigint, \"session\" bigint) external name sql.settimeout;", "sql", 1, 2,
true, false, false ]
+[ "sys", "shpattach", "create procedure shpattach(fname string)
external name shp.attach;", "shp", 1, 2, true, false, false ]
+[ "sys", "shpload", "create procedure shpload(fid integer) external
name shp.load;", "shp", 1, 2, true, false, false ]
+[ "sys", "shpload", "create procedure shpload(fid integer, filter
geometry) external name shp.import;", "shp", 1, 2, true,
false, false ]
[ "sys", "shrink", "create procedure shrink(sys string, tab
string) external name sql.shrink;", "sql", 1, 2, true, false,
false ]
[ "sys", "shutdown", "create procedure sys.shutdown(delay tinyint)
external name sql.shutdown;", "sql", 1, 2, true, false, false
]
[ "sys", "shutdown", "create procedure sys.shutdown(delay tinyint,
force bool) external name sql.shutdown;", "sql", 1, 2, true,
false, false ]
@@ -4497,6 +4507,9 @@ drop function pcre_replace(string, strin
[ "sys", "setsession", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "settimeout", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "settimeout", "session", "bigint", 64, 0,
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys", "shpattach", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys", "shpload", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys", "shpload", "filter", "geometry", 0, 0,
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys", "shrink", "tab", "clob", 0, 0, 1, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "shutdown", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "shutdown", "force", "boolean", 1, 0,
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
@@ -5024,54 +5037,12 @@ drop function pcre_replace(string, strin
% sys.s1, sys.f1, sys.s2, sys.f2, .dt # table_name
% name, name, name, name, name # name
% varchar, varchar, varchar, varchar, char # type
-% 3, 17, 3, 31, 20 # length
-[ "sys", "=", "sys", "columnsize", "FUNC_DEPENDENCY" ]
-[ "sys", "left_shift", "sys", "columnsize", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "columnsize", "FUNC_DEPENDENCY"
]
-[ "sys", "pi", "sys", "degrees", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_div", "sys", "degrees", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "degrees", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "dependencies_columns_on_indexes",
"FUNC_DEPENDENCY" ]
-[ "sys", "hash", "sys", "dependencies_columns_on_indexes",
"FUNC_DEPENDENCY" ]
-[ "sys", "rotate_xor_hash", "sys",
"dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ]
-[ "sys", "=", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "hash", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "rotate_xor_hash", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "sql_neg", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "zero_or_one", "sys", "getproj4", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "hashsize", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_mul", "sys", "hashsize", "FUNC_DEPENDENCY"
]
-[ "sys", "<>", "sys", "heapsize", "FUNC_DEPENDENCY" ]
-[ "sys", "and", "sys", "heapsize", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_add", "sys", "heapsize", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "heapsize", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "imprintsize", "FUNC_DEPENDENCY" ]
-[ "sys", "or", "sys", "imprintsize", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_mul", "sys", "imprintsize", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "ms_round", "FUNC_DEPENDENCY" ]
-[ "sys", "isnull", "sys", "ms_round", "FUNC_DEPENDENCY"
]
+% 3, 17, 3, 13, 20 # length
[ "sys", "ms_trunc", "sys", "ms_round", "FUNC_DEPENDENCY"
]
-[ "sys", "not", "sys", "ms_round", "FUNC_DEPENDENCY" ]
-[ "sys", "or", "sys", "ms_round", "FUNC_DEPENDENCY" ]
-[ "sys", "round", "sys", "ms_round", "FUNC_DEPENDENCY"
]
-[ "sys", "<", "sys", "ms_stuff", "FUNC_DEPENDENCY" ]
-[ "sys", ">", "sys", "ms_stuff", "FUNC_DEPENDENCY" ]
-[ "sys", "concat", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "length", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "or", "sys", "ms_stuff", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_add", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_sub", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "substring", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "pi", "sys", "radians", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_div", "sys", "radians", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "radians", "FUNC_DEPENDENCY"
]
[ "sys", "st_numgeometries", "sys", "st_numpatches",
"FUNC_DEPENDENCY" ]
[ "sys", "st_geometryn", "sys", "st_patchn", "FUNC_DEPENDENCY"
]
[ "sys", "getproj4", "sys", "st_transform", "FUNC_DEPENDENCY"
]
[ "sys", "internaltransform", "sys", "st_transform",
"FUNC_DEPENDENCY" ]
-[ "sys", "isnull", "sys", "st_transform", "FUNC_DEPENDENCY"
]
-[ "sys", "not", "sys", "st_transform", "FUNC_DEPENDENCY" ]
-[ "sys", "or", "sys", "st_transform", "FUNC_DEPENDENCY" ]
[ "sys", "st_srid", "sys", "st_transform", "FUNC_DEPENDENCY"
]
[ "sys", "columnsize", "sys", "storagemodel", "FUNC_DEPENDENCY"
]
[ "sys", "hashsize", "sys", "storagemodel", "FUNC_DEPENDENCY"
]
@@ -5242,7 +5213,6 @@ drop function pcre_replace(string, strin
[ "sys", "get_type", "sys", "geometry_columns",
"VIEW_DEPENDENCY" ]
[ "sys", "has_m", "sys", "geometry_columns",
"VIEW_DEPENDENCY" ]
[ "sys", "has_z", "sys", "geometry_columns",
"VIEW_DEPENDENCY" ]
-[ "sys", "sql_add", "sys", "geometry_columns",
"VIEW_DEPENDENCY" ]
[ "sys", "optimizers", "sys", "optimizers", "VIEW_DEPENDENCY"
]
[ "sys", "querylog_calls", "sys", "querylog_calls",
"VIEW_DEPENDENCY" ]
[ "sys", "querylog_catalog", "sys", "querylog_catalog",
"VIEW_DEPENDENCY" ]
@@ -5253,13 +5223,7 @@ drop function pcre_replace(string, strin
[ "sys", "sessions", "sys", "sessions", "VIEW_DEPENDENCY"
]
[ "sys", "storage", "sys", "storage", "VIEW_DEPENDENCY"
]
[ "sys", "storagemodel", "sys", "storagemodel", "VIEW_DEPENDENCY"
]
-[ "sys", "=", "sys", "tablestoragemodel", "VIEW_DEPENDENCY"
]
-[ "sys", "ifthenelse", "sys", "tablestoragemodel",
"VIEW_DEPENDENCY" ]
-[ "sys", "isnull", "sys", "tablestoragemodel",
"VIEW_DEPENDENCY" ]
-[ "sys", "max", "sys", "tablestoragemodel", "VIEW_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "tablestoragemodel",
"VIEW_DEPENDENCY" ]
[ "sys", "storagemodel", "sys", "tablestoragemodel",
"VIEW_DEPENDENCY" ]
-[ "sys", "sum", "sys", "tablestoragemodel", "VIEW_DEPENDENCY"
]
[ "sys", "tracelog", "sys", "tracelog", "VIEW_DEPENDENCY"
]
#select s1.name, t1.name, s2.name, t2.name, dt.name from (values (1,
'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4,
'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7,
'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10,
'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13,
'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as
dt (id, name), schemas s1, _tables t1, schemas s2, _tables t2, dependencies d
where d.depend_type = dt.id and d.id = t1.id and t1.schema_id = s1.id and
d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name,
s1.name, t1.name;
% sys.s1, sys.t1, sys.s2, sys.t2, .dt # table_name
@@ -6650,6 +6614,9 @@ drop function pcre_replace(string, strin
[ "setstream" ]
[ "settimeout" ]
[ "settimeout" ]
+[ "shpattach" ]
+[ "shpload" ]
+[ "shpload" ]
[ "shrink" ]
[ "shutdown" ]
[ "shutdown" ]
diff --git a/clients/Tests/SQL-dump.stable.out.int128
b/clients/Tests/SQL-dump.stable.out.int128
--- a/clients/Tests/SQL-dump.stable.out.int128
+++ b/clients/Tests/SQL-dump.stable.out.int128
@@ -235,6 +235,8 @@ Ready.
\dSf sys."setmasklen"
\dSf sys."setsession"
\dSf sys."settimeout"
+\dSf sys."shpattach"
+\dSf sys."shpload"
\dSf sys."shrink"
\dSf sys."shutdown"
\dSf sys."st_area"
@@ -629,6 +631,8 @@ SYSTEM FUNCTION sys.sessions
SYSTEM FUNCTION sys.setmasklen
SYSTEM FUNCTION sys.setsession
SYSTEM FUNCTION sys.settimeout
+SYSTEM FUNCTION sys.shpattach
+SYSTEM FUNCTION sys.shpload
SYSTEM FUNCTION sys.shrink
SYSTEM FUNCTION sys.shutdown
SYSTEM FUNCTION sys.sign
@@ -1008,6 +1012,9 @@ create function "setmasklen" (p inet, ma
create procedure sys.setsession("timeout" bigint) external name sql.setsession;
create procedure sys.settimeout("query" bigint) external name sql.settimeout;
create procedure sys.settimeout("query" bigint, "session" bigint) external
name sql.settimeout;
+create procedure shpattach(fname string) external name shp.attach;
+create procedure shpload(fid integer) external name shp.load;
+create procedure shpload(fid integer, filter geometry) external name
shp.import;
create procedure shrink(sys string, tab string) external name sql.shrink;
create procedure sys.shutdown(delay tinyint) external name sql.shutdown;
create procedure sys.shutdown(delay tinyint, force bool) external name
sql.shutdown;
@@ -2992,6 +2999,9 @@ drop function pcre_replace(string, strin
[ "sys", "setsession", "create procedure sys.setsession(\"timeout\"
bigint) external name sql.setsession;", "sql", 1, 2, true,
false, false ]
[ "sys", "settimeout", "create procedure sys.settimeout(\"query\"
bigint) external name sql.settimeout;", "sql", 1, 2, true,
false, false ]
[ "sys", "settimeout", "create procedure sys.settimeout(\"query\"
bigint, \"session\" bigint) external name sql.settimeout;", "sql", 1, 2,
true, false, false ]
+[ "sys", "shpattach", "create procedure shpattach(fname string)
external name shp.attach;", "shp", 1, 2, true, false, false ]
+[ "sys", "shpload", "create procedure shpload(fid integer) external
name shp.load;", "shp", 1, 2, true, false, false ]
+[ "sys", "shpload", "create procedure shpload(fid integer, filter
geometry) external name shp.import;", "shp", 1, 2, true,
false, false ]
[ "sys", "shrink", "create procedure shrink(sys string, tab
string) external name sql.shrink;", "sql", 1, 2, true, false,
false ]
[ "sys", "shutdown", "create procedure sys.shutdown(delay tinyint)
external name sql.shutdown;", "sql", 1, 2, true, false, false
]
[ "sys", "shutdown", "create procedure sys.shutdown(delay tinyint,
force bool) external name sql.shutdown;", "sql", 1, 2, true,
false, false ]
@@ -4817,6 +4827,9 @@ drop function pcre_replace(string, strin
[ "sys", "setsession", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "settimeout", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "settimeout", "session", "bigint", 64, 0,
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys", "shpattach", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys", "shpload", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys", "shpload", "filter", "geometry", 0, 0,
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys", "shrink", "tab", "clob", 0, 0, 1, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "shutdown", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "shutdown", "force", "boolean", 1, 0,
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
@@ -5406,55 +5419,12 @@ drop function pcre_replace(string, strin
% sys.s1, sys.f1, sys.s2, sys.f2, .dt # table_name
% name, name, name, name, name # name
% varchar, varchar, varchar, varchar, char # type
-% 3, 17, 3, 31, 20 # length
-[ "sys", "=", "sys", "columnsize", "FUNC_DEPENDENCY" ]
-[ "sys", "left_shift", "sys", "columnsize", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "columnsize", "FUNC_DEPENDENCY"
]
-[ "sys", "pi", "sys", "degrees", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_div", "sys", "degrees", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "degrees", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "dependencies_columns_on_indexes",
"FUNC_DEPENDENCY" ]
-[ "sys", "hash", "sys", "dependencies_columns_on_indexes",
"FUNC_DEPENDENCY" ]
-[ "sys", "rotate_xor_hash", "sys",
"dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ]
-[ "sys", "=", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "hash", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "rotate_xor_hash", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "sql_neg", "sys", "dependencies_columns_on_keys",
"FUNC_DEPENDENCY" ]
-[ "sys", "zero_or_one", "sys", "getproj4", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "hashsize", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_mul", "sys", "hashsize", "FUNC_DEPENDENCY"
]
-[ "sys", "<>", "sys", "heapsize", "FUNC_DEPENDENCY" ]
-[ "sys", "and", "sys", "heapsize", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_add", "sys", "heapsize", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_mul", "sys", "heapsize", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "imprintsize", "FUNC_DEPENDENCY" ]
-[ "sys", "or", "sys", "imprintsize", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_mul", "sys", "imprintsize", "FUNC_DEPENDENCY"
]
-[ "sys", "=", "sys", "ms_round", "FUNC_DEPENDENCY" ]
-[ "sys", "isnull", "sys", "ms_round", "FUNC_DEPENDENCY"
]
+% 3, 17, 3, 13, 20 # length
[ "sys", "ms_trunc", "sys", "ms_round", "FUNC_DEPENDENCY"
]
-[ "sys", "not", "sys", "ms_round", "FUNC_DEPENDENCY" ]
-[ "sys", "or", "sys", "ms_round", "FUNC_DEPENDENCY" ]
-[ "sys", "round", "sys", "ms_round", "FUNC_DEPENDENCY"
]
-[ "sys", "<", "sys", "ms_stuff", "FUNC_DEPENDENCY" ]
-[ "sys", ">", "sys", "ms_stuff", "FUNC_DEPENDENCY" ]
-[ "sys", "concat", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "length", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "or", "sys", "ms_stuff", "FUNC_DEPENDENCY" ]
-[ "sys", "sql_add", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_add", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "sql_sub", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
-[ "sys", "substring", "sys", "ms_stuff", "FUNC_DEPENDENCY"
]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
