oceanbase
[Bug]: An error message is reported when the exported insert into statement is executed in the SQL window
ODC version
odc4.3.2
OB version
obkv redis source
What happened?
Copy an insert into statement in the file of the exported table and run it in the SQL window of the table with the error message ErrorCode = 3105, SQLState = HY000, Details = The value specified for generated column 'vk' in table 'obkv_redis_hash_table' is not allowed
What did you expect to happen?
The system handles the OBKV Redis data source accordingly
How can we reproduce it (as minimally and precisely as possible)?
Copy an insert into statement in the file of the exported table and run it in the SQL window of the table with the error message ErrorCode = 3105, SQLState = HY000, Details = The value specified for generated column 'vk' in table 'obkv_redis_hash_table' is not allowed
Anything else we need to know?
No response
by default, virtual columns' data are exported by obdumper. when importing data using obloader, virtual columns are ignored, so it works. however, executing sql directly will cause error. This is actually a compatibility issue
