📄 identifier.out
字号:
0 rows inserted/updated/deletedij> drop table longid3;0 rows inserted/updated/deletedij> drop table longid4;0 rows inserted/updated/deletedij> drop tableasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfaslast;0 rows inserted/updated/deletedij> drop table"delimitedsdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfaslast";0 rows inserted/updated/deletedij> drop procedure pppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp;0 rows inserted/updated/deletedij> drop procedure "pppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp";0 rows inserted/updated/deletedij> -- xxxxxxFILTERED-TIMESTAMPxxxxx-- new testcases for SQL92 reserved keywords as identifiersCREATE TABLE WHEN (WHEN INT, A INT);0 rows inserted/updated/deletedij> INSERT INTO WHEN (WHEN) VALUES (1);1 row inserted/updated/deletedij> INSERT INTO WHEN VALUES (2, 2);1 row inserted/updated/deletedij> SELECT * FROM WHEN;WHEN |A -----------------------1 |NULL 2 |2 ij> SELECT WHEN.WHEN, WHEN FROM WHEN;WHEN |WHEN -----------------------1 |1 2 |2 ij> SELECT WHEN.WHEN, WHEN FROM WHEN WHEN;WHEN |WHEN -----------------------1 |1 2 |2 ij> DROP TABLE WHEN;0 rows inserted/updated/deletedij> CREATE TABLE THEN (THEN INT, A INT);0 rows inserted/updated/deletedij> INSERT INTO THEN (THEN) VALUES (1);1 row inserted/updated/deletedij> INSERT INTO THEN VALUES (2, 2);1 row inserted/updated/deletedij> SELECT * FROM THEN;THEN |A -----------------------1 |NULL 2 |2 ij> SELECT THEN.THEN, THEN FROM THEN;THEN |THEN -----------------------1 |1 2 |2 ij> SELECT THEN.THEN, THEN FROM THEN THEN;THEN |THEN -----------------------1 |1 2 |2 ij> DROP TABLE THEN;0 rows inserted/updated/deletedij> CREATE TABLE SIZE (SIZE INT, A INT);0 rows inserted/updated/deletedij> INSERT INTO SIZE (SIZE) VALUES (1);1 row inserted/updated/deletedij> INSERT INTO SIZE VALUES (2, 2);1 row inserted/updated/deletedij> SELECT * FROM SIZE;SIZE |A -----------------------1 |NULL 2 |2 ij> SELECT SIZE.SIZE, SIZE FROM SIZE;SIZE |SIZE -----------------------1 |1 2 |2 ij> SELECT SIZE.SIZE, SIZE FROM SIZE SIZE;SIZE |SIZE -----------------------1 |1 2 |2 ij> DROP TABLE SIZE;0 rows inserted/updated/deletedij> CREATE TABLE LEVEL (LEVEL INT, A INT);0 rows inserted/updated/deletedij> INSERT INTO LEVEL (LEVEL) VALUES (1);1 row inserted/updated/deletedij> INSERT INTO LEVEL VALUES (2, 2);1 row inserted/updated/deletedij> SELECT * FROM LEVEL;LEVEL |A -----------------------1 |NULL 2 |2 ij> SELECT LEVEL.LEVEL, LEVEL FROM LEVEL;LEVEL |LEVEL -----------------------1 |1 2 |2 ij> SELECT LEVEL.LEVEL, LEVEL FROM LEVEL LEVEL;LEVEL |LEVEL -----------------------1 |1 2 |2 ij> DROP TABLE LEVEL;0 rows inserted/updated/deletedij> CREATE TABLE DOMAIN (DOMAIN INT, A INT);0 rows inserted/updated/deletedij> INSERT INTO DOMAIN (DOMAIN) VALUES (1);1 row inserted/updated/deletedij> INSERT INTO DOMAIN VALUES (2, 2);1 row inserted/updated/deletedij> SELECT * FROM DOMAIN;DOMAIN |A -----------------------1 |NULL 2 |2 ij> SELECT DOMAIN.DOMAIN, DOMAIN FROM DOMAIN;DOMAIN |DOMAIN -----------------------1 |1 2 |2 ij> SELECT DOMAIN.DOMAIN, DOMAIN FROM DOMAIN DOMAIN;DOMAIN |DOMAIN -----------------------1 |1 2 |2 ij> DROP TABLE DOMAIN;0 rows inserted/updated/deletedij> CREATE TABLE ZONE (ZONE INT, A INT);0 rows inserted/updated/deletedij> INSERT INTO ZONE (ZONE) VALUES (1);1 row inserted/updated/deletedij> INSERT INTO ZONE VALUES (2, 2);1 row inserted/updated/deletedij> SELECT * FROM ZONE;ZONE |A -----------------------1 |NULL 2 |2 ij> SELECT ZONE.ZONE, ZONE FROM ZONE;ZONE |ZONE -----------------------1 |1 2 |2 ij> SELECT ZONE.ZONE, ZONE FROM ZONE ZONE;ZONE |ZONE -----------------------1 |1 2 |2 ij> DROP TABLE ZONE;0 rows inserted/updated/deletedij> CREATE TABLE LOCAL (LOCAL INT, A INT);0 rows inserted/updated/deletedij> INSERT INTO LOCAL (LOCAL) VALUES (1);1 row inserted/updated/deletedij> INSERT INTO LOCAL VALUES (2, 2);1 row inserted/updated/deletedij> SELECT * FROM LOCAL;LOCAL |A -----------------------1 |NULL 2 |2 ij> SELECT LOCAL.LOCAL, LOCAL FROM LOCAL;LOCAL |LOCAL -----------------------1 |1 2 |2 ij> SELECT LOCAL.LOCAL, LOCAL FROM LOCAL LOCAL;LOCAL |LOCAL -----------------------1 |1 2 |2 ij> DROP TABLE LOCAL;0 rows inserted/updated/deletedij> -- Negative tests-- Novera wanted 0-length delimited identifiers but for db2-compatibility, we are going to stop supporting 0-length delimited identifiers-- test1create table "" (c1 int);ERROR 42X01: Syntax error: Encountered "\"" at line 4, column 14.ij> -- test2create table t1111 ("" int);ERROR 42X01: Syntax error: Encountered "\"" at line 2, column 21.ij> -- test3create schema "";ERROR 42X01: Syntax error: Encountered "\"" at line 2, column 15.ij> -- identifiers can not start with "_"-- test4create table _t1(_c1 int);ERROR 42X01: Syntax error: Encountered "_" at line 3, column 14.ij> -- test5create table t1(_c1 int);ERROR 42X01: Syntax error: Encountered "_" at line 2, column 17.ij> -- test6create view _v1 (c1) as select * from t1;ERROR 42X01: Syntax error: Encountered "_" at line 2, column 13.ij> -- test7create view v1 (__c1) as select * from t1;ERROR 42X01: Syntax error: Encountered "_" at line 2, column 17.ij> -- test8create index _i1 on t1(c1);ERROR 42X01: Syntax error: Encountered "_" at line 2, column 14.ij> -- test9create table "_"."_"(c1 int);0 rows inserted/updated/deletedij> -- test10create table "".""(c1 int);ERROR 42X01: Syntax error: Encountered "\"" at line 2, column 14.ij> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -