Changeset: 61791f176083 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=61791f176083
Modified Files:
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.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.int128
Branch: default
Log Message:
Approved after changeset 604ae9397192.
diffs (truncated from 6198 to 300 lines):
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
@@ -108,20 +108,59 @@ SYSTEM VIEW sys.tables
SYSTEM VIEW sys.tablestoragemodel
SYSTEM VIEW sys.tracelog
SYSTEM VIEW sys.users
+SYSTEM FUNCTION sys.<
+SYSTEM FUNCTION sys.<=
+SYSTEM FUNCTION sys.<>
+SYSTEM FUNCTION sys.=
+SYSTEM FUNCTION sys.>
+SYSTEM FUNCTION sys.>=
SYSTEM FUNCTION sys.abbrev
+SYSTEM FUNCTION sys.abs
+SYSTEM FUNCTION sys.acos
SYSTEM FUNCTION sys.alpha
SYSTEM FUNCTION sys.analyze
+SYSTEM FUNCTION sys.and
+SYSTEM FUNCTION sys.ascii
+SYSTEM FUNCTION sys.asin
+SYSTEM FUNCTION sys.atan
+SYSTEM FUNCTION sys.avg
SYSTEM FUNCTION sys.bbp
+SYSTEM FUNCTION sys.bit_and
+SYSTEM FUNCTION sys.bit_not
+SYSTEM FUNCTION sys.bit_or
+SYSTEM FUNCTION sys.bit_xor
SYSTEM FUNCTION sys.broadcast
+SYSTEM FUNCTION sys.ceil
+SYSTEM FUNCTION sys.ceiling
+SYSTEM FUNCTION sys.char_length
+SYSTEM FUNCTION sys.character_length
SYSTEM FUNCTION sys.chi2prob
SYSTEM FUNCTION sys.clearrejects
+SYSTEM FUNCTION sys.code
SYSTEM FUNCTION sys.columnsize
+SYSTEM FUNCTION sys.concat
SYSTEM FUNCTION sys.contains
+SYSTEM FUNCTION sys.copyfrom
SYSTEM FUNCTION sys.corr
+SYSTEM FUNCTION sys.cos
+SYSTEM FUNCTION sys.cosh
+SYSTEM FUNCTION sys.cot
+SYSTEM FUNCTION sys.count
+SYSTEM FUNCTION sys.count_no_nil
+SYSTEM FUNCTION sys.curdate
+SYSTEM FUNCTION sys.current_date
+SYSTEM FUNCTION sys.current_time
+SYSTEM FUNCTION sys.current_timestamp
+SYSTEM FUNCTION sys.curtime
SYSTEM FUNCTION sys.date_to_str
+SYSTEM FUNCTION sys.day
+SYSTEM FUNCTION sys.dayofmonth
+SYSTEM FUNCTION sys.dayofweek
+SYSTEM FUNCTION sys.dayofyear
SYSTEM FUNCTION sys.db_users
SYSTEM FUNCTION sys.debug
SYSTEM FUNCTION sys.degrees
+SYSTEM FUNCTION sys.dense_rank
SYSTEM FUNCTION sys.dependencies_columns_on_functions
SYSTEM FUNCTION sys.dependencies_columns_on_indexes
SYSTEM FUNCTION sys.dependencies_columns_on_keys
@@ -139,17 +178,25 @@ SYSTEM FUNCTION sys.dependencies_tables
SYSTEM FUNCTION sys.dependencies_tables_on_views
SYSTEM FUNCTION sys.dependencies_views_on_functions
SYSTEM FUNCTION sys.dependencies_views_on_triggers
+SYSTEM FUNCTION sys.diff
+SYSTEM FUNCTION sys.difference
+SYSTEM FUNCTION sys.editdistance
+SYSTEM FUNCTION sys.editdistance2
SYSTEM FUNCTION sys.env
SYSTEM FUNCTION sys.environment
SYSTEM FUNCTION sys.epoch
SYSTEM FUNCTION sys.evalalgebra
+SYSTEM FUNCTION sys.exist
+SYSTEM FUNCTION sys.exp
SYSTEM FUNCTION sys.fitsattach
SYSTEM FUNCTION sys.fitsload
+SYSTEM FUNCTION sys.floor
SYSTEM FUNCTION sys.flush_log
SYSTEM FUNCTION sys.fuse
SYSTEM FUNCTION sys.generate_series
SYSTEM FUNCTION sys.geometrytype
SYSTEM FUNCTION sys.get_type
+SYSTEM FUNCTION sys.get_value_for
SYSTEM FUNCTION sys.getanchor
SYSTEM FUNCTION sys.getbasename
SYSTEM FUNCTION sys.getcontent
@@ -166,25 +213,64 @@ SYSTEM FUNCTION sys.getroboturl
SYSTEM FUNCTION sys.getuser
SYSTEM FUNCTION sys.has_m
SYSTEM FUNCTION sys.has_z
+SYSTEM FUNCTION sys.hash
SYSTEM FUNCTION sys.hashsize
SYSTEM FUNCTION sys.heapsize
SYSTEM FUNCTION sys.host
SYSTEM FUNCTION sys.hostmask
+SYSTEM FUNCTION sys.hour
+SYSTEM FUNCTION sys.identity
+SYSTEM FUNCTION sys.ifthenelse
SYSTEM FUNCTION sys.ilike
SYSTEM FUNCTION sys.imprintsize
+SYSTEM FUNCTION sys.in
+SYSTEM FUNCTION sys.index
+SYSTEM FUNCTION sys.insert
SYSTEM FUNCTION sys.internaltransform
SYSTEM FUNCTION sys.isaurl
SYSTEM FUNCTION sys.isauuid
+SYSTEM FUNCTION sys.isnull
+SYSTEM FUNCTION sys.lcase
+SYSTEM FUNCTION sys.left
SYSTEM FUNCTION sys.left_shift
SYSTEM FUNCTION sys.left_shift_assign
+SYSTEM FUNCTION sys.length
+SYSTEM FUNCTION sys.levenshtein
SYSTEM FUNCTION sys.like
SYSTEM FUNCTION sys.listdir
SYSTEM FUNCTION sys.listdirpat
+SYSTEM FUNCTION sys.local_timezone
+SYSTEM FUNCTION sys.localtime
+SYSTEM FUNCTION sys.localtimestamp
+SYSTEM FUNCTION sys.locate
+SYSTEM FUNCTION sys.log
+SYSTEM FUNCTION sys.log10
+SYSTEM FUNCTION sys.lower
+SYSTEM FUNCTION sys.lpad
+SYSTEM FUNCTION sys.ltrim
SYSTEM FUNCTION sys.malfunctions
SYSTEM FUNCTION sys.masklen
+SYSTEM FUNCTION sys.max
SYSTEM FUNCTION sys.mbr
+SYSTEM FUNCTION sys.mbr_above
+SYSTEM FUNCTION sys.mbr_below
+SYSTEM FUNCTION sys.mbr_contained
+SYSTEM FUNCTION sys.mbr_contains
+SYSTEM FUNCTION sys.mbr_distance
+SYSTEM FUNCTION sys.mbr_equal
+SYSTEM FUNCTION sys.mbr_left
+SYSTEM FUNCTION sys.mbr_overlap
+SYSTEM FUNCTION sys.mbr_overlap_or_above
+SYSTEM FUNCTION sys.mbr_overlap_or_below
+SYSTEM FUNCTION sys.mbr_overlap_or_left
+SYSTEM FUNCTION sys.mbr_overlap_or_right
+SYSTEM FUNCTION sys.mbr_right
SYSTEM FUNCTION sys.md5
SYSTEM FUNCTION sys.median
+SYSTEM FUNCTION sys.min
+SYSTEM FUNCTION sys.minute
+SYSTEM FUNCTION sys.mod
+SYSTEM FUNCTION sys.month
SYSTEM FUNCTION sys.ms_round
SYSTEM FUNCTION sys.ms_str
SYSTEM FUNCTION sys.ms_stuff
@@ -194,10 +280,24 @@ SYSTEM FUNCTION sys.netcdf_importvar
SYSTEM FUNCTION sys.netmask
SYSTEM FUNCTION sys.network
SYSTEM FUNCTION sys.newurl
+SYSTEM FUNCTION sys.next_value_for
+SYSTEM FUNCTION sys.not
+SYSTEM FUNCTION sys.not_exist
+SYSTEM FUNCTION sys.not_ilike
+SYSTEM FUNCTION sys.not_like
+SYSTEM FUNCTION sys.not_unique
+SYSTEM FUNCTION sys.not_uniques
+SYSTEM FUNCTION sys.octet_length
SYSTEM FUNCTION sys.optimizer_stats
SYSTEM FUNCTION sys.optimizers
+SYSTEM FUNCTION sys.or
SYSTEM FUNCTION sys.password_hash
+SYSTEM FUNCTION sys.patindex
SYSTEM FUNCTION sys.pause
+SYSTEM FUNCTION sys.pi
+SYSTEM FUNCTION sys.power
+SYSTEM FUNCTION sys.prod
+SYSTEM FUNCTION sys.qgramnormalize
SYSTEM FUNCTION sys.quantile
SYSTEM FUNCTION sys.querycache
SYSTEM FUNCTION sys.querylog
@@ -208,18 +308,48 @@ SYSTEM FUNCTION sys.querylog_empty
SYSTEM FUNCTION sys.querylog_enable
SYSTEM FUNCTION sys.queue
SYSTEM FUNCTION sys.radians
+SYSTEM FUNCTION sys.rand
+SYSTEM FUNCTION sys.rank
SYSTEM FUNCTION sys.rejects
+SYSTEM FUNCTION sys.repeat
+SYSTEM FUNCTION sys.replace
+SYSTEM FUNCTION sys.restart
SYSTEM FUNCTION sys.resume
SYSTEM FUNCTION sys.reuse
SYSTEM FUNCTION sys.reverse
+SYSTEM FUNCTION sys.right
SYSTEM FUNCTION sys.right_shift
SYSTEM FUNCTION sys.right_shift_assign
+SYSTEM FUNCTION sys.rotate_xor_hash
+SYSTEM FUNCTION sys.round
+SYSTEM FUNCTION sys.row_number
+SYSTEM FUNCTION sys.rowid
+SYSTEM FUNCTION sys.rpad
+SYSTEM FUNCTION sys.rtrim
+SYSTEM FUNCTION sys.scale_down
+SYSTEM FUNCTION sys.scale_up
+SYSTEM FUNCTION sys.second
SYSTEM FUNCTION sys.sessions
SYSTEM FUNCTION sys.setmasklen
SYSTEM FUNCTION sys.setsession
SYSTEM FUNCTION sys.settimeout
SYSTEM FUNCTION sys.shrink
SYSTEM FUNCTION sys.shutdown
+SYSTEM FUNCTION sys.sign
+SYSTEM FUNCTION sys.similarity
+SYSTEM FUNCTION sys.sin
+SYSTEM FUNCTION sys.sinh
+SYSTEM FUNCTION sys.soundex
+SYSTEM FUNCTION sys.space
+SYSTEM FUNCTION sys.splitpart
+SYSTEM FUNCTION sys.sql_add
+SYSTEM FUNCTION sys.sql_div
+SYSTEM FUNCTION sys.sql_max
+SYSTEM FUNCTION sys.sql_min
+SYSTEM FUNCTION sys.sql_mul
+SYSTEM FUNCTION sys.sql_neg
+SYSTEM FUNCTION sys.sql_sub
+SYSTEM FUNCTION sys.sqrt
SYSTEM FUNCTION sys.st_area
SYSTEM FUNCTION sys.st_asbinary
SYSTEM FUNCTION sys.st_asewkt
@@ -322,16 +452,30 @@ SYSTEM FUNCTION sys.storagemodelinit
SYSTEM FUNCTION sys.str_to_date
SYSTEM FUNCTION sys.str_to_time
SYSTEM FUNCTION sys.str_to_timestamp
+SYSTEM FUNCTION sys.strings
+SYSTEM FUNCTION sys.substring
+SYSTEM FUNCTION sys.sum
+SYSTEM FUNCTION sys.tan
+SYSTEM FUNCTION sys.tanh
SYSTEM FUNCTION sys.text
SYSTEM FUNCTION sys.time_to_str
SYSTEM FUNCTION sys.times
SYSTEM FUNCTION sys.timestamp_to_str
SYSTEM FUNCTION sys.tracelog
+SYSTEM FUNCTION sys.trim
+SYSTEM FUNCTION sys.truncate
+SYSTEM FUNCTION sys.ucase
+SYSTEM FUNCTION sys.upper
SYSTEM FUNCTION sys.uuid
SYSTEM FUNCTION sys.vacuum
SYSTEM FUNCTION sys.var
SYSTEM FUNCTION sys.var_pop
SYSTEM FUNCTION sys.var_samp
+SYSTEM FUNCTION sys.week
+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
@@ -647,6 +791,9 @@ return table (select v.name, f.name, 'DE
create function dependencies_views_on_triggers()
returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
return table (select v.name, tri.name, 'DEP_TRIGGER' from tables as v,
triggers as tri, dependencies as dep where dep.id = v.id and dep.depend_id
=tri.id and dep.depend_type = 8 and v.type = 1);
+stringdiff
+stringdiff
+stringdiff
CREATE FUNCTION env () RETURNS TABLE( name varchar(1024), value varchar(2048))
EXTERNAL NAME sql.sql_environment;
create function sys.environment()
returns table ("name" string, value string)
@@ -754,6 +901,12 @@ create function "host" (p inet) returns
external name inet."host";
create function "hostmask" (p inet) returns inet
external name inet."hostmask";
+ilike
+ilike
+ilike
+ilike
+ilike
+ilike
create filter function "ilike"(val string, pat string, esc string) external
name algebra."ilike";
create filter function "ilike"(val string, pat string) external name
algebra."ilike";
create function sys.imprintsize(i bigint, nme string)
@@ -781,10 +934,31 @@ create function sys.isauuid(u uuid)
returns uuid external name uuid."isaUUID";
create function sys.isauuid(u string)
returns uuid external name uuid."isaUUID";
+mbrLeft
+mbrLeft
+<<
+<<
+<<
+<<
+<<
+<<
+<<
+<<
+<<
+<<
create function "left_shift"(i1 inet, i2 inet) returns boolean
external name inet."<<";
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
