mariadb ADD NUMERIC(5, 2)

[lufi78]

using MariaDB

ALTER TABLE TableName ADD factor NUMERIC(5, 2) DEFAULT NULL;

[dbrepl database 2025-02-24 11:09:58,241 INFO] launched db_replicator
[dbrepl database 2025-02-24 11:09:58,245 INFO] running realtime replication from the position: ('mysql-bin.000644', 47265645)
[dbrepl database 2025-02-24 11:09:58,977 INFO] set position to /home/lufi/mysql_ch_replicator/binlog/database/4.bin
[dbrepl database 2025-02-24 11:09:59,073 INFO] found transaction ('mysql-bin.000644', 47265645) inside /home/user/mysql_ch_replicator/binlog/database/4.bin
[dbrepl database 2025-02-24 11:09:59,089 ERROR] unhandled exception
Traceback (most recent call last):
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 191, in run
self.run_realtime_replication()
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 392, in run_realtime_replication
self.handle_event(event)
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 414, in handle_event
event_handlersevent.event_type
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 494, in handle_query_event
self.handle_alter_query(query, event.db_name)
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 505, in handle_alter_query
self.converter.convert_alter_query(query, db_name)
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 453, in convert_alter_query
self.__convert_alter_table_add_column(db_name, table_name, tokens)
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 493, in __convert_alter_table_add_column
column_type_ch = self.convert_field_type(column_type_mysql, column_type_mysql_parameters)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 291, in convert_field_type
clickhouse_type = self.convert_type(mysql_type, mysql_parameters)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/user/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 285, in convert_type
raise Exception(f'unknown mysql type "{mysql_type}"')
Exception: unknown mysql type "numeric(5,"

[bakwc]

Fixed in v0.0.69, please check if it helped.

[lufi78]

@bakwc thanks for fixing - it works!