Changeset: af0db0435e6a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=af0db0435e6a
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/scripts/24_zorder.sql
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
monetdb5/ChangeLog
monetdb5/modules/mal/Makefile.ag
monetdb5/modules/mal/Tests/All
monetdb5/modules/mal/mal_init.mal
sql/ChangeLog
sql/backends/monet5/sql_upgrades.c
sql/scripts/Makefile.ag
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/check1.stable.out.int128
sql/test/leaks/Tests/check2.stable.out.int128
sql/test/leaks/Tests/check3.stable.out.int128
sql/test/leaks/Tests/check4.stable.out.int128
sql/test/leaks/Tests/check5.stable.out.int128
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.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
Branch: default
Log Message:
Removed zorder module.
diffs (truncated from 2437 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";
@@ -3293,9 +3287,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),
@@ -4847,9 +4838,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
@@ -5314,9 +5302,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
@@ -6882,9 +6867,6 @@ drop function pcre_replace(string, strin
[ "year" ]
[ "year" ]
[ "zero_or_one" ]
-[ "zorder_decode_x" ]
-[ "zorder_decode_y" ]
-[ "zorder_encode" ]
#select t.name, g.name, g.time, g.orientation, g.event, g.old_name,
g.new_name, g.condition, g.statement from sys.triggers g left outer join
sys._tables t on g.table_id = t.id order by t.name, g.name;
% .t, .g, .g, .g, .g, .g, .g, .g, .g # table_name
% name, name, time, orientation, event, old_name,
new_name, condition, statement # name
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
@@ -353,9 +353,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
@@ -781,9 +778,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";
@@ -1196,9 +1190,6 @@ create aggregate var_samp(val date) retu
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 aggregate var_samp(val hugeint) 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;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
