MySQL 8.0 Adapter Limitations

Supported Version

This adapter supports types as follows.

Type name	Support	Remarks
BOOL (BOOLEAN)	Yes	Alias of tinyint(1)
BIT	Limited
TINYINT	Yes
TINYINT UNSIGNED	Limited
MEDIUMINT	Yes
MEDIUMINT UNSIGNED	Limited
SMALLINT	Yes
SMALLINT UNSIGNED	Limited
INT (INTEGER)	Yes
INT UNSIGNED (INTEGER UNSIGNED)	Limited
BIGINT	Yes
BIGINT UNSIGNED	Limited
FLOAT	Limited
FLOAT UNSIGNED	Limited
DOUBLE (REAL)	Limited
DOUBLE UNSIGNED (REAL UNSIGNED)	Limited
DECIMAL (NUMERIC)	Yes
DECIMAL UNSIGNED (NUMERIC UNSIGNED)	Limited
DATE	Limited
DATETIME	Limited
TIMESTAMP	Limited
TIME	Limited
YEAR	Limited
CHAR	Limited
VARCHAR	Limited
BINARY	Yes
VARBINARY	Yes
TINYBLOB	Yes
TINYTEXT	Limited
BLOB	Yes
TEXT	Limited
MEDIUMBLOB	Yes
MEDIUMTEXT	Limited
LONGBLOB	Yes
LONGTEXT	Limited
ENUM	Limited
SET	Limited
JSON	No

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- Error occurs when data is 0000-00-00 00:00:00.
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Even if ZEROFILL optional extension attribute is specified, it returns results in which 0s are excluded.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- Error occurs when data is 0000-00-00 00:00:00.
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Even if ZEROFILL optional extension attribute is specified, it returns results in which 0s are excluded.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- If the date does not exist, it will not be written correctly.
  For example: "00 month 00 day, 0000" becomes "November 30, 0002".
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DATE, DATETIME, TIMESTAMP
- If the date does not exist, it will not be written correctly.
  For example: "00 month 00 day, 0000" becomes "November 30, 0002".
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

BIT
- BIT type data that size is 1 is treated as Boolean.Other sized BIT type is not supported.
FLOAT, FLOAT UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
DOUBLE, DOUBLE UNSIGNED
- MySQL has a number of considerations about floating point accuracy .
  For more information refer to "MySQL Reference Manual" (the URL below).
  https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html
CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
- When using the argument that contains a multi-byte character, an error occurs.
TIME
- Supports the range of 00:00:00 to 23:59:59.Otherwise, error occurs.
YEAR
- Treated as String data.
ENUM, SET
- When using the argument that contains a multi-byte character, an error occurs.
TINYINT UNSIGNED, MEDIUMINT UNSIGNED, SMALLINT UNSIGNED, INT UNSIGNED, BIGINT UNSIGNED, FLOAT UNSIGNED, DOUBLE UNSIGNED, DECIMAL UNSIGNED
- It is displayed without UNSIGNED in [Input/Type] and [Output/Type].
Even if a table name is enclosed by quotation marks, table names are not case sensitive.

Exception name	Cause	Actions
com.mysql.cj.jdbc.exceptions.CommunicationsException	Cannot connect to the database.	Check the [Hostname] and [Port number].
java.sql.SQLNonTransientConnectionException	Cannot connect to the database.	Check the [Hostname] and [Port number].
java.sql.SQLSyntaxErrorException Unknown database '<database name>'	The database does not exist.	Make sure the specified [Database name] exists.
java.sql.SQLException Access denied for user '<username >'@'< terminal name>' (using password: YES)	Connected to the database but cannot login.	Check that the correct [User name] and [Password] is specified.
java.sql.SQLSyntaxErrorException Table '<table name>' doesn't exist	The table does not exist.	Make sure the specified [Table name] exists.