--  @testpoint:openGauss关键字datetime_interval_code(非保留)，同时作为表名和列名带引号，并进行dml操作,datetime_interval_code列的值最终显示为1000
drop table if exists "datetime_interval_code";
SQL SUCCESS
create table "datetime_interval_code"(
	c_id int, c_int int, c_integer integer, c_bool int, c_boolean int, c_bigint integer,
	c_real real, c_double real,
	c_decimal decimal(38), c_number number(38), c_numeric numeric(38),
	c_char char(50) default null, c_varchar varchar(20), c_varchar2 varchar2(4000),
	c_date date, c_datetime date, c_timestamp timestamp,
	"datetime_interval_code" varchar(100) default 'datetime_interval_code'
)
PARTITION BY RANGE (c_integer)
(
	partition P_20180121 values less than (0),
	partition P_20190122 values less than (50000),
	partition P_20200123 values less than (100000),
	partition P_max values less than (maxvalue)
);
SQL SUCCESS
insert into "datetime_interval_code"(c_id,"datetime_interval_code") values(1,'hello');
SQL SUCCESS
insert into "datetime_interval_code"(c_id,"datetime_interval_code") values(2,'china');
SQL SUCCESS
update "datetime_interval_code" set "datetime_interval_code"=1000 where "datetime_interval_code"='hello';
SQL SUCCESS
delete from "datetime_interval_code" where "datetime_interval_code"='china';
SQL SUCCESS
select "datetime_interval_code" from "datetime_interval_code" where "datetime_interval_code"!='hello' order by "datetime_interval_code";
+------------------------+
| datetime_interval_code |
+------------------------+
| 1000                   |
+------------------------+
drop table "datetime_interval_code";
SQL SUCCESS