Skip to content

Several MySQL column types are not supported #31

@Stanpol

Description

@Stanpol

I have a table:

--- processing statement:
 CREATE TABLE `test` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `final` bit(1) NOT NULL,
  `coordinate` point DEFAULT NULL,
  `external_id` binary(16) NOT NULL,
  PRIMARY KEY (`id`),
) ENGINE=InnoDB AUTO_INCREMENT=2906 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 

This results in exceptions:

  File "/.direnv/python-3.11.2/lib/python3.11/site-packages/mysql_ch_replicator/converter.py", line 140, in convert_type
    raise Exception(f'unknown mysql type "{mysql_type}"')
Exception: unknown mysql type "bit(1)"

and

File "/.direnv/python-3.11.2/lib/python3.11/site-packages/mysql_ch_replicator/converter.py", line 140, in convert_type
    raise Exception(f'unknown mysql type "{mysql_type}"')
Exception: unknown mysql type "point"

and

File "/.direnv/python-3.11.2/lib/python3.11/site-packages/mysql_ch_replicator/converter.py", line 140, in convert_type
    raise Exception(f'unknown mysql type "{mysql_type}"')
Exception: unknown mysql type "binary(16)"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions