Babelfish 的各个版本支持的功能 - Amazon Aurora
Amazon Web Services 文档中描述的 Amazon Web Services 服务或功能可能因区域而异。要查看适用于中国区域的差异,请参阅 中国的 Amazon Web Services 服务入门 (PDF)

Babelfish 的各个版本支持的功能

在下表中,您可以找到不同 Babelfish 版本支持的 T-SQL 功能。有关不受支持的功能的列表,请参阅Babelfish 不支持的功能。有关各种 Babelfish 版本的信息,请参阅 Aurora PostgreSQL 版本注释

功能或语法 4.0.0 3.4.0 3.3.0 3.2.0 3.1.0 2.7.0 2.6.0 2.5.0 2.4.0 2.3.0 2.2.0 2.1.0 1.2.1 1.1.0 1.0.0
4 parts object name references for SELECT statements
ALTER AUTHORIZATION syntax to change database owner
ALTER ROLE
ALTER USER...WITH LOGIN
AT TIME ZONE clause
Babelfish instance as a linked server
CREATE ROLE
CREATE TRIGGER
Create unique indexes
Cross–database procedure execution
Cross–database references SELECT,SELECT..INTO, INSERT, UPDATE, DELETE
Cursor-typed parameters for input parameters only (not output)
Data migration using the bcp client utility
Database authentication with Kerberos using Amazon Directory Service
Datatypes TIMESTAMP, ROWVERSION (for usage information, see Features with limited implementation
DEFAULT keyword in calls to stored procedures and functions
DBCC CHECKIDENT
DROP DATABASE
DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects)
DROP ROLE
Dump and restore
ENABLE/DISABLE TRIGGER
FULL TEXT SEARCH
GRANT
GUC babelfishpg_tds.product_version
Identifiers with leading dot character
INSTEAD OF triggers on tables
INSTEAD OF triggers on views
KILL
pg_stat_statement extension
PIVOT(supported from 3.4.0 and higher releases except when used in a view definition, a common table expression, or a join)
REVOKE
SET BABELFISH_SHOWPLAN_ALL ON (and OFF)
SET BABELFISH_STATISTICS PROFILE ON (OFF)
SET CONTEXT_INFO
SET LOCK_TIMEOUT
SET NO_BROWSETABLE
SET rowcount
SET SHOWPLAN_ALL
SET STATISTICS IO
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SSMS: Connecting with the object explorer connection dialog
SSMS: Data migration with the Import/Export Wizard
SSMS: Partial support for the object explorer
STDEV
STDEVP
Triggers with multiple DML actions can reference transition tables
T-SQL hints (join methods, index usage, MAXDOP)
T-SQL square bracket syntax with the LIKE predicate
VAR
VARP
Zero-downtime patching (ZDP)
Built-in functions:
APP_NAME
ATN2
CHARINDEX
CHOOSE
COL_LENGTH
COL_NAME
COLUMNS_UPDATED
COLUMNPROPERTY (CharMaxLen, AllowsNull only)
CONCAT_WS
CONTEXT_INFO
CURSOR_STATUS
DATABASE_PRINCIPAL_ID
DATEADD
DATEDIFF
DATEDIFF_BIG
DATEFROMPARTS
DATENAME
DATEPART
DATETIMEFROMPARTS
DATETIME2FROMPARTS
DATETIMEOFFSETFROMPARTS
DATETRUNC
DATE_BUCKET
EOMONTH
EXECUTE AS CALLER
fn_listextendedproperty
FOR JSON
FULLTEXTSERVICEPROPERTY
HAS_DBACCESS
HAS_PERMS_BY_NAME
HOST_NAME
HOST_ID
IDENTITY
IS_MEMBER
IS_ROLEMEMBER
IS_SRVROLEMEMBER
ISJSON
JSON_MODIFY
JSON_QUERY
JSON_VALUE
NEXT VALUE FOR
OBJECT_DEFINITION
OBJECT_SCHEMA_NAME
OPENJSON
OPENQUERY
ORIGINAL_LOGIN
PARSENAME
PATINDEX
ROWCOUNT_BIG
SCHEMA_NAME
SESSION_CONTEXT
SESSION_USER
SID_BINARY (returns NULL always)
SMALLDATETIMEFROMPARTS
SQUARE
STR
STRING_AGG
STRING_SPLIT
SUSER_SID
SUSER_SNAME
SWITCHOFFSET
SYSTEM_USER
TIMEFROMPARTS
TODATETIMEOFFSET
TO_CHAR
TRIGGER_NESTLEVEL (without arguments only)
TRY_CONVERT
TYPE_ID
TYPE_NAME
UPDATE
INFORMATION_SCHEMA catalogs
CHECK_CONSTRAINTS
COLUMN_DOMAIN_USAGE
COLUMNS
CONSTRAINT_COLUMN_USAGE
DOMAINS
KEY_COLUMN_USAGE
ROUTINES
TABLES
TABLE_CONSTRAINTS
VIEWS
System-defined @@ variables:
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@ERROR=213
@@FETCH_STATUS
@@IDENTITY
@@LANGUAGE
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@MICROSOFTVERSION
@@NESTLEVEL
@@PROCID
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TRANCOUNT
@@VERSION (note format difference as described in Babelfish 中的 T-SQL 差异.
System stored procedures:
sp_addextendedproperty
sp_addlinkedserver
sp_addlinkedsrvlogin
sp_addrole
sp_addrolemember
sp_babelfish_volatility
sp_column_privileges
sp_columns
sp_columns_100
sp_columns_managed
sp_cursor
sp_cursor_list
sp_cursorclose
sp_cursorexecute
sp_cursorfetch
sp_cursoropen
sp_cursoroption
sp_cursorprepare
sp_cursorprepexec
sp_cursorunprepare
sp_databases
sp_datatype_info
sp_datatype_info_100
sp_describe_cursor
sp_describe_first_result_set
sp_describe_undeclared_parameters
sp_dropextendedproperty
sp_droplinkedsrvlogin
sp_droprole
sp_droprolemember
sp_dropserver
sp_enum_oledb_providers
sp_execute
sp_execute_postgresql(CREATE, ALTER, DROP)
sp_executesql
sp_fkeys
sp_getapplock
sp_helpdb
sp_helpdbfixedrole
sp_helplinkedsrvlogin
sp_helprole
sp_helprolemember
sp_helpsrvrolemember
sp_helpuser
sp_linkedservers
sp_oledb_ro_usrname
sp_pkeys
sp_prefix
sp_prepare
sp_releaseapplock
sp_rename
sp_serveroption(connect_timeout option)
sp_set_session_context
sp_special_columns
sp_sproc_columns
sp_sproc_columns_100
sp_statistics
sp_statistics_100
sp_stored_procedures
sp_table_privileges
sp_tablecollations_100
sp_tables
sp_testlinkedserver
sp_unprepare
sp_updateextendedproperty
sp_who
xp_qv
Properties supported on the CONNECTIONPROPERTY system function
auth_scheme
client_net_address
local_net_address
local_tcp_port
net_transport
protocol_type
physical_net_transport
Properties supported on the OBJECTPROPERTY system function
IsInlineFunction
IsScalarFunction
IsTableFunction
Properties supported on the SERVERPROPERTY function
Babelfish
Collation
CollationID
Edition
EditionID
EngineEdition
InstanceName
IsAdvancedAnalyticsInstalled
IsBigDataCluster
IsFullTextInstalled
IsIntegratedSecurityOnly
IsLocalDB
IsPolyBaseInstalled
IsSingleUser
IsXTPSupported
Japanese_CI_AI
Japanese_CI_AS
Japanese_CS_AS
LicenseType
MachineName
ProductLevel
ProductMajorVersion
ProductMinorVersion
ProductUpdateLevel
ProductVersion
ServerName
SQL Server views supported by Babelfish
information_schema.key_column_usage
information_schema.routines
information_schema.schemata
information_schema.sequences
sys.all_columns
sys.all_objects
sys.all_parameters
sys.all_sql_modules
sys.all_views
sys.columns
sys.configurations
sys.data_spaces
sys.database_files
sys.database_mirroring
sys.database_principals
sys.database_role_members
sys.databases
sys.dm_exec_connections
sys.dm_exec_sessions
sys.dm_hadr_database_replica_states
sys.dm_os_host_info
sys.endpoints
sys.extended_properties
sys.indexes
sys.schemas
sys.server_principals
sys.server_role_members
sys.sql_modules
sys.sysconfigures
sys.syscurconfigs
sys.syslogins
sys.sysprocesses
sys.sysusers
sys.table_types
sys.tables
sys.types
sys.xml_schema_collections
syslanguages
sysobjects.crdate