刘安
刘安
dble对HEX()的结果也不能完全保证 https://actiontech.github.io/dble-docs-cn/3.SQL_Syntax/3.10_func_and_operators.html
字符类型null值错误 ``` CREATE TABLE ACTION_DB.CHAR_255_COLUMNS(col1 INT, col2 CHAR(255)) CREATE TABLE ACTION_DB.CHAR_2000_COLUMNS(col1 INT, col2 CHAR(2000)) CREATE TABLE ACTION_DB.CHARACTER_255_COLUMNS(col1 INT, col2 CHARACTER(255)) CREATE TABLE ACTION_DB.CHARACTER_2000_COLUMNS(col1 INT, col2 CHARACTER(2000)) CREATE TABLE ACTION_DB.NCHAR_255_COLUMNS(col1 INT,...
目标端数据类型错误 oracle建表 ``` CREATE TABLE ACTION_DB.INTEGER_COLUMNS(col1 INT, col2 INTEGER) CREATE TABLE ACTION_DB.INT_COLUMNS(col1 INT, col2 INT) ``` MySQL 验证: ``` SELECT DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, DATETIME_PRECISION FROM COLUMNS WHERE TABLE_SCHEMA='ACTION_DB' AND...
INTERVA_xxx数据错误 ``` CREATE TABLE ACTION_DB.INTERVAL_YEAR_COLUMNS(col1 INT, col2 INTERVAL YEAR(9) TO MONTH) CREATE TABLE ACTION_DB.INTERVAL_DAY_COLUMNS(col1 INT, col2 INTERVAL DAY(9) TO SECOND(9)) ``` ``` INSERT INTO ACTION_DB.INTERVAL_YEAR_COLUMNS VALUES (1, INTERVAL '999999999-11' YEAR(9)...
"DROP PROCEDURE IF EXISTS not_exists" cause same issue
fixed version: ``` 9.9.9.9-master-7a98826 ```