Default values for binary columns not escaped correctly

[digiflex]

I have a table with a not-null binary column. "SHOW CREATE TABLE" says:

Code: Select all

CREATE TABLE `panel_data_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `packet_data` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3238 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

(extra columns removed for this example)

But when I view that table in DBForge I get a create table with extra escaping:

Code: Select all

CREATE TABLE `panel_data_requests` (
  id int(11) NOT NULL AUTO_INCREMENT,
  packet_data binary(16) NOT NULL DEFAULT '\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0',
  ...

That also happens in the "Columns" editor in that table view tab - the default column has the twice-escaped text.

Obviously that is invalid SQL and it's not possible to create or set a non-ASCII default via DBForge.

Both hex and escaped zeros are valid in that situation:

Code: Select all

ALTER TABLE panel_data_requests
  CHANGE COLUMN packet_data packet_data binary(16) NOT NULL DEFAULT 0x00000000000000000000000000000000;
ALTER TABLE panel_data_requests
  CHANGE COLUMN packet_data packet_data binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0';

[alexa]

We will investigate this issue and will answer you as soon as possible.

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

[digiflex]

thanks