Changeset: 78256c79708e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=78256c79708e
Modified Files:
        sql/test/emptydb/Tests/check.stable.out
        sql/test/emptydb/Tests/check.stable.out.32bit
        sql/test/emptydb/Tests/check.stable.out.int128
Branch: comment-on
Log Message:

Approve changes to sql/test/emptydb/check


diffs (truncated from 2441 to 300 lines):

diff --git a/sql/test/emptydb/Tests/check.stable.out 
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -49,6 +49,7 @@ Ready.
 \dSt sys._tables
 \dSt sys.args
 \dSt sys.auths
+\dSt sys.comments
 \dSt sys.db_user_info
 \dSt sys.dependencies
 \dSt sys.dependency_types
@@ -85,6 +86,7 @@ Ready.
 \dSt tmp.objects
 \dSt tmp.triggers
 \dSv sys.columns
+\dSv sys.commented_function_signatures
 \dSv sys.environment
 \dSv sys.geometry_columns
 \dSv sys.optimizers
@@ -107,6 +109,7 @@ Ready.
 \dSf sys."broadcast"
 \dSf sys."clearrejects"
 \dSf sys."columnsize"
+\dSf sys."comment_on"
 \dSf sys."contains"
 \dSf sys."corr"
 \dSf sys."createorderindex"
@@ -131,6 +134,7 @@ Ready.
 \dSf sys."dependencies_tables_on_views"
 \dSf sys."dependencies_views_on_functions"
 \dSf sys."dependencies_views_on_triggers"
+\dSf sys."describe_all_objects"
 \dSf sys."droporderindex"
 \dSf sys."env"
 \dSf sys."epoch"
@@ -138,6 +142,7 @@ Ready.
 \dSf sys."fitsattach"
 \dSf sys."fitsload"
 \dSf sys."flush_log"
+\dSf sys."function_type_keyword"
 \dSf sys."fuse"
 \dSf sys."generate_series"
 \dSf sys."geometrytype"
@@ -347,6 +352,7 @@ SYSTEM TABLE  sys._columns
 SYSTEM TABLE  sys._tables
 SYSTEM TABLE  sys.args
 SYSTEM TABLE  sys.auths
+SYSTEM TABLE  sys.comments
 SYSTEM TABLE  sys.db_user_info
 SYSTEM TABLE  sys.dependencies
 SYSTEM TABLE  sys.dependency_types
@@ -377,6 +383,7 @@ SYSTEM TABLE  sys.triggers
 SYSTEM TABLE  sys.types
 SYSTEM TABLE  sys.user_role
 SYSTEM VIEW  sys.columns
+SYSTEM VIEW  sys.commented_function_signatures
 SYSTEM VIEW  sys.environment
 SYSTEM VIEW  sys.geometry_columns
 SYSTEM VIEW  sys.optimizers
@@ -401,15 +408,15 @@ SYSTEM FUNCTION  sys.>=
 SYSTEM FUNCTION  sys.abbrev
 SYSTEM FUNCTION  sys.abs
 SYSTEM FUNCTION  sys.acos
-SYSTEM FUNCTION  sys.all
+SYSTEM AGGREGATE        sys.all
 SYSTEM FUNCTION  sys.alpha
-SYSTEM FUNCTION  sys.analyze
+SYSTEM PROCEDURE        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 AGGREGATE        sys.avg
+SYSTEM ROUTINE          sys.bbp
 SYSTEM FUNCTION  sys.bit_and
 SYSTEM FUNCTION  sys.bit_not
 SYSTEM FUNCTION  sys.bit_or
@@ -420,19 +427,20 @@ SYSTEM FUNCTION  sys.ceiling
 SYSTEM FUNCTION  sys.char_length
 SYSTEM FUNCTION  sys.character_length
 SYSTEM FUNCTION  sys.charindex
-SYSTEM FUNCTION  sys.clearrejects
+SYSTEM PROCEDURE        sys.clearrejects
 SYSTEM FUNCTION  sys.code
 SYSTEM FUNCTION  sys.columnsize
+SYSTEM PROCEDURE        sys.comment_on
 SYSTEM FUNCTION  sys.concat
 SYSTEM FUNCTION  sys.contains
-SYSTEM FUNCTION  sys.copyfrom
-SYSTEM FUNCTION  sys.corr
+SYSTEM ROUTINE          sys.copyfrom
+SYSTEM AGGREGATE        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.createorderindex
+SYSTEM AGGREGATE        sys.count
+SYSTEM AGGREGATE        sys.count_no_nil
+SYSTEM PROCEDURE        sys.createorderindex
 SYSTEM FUNCTION  sys.curdate
 SYSTEM FUNCTION  sys.current_date
 SYSTEM FUNCTION  sys.current_time
@@ -443,43 +451,45 @@ SYSTEM FUNCTION  sys.day
 SYSTEM FUNCTION  sys.dayofmonth
 SYSTEM FUNCTION  sys.dayofweek
 SYSTEM FUNCTION  sys.dayofyear
-SYSTEM FUNCTION  sys.db_users
+SYSTEM ROUTINE          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
-SYSTEM FUNCTION  sys.dependencies_columns_on_triggers
-SYSTEM FUNCTION  sys.dependencies_columns_on_views
-SYSTEM FUNCTION  sys.dependencies_functions_on_functions
-SYSTEM FUNCTION  sys.dependencies_functions_os_triggers
-SYSTEM FUNCTION  sys.dependencies_keys_on_foreignkeys
-SYSTEM FUNCTION  sys.dependencies_owners_on_schemas
-SYSTEM FUNCTION  sys.dependencies_schemas_on_users
-SYSTEM FUNCTION  sys.dependencies_tables_on_foreignkeys
-SYSTEM FUNCTION  sys.dependencies_tables_on_functions
-SYSTEM FUNCTION  sys.dependencies_tables_on_indexes
-SYSTEM FUNCTION  sys.dependencies_tables_on_triggers
-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 ROUTINE          sys.dense_rank
+SYSTEM ROUTINE          sys.dependencies_columns_on_functions
+SYSTEM ROUTINE          sys.dependencies_columns_on_indexes
+SYSTEM ROUTINE          sys.dependencies_columns_on_keys
+SYSTEM ROUTINE          sys.dependencies_columns_on_triggers
+SYSTEM ROUTINE          sys.dependencies_columns_on_views
+SYSTEM ROUTINE          sys.dependencies_functions_on_functions
+SYSTEM ROUTINE          sys.dependencies_functions_os_triggers
+SYSTEM ROUTINE          sys.dependencies_keys_on_foreignkeys
+SYSTEM ROUTINE          sys.dependencies_owners_on_schemas
+SYSTEM ROUTINE          sys.dependencies_schemas_on_users
+SYSTEM ROUTINE          sys.dependencies_tables_on_foreignkeys
+SYSTEM ROUTINE          sys.dependencies_tables_on_functions
+SYSTEM ROUTINE          sys.dependencies_tables_on_indexes
+SYSTEM ROUTINE          sys.dependencies_tables_on_triggers
+SYSTEM ROUTINE          sys.dependencies_tables_on_views
+SYSTEM ROUTINE          sys.dependencies_views_on_functions
+SYSTEM ROUTINE          sys.dependencies_views_on_triggers
+SYSTEM ROUTINE          sys.describe_all_objects
+SYSTEM ROUTINE          sys.diff
 SYSTEM FUNCTION  sys.difference
-SYSTEM FUNCTION  sys.droporderindex
+SYSTEM PROCEDURE        sys.droporderindex
 SYSTEM FUNCTION  sys.editdistance
 SYSTEM FUNCTION  sys.editdistance2
-SYSTEM FUNCTION  sys.env
+SYSTEM ROUTINE          sys.env
 SYSTEM FUNCTION  sys.epoch
-SYSTEM FUNCTION  sys.evalalgebra
-SYSTEM FUNCTION  sys.exist
+SYSTEM PROCEDURE        sys.evalalgebra
+SYSTEM AGGREGATE        sys.exist
 SYSTEM FUNCTION  sys.exp
-SYSTEM FUNCTION  sys.fitsattach
-SYSTEM FUNCTION  sys.fitsload
+SYSTEM PROCEDURE        sys.fitsattach
+SYSTEM PROCEDURE        sys.fitsload
 SYSTEM FUNCTION  sys.floor
-SYSTEM FUNCTION  sys.flush_log
+SYSTEM PROCEDURE        sys.flush_log
+SYSTEM FUNCTION         sys.function_type_keyword
 SYSTEM FUNCTION  sys.fuse
-SYSTEM FUNCTION  sys.generate_series
+SYSTEM ROUTINE          sys.generate_series
 SYSTEM FUNCTION  sys.geometrytype
 SYSTEM FUNCTION  sys.get_type
 SYSTEM FUNCTION  sys.get_value_for
@@ -507,7 +517,7 @@ SYSTEM FUNCTION  sys.hostmask
 SYSTEM FUNCTION  sys.hour
 SYSTEM FUNCTION  sys.identity
 SYSTEM FUNCTION  sys.ifthenelse
-SYSTEM FUNCTION  sys.ilike
+SYSTEM FILTER FUNCTION  sys.ilike
 SYSTEM FUNCTION  sys.imprintsize
 SYSTEM FUNCTION  sys.in
 SYSTEM FUNCTION  sys.index
@@ -522,12 +532,12 @@ SYSTEM FUNCTION  sys.left_shift
 SYSTEM FUNCTION  sys.left_shift_assign
 SYSTEM FUNCTION  sys.length
 SYSTEM FUNCTION  sys.levenshtein
-SYSTEM FUNCTION  sys.lidarattach
-SYSTEM FUNCTION  sys.lidarexport
-SYSTEM FUNCTION  sys.lidarload
-SYSTEM FUNCTION  sys.like
-SYSTEM FUNCTION  sys.listdir
-SYSTEM FUNCTION  sys.listdirpat
+SYSTEM PROCEDURE        sys.lidarattach
+SYSTEM PROCEDURE        sys.lidarexport
+SYSTEM PROCEDURE        sys.lidarload
+SYSTEM FILTER FUNCTION  sys.like
+SYSTEM PROCEDURE        sys.listdir
+SYSTEM PROCEDURE        sys.listdirpat
 SYSTEM FUNCTION  sys.local_timezone
 SYSTEM FUNCTION  sys.localtime
 SYSTEM FUNCTION  sys.localtimestamp
@@ -537,13 +547,13 @@ SYSTEM FUNCTION  sys.log10
 SYSTEM FUNCTION  sys.lower
 SYSTEM FUNCTION  sys.lpad
 SYSTEM FUNCTION  sys.ltrim
-SYSTEM FUNCTION  sys.malfunctions
+SYSTEM ROUTINE          sys.malfunctions
 SYSTEM FUNCTION  sys.masklen
-SYSTEM FUNCTION  sys.master
-SYSTEM FUNCTION  sys.masterbeat
+SYSTEM PROCEDURE        sys.master
+SYSTEM PROCEDURE        sys.masterbeat
 SYSTEM FUNCTION  sys.masterclock
 SYSTEM FUNCTION  sys.mastertick
-SYSTEM FUNCTION  sys.max
+SYSTEM AGGREGATE        sys.max
 SYSTEM FUNCTION  sys.mbr
 SYSTEM FUNCTION  sys.mbr_above
 SYSTEM FUNCTION  sys.mbr_below
@@ -559,8 +569,8 @@ 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 AGGREGATE        sys.median
+SYSTEM AGGREGATE        sys.min
 SYSTEM FUNCTION  sys.minute
 SYSTEM FUNCTION  sys.mod
 SYSTEM FUNCTION  sys.month
@@ -568,73 +578,73 @@ SYSTEM FUNCTION  sys.ms_round
 SYSTEM FUNCTION  sys.ms_str
 SYSTEM FUNCTION  sys.ms_stuff
 SYSTEM FUNCTION  sys.ms_trunc
-SYSTEM FUNCTION  sys.netcdf_attach
-SYSTEM FUNCTION  sys.netcdf_importvar
+SYSTEM PROCEDURE        sys.netcdf_attach
+SYSTEM PROCEDURE        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 AGGREGATE        sys.not_exist
 SYSTEM FUNCTION  sys.not_ilike
 SYSTEM FUNCTION  sys.not_like
-SYSTEM FUNCTION  sys.not_unique
+SYSTEM AGGREGATE        sys.not_unique
 SYSTEM FUNCTION  sys.not_uniques
 SYSTEM FUNCTION  sys.octet_length
-SYSTEM FUNCTION  sys.optimizer_stats
-SYSTEM FUNCTION  sys.optimizers
+SYSTEM ROUTINE          sys.optimizer_stats
+SYSTEM ROUTINE          sys.optimizers
 SYSTEM FUNCTION  sys.or
 SYSTEM FUNCTION  sys.password_hash
 SYSTEM FUNCTION  sys.patindex
-SYSTEM FUNCTION  sys.pause
+SYSTEM PROCEDURE        sys.pause
 SYSTEM FUNCTION  sys.pi
 SYSTEM FUNCTION  sys.power
-SYSTEM FUNCTION  sys.prod
+SYSTEM AGGREGATE        sys.prod
 SYSTEM FUNCTION  sys.qgramnormalize
-SYSTEM FUNCTION  sys.quantile
+SYSTEM AGGREGATE        sys.quantile
 SYSTEM FUNCTION  sys.quarter
-SYSTEM FUNCTION  sys.querycache
-SYSTEM FUNCTION  sys.querylog
-SYSTEM FUNCTION  sys.querylog_calls
-SYSTEM FUNCTION  sys.querylog_catalog
-SYSTEM FUNCTION  sys.querylog_disable
-SYSTEM FUNCTION  sys.querylog_empty
-SYSTEM FUNCTION  sys.querylog_enable
-SYSTEM FUNCTION  sys.queue
+SYSTEM ROUTINE          sys.querycache
+SYSTEM PROCEDURE        sys.querylog
+SYSTEM ROUTINE          sys.querylog_calls
+SYSTEM ROUTINE          sys.querylog_catalog
+SYSTEM PROCEDURE        sys.querylog_disable
+SYSTEM PROCEDURE        sys.querylog_empty
+SYSTEM PROCEDURE        sys.querylog_enable
+SYSTEM ROUTINE          sys.queue
 SYSTEM FUNCTION  sys.radians
 SYSTEM FUNCTION  sys.rand
-SYSTEM FUNCTION  sys.rank
-SYSTEM FUNCTION  sys.rejects
+SYSTEM ROUTINE          sys.rank
+SYSTEM ROUTINE          sys.rejects
 SYSTEM FUNCTION  sys.repeat
 SYSTEM FUNCTION  sys.replace
-SYSTEM FUNCTION  sys.replicabeat
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to