Changeset: 52023c4a6786 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=52023c4a6786
Added Files:
sql/benchmarks/tpch/Tests/02-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/02-plan.stable.out.32bit
sql/benchmarks/tpch/Tests/13-plan.stable.out.32bit
sql/benchmarks/tpch/Tests/16-plan.stable.out.32bit
sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.err.32bit
sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.out.32bit
sql/test/lateral/Tests/All
sql/test/lateral/Tests/lateral.sql
sql/test/lateral/Tests/lateral.stable.err
sql/test/lateral/Tests/lateral.stable.out
sql/test/orderidx/Tests/simpletable.stable.out.32bit
sql/test/orderidx/Tests/smalltable.stable.out.32bit
sql/test/pg_regress/Tests/oid.stable.out.32bit
sql/test/pg_regress/Tests/without_oid.stable.out.32bit
Removed Files:
monetdb5/modules/mal/Tests/zorder.malC
monetdb5/modules/mal/Tests/zorder.stable.err
monetdb5/modules/mal/Tests/zorder.stable.out
monetdb5/modules/mal/zorder.c
monetdb5/modules/mal/zorder.h
monetdb5/modules/mal/zorder.mal
sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
sql/scripts/24_zorder.sql
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out.32bit
sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out.32bit
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.32bit
sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.out.32bit
sql/test/Dependencies/Tests/Dependencies.stable.out.int128
Modified Files:
NT/installer32/MonetDB5-SQL-Installer.vdproj
NT/installer64/MonetDB5-SQL-Installer.vdproj
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/Tests/exports.stable.out
clients/odbc/driver/README
clients/odbc/driver/SQLBindParameter.c
clients/odbc/driver/SQLBulkOperations.c
clients/odbc/driver/SQLCopyDesc.c
clients/odbc/driver/SQLDescribeParam.c
clients/odbc/driver/SQLEndTran.c
clients/odbc/driver/SQLExtendedFetch.c
clients/odbc/driver/SQLFetchScroll.c
clients/odbc/driver/SQLGetEnvAttr.c
clients/odbc/driver/SQLGetFunctions.c
clients/odbc/driver/SQLNumParams.c
clients/odbc/driver/SQLSetDescRec.c
clients/odbc/driver/SQLSetEnvAttr.c
configure.ag
gdk/gdk_aggr.c
gdk/gdk_atoms.h
gdk/gdk_calc.h
gdk/gdk_cross.c
gdk/gdk_heap.c
gdk/gdk_unique.c
java/src/main/java/nl/cwi/monetdb/jdbc/MonetBlob.java
java/src/main/java/nl/cwi/monetdb/jdbc/MonetDriver.java.in
monetdb5/ChangeLog
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows.single
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
monetdb5/mal/mal.h
monetdb5/mal/mal_debugger.c
monetdb5/mal/mal_instruction.c
monetdb5/mal/mal_instruction.h
monetdb5/mal/mal_interpreter.c
monetdb5/mal/mal_listing.c
monetdb5/mal/mal_module.c
monetdb5/mal/mal_module.h
monetdb5/mal/mal_parser.c
monetdb5/mal/mal_profiler.c
monetdb5/mal/mal_runtime.c
monetdb5/modules/atoms/batxml.c
monetdb5/modules/atoms/json.c
monetdb5/modules/atoms/uuid.c
monetdb5/modules/mal/Makefile.ag
monetdb5/modules/mal/Tests/All
monetdb5/modules/mal/Tests/inspect05.stable.out
monetdb5/modules/mal/mal_init.mal
monetdb5/modules/mal/mkey.c
monetdb5/modules/mal/mkey.h
monetdb5/optimizer/Tests/manifold2.stable.out.single
monetdb5/optimizer/opt_profiler.c
rpm.mk.in
sql/ChangeLog
sql/backends/monet5/rel_bin.c
sql/backends/monet5/sql.c
sql/backends/monet5/sql_gencode.c
sql/backends/monet5/sql_scenario.c
sql/backends/monet5/sql_statement.c
sql/backends/monet5/sql_statement.h
sql/backends/monet5/sql_upgrades.c
sql/benchmarks/tpch/Tests/01-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/06-explain.stable.out
sql/benchmarks/tpch/Tests/07-explain.stable.out
sql/benchmarks/tpch/Tests/08-explain.stable.out
sql/benchmarks/tpch/Tests/09-explain.stable.out
sql/benchmarks/tpch/Tests/10-explain.stable.out
sql/benchmarks/tpch/Tests/11-explain.stable.out
sql/benchmarks/tpch/Tests/14-explain.stable.out
sql/benchmarks/tpch/Tests/15-explain.stable.out
sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/19-explain.stable.out
sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
sql/common/sql_keyword.c
sql/common/sql_list.c
sql/common/sql_types.c
sql/include/sql_catalog.h
sql/include/sql_relation.h
sql/scripts/Makefile.ag
sql/server/Makefile.ag
sql/server/rel_exp.c
sql/server/rel_exp.h
sql/server/rel_optimizer.c
sql/server/rel_psm.c
sql/server/rel_psm.h
sql/server/rel_rel.c
sql/server/rel_rel.h
sql/server/rel_select.c
sql/server/rel_select.h
sql/server/rel_updates.c
sql/server/sql_datetime.c
sql/server/sql_decimal.c
sql/server/sql_parser.y
sql/server/sql_scan.c
sql/server/sql_symbol.c
sql/server/sql_symbol.h
sql/storage/store.c
sql/test/BugTracker-2009/Tests/All
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128.single
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.single
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out.single
sql/test/BugTracker-2015/Tests/expression_with_comparison.Bug-3854.stable.out
sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out
sql/test/BugTracker-2015/Tests/schemadiff.Bug-3778.stable.out
sql/test/BugTracker-2016/Tests/All
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out
sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
sql/test/Dependencies/Tests/Dependencies.stable.out
sql/test/SQLite_regress/sqllogictest/Tests/All
sql/test/Tests/systemfunctions.stable.out
sql/test/Tests/systemfunctions.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/check.stable.out
sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/check.stable.out
sql/test/emptydb-upgrade/Tests/check.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/leaks/Tests/check0.stable.out
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/leaks/Tests/select1.stable.out
sql/test/leaks/Tests/select2.stable.out
sql/test/pg_regress/Tests/interval.stable.err
sql/test/pg_regress/Tests/interval.stable.err.int128
sql/test/pg_regress/Tests/interval.stable.out
sql/test/pg_regress/Tests/interval.stable.out.int128
sql/test/pg_regress/Tests/strings.stable.err
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
tools/merovingian/daemon/argvcmds.c
tools/merovingian/daemon/handlers.c
tools/merovingian/daemon/monetdbd.service.in
Branch: sfcgal
Log Message:
Merge with default
diffs (truncated from 18366 to 300 lines):
diff --git a/NT/installer32/MonetDB5-SQL-Installer.vdproj
b/NT/installer32/MonetDB5-SQL-Installer.vdproj
--- a/NT/installer32/MonetDB5-SQL-Installer.vdproj
+++ b/NT/installer32/MonetDB5-SQL-Installer.vdproj
@@ -897,12 +897,6 @@
}
"Entry"
{
- "MsmKey" = "8:_EC56B031A65A44BCA049E43F5A7641C4"
- "OwnerKey" = "8:_UNDEFINED"
- "MsmSig" = "8:_UNDEFINED"
- }
- "Entry"
- {
"MsmKey" = "8:_F0AD495DD01A481B8FDB22499521AFB7"
"OwnerKey" = "8:_UNDEFINED"
"MsmSig" = "8:_UNDEFINED"
@@ -939,12 +933,6 @@
}
"Entry"
{
- "MsmKey" = "8:_F64E69D474DA4F6A89A1B014F77E4669"
- "OwnerKey" = "8:_UNDEFINED"
- "MsmSig" = "8:_UNDEFINED"
- }
- "Entry"
- {
"MsmKey" = "8:_F827A21B394243CA9A2DA27D42DA0C93"
"OwnerKey" = "8:_UNDEFINED"
"MsmSig" = "8:_UNDEFINED"
@@ -3964,26 +3952,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_EC56B031A65A44BCA049E43F5A7641C4"
- {
- "SourcePath" = "8:lib\\monetdb5\\zorder.mal"
- "TargetName" = "8:zorder.mal"
- "Tag" = "8:"
- "Folder" = "8:_B593DAA0787744D6A44D17884E0C3951"
- "Condition" = "8:"
- "Transitive" = "11:FALSE"
- "Vital" = "11:TRUE"
- "ReadOnly" = "11:FALSE"
- "Hidden" = "11:FALSE"
- "System" = "11:FALSE"
- "Permanent" = "11:FALSE"
- "SharedLegacy" = "11:FALSE"
- "PackageAs" = "3:1"
- "Register" = "3:1"
- "Exclude" = "11:FALSE"
- "IsDependency" = "11:FALSE"
- "IsolateTo" = "8:"
- }
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_F0AD495DD01A481B8FDB22499521AFB7"
{
"SourcePath" = "8:lib\\monetdb5\\autoload\\01_batcalc.mal"
@@ -4104,26 +4072,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_F64E69D474DA4F6A89A1B014F77E4669"
- {
- "SourcePath" = "8:lib\\monetdb5\\createdb\\24_zorder.sql"
- "TargetName" = "8:24_zorder.sql"
- "Tag" = "8:"
- "Folder" = "8:_7F962DDBDF894636B6CAFE6FE4887567"
- "Condition" = "8:"
- "Transitive" = "11:FALSE"
- "Vital" = "11:TRUE"
- "ReadOnly" = "11:FALSE"
- "Hidden" = "11:FALSE"
- "System" = "11:FALSE"
- "Permanent" = "11:FALSE"
- "SharedLegacy" = "11:FALSE"
- "PackageAs" = "3:1"
- "Register" = "3:1"
- "Exclude" = "11:FALSE"
- "IsDependency" = "11:FALSE"
- "IsolateTo" = "8:"
- }
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_F827A21B394243CA9A2DA27D42DA0C93"
{
"SourcePath" = "8:lib\\libmapi.lib"
diff --git a/NT/installer64/MonetDB5-SQL-Installer.vdproj
b/NT/installer64/MonetDB5-SQL-Installer.vdproj
--- a/NT/installer64/MonetDB5-SQL-Installer.vdproj
+++ b/NT/installer64/MonetDB5-SQL-Installer.vdproj
@@ -897,12 +897,6 @@
}
"Entry"
{
- "MsmKey" = "8:_EC56B031A65A44BCA049E43F5A7641C4"
- "OwnerKey" = "8:_UNDEFINED"
- "MsmSig" = "8:_UNDEFINED"
- }
- "Entry"
- {
"MsmKey" = "8:_F0AD495DD01A481B8FDB22499521AFB7"
"OwnerKey" = "8:_UNDEFINED"
"MsmSig" = "8:_UNDEFINED"
@@ -939,12 +933,6 @@
}
"Entry"
{
- "MsmKey" = "8:_F64E69D474DA4F6A89A1B014F77E4669"
- "OwnerKey" = "8:_UNDEFINED"
- "MsmSig" = "8:_UNDEFINED"
- }
- "Entry"
- {
"MsmKey" = "8:_F827A21B394243CA9A2DA27D42DA0C93"
"OwnerKey" = "8:_UNDEFINED"
"MsmSig" = "8:_UNDEFINED"
@@ -3964,26 +3952,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_EC56B031A65A44BCA049E43F5A7641C4"
- {
- "SourcePath" = "8:lib\\monetdb5\\zorder.mal"
- "TargetName" = "8:zorder.mal"
- "Tag" = "8:"
- "Folder" = "8:_B593DAA0787744D6A44D17884E0C3951"
- "Condition" = "8:"
- "Transitive" = "11:FALSE"
- "Vital" = "11:TRUE"
- "ReadOnly" = "11:FALSE"
- "Hidden" = "11:FALSE"
- "System" = "11:FALSE"
- "Permanent" = "11:FALSE"
- "SharedLegacy" = "11:FALSE"
- "PackageAs" = "3:1"
- "Register" = "3:1"
- "Exclude" = "11:FALSE"
- "IsDependency" = "11:FALSE"
- "IsolateTo" = "8:"
- }
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_F0AD495DD01A481B8FDB22499521AFB7"
{
"SourcePath" = "8:lib\\monetdb5\\autoload\\01_batcalc.mal"
@@ -4104,26 +4072,6 @@
"IsDependency" = "11:FALSE"
"IsolateTo" = "8:"
}
-
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_F64E69D474DA4F6A89A1B014F77E4669"
- {
- "SourcePath" = "8:lib\\monetdb5\\createdb\\24_zorder.sql"
- "TargetName" = "8:24_zorder.sql"
- "Tag" = "8:"
- "Folder" = "8:_7F962DDBDF894636B6CAFE6FE4887567"
- "Condition" = "8:"
- "Transitive" = "11:FALSE"
- "Vital" = "11:TRUE"
- "ReadOnly" = "11:FALSE"
- "Hidden" = "11:FALSE"
- "System" = "11:FALSE"
- "Permanent" = "11:FALSE"
- "SharedLegacy" = "11:FALSE"
- "PackageAs" = "3:1"
- "Register" = "3:1"
- "Exclude" = "11:FALSE"
- "IsDependency" = "11:FALSE"
- "IsolateTo" = "8:"
- }
"{1FB2D0AE-D3B9-43D4-B9DD-F88EC61E35DE}:_F827A21B394243CA9A2DA27D42DA0C93"
{
"SourcePath" = "8:lib\\libmapi.lib"
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
@@ -8689,15 +8689,6 @@ Ready.
[ "xml", "subaggr", "command
xml.subaggr(val:bat[:xml],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit):bat[:xml]
", "AGGRsubxmlcand;", "Grouped aggregation of XML values with
candidates list." ]
[ "xml", "text", "command xml.text(src:xml):str ", "XMLxmltext;",
"Extract text from an xml atom" ]
[ "xml", "xml", "command xml.xml(src:str):xml ", "XMLstr2xml;",
"Cast the string to an xml compliant string" ]
-[ "zorder", "decode", "command zorder.decode(z:bat[:oid])
(X_0:bat[:int],X_1:bat[:int]) ", "ZORDbatdecode_int_oid;", "Derive the
z-order pair" ]
-[ "zorder", "decode", "command zorder.decode(z:oid) (x:int,y:int) ",
"ZORDdecode_int_oid;", "Derive the z-order pair" ]
-[ "zorder", "decode_x", "command zorder.decode_x(z:bat[:oid]):bat[:int]
", "ZORDbatdecode_int_oid_x;", "Derive the z-order x-coordinate"
]
-[ "zorder", "decode_x", "command zorder.decode_x(z:oid):int ",
"ZORDdecode_int_oid_x;", "Derive the z-order x-coordinate" ]
-[ "zorder", "decode_y", "command zorder.decode_y(z:bat[:oid]):bat[:int]
", "ZORDbatdecode_int_oid_y;", "Derive the z-order y-coordinate"
]
-[ "zorder", "decode_y", "command zorder.decode_y(z:oid):int ",
"ZORDdecode_int_oid_y;", "Derive the z-order y-coordinate" ]
-[ "zorder", "encode", "command
zorder.encode(x:bat[:int],y:bat[:int]):bat[:oid] ",
"ZORDbatencode_int_oid;", "Derive the z-order index from a value pair"
]
-[ "zorder", "encode", "command zorder.encode(x:int,y:int):oid ",
"ZORDencode_int_oid;", "Derive the z-order index from a value pair" ]
-[ "zorder", "slice", "command
zorder.slice(xb:int,yb:int,xt:int,yt:int):bat[:oid] ", "ZORDslice_int;",
"Extract the Z-order indices between two points" ]
[ "zrule", "#fromstr", "command zrule.#fromstr():void ",
"rule_fromstr;", "" ]
[ "zrule", "#tostr", "command zrule.#tostr():void ", "rule_tostr;",
"" ]
[ "zrule", "define", "command
zrule.define(m:int,d:int,w:int,h:int,min:int):zrule ", "MTIMEruleDef0;",
"Introduce a synomym timezone rule." ]
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
@@ -11059,15 +11059,6 @@ Ready.
[ "xml", "subaggr", "command
xml.subaggr(val:bat[:xml],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit):bat[:xml]
", "AGGRsubxmlcand;", "Grouped aggregation of XML values with
candidates list." ]
[ "xml", "text", "command xml.text(src:xml):str ", "XMLxmltext;",
"Extract text from an xml atom" ]
[ "xml", "xml", "command xml.xml(src:str):xml ", "XMLstr2xml;",
"Cast the string to an xml compliant string" ]
-[ "zorder", "decode", "command zorder.decode(z:bat[:oid])
(X_0:bat[:int],X_1:bat[:int]) ", "ZORDbatdecode_int_oid;", "Derive the
z-order pair" ]
-[ "zorder", "decode", "command zorder.decode(z:oid) (x:int,y:int) ",
"ZORDdecode_int_oid;", "Derive the z-order pair" ]
-[ "zorder", "decode_x", "command zorder.decode_x(z:bat[:oid]):bat[:int]
", "ZORDbatdecode_int_oid_x;", "Derive the z-order x-coordinate"
]
-[ "zorder", "decode_x", "command zorder.decode_x(z:oid):int ",
"ZORDdecode_int_oid_x;", "Derive the z-order x-coordinate" ]
-[ "zorder", "decode_y", "command zorder.decode_y(z:bat[:oid]):bat[:int]
", "ZORDbatdecode_int_oid_y;", "Derive the z-order y-coordinate"
]
-[ "zorder", "decode_y", "command zorder.decode_y(z:oid):int ",
"ZORDdecode_int_oid_y;", "Derive the z-order y-coordinate" ]
-[ "zorder", "encode", "command
zorder.encode(x:bat[:int],y:bat[:int]):bat[:oid] ",
"ZORDbatencode_int_oid;", "Derive the z-order index from a value pair"
]
-[ "zorder", "encode", "command zorder.encode(x:int,y:int):oid ",
"ZORDencode_int_oid;", "Derive the z-order index from a value pair" ]
-[ "zorder", "slice", "command
zorder.slice(xb:int,yb:int,xt:int,yt:int):bat[:oid] ", "ZORDslice_int;",
"Extract the Z-order indices between two points" ]
[ "zrule", "#fromstr", "command zrule.#fromstr():void ",
"rule_fromstr;", "" ]
[ "zrule", "#tostr", "command zrule.#tostr():void ", "rule_tostr;",
"" ]
[ "zrule", "define", "command
zrule.define(m:int,d:int,w:int,h:int,min:int):zrule ", "MTIMEruleDef0;",
"Introduce a synomym timezone rule." ]
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
@@ -357,9 +357,6 @@ Ready.
\dSf sys."var"
\dSf sys."var_pop"
\dSf sys."var_samp"
-\dSf sys."zorder_decode_x"
-\dSf sys."zorder_decode_y"
-\dSf sys."zorder_encode"
SYSTEM SCHEMA bam
SYSTEM SCHEMA json
SYSTEM SCHEMA profiler
@@ -785,9 +782,6 @@ SYSTEM FUNCTION sys.weekofyear
SYSTEM FUNCTION sys.xor
SYSTEM FUNCTION sys.year
SYSTEM FUNCTION sys.zero_or_one
-SYSTEM FUNCTION sys.zorder_decode_x
-SYSTEM FUNCTION sys.zorder_decode_y
-SYSTEM FUNCTION sys.zorder_encode
CREATE SCHEMA "bam" AUTHORIZATION "monetdb";
CREATE SCHEMA "json" AUTHORIZATION "monetdb";
CREATE SCHEMA "profiler" AUTHORIZATION "monetdb";
@@ -1190,9 +1184,6 @@ create aggregate var_samp(val double) re
create aggregate var_samp(val date) returns double external name
"aggr"."variance";
create aggregate var_samp(val time) returns double external name
"aggr"."variance";
create aggregate var_samp(val timestamp) returns double external name
"aggr"."variance";
-create function zorder_decode_x(z oid) returns integer external name
zorder.decode_x;
-create function zorder_decode_y(z oid) returns integer external name
zorder.decode_y;
-create function zorder_encode(x integer, y integer) returns oid external name
zorder.encode;
-- helper function
create function pcre_replace(origin string, pat string, repl string, flags
string) returns string external name pcre.replace;
@@ -1826,6 +1817,11 @@ drop function pcre_replace(string, strin
[ "sys", "atan", "atan2", "mmath", 0, 1, false,
false, false ]
[ "sys", "atan", "atan2", "mmath", 0, 1, false,
false, false ]
[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
+[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
+[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
+[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
+[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
+[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
[ "sys", "bbp", "create function sys.bbp () returns table (id int, name
string, ttype string, count bigint, refcnt int, lrefcnt int, location string,
heat int, dirty string, status string, kind string) external name bbp.get;",
"bbp", 1, 5, false, false, false ]
[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
@@ -3293,9 +3289,6 @@ drop function pcre_replace(string, strin
[ "sys", "year", "year", "mtime", 0, 1, false, false,
false ]
[ "sys", "year", "year", "mtime", 0, 1, false, false,
false ]
[ "sys", "zero_or_one", "zero_or_one", "sql", 0, 3, false,
false, false ]
-[ "sys", "zorder_decode_x", "create function zorder_decode_x(z oid)
returns integer external name zorder.decode_x;", "zorder", 1,
1, false, false, false ]
-[ "sys", "zorder_decode_y", "create function zorder_decode_y(z oid)
returns integer external name zorder.decode_y;", "zorder", 1,
1, false, false, false ]
-[ "sys", "zorder_encode", "create function zorder_encode(x
integer, y integer) returns oid external name zorder.encode;", "zorder",
1, 1, false, false, false ]
#with
#arg1 (id, id1, name1, type1, type_digits1, type_scale1, inout1) as (select
f.id, a1.id, a1.name, a1.type, a1.type_digits, a1.type_scale, a1.inout from
sys.functions f left outer join args a1 on a1.func_id = f.id and a1.number = 1),
#arg2 (id, id1, name1, type1, type_digits1, type_scale1, inout1, id2, name2,
type2, type_digits2, type_scale2, inout2) as (select arg1.*, a2.id, a2.name,
a2.type, a2.type_digits, a2.type_scale, a2.inout from arg1 left outer join args
a2 on a2.func_id = arg1.id and a2.number = 2),
@@ -3379,7 +3372,12 @@ drop function pcre_replace(string, strin
[ "sys", "atan", "arg_1", "double", 53, 0, 1,
"arg_2", "double", 53, 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 ]
[ "sys", "atan", "arg_1", "real", 24, 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", "atan", "arg_1", "real", 24, 0, 1,
"arg_2", "real", 24, 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 ]
+[ "sys", "avg", "arg", "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", "avg", "arg", "double", 53, 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", "avg", "arg", "int", 32, 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", "avg", "arg", "real", 24, 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", "avg", "arg", "smallint", 16, 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", "avg", "arg", "tinyint", 8, 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", "bbp", "name", "clob", 0, 0, 0, "ttype",
"clob", 0, 0, 0, "count", "bigint", 64, 0,
0, "refcnt", "int", 32, 0, 0, "lrefcnt", "int",
32, 0, 0, "location", "clob", 0, 0, 0, "heat",
"int", 32, 0, 0, "dirty", "clob", 0, 0, 0,
"status", "clob", 0, 0, 0, "kind", "clob", 0, 0,
0, NULL, 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", "bit_and", "arg_1", "bigint", 64, 0,
1, "arg_2", "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 ]
[ "sys", "bit_and", "arg_1", "decimal", 2, 0,
1, "arg_2", "decimal", 2, 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 ]
@@ -4847,9 +4845,6 @@ drop function pcre_replace(string, strin
[ "sys", "year", "arg_1", "timestamp", 7, 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", "year", "arg_1", "timestamptz", 7, 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", "zero_or_one", "arg", "any", 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", "zorder_decode_x", "z", "oid", 63, 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", "zorder_decode_y", "z", "oid", 63, 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", "zorder_encode", "x", "int", 32, 0, 1,
"y", "int", 32, 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
]
#select name, grantor from sys.auths;
% sys.auths, sys.auths # table_name
% name, grantor # name
@@ -4984,6 +4979,7 @@ drop function pcre_replace(string, strin
[ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys",
"FUNC_DEPENDENCY" ]
[ "sys", "auths", "id", "sys",
"dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ]
[ "sys", "auths", "name", "sys",
"dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ]
+[ "sys", "schemas", "id", "sys",
"dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ]
[ "sys", "schemas", "name", "sys",
"dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ]
[ "sys", "schemas", "owner", "sys",
"dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ]
[ "sys", "schemas", "id", "sys",
"dependencies_schemas_on_users", "FUNC_DEPENDENCY" ]
@@ -5314,9 +5310,6 @@ drop function pcre_replace(string, strin
[ "time_to_str", "public", 16, "monetdb", 0 ]
[ "times", "public", 16, "monetdb", 0 ]
[ "timestamp_to_str", "public", 16, "monetdb", 0 ]
-[ "zorder_decode_x", "public", 16, "monetdb", 0 ]
-[ "zorder_decode_y", "public", 16, "monetdb", 0 ]
-[ "zorder_encode", "public", 16, "monetdb", 0 ]
#select s.name, q.name, q.start, q.minvalue, q.maxvalue, q.increment,
q.cacheinc, q.cycle from sys.sequences q left outer join sys.schemas s on
q.schema_id = s.id order by s.name, q.name;
% .s, .q, .q, .q, .q, .q, .q, .q # table_name
% name, name, start, minvalue, maxvalue, increment,
cacheinc, cycle # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
