更新时间:2025-09-11 GMT+08:00
分享

函数和操作符

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

开发指南》中的“SQL参考 > 函数和操作符”章节中的函数和操作符在M-Compatibility下属于内部接口,禁止使用,使用这些函数和操作符可能产生预期外的结果。

开发指南》中的“SQL参考 > 函数和操作符”章节中的以下函数在M-Compatibility中暂不支持:

表1 和MySQL同名且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

-

表2 系统信息函数

adm_hist_snapshot_func

adm_hist_sqlstat_func

adm_hist_sqltext_func

session_context

表3 统计信息函数

get_global_transactions_prepared_xacts

get_global_transactions_running_xacts

表4 系统管理函数

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

表5 其他函数

information_schema_pg_truetypid

information_schema._pg_truetypmod

summary_create

sys_context

表6 内部函数

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

表7 废弃函数

pgxc_get_stat_dirty_tables

gs_wIm_persistent_user_resource_info

表8 GaussDB自定义函数

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的行为未知,不建议使用。

相关文档