Page tree
Skip to end of metadata
Go to start of metadata

This topic lists MySQL functionality that ClustrixDB does not support. For a description of features that are supported but differ from the MySQL implementation, see the section on MySQL Compatibility.

Unsupported SQL

Please see Unsupported SQL (in the ClustrixDB SQL and DDL section)

Unsupported Data Types

  • Spatial Extensions

Unsupported Features

  • Full Text Search
  • XML Functions (limited support only)
  • MySQL Performance Schema
  • The SET NAMES ASCII option. Use SET NAMES LATIN1 instead
  • SELECT INTO ... OUTFILE option. ClustrixDB does support the LOAD DATA INFILE command
    • Instead, if there is a MySQL client installed on remote machine, run the following to generate the file on the client host:

      shell> mysql -e "SELECT ..." > file_name  

Unsupported Functions

  • ANALYSE() 

  • BENCHMARK() 

  • CHARSET() 

  • COERCIBILITY() 

  • COLLATION() 

  • CURRENT_USER() 

  • EXTRACT() 

  • GET_FORMAT() 

  • LOAD_FILE() 
  • MAKEDATE() 

  • SESSION_USER()

Unsupported Privileges

The following MySQL privileges are not supported, and generate a syntax error if used in a GRANT statement:

  • EVENT

The following privileges are ignored:

  • FILE
  • LOCK TABLES
  • PROCESS
  • REFERENCES
  • RELOAD
  • SHOW DATABASES
  • SHOW VIEW
  • SHUTDOWN

Unsupported Statements

  • CHECKSUM TABLE
  • RENAME USER
  • SHOW WARNINGS
    • ClustrixDB accepts this syntax but will not show any warnings.

Miscellaneous

  • The _ and % wild cards are not supported in database names.
  • The GRANT statement ignores REQUIRE, if included.
  • The DEFINER and SQL SECURITY arguments for views are ignored.

The following variables are not supported and generate a syntax error:

  • MAX_QUERIES_PER_HOUR
  • MAX_UPDATES_PER_HOUR
  • MAX_CONNECTIONS_PER_HOUR
  • MAX_USER_CONNECTIONS
  • MAX_JOIN_SIZE
  • SQL_MAX_JOIN_SIZE

SQL_MODE

ClustrixDB emulates the default SQL mode behavior and supports NO_AUTO_VALUE_ON_ZERO. Other values for SQL_MODE are not supported.

GTID

ClustrixDB does not support MySQL 5.7 GTIDs for replication. To replicate to or from MySQL 5.7, disable the GTID functionality as described in Using ClustrixDB as a Replication Master or Using ClustrixDB as a Replication Slave.

  • No labels