Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.2

Supported Data Types

Data Types supported by ClustrixDB include:

  • BIGINT
  • BINARY
  • BIT
  • BLOB 
  • BOOL 
  • CHAR 
  • DATE and DATETIME including Fractional Seconds
  • DECIMAL (M,D) 
  • DOUBLE (M,D) 
  • DOUBLE PRECISION (M,D) (is treated as DOUBLE
  • ENUM ("A") 
  • FLOAT (M,D) 
  • INT 
  • JSON 
  • LONGBLOB

  • LONGTEXT      

  • MEDIUMBLOB 
  • MEDIUMINT 
  • MEDIUMTEXT 
  • NUMERIC (M,D) (is treated as DECIMAL
  • REAL (is treated as DOUBLE
  • SERIAL (is treated as BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT
  • SET ("A","B") SMALLINT TEXT TIME TIMESTAMP
  • SMALLINT
  • TEXT
  • TIME
  • TINYBLOB 
  • TINYINT 
  • TINYTEXT 
  • VARBINARY 
  • VARCHAR 
  • YEAR 

Unsupported Data Types

ClustrixDB does not support:

  • Spatial Extensions

Caveats for Data Type Support

  • Boolean values (TrueFalseNull) are accepted in a DATETIME column. This matches the behavior for MySQL v5.5. MySQL v5.6 provides an error message. 
  • On ClustrixDB, supplying a zero value for day, month, or year within a date will in a zero date ('0000-00-00'). MySQL will issue an error (if the sql_mode for NO_ZERO_IN_DATE) is set, or allow zero value for the specific portion of the date. 
  • ClustrixDB permits table definitions that use the VARCHAR data type with no max length, and supply a default max length of 21845. MySQL does not permit this. 
  • When creating a column of type bit(0), MySQL will automatically create a bit(1). ClustrixDB will not allow you to create a column with type bit(0) and will provide an error message.