oceanbase
[Bug]: Export an obkv Redis table structure, run it in SQL window, reconstruct the table statement, and report an error
ODC version
ODC 4.3.2
OB version
OBKV REDIS
What happened?
Export an obkv Redis table structure, run it in SQL window, reconstruct the table statement, and report an error
CREATE TABLE obkv_redis_hash_table (
db bigint(20) NOT NULL,
rkey varbinary(16384) NOT NULL,
expire_ts timestamp(6) NULL DEFAULT NULL,
insert_ts timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6),
value varbinary(1048576) DEFAULT NULL,
vk varbinary(16384) GENERATED ALWAYS AS (substr(rkey,9,conv(substr(rkey,1,8),16,10))) VIRTUAL,
PRIMARY KEY (db, rkey)
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 KV_ATTRIBUTES = ({"Redis": {"isTTL": true, "model": "hash"}})
partition by key(db, vk)
(partition p0,
partition p1,
partition p2,
partition p3,
partition p4,
partition p5,
partition p6,
partition p7,
partition p8,
partition p9,
partition p10,
partition p11,
partition p12,
partition p13,
partition p14,
partition p15,
partition p16,
partition p17,
partition p18,
partition p19,
partition p20,
partition p21,
partition p22,
partition p23,
partition p24,
partition p25,
partition p26,
partition p27,
partition p28,
partition p29,
partition p30,
partition p31,
partition p32,
partition p33,
partition p34,
partition p35,
partition p36,
partition p37,
partition p38,
partition p39,
partition p40,
partition p41,
partition p42,
partition p43,
partition p44,
partition p45,
partition p46,
partition p47,
partition p48,
partition p49,
partition p50,
partition p51,
partition p52,
partition p53,
partition p54,
partition p55,
partition p56,
partition p57,
partition p58,
partition p59,
partition p60,
partition p61,
partition p62,
partition p63,
partition p64,
partition p65,
partition p66,
partition p67,
partition p68,
partition p69,
partition p70,
partition p71,
partition p72,
partition p73,
partition p74,
partition p75,
partition p76,
partition p77,
partition p78,
partition p79,
partition p80,
partition p81,
partition p82,
partition p83,
partition p84,
partition p85,
partition p86,
partition p87,
partition p88,
partition p89,
partition p90,
partition p91,
partition p92,
partition p93,
partition p94,
partition p95,
partition p96);
What did you expect to happen?
Tables can be created as normal
How can we reproduce it (as minimally and precisely as possible)?
Select an obkv redis table, export the table structure, copy the SQL statement, execute it in the SQL window, and get the result of ErrorCode = 0, SQLState = null, Details = unknown escape sequence {"Redis": {"isTTL": true, "model": "hash"}}
Anything else we need to know?
No response
this seems to be a problem with 'show create table' statement, what does 'show create table obkv_redis_hash_table' result looks like ?
