函数和操作符
本章介绍M-Compatibility下的函数和操作符。

《开发指南》中的“SQL参考 > 函数和操作符”章节中的函数和操作符在M-Compatibility下属于内部接口,禁止使用,使用这些函数和操作符可能产生预期外的结果。
《开发指南》中的“SQL参考 > 函数和操作符”章节中的以下函数在M-Compatibility中暂不支持:
cot | isEmpty | json_append | json_array | json_array_append |
json_array_insert | json_contains | json_contains_path | json_depth | json_extract |
json_insert | json_keys | json_length | json_merge | json_merge_patch |
json_merge_preserve | json_object | json_quote | json_remove | json_valid |
json_replace | json_search | json_set | json_type | json_unquote |
last_insert_id | md5 | mod | octet_length | overlaps |
point | radians | stddev_pop | stddev_samp | var_pop |
var_samp | variance | lag | lead | - |
adm_hist_snapshot_func | adm_hist_sqlstat_func | adm_hist_sqltext_func | session_context |
get_global_transactions_prepared_xacts | get_global_transactions_running_xacts |
dbe_perf.get_full_sql_by_parent_id_and_timestamp | dbe_perf.get_active_session_profile | dbe_perf.get_global_slow_sql_by_timestamp | dbe_perf.get_global_full_sql_by_timestamp |
information_schema_pg_truetypid | information_schema._pg_truetypmod | summary_create | sys_context |
db4ai.archive_snapshot | db4ai.create_snapshot | db4ai.create_snapshot_internal | db4ai.manage_snapshot_internal | db4ai.prepare_snapshot |
db4ai.prepare_snapshot_internal | db4ai.publish_snapshot | db4ai.purge_snapshot | db4ai.purge_snapshot_internal | db4ai.sample_snapshot |
pgxc_get_stat_dirty_tables | gs_wIm_persistent_user_resource_info |
pg_catalog.ts_debug | pg_catalog.gs_check_logic_cluster_consistency | pg_catalog.gs_check_tables_distribution | pg_catalog.gs_wlm_persistent_user_resource_info | pg_catalog.create_wlm_instance_statistics_info |
pg_catalog.pgxc_get_wlm_current_instance_info | pg_catalog.pgxc_get_wlm_history_instance_info | pg_catalog.pgxc_get_wlm_session_info_bytime | pg_catalog.create_wlm_session_info | pg_catalog.to_char |
pg_catalog.to_nchar | pg_catalog.report_application_error | pg_catalog.to_text | pg_catalog.time_text | pg_catalog.timetz_text |
pg_catalog.reltime_text | pg_catalog.abstime_text | pg_catalog.int1 | pg_catalog.int2 | pg_catalog.int4 |
pg_catalog.int8 | pg_catalog.float4 | pg_catalog.float8 | pg_catalog.to_numeric | pg_catalog.to_integer |
pg_catalog.rawtohex | pg_catalog.to_clob | pg_catalog.trunc | pg_catalog.to_varchar2 | pg_catalog.to_interval |
pg_catalog.to_ts | pg_catalog.timestamp_to_smalldatetime | pg_catalog.smalldatetime_to_timestamp | pg_catalog.smalldatetime_to_varchar2 | pg_catalog.varchar2_to_smalldatetime |
pg_catalog.bpchar_to_smalldatetime | pg_catalog.abstime_to_smalldatetime | pg_catalog.smalldatetime_to_abstime | pg_catalog.smalldatetime_to_time | pg_catalog.smalldatetime_to_timestamptz |
pg_catalog.timestamptz_to_smalldatetime | pg_catalog.regexp_like | pg_catalog.intervaltonum | pg_catalog.to_nvarchar2 | pg_catalog.invalidate_plsql_object |
pg_catalog.table_skewness | pg_catalog.pgxc_xacts_iscommitted | pg_catalog.pgxc_parse_clog | pg_catalog.pgxc_get_senders_catchup_time | pg_catalog.global_transaction |
pg_catalog.gs_stat_reset | pg_catalog.pgxc_fenced_udf_process | pg_catalog.pgxc_terminate_all_fenced_udf_process | pg_catalog.create_wlm_operator_info | pg_catalog.copy_error_log_create |
pg_catalog.get_delta_info | pg_catalog.pgxc_stat_bad_block_clear | pg_catalog.pgxc_query_audit | pg_catalog.is_oid_in_group_members | pg_catalog.get_shard_oids_byname |
pg_catalog.reload_active_coordinator | pg_catalog.lock_cluster_ddl | pg_catalog.unlock_cluster_ddl | pg_catalog.pgxc_get_stat_dirty_tables | pg_catalog.pgxc_get_stat_dirty_tables |
pg_catalog.get_large_table_name | pg_catalog.global_segment_space_info | dbe_perf.get_global_full_sql_by_timestamp | dbe_perf.get_global_slow_sql_by_timestamp | dbe_perf.get_full_sql_by_parent_id_and_timestamp |
dbe_perf.global_plancache_clean | dbe_perf.global_slow_query_info_bytime | dbe_perf.get_global_gs_asp | dbe_perf.get_datanode_active_session | dbe_perf.get_datanode_active_session_hist |
dbe_perf.global_stat_activity_timeout | dbe_perf.get_active_session_profile | dbe_perf.generate_asp_report | - | - |

表8为GaussDB自定义的函数,在M-Compatibility的行为未知,不建议使用。

