【产品名称】BenchMarkSQL5
【产品版本】5.0
【问题描述】
改造 BenchMarkSQL5 中的 SQL。按文档操作报错
create table bmsql_config ( cfg_name varchar(30) primary key, cfg_value varchar(50) ); create tablegroup if not exists tpcc_group binding true partition by hash partitions 128; create table bmsql_warehouse ( w_id integer not null, w_ytd decimal(12,2), w_tax decimal(4,4), w_name varchar(10), w_street_1 varchar(20), w_street_2 varchar(20), w_city varchar(20), w_state char(2), w_zip char(9), primary key(w_id) )tablegroup=‘tpcc_group’ partition by hash(w_id) partitions 128;
报错如下:语法错误
You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'varchar2(30) primary key,
db=oceanbase 开源版支持oceanbase吗?
测试结果如下
db=oceanbase 开源版支持oceanbase