Help Center/ TaurusDB_TaurusDB for PostgreSQL/ Kernel/ Babelfish/ Compatibility/ Functionality Not Supported by Babelfish
Updated on 2025-12-09 GMT+08:00
View PDF
Share

Functionality Not Supported by Babelfish

Unsupported Functionality

The following table lists functionality that is not supported by Babelfish.

Table 1 Unsupported functionality or syntax

Functionality or Syntax

Description

Assembly modules and SQL Common Language Runtime (CLR) routines

Functionality related to assembly modules and CLR routines is not supported.

Column attributes

ROWGUIDCOL, SPARSE, FILESTREAM, and MASKED are not supported.

Contained databases

Contained databases with logins authenticated at the database level rather than at the server level are not supported.

Cross-database DDL

Performing DDL statements that reference or operate on objects across multiple databases is not supported.

Cursors (updatable)

Updatable cursors are not supported.

Cursors (global)

GLOBAL cursors are not supported.

Cursors (fetch behaviors)

The following cursor fetch behaviors are not supported: FETCH PRIOR, FIRST, LAST, ABSOLUTE, and RELATIVE.

Cursor-typed output parameters

Cursor-typed variables and parameters are not supported for output parameters (errors are reported).

Cursor options

SCROLL, KEYSET, DYNAMIC, FAST_FORWARD, SCROLL_LOCKS, OPTIMISTIC, TYPE_WARNING, and FOR UPDATE are not supported.

Data encryption

Data encryption is not supported.

Data-tier applications (DAC)

DAC packages (.dacpac) or DAC backup (.bacpac) files cannot be used to import or export data-tier applications (DAC).

DBCC commands

Microsoft SQL Server Database Console Commands (DBCC) are not supported. DBCC CHECKIDENT is supported.

DROP IF EXISTS

USER and SCHEMA objects do not support this syntax. Objects TABLE, VIEW, PROCEDURE, FUNCTION, and DATABASE support it.

Encryption

Built-in functions and statements do not support encryption.

ENCRYPT_CLIENT_CERT connections

Client certificate connections are not supported.

EXECUTE AS statement

This statement is not supported.

EXECUTE AS SELF clause

This clause is not supported in functions, procedures, or triggers.

EXECUTE AS USER clause

This clause is not supported in functions, procedures, or triggers.

Foreign key constraints referencing database names

Foreign key constraints referencing database names are not supported.

FORMAT

User-defined types are not supported.

Function declarations with more than 100 parameters

Function declarations with more than 100 parameters are not supported.

Externally defined functions

External functions such as SQL CLR functions are not supported.

Global temporary tables (tables whose names start with ##)

Global temporary tables are not supported.

Graph functionality

All SQL graph functionality is not supported.

General extended stored procedures

System stored procedures that provide interfaces from SQL Server instances to external programs for various maintenance activities are not supported. These system stored procedures include xp_cmdshell and other system stored procedures. For more information, see General extended stored procedures.

Identifiers (variables or parameters) with multiple leading @ characters

Identifiers that start with multiple leading @ characters are not supported.

Identifiers, table names, or column names containing @ or ]] characters

Table or column names that contain @ or ]] characters are not supported.

Inline indexes

Inline indexes are not supported.

Invoking a procedure whose name is in a variable

Variables cannot be used as procedure names.

Materialized views

Materialized views are not supported.

NOT FOR REPLICATION clause

This syntax is accepted and ignored.

ODBC escape functions

ODBC escape functions are not supported.

Procedure calls with DEFAULT as a parameter value

Procedure calls with DEFAULT as a parameter value are not supported. Function calls with DEFAULT as a parameter value are supported.

Procedure declarations with more than 100 parameters

Declarations with more than 100 parameters are not supported.

External defined procedures

External defined procedures such as SQL CLR procedures are not supported.

Procedure versioning

Procedure versioning is not supported.

Procedures WITH RECOMPILE

WITH RECOMPILE (used together with DECLARE and EXECUTE) is not supported.

Remote object references

Executing stored procedures against Babelfish linked servers is not supported. Four-part object names work only for reading and does not work for modifying a remote table. An UPDATE statement can reference a remote table in the FROM clause without modifying it.

Row-level security

Row-level security with CREATE SECURITY POLICY and inline table-valued functions is not supported.

Service broker functionality

Service broker functionality is not supported.

SESSIONPROPERTY

Unsupported attributes: ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, and NUMERIC_ROUNDABORT

SET LANGUAGE

This syntax does not support any value other than english or us_english.

SP_CONFIGURE

This system stored procedure is not supported.

SQL keyword SPARSE

The SPARSE keyword is accepted and ignored.

Table value constructor syntax (FROM clause)

The unsupported syntax applies to derived tables constructed using the FROM clause.

Temporary tables

Temporary tables are not supported.

Temporary procedures are not dropped automatically

This functionality is not supported.

Externally defined triggers

These triggers are not supported, including SQL Common Language Runtime (CLR).

Without SCHEMABINDING clause

Creating a view without SCHEMABINDING is not supported, but the view is created as if WITH SCHEMABINDING was specified. Using SCHEMABINDING when creating functions, procedures, and triggers is silently ignored.

Unsupported Settings

The following settings are not supported:

  • SET ANSI_NULL_DFLT_OFF ON
  • SET ANSI_NULL_DFLT_ON OFF
  • SET ANSI_PADDING OFF
  • SET ANSI_WARNINGS OFF
  • SET ARITHABORT OFF
  • SET ARITHIGNORE ON
  • SET CURSOR_CLOSE_ON_COMMIT ON
  • SET NUMERIC_ROUNDABORT ON
  • SET PARSEONLY ON (The command does not work as expected.)
  • SET FMTONLY ON (The command does not work as expected. It suppresses only the execution of SELECT statements but not others.)

Unsupported Commands

Some functions of the following commands are not supported:

  • ADD SIGNATURE
  • ALTER DATABASE, ALTER DATABASE SET
  • BACKUP/RESTORE DATABASE/LOG
  • BACPAC and DACPAC FILES RESTORE
  • CREATE, ALTER, DROP AUTHORIZATION (Database objects support ALTER AUTHORIZATION.)
  • CREATE, ALTER, DROP AVAILABILITY GROUP
  • CREATE, ALTER, DROP BROKER PRIORITY
  • CREATE, ALTER, DROP COLUMN ENCRYPTION KEY
  • CREATE, ALTER, DROP DATABASE ENCRYPTION KEY
  • CREATE, ALTER, DROP, BACKUP CERTIFICATE
  • CREATE AGGREGATE
  • CREATE CONTRACT
  • CHECKPOINT

Unsupported Column Names or Attributes

The following column names are not supported:

  • $IDENTITY
  • $ROWGUID
  • IDENTITYCOL

Unsupported Data Types

The HIERARCHYID data type is not supported.

Unsupported Object Types

The following object types are not supported:

  • COLUMN MASTER KEY
  • CREATE, ALTER EXTERNAL DATA SOURCE
  • CREATE, ALTER, DROP DATABASE AUDIT SPECIFICATION
  • CREATE, ALTER, DROP EXTERNAL LIBRARY
  • CREATE, ALTER, DROP SERVER AUDIT
  • CREATE, ALTER, DROP SERVER AUDIT SPECIFICATION
  • CREATE, ALTER, DROP, OPEN/CLOSE SYMMETRIC KEY
  • CREATE, DROP DEFAULT
  • CREDENTIAL
  • CRYPTOGRAPHIC PROVIDER
  • DIAGNOSTIC SESSION
  • Indexed views
  • SERVICE MASTER KEY
  • SYNONYM

Unsupported Functions

The following table lists unsupported built-in functions.

Table 2 Unsupported functions

Function Type

Function

Aggregate functions
  • APPROX_COUNT_DISTINCT
  • CHECKSUM_AGG
  • GROUPING_ID
  • STRING_AGG using the WITHIN GROUP clause

Cryptographic functions
  • CERTENCODED function
  • CERTID function
  • CERTPROPERTY function

Security functions
  • CERTPRIVATEKEY
  • LOGINPROPERTY

Statements, operators, and other functions
  • EVENTDATA function
  • GET_TRANSMISSION_STATUS
  • OPENXML

Metadata functions
  • COLUMNPROPERTY
  • TYPEPROPERTY
  • SERVERPROPERTY function. The following properties are not supported:
    • BuildClrVersion
    • ComparisonStyle
    • ComputerNamePhysicalNetBIOS
    • HadrManagerStatus
    • InstanceDefaultDataPath
    • InstanceDefaultLogPath
    • IsClustered
    • IsHadrEnabled
    • LCID
    • NumLicenses
    • ProcessID
    • ProductBuild
    • ProductBuildType
    • ProductUpdateReference
    • ResourceLastUpdateDateTime
    • ResourceVersion
    • ServerName
    • SqlCharSet
    • SqlCharSetName
    • SqlSortOrder
    • SqlSortOrderName
    • FilestreamShareName
    • FilestreamConfiguredLevel
    • FilestreamEffectiveLevel

Unsupported Syntax

The following syntax is not supported:

  • ALTER DATABASE
  • ALTER DATABASE SCOPED CONFIGURATION
  • ALTER DATABASE SCOPED CREDENTIAL
  • ALTER DATABASE SET HADR
  • ALTER INDEX
  • ALTER PARTITION FUNCTION
  • ALTER PARTITION SCHEME
  • ALTER SCHEMA
  • ALTER SERVER CONFIGURATION
  • ALTER SERVICE, BACKUP/RESTORE SERVICE MASTER KEY clause
  • ALTER VIEW
  • BEGIN CONVERSATION TIMER
  • BEGIN DISTRIBUTED TRANSACTION
  • BEGIN DIALOG CONVERSATION
  • BULK INSERT
  • CREATE COLUMNSTORE INDEX
  • CREATE EXTERNAL FILE FORMAT
  • CREATE EXTERNAL TABLE
  • CREATE, ALTER, DROP APPLICATION ROLE
  • CREATE, ALTER, DROP ASSEMBLY
  • CREATE, ALTER, DROP ASYMMETRIC KEY
  • CREATE, ALTER, DROP CREDENTIAL
  • CREATE, ALTER, DROP CRYPTOGRAPHIC PROVIDER
  • CREATE, ALTER, DROP ENDPOINT
  • CREATE, ALTER, DROP EVENT SESSION
  • CREATE, ALTER, DROP EXTERNAL LANGUAGE
  • CREATE, ALTER, DROP EXTERNAL RESOURCE POOL
  • CREATE, ALTER, DROP FULLTEXT CATALOG
  • CREATE, ALTER, DROP FULLTEXT INDEX
  • CREATE, ALTER, DROP FULLTEXT STOPLIST
  • CREATE, ALTER, DROP MESSAGE TYPE
  • CREATE, ALTER, DROP, OPEN/CLOSE, BACKUP/RESTORE MASTER KEY
  • CREATE, ALTER, DROP QUEUE
  • CREATE, ALTER, DROP RESOURCE GOVERNOR
  • CREATE, ALTER, DROP RESOURCE POOL
  • CREATE, ALTER, DROP ROUTE
  • CREATE, ALTER, DROP SEARCH PROPERTY LIST
  • CREATE, ALTER, DROP SECURITY POLICY
  • CREATE, ALTER, DROP SELECTIVE XML INDEX clause
  • CREATE, ALTER, DROP SERVICE
  • CREATE, ALTER, DROP SPATIAL INDEX
  • CREATE, ALTER, DROP TYPE
  • CREATE, ALTER, DROP XML INDEX
  • CREATE, ALTER, DROP XML SCHEMA COLLECTION
  • CREATE/DROP RULE
  • CREATE, DROP WORKLOAD CLASSIFIER
  • CREATE, ALTER, DROP WORKLOAD GROUP
  • ALTER TRIGGER
  • CREATE TABLE... GRANT clause
  • CREATE TABLE... IDENTITY clause
  • CREATE USER (This syntax is not supported. The PostgreSQL statement CREATE USER does not create a user equivalent to the CREATE USER syntax of SQL Server.)
  • DENY
  • END, MOVE CONVERSATION
  • EXECUTE with AS LOGIN or AT option
  • GET CONVERSATION GROUP
  • GROUP BY ALL clause
  • GROUP BY CUBE clause
  • GROUP BY ROLLUP clause
  • INSERT... DEFAULT VALUES
  • MERGE
  • READTEXT
  • REVERT
  • UNPIVOT
  • SELECT TOP x PERCENT WHERE x <> 100
  • SELECT TOP... WITH TIES
  • SELECT... FOR BROWSE
  • SELECT... FOR XML AUTO
  • SELECT... FOR XML EXPLICIT
  • SELECT... FOR XML PATH
  • SEND
  • SET DATEFORMAT
  • SET DEADLOCK_PRIORITY
  • SET FMTONLY
  • SET FORCEPLAN
  • SET NUMERIC_ROUNDABORT ON
  • SET OFFSETS
  • SET REMOTE_PROC_TRANSACTIONS
  • SET SHOWPLAN_TEXT
  • SET SHOWPLAN_XML
  • SET STATISTICS
  • SET STATISTICS PROFILE
  • SET STATISTICS TIME
  • SET STATISTICS XML
  • SHUTDOWN statement
  • UPDATE STATISTICS
  • UPDATETEXT
  • Using EXECUTE to call a SQL function
  • VIEW... CHECK OPTION clause
  • VIEW... VIEW_METADATA clause
  • WAITFOR DELAY
  • WAITFOR TIME
  • WAITFOR, RECEIVE
  • WITH XMLNAMESPACES construct
  • WRITETEXT
  • XPATH expressions
Parent Topic: Compatibility