Link Search Menu Expand Document Documentation Menu

Babelfish Version 2.2.0

Feature Options Notes
@@variable Unsupported : @@CONNECTIONS, @@CPU_BUSY, @@IDLE, @@IO_BUSY, @@LANGID, @@PACKET_ERRORS, @@PACK_RECEIVED, @@PACK_SENT, @@REMSERVER, @@TEXTSIZE, @@TIMETICKS, @@TOTAL_ERRORS, @@TOTAL_READ, @@TOTAL_WRITE  
ADD SIGNATURE Unsupported  
ALTER AUTHORIZATION Unsupported  
ALTER DATABASE Unsupported  
ALTER DATABASE options Unsupported  
ALTER FUNCTION Unsupported  
ALTER INDEX Unsupported Index rebuilding workaround
ALTER PROCEDURE Unsupported  
ALTER SCHEMA Unsupported  
ALTER SERVER CONFIGURATION Unsupported  
ALTER SERVER ROLE Unsupported : BULKADMIN, DBCREATOR, DISKADMIN, PROCESSADMIN, SECURITYADMIN, SERVERADMIN, SETUPADMIN  
ALTER TABLE Unsupported : ADD MULTIPLE COLUMNS/CONSTRAINTS, ADD PERIOD FOR SYSTEM TIME, ALTER COLUMN NOT NULL, ALTER COLUMN NULL, CHECK CONSTRAINT, DISABLE CHANGE_TRACKING, DROP CONSTRAINT_BY_NAME_ONLY, DROP MULTIPLE COLUMNS, DROP MULTIPLE CONSTRAINTS, DROP MULTIPLE ITEMS, DROP PERIOD FOR SYSTEM_TIME, ENABLE CHANGE_TRACKING, NOCHECK CONSTRAINT, REBUILD, SET FILESTREAM_ON, SET FILETABLE, SET LOCK_ESCALATION, SET SYSTEM_VERSIONING  
ALTER TRIGGER Unsupported  
ALTER VIEW Unsupported  
Aggregate functions Unsupported : APPROX_COUNT_DISTINCT, CHECKSUM_AGG, GROUPING_ID, ROWCOUNT_BIG, STDEV, STDEVP, VAR, VARP  
BULK INSERT Unsupported  
CHECKPOINT Unsupported  
CHECKSUM Supported : arg1=SINGLE ARGUMENT, arg1=STAR, MULTIPLE ARGUMENTS  
CLOSE KEY Unsupported  
CLUSTERED index Unsupported  
COLUMNPROPERTY Supported : arg3=CharMaxLen, AllowsNull  
CONNECTIONPROPERTY Supported : arg1=net_transport, protocol_type, auth_scheme, local_tcp_port, arg1=physical_net_transport, client_net_address  
CREATE DATABASE options Unsupported : ALLOW_SNAPSHOT_ISOLATION, ANSI_NULLS, ANSI_NULL_DEFAULT, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, AUTO_CLOSE, AUTO_SHRINK, AUTO_UPDATE_STATISTICS, AUTO_UPDATE_STATISTICS_ASYNC, CATALOG_COLLATION, COMPATIBILITY_LEVEL, CONCAT_NULL_YIELDS_NULL, CONTAINMENT=PARTIAL, CURSOR_CLOSE_ON_COMMIT, CURSOR_DEFAULT, DATE_CORRELATION_OPTIMIZATION, DB_CHAINING, DELAYED_DURABILITY, DISABLE_BROKER, FILESTREAM, HONOR_BROKER_PRIORITY, MULTI_USER, NUMERIC_ROUNDABORT, PAGE_VERIFY, PARAMETERIZATION, QUERY_STORE, QUOTED_IDENTIFIER, READ_COMMITTED_SNAPSHOT, RECOVERY, RECURSIVE_TRIGGERS, TARGET_RECOVERY_TIME, TRUSTWORTHY  
CREATE SERVER ROLE Unsupported  
CURSOR parameters Unsupported  
Case-sensitive collation Unsupported : CATALOG_COLLATION, DATABASE, SERVER  
Column attribute Unsupported  
Compound operator containing whitespace Unsupported  
Cross-database reference Unsupported : ALTER TABLE, CREATE INDEX, CREATE TABLE, DROP INDEX, MERGE, TRUNCATE TABLE, UPDATE STATISTICS  
Cursor options Unsupported : DYNAMIC, FAST_FORWARD, FOR UPDATE, KEYSET, OPTIMISTIC, SCROLL, SCROLL_LOCKS, TYPE_WARNING Dynamically defined cursor workaround
DATABASEPROPERTYEX Supported : arg2=Collation, Edition, IsAutoClose, IsAutoCreateStatistics, IsInStandBy, IsTornPageDetectionEnabled, Status, Updateability, Version  
DATEADD Supported : arg1=D, DAY, DAYOFYEAR, DD, DY, HH, HOUR, M, MCS, MICROSECOND, MINUTE, MM, MONTH, N, NS, Q, QQ, QUARTER, S, SECOND, SS, WEEK, WEEKDAY, WK, WW, Y, YEAR, YY, YYYY, arg1=MILLISECOND, MS, W  
DATEDIFF Supported : arg1=D, DAY, DAYOFYEAR, DD, DY, HH, HOUR, M, MCS, MICROSECOND, MILLISECOND, MINUTE, MM, MONTH, MS, N, NANOSECOND, NS, Q, QQ, QUARTER, S, SECOND, SS, WEEK, WK, WW, Y, YEAR, YY, YYYY, arg1=W  
DATENAME Supported : arg1=D, DAY, DAYOFYEAR, DD, DW, DY, HH, HOUR, ISO_WEEK, ISOWK, ISOWW, M, MCS, MICROSECOND, MILLISECOND, MINUTE, MM, MONTH, MS, N, NANOSECOND, NS, Q, QQ, QUARTER, S, SECOND, SS, TZ, TZOFFSET, WEEK, WEEKDAY, WK, WW, YEAR, YY, YYYY, arg1=W  
DATEPART Supported : arg1=D, DAY, DAYOFYEAR, DD, DW, DY, HH, HOUR, ISO_WEEK, ISOWK, ISOWW, M, MCS, MICROSECOND, MILLISECOND, MINUTE, MM, MONTH, MS, N, NANOSECOND, NS, Q, QQ, QUARTER, S, SECOND, SS, TZ, TZOFFSET, WEEK, WEEKDAY, WK, WW, YEAR, YY, YYYY, arg1=W  
DB role options Unsupported : AUTHORIZATION  
DB roles Unsupported  
DBA statements Unsupported  
DBCC statements Unsupported  
DELETE Unsupported : OPENDATASOURCE, OPENQUERY, OPENROWSET, OUTPUT OUTPUT, WHERE CURRENT OF  
DENY Unsupported  
DESC constraint Unsupported  
DISABLE TRIGGER Unsupported  
DML Table Source Unsupported  
DROP INDEX Unsupported : INDEX ON SCHEMA.TABLE, SCHEMA.TABLE.INDEX, TABLE.INDEX  
DROP multiple objects Unsupported : DATABASE, INDEX, TRIGGER  
Datatypes Unsupported : CHARACTER VARYING, GEOGRAPHY, GEOMETRY, HIERARCHYID, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, NCHARACTER, NCHARACTER VARYING, XML COLUMN_SET FOR ALL_SPARSE_COLUMNS, XML(xmlschema)  
Double-quoted string Unsupported : EMBEDDED_DOUBLE_QUOTE, EMBEDDED_SINGLE_QUOTE  
Dynamic SQL Unsupported  
ENABLE TRIGGER Unsupported  
EXECUTE AS Unsupported  
EXECUTE SQL function Unsupported  
Execute procedure options Unsupported : RECOMPILE  
Execute string options Unsupported  
FETCH cursor Unsupported : ABSOLUTE, FIRST, LAST, PRIOR, RELATIVE  
FOR REPLICATION Unsupported  
Features in computed columns Unsupported  
Function options Unsupported : ATOMIC NATIVELY COMPILED, CLR, ENCRYPTION, EXECUTE AS CALLER, EXECUTE AS OWNER, EXECUTE AS SELF, EXECUTE AS USER, EXTERNAL, INLINE, SCHEMABINDING  
GLOBAL cursor Unsupported  
GRANT Supported : ALL PRIVILEGES ON OBJECT, SELECT ON OBJECT, INSERT ON OBJECT, UPDATE ON OBJECT, DELETE ON OBJECT, REFERENCES ON OBJECT, EXECUTE ON OBJECT  
GROUP BY ROLLUP/CUBE (old syntax) Unsupported  
Geospatial features Unsupported  
Global Temporary Tables Unsupported  
HASHBYTES Supported : arg1=MD5, SHA1, SHA2_256, SHA2_512  
HIERARCHYID features Unsupported  
IGNORE_DUP_KEY index Unsupported  
INDEXKEY_PROPERTY Supported : arg4=NO_SUPPORTED_ARGUMENTS_RIGHT_NOW  
INDEXPROPERTY Supported : arg3=IndexFillFactor, IndexID, IsClustered, IsDisabled, IsHypothetical, IsPadIndex, IsPageLockDisallowed, IsRowLockDisallowed, IsUnique  
INFORMATION_SCHEMA Unsupported : COLUMN_PRIVILEGES, CONSTRAINT_TABLE_USAGE, DOMAIN_CONSTRAINTS, KEY_COLUMN_USAGE, PARAMETERS, REFERENTIAL_CONSTRAINTS, ROUTINE_COLUMNS, SCHEMATA, TABLE_PRIVILEGES, VIEW_COLUMN_USAGE, VIEW_TABLE_USAGE  
INSERT Unsupported : DEFAULT VALUES, EXECUTE SP_EXECUTESQL, EXECUTE(EXPRESSION), OPENQUERY, OPENROWSET, OUTPUT OUTPUT, TOP  
INSERT BULK Unsupported  
Index attribute Unsupported  
Index options Unsupported  
Indexed view Unsupported  
Inline index Unsupported  
Instead-Of Trigger Unsupported : VIEW  
JSON features Unsupported  
Join hint Unsupported  
LIKE ‘[…]’ Unsupported  
LOGINPROPERTY Supported : arg2=NO_SUPPORTED_ARGUMENTS_RIGHT_NOW  
Line continuation character Unsupported  
Login options Unsupported : ADD CREDENTIAL, CHECK_EXPIRATION, CHECK_POLICY, CREDENTIAL, DROP CREDENTIAL, FROM ASYMMETRIC KEY, FROM CERTIFICATE, FROM WINDOWS, MUST_CHANGE, NAME, NO CREDENTIAL, OLD_PASSWORD, PASSWORD HASHED, SID, UNLOCK  
MERGE Unsupported  
Materialized view Unsupported  
Maximum columns per index Supported : 32  
Maximum identifier length Supported : 63  
Maximum parameters per function Supported : 100  
Maximum parameters per procedure Supported : 100  
Maximum precision IDENTITY column Supported : 18  
Miscellaneous objects Unsupported : AGGREGATE, APPLICATION ROLE, ASSEMBLY, ASYMMETRIC KEY, AVAILABILITY GROUP, CERTIFICATE, COLUMN ENCRYPTION KEY, COLUMN MASTER KEY, CONTRACT, CREDENTIAL, CRYPTOGRAPHIC PROVIDER, DEFAULT, DIAGNOSTIC SESSION, EXTERNAL DATA SOURCE, EXTERNAL LIBRARY, EXTERNAL RESOURCE POOL, FULLTEXT CATALOG, FULLTEXT INDEX, FULLTEXT STOPLIST, MASTER KEY, MESSAGE TYPE, QUEUE, QUEUE, REMOTE SERVICE BINDING, RESOURCE GOVERNOR, ROUTE, RULE, SERVER AUDIT, SERVER AUDIT SPECIFICATION, SERVER ROLE, SERVICE, SERVICE MASTER KEY, SYMMETRIC KEY, SYNONYM, WORKLOAD CLASSIFIER, WORKLOAD GROUP  
NEXT VALUE FOR Unsupported  
NONCLUSTERED HASH index Unsupported  
NOT FOR REPLICATION Unsupported  
Non-PERSISTED computed columns Unsupported  
Nullable column Unsupported  
Numeric assignment to datetime variable/parameter/column Unsupported  
Numeric representation of datetime Unsupported : CONVERT, DATEADD, DATEDIFF, DATENAME, DATEPART, PARSE, TRY_CAST, TRY_CONVERT, TRY_PARSE  
OBJECTPROPERTY Supported : arg2=ExecIsAnsiNullsOn, ExecIsQuotedIdentOn, IsDefault, IsDefaultCnst, IsDeterministic, IsIndexed, IsInlineFunction, IsMSShipped, IsPrimaryKey, IsProcedure, IsRule, IsScalarFunction, IsSchemaBound, IsTable, IsTableFunction, IsTrigger, IsUserTable, IsView, OwnerId, TableFulltextPopulateStatus, TableHasVarDecimalStorageFormat  
OBJECTPROPERTYEX Supported : arg2=ExecIsAnsiNullsOn, ExecIsQuotedIdentOn, IsDefault, IsDefaultCnst, IsDeterministic, IsIndexed, IsInlineFunction, IsMSShipped, IsPrimaryKey, IsProcedure, IsRule, IsScalarFunction, IsSchemaBound, IsTable, IsTableFunction, IsTrigger, IsUserTable, IsView, OwnerId, TableFulltextPopulateStatus, TableHasVarDecimalStorageFormat, BaseType  
ODBC Outer Join Unsupported  
ODBC literal Unsupported  
ODBC scalar function Unsupported  
OPEN KEY Unsupported  
Parameter value DEFAULT Unsupported DEFAULT parameter value workaround
Partitioning Unsupported Partitioning Workaround - Babelfish code supports PostgreSQL-style partitioning on the PostgreSQL port, but use of PostgreSQL-styled partitioned tables from the TDS port is not recommended.
Procedure options Unsupported : ATOMIC NATIVELY COMPILED, ENCRYPTION, EXECUTE AS CALLER, EXECUTE AS OWNER, EXECUTE AS SELF, EXECUTE AS USER, EXTERNAL, RECOMPILE, SCHEMABINDING  
Procedure versioning (declaration) Unsupported  
Procedure versioning (execution) Unsupported  
Query hint Unsupported  
READTEXT Unsupported  
REVOKE Supported : ALL PRIVILEGES ON OBJECT, SELECT ON OBJECT, INSERT ON OBJECT, UPDATE ON OBJECT, DELETE ON OBJECT, REFERENCES ON OBJECT, EXECUTE ON OBJECT, CASCADE  
Regular variable named @@v Unsupported  
Remote object reference Unsupported  
SCHEMA options Unsupported : CREATE TABLE, CREATE VIEW, DENY, GRANT, REVOKE, TRANSFER, TRANSFER OBJECT, TRANSFER TYPE, TRANSFER XML SCHEMA COLLECTION  
SCHEMA_ID with N arguments Supported : 1, 0  
SCHEMA_NAME with N arguments Supported : 1, 0  
SECURITY DEFINER transaction mgmt Unsupported  
SELECT TOP PERCENT Unsupported : 0, EXPRESSION, NONZERO, VARIABLE  
SELECT TOP WITH TIES Unsupported  
SELECT TOP in Table-Valued Function Unsupported  
SELECT TOP without ORDER BY Unsupported  
SELECT..PIVOT Unsupported  
SELECT..UNPIVOT Unsupported  
SEQUENCE options Unsupported  
SERVERPROPERTY Supported : arg1=Collation, CollationID, Edition, IsSingleUser, ServerName, Babelfish, arg1=EditionID, EngineEdition, LicenseType, ProductVersion, ProductMajorVersion, ProductMinorVersion, IsIntegratedSecurityOnly, IsLocalDB, IsAdvancedAnalyticsInstalled, IsBigDataCluster, IsPolyBaseInstalled, IsFullTextInstalled, IsXTPSupported, arg1=MachineName, InstanceName  
SET ANSI_NULL_DFLT_OFF Supported : OFF  
SET ANSI_NULL_DFLT_ON Supported : ON  
SET ANSI_PADDING Supported : ON  
SET ANSI_WARNINGS Supported : ON  
SET ARITHABORT Supported : ON  
SET ARITHIGNORE Supported : OFF  
SET CONTEXT_INFO Unsupported  
SET CURSOR_CLOSE_ON_COMMIT Supported : OFF  
SET DATEFORMAT Unsupported  
SET DEADLOCK_PRIORITY Unsupported  
SET FMTONLY Unsupported  
SET LANGUAGE Supported : english, us_english  
SET NOEXEC Supported : OFF  
SET NUMERIC_ROUNDABORT Supported : OFF  
SET OFFSETS Unsupported  
SET QUERY_GOVERNOR_COST_LIMIT Unsupported  
SET QUOTED_IDENTIFIER in batch Unsupported  
SET ROWCOUNT Unsupported : NONZERO, VARIABLE SET ROWCOUNT workaround
SET SHOWPLAN_TEXT Unsupported  
SET SHOWPLAN_XML Unsupported  
SET TEXTSIZE Unsupported  
SET TRANSACTION ISOLATION LEVEL Supported : READ COMMITTED, READ UNCOMMITTED, SNAPSHOT  
SETUSER Unsupported  
SQL graph Unsupported  
SQL_VARIANT_PROPERTY Supported : arg2=*  
STRING_AGG() WITHIN GROUP Unsupported  
Scalar UDF in table DDL Unsupported : ALTER TABLE DEFAULT  
Server role options Unsupported : AUTHORIZATION, NAME  
Service Broker Unsupported  
Special characters in identifier Unsupported  
Special characters in parameter Unsupported  
Special column names Unsupported  
Syntax Issues Unsupported  
T-SQL Outer Join operator Unsupported  
TRIGGER_NESTLEVEL with N arguments Supported : 0  
TYPEPROPERTY Supported : arg2=NO_SUPPORTED_ARGUMENTS_RIGHT_NOW  
Table hint Unsupported  
Table value constructor Unsupported  
Temporal table Unsupported  
Temporary procedures Unsupported  
Traceflags Unsupported  
Transactions Unsupported : BEGIN DISTRIBUTED TRANSACTION, DELAYED_DURABILITY, MARK  
Trigger options Unsupported : APPEND, ENCRYPTION, EXECUTE AS CALLER, EXECUTE AS OWNER, EXECUTE AS SELF, EXECUTE AS USER, EXTERNAL, NATIVE_COMPILATION, SCHEMABINDING  
UPDATE Unsupported : OPENDATASOURCE, OPENQUERY, OPENROWSET, OUTPUT OUTPUT, WHERE CURRENT OF  
UPDATE STATISTICS Unsupported  
UPDATETEXT Unsupported  
Unquoted string Unsupported  
User options Unsupported : ALLOW_ENCRYPTED_VALUE_MODIFICATIONS, DEFAULT_LANGUAGE, FROM ASYMMETRIC KEY, FROM CERTIFICATE, OLD_PASSWORD, PASSWORD, WITH LOGIN, WITH NAME, WITHOUT LOGIN  
Variable aggregates across rows Unsupported  
Variable assignment dependency Unsupported  
Variable procedure name Unsupported  
View options Unsupported : CHECK OPTION, ENCRYPTION, VIEW_METADATA, WITHOUT SCHEMABINDING  
WAITFOR Unsupported  
WRITETEXT Unsupported  
XML features Unsupported : EXIST, MODIFY, NODES, QUERY, SELECT FOR XML AUTO, SELECT FOR XML AUTO ELEMENTS, SELECT FOR XML EXPLICIT, SELECT FOR XML PATH ELEMENTS, SELECT FOR XML RAW ELEMENTS, SELECTIVE XML INDEX, VALUE, WITH XMLNAMESPACES, XML INDEX, XML SCHEMA COLLECTION, XML TYPE DEFINITION  
expression AT TIME ZONE Unsupported  

Babelfish for PostgreSQL Links