-- @owner: wang-tianjing1
-- @date: 2025/2/7
-- @testpoint:openGauss保留关键字not作为视图名,部分测试点合理报错
--不带引号-合理报错
CREATE or replace VIEW not AS
    SELECT * FROM pg_tablespace WHERE spcname = 'pg_default';
?.*ERROR: syntax error at or near "not"
?.*Position.*
--加双引号-创建成功
CREATE  or replace VIEW "not" AS
    SELECT * FROM pg_tablespace WHERE spcname = 'pg_default';
SQL SUCCESS
--清理环境	
drop VIEW "not";
SQL SUCCESS
--加单引号-合理报错
CREATE or replace VIEW 'not' AS
 SELECT * FROM pg_tablespace WHERE spcname = 'pg_default';
?.*ERROR: syntax error at or near "'not'".*
?.*Position.*
--加反引号-合理报错
CREATE or replace VIEW `not` AS
 SELECT * FROM pg_tablespace WHERE spcname = 'pg_default';
?.*ERROR: syntax error at or near "`".*
?.*Position.*