创建B库
create database dolphindb dbcompatibility ‘B’;
确认是否开启b_compatibility_mode
#参考资料:https://www.bookstack.cn/read/opengauss-3.1.1zh/78d7b6e9d26c76fe.md#dolphin.b_compatibility_mode
show dolphin.b_compatibility_mode;
未开启使用命令开启
SET dolphin.b_compatibility_mode = on;
或者:
ALTER DATABASE dolphindb SET dolphin.b_compatibility_mode = on;
给对应的数据库设置sql_mode
ALTER DATABASE dolphindb SET dolphin.sql_mode TO ‘sql_mode_strict,pipes_as_concat,ansi_quotes,no_zero_date,pad_char_to_full_length’;