Funcionalidade compatível no Babelfish por versão - Amazon Aurora

Funcionalidade compatível no Babelfish por versão

Na tabela a seguir, você pode encontrar a funcionalidade T-SQL compatível com diferentes versões do Babelfish. Para ver uma lista de funcionalidades incompatíveis, consulte Funcionalidade não compatível com o Babelfish. Para obter informações sobre várias versões do Babelfish, consulte as Notas de lançamento do Aurora PostgreSQL.

Funcionalidade ou sintaxe 2.3.0 2.2.0 2.1.0 1.2.1 1.1.0 1.0.0
ALTER ROLE✓✓✓–––
CREATE ROLE✓✓✓–––
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✓✓✓–––
Datatypes TIMESTAMP, ROWVERSION (for usage information, see Features with limited implementation✓✓✓✓––
DROP DATABASE✓–––––
DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects)✓✓✓✓––
DROP ROLE✓✓✓–––
GRANT✓✓✓✓––
Identifiers with leading dot character✓✓✓✓✓–
INSTEAD OF triggers on tables (tables only, not views)✓✓✓✓––
REVOKE✓✓✓✓––
SET BABELFISH_SHOWPLAN_ALL ON (and OFF)✓✓✓–––
SET BABELFISH_STATISTICS PROFILE ON (OFF)✓✓✓–––
SET LOCK_TIMEOUT✓✓✓✓––
SSMS: Connecting with the object explorer connection dialog✓✓✓–––
SSMS: Data migration with the Import/Export Wizard✓✓✓–––
SSMS: Partial support for the object explorer✓✓✓–––
Triggers with multiple DML actions can reference transition tables✓✓✓✓✓–
T-SQL hints (join methods, index usage, MAXDOP)✓–––––
Zero-downtime patching (ZDP)✓–––––
Built-in functions:
CHARINDEX✓✓✓–––
CHOOSE✓✓✓✓✓–
COLUMNS_UPDATED✓✓✓✓––
COLUMNPROPERTY (CharMaxLen, AllowsNull only)✓✓✓✓✓–
CONCAT_WS✓✓✓✓✓–
CURSOR_STATUS✓✓✓✓✓–
DATEADD✓–––––
DATEDIFF✓–––––
DATEFROMPARTS✓✓✓✓✓–
DATENAME✓–––––
DATEPART✓–––––
DATETIMEFROMPARTS✓✓✓✓✓–
DATETIMEOFFSETFROMPARTS✓–––––
FOR JSON✓–––––
FULLTEXTSERVICEPROPERTY✓✓✓✓––
HAS_DBACCESS✓✓✓✓––
HAS_PERMS_BY_NAME✓✓✓–––
HOST_NAME✓✓––––
IS_MEMBER✓✓✓–––
IS_ROLEMEMBER✓✓✓–––
IS_SRVROLEMEMBER✓✓✓✓––
ISJSON✓✓✓✓––
JSON_MODIFY✓–––––
JSON_QUERY✓✓✓✓––
JSON_VALUE✓✓✓✓––
OPENJSON✓✓✓–––
ORIGINAL_LOGIN✓✓✓✓✓–
PATINDEX✓✓✓–––
SCHEMA_NAME✓✓✓✓✓–
SESSION_USER✓✓✓✓✓–
SID_BINARY (returns NULL always)✓✓––––
SQUARE✓✓✓✓✓–
STRING_SPLIT✓✓✓–––
SUSER_SID✓✓✓✓––
SUSER_SNAME✓✓✓✓––
SYSTEM_USER✓✓––––
TO_CHAR✓–––––
TRIGGER_NESTLEVEL (without arguments only)✓✓✓✓✓–
TRY_CONVERT✓–––––
UPDATE✓✓✓✓––
INFORMATION_SCHEMA catalogs
CHECK_CONSTRAINTS✓✓––––
COLUMN_DOMAIN_USAGE✓✓––––
COLUMNS✓✓✓✓––
CONSTRAINT_COLUMN_USAGE✓✓✓––––
DOMAINS✓✓✓✓––
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 Diferenças do T-SQL no Babelfish.✓✓✓✓✓✓
System stored procedures:
sp_addrole✓–––––
sp_addrolemember✓–––––
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_droprole✓–––––
sp_droprolemember✓–––––
sp_fkeys✓✓✓✓––
sp_getapplock✓✓✓✓✓✓
sp_helpdb✓✓✓✓✓✓
sp_helpdbfixedrole✓–––––
sp_helprole✓✓✓–––
sp_helprolemember✓✓✓–––
sp_helpsrvrolemember✓✓––––
sp_helpuser✓✓✓✓––
sp_oledb_ro_usrname✓✓✓✓✓–
sp_pkeys✓✓✓✓✓–
sp_prefix✓✓––––
sp_prepare✓✓✓✓✓–
sp_releaseapplock✓✓✓✓✓✓
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_unprepare✓✓✓✓✓–
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✓✓––––
ProductMajorVersion✓✓✓✓––
ProductMinorVersion✓✓✓✓––
ProductVersion✓✓✓✓––
ServerName✓✓✓✓✓✓
SQL Server views supported by Babelfish
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.indexes✓✓✓–––
sys.schemas✓✓✓✓✓✓
sys.server_principals✓✓✓✓✓✓
sys.sql_modules✓✓✓–––
sys.sysconfigures✓✓✓✓––
sys.syscurconfigs✓✓✓✓––
sys.sysprocesses ✓✓✓✓––
sys.table_types✓✓✓✓––
sys.tables✓✓✓✓✓✓
sys.xml_schema_collections✓✓✓–––
syslanguages✓✓✓–––
sysobjects.crdate✓–––––