バージョンごとに Babelfish でサポートされている機能
次の表に、さまざまな Babelfish バージョンでサポートされている T-SQL 機能を示します。サポートされていない機能のリストについては、Babelfish でサポートされていない機能を参照してください。Babelfish のリリースの詳細については、「Aurora PostgreSQL リリースノート」を参照してください。
機能または構文 | 1.2.0 | 1.1.0 | 1.0.0 |
---|---|---|---|
Create unique indexes | ✓ | ✓ | – |
Triggers with multiple DML actions can reference transition tables | ✓ | ✓ | – |
INSTEAD OF triggers on tables (tables only, not views) | ✓ | – | – |
Identifiers with leading dot character | ✓ | ✓ | – |
SET LOCK_TIMEOUT | ✓ | – | – |
Datatypes TIMESTAMP, ROWVERSION (for usage information, see 実装が制限されている機能. | ✓ | – | – |
DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects) | ✓ | – | – |
Built-in functions: | |||
CHOOSE | ✓ | ✓ | – |
COLUMNS_UPDATED | ✓ | – | – |
COLUMNPROPERTY (CharMaxLen, AllowsNull only) | ✓ | ✓ | – |
CONCAT_WS | ✓ | ✓ | – |
CURSOR_STATUS | ✓ | ✓ | – |
DATEFROMPARTS | ✓ | ✓ | – |
DATETIMEFROMPARTS | ✓ | ✓ | – |
FULLTEXTSERVICEPROPERTY | ✓ | – | – |
HAS_DBACCESS | ✓ | – | – |
IS_SRVROLEMEMBER | ✓ | – | – |
ISJSON | ✓ | – | – |
JSON_QUERY | ✓ | – | – |
JSON_VALUE | ✓ | – | – |
ORIGINAL_LOGIN | ✓ | ✓ | – |
SCHEMA_NAME | ✓ | ✓ | – |
SESSION_USER | ✓ | ✓ | – |
SQUARE | ✓ | ✓ | – |
SUSER_SID | ✓ | – | – |
SUSER_SNAME | ✓ | – | – |
TRIGGER_NESTLEVEL (without arguments only) | ✓ | ✓ | – |
UPDATE | ✓ | – | – |
INFORMATION_SCHEMA catalogs | |||
COLUMNS | ✓ | – | – |
DOMAINS | ✓ | – | – |
TABLES | ✓ | – | – |
TABLE_CONSTRAINTS | ✓ | – | – |
System-defined @@ variables: | |||
@@CURSOR_ROWS | ✓ | ✓ | – |
@@DATEFIRST | ✓ | ✓ | ✓ |
@@DBTS | ✓ | – | – |
@@ERROR | ✓ | ✓ | ✓ |
@@FETCH_STATUS | ✓ | ✓ | ✓ |
@@IDENTITY | ✓ | ✓ | ✓ |
@@LOCK_TIMEOUT | ✓ | ✓ | – |
@@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_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_fkeys | ✓ | – | – |
sp_getapplock | ✓ | ✓ | ✓ |
sp_helpdb | ✓ | ✓ | ✓ |
sp_helpuser | ✓ | – | – |
sp_oledb_ro_usrname | ✓ | ✓ | – |
sp_pkeys | ✓ | ✓ | – |
sp_pkeys | ✓ | – | – |
sp_prepare | ✓ | ✓ | – |
sp_releaseapplock | ✓ | ✓ | ✓ |
sp_special_columns | ✓ | – | – |
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 SERVERPROPERTY function | |||
Babelfish | ✓ | ✓ | ✓ |
Collation | ✓ | ✓ | ✓ |
CollationID | ✓ | ✓ | ✓ |
Edition | ✓ | ✓ | ✓ |
EditionID | ✓ | – | – |
EngineEdition | ✓ | – | – |
IsAdvancedAnalyticsInstalled | ✓ | – | – |
IsBigDataCluster | ✓ | – | – |
IsFullTextInstalled | ✓ | – | – |
IsIntegratedSecurityOnly | ✓ | – | – |
IsLocalDB | ✓ | – | – |
IsPolyBaseInstalled | ✓ | – | – |
IsSingleUser | ✓ | ✓ | ✓ |
IsXTPSupported | ✓ | – | – |
LicenseType | ✓ | – | – |
ProductMajorVersion | ✓ | – | – |
ProductMinorVersion | ✓ | – | – |
ProductVersion | ✓ | – | – |
ServerName | ✓ | ✓ | ✓ |
SQL Server views supported by Babelfish | |||
sys.all_columns | ✓ | ✓ | ✓ |
sys.all_objects | ✓ | ✓ | ✓ |
sys.all_views | ✓ | ✓ | ✓ |
sys.columns | ✓ | ✓ | ✓ |
sys.configurations | ✓ | – | – |
sys.database_principals | ✓ | – | – |
sys.databases | ✓ | ✓ | ✓ |
sys.dm_exec_connections | ✓ | – | – |
sys.dm_exec_sessions | ✓ | – | – |
sys.dm_os_host_info | ✓ | – | – |
sys.endpoints | ✓ | – | – |
sys.schemas | ✓ | ✓ | ✓ |
sys.server_principals | ✓ | ✓ | ✓ |
sys.sysconfigures | ✓ | – | – |
sys.syscurconfigs | ✓ | – | – |
sys.sysprocesses | ✓ | – | – |
sys.table_types | ✓ | – | – |
sys.tables | ✓ | ✓ | ✓ |