建表如下,都是带双引号,因从mysql项目过来
CREATE TABLE "block_info" (
"blockId" serial8 PRIMARY KEY NOT NULL,
"parentId" int8,
"blockName" varchar(80) NOT NULL,
"flag" varchar(40) NOT NULL,
"type" int4 NOT NULL,
"siteId" int8 NOT NULL,
"templateUrl" varchar(200) ,
"creator" varchar(255) ,
"blockDesc" varchar(600) ,
"staticUrl" varchar(700) ,
"jobId" int8,
"periodType" int4,
"period" int4,
"lastPubTime" timestamptz(0)
)
;
但查询中如order by blockId dedsc 都被提示 blockid does not exist
openGauss 5记得可以调整参数适配,请问openGauss 6 如果解决?