バージョンごとに 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 | ✓ | ✓ | ✓ |
