📄 views.out
字号:
S_WAS_I |DP_WA&|I_WAS_F |F_WAS_DP |DP |F --------------------------------------------------------------------------------------------------------------1 |1 |1.0 |1.0 |1.0 |1.0 ij> select * from cv3;I |S |F |DP ---------------------------------------------------------------------1 |1 |1.0 |1.0 1 |2 |3.0 |4.0 2 |1 |4.0 |3.0 7 |8 |5.0 |6.0 8 |7 |6.0 |5.0 ij> select * from cv4 order by 1;DISTINCT_I -----------1 8 ij> select * from cv5;I |S -----------------------1 |1 ij> select * from cv6;C1 |C2 -----------------------1 |2 1 |3 2 |1 2 |3 3 |1 3 |2 ij> select * from cv7;I |C1 -----------------------1 |1 1 |1 1 |1 1 |1 ij> select * from cv8;COL1 |COL2 ----------------------Column 1|Value = 1 Column 1|Value = 1 Column 1|Value = 1 Column 1|Value = 1 ij> select * from (select * from cv3) x order by 1,2;I |S |F |DP ---------------------------------------------------------------------1 |1 |1.0 |1.0 1 |2 |3.0 |4.0 2 |1 |4.0 |3.0 7 |8 |5.0 |6.0 8 |7 |6.0 |5.0 ij> select * from (select * from cv4) x order by 1;DISTINCT_I -----------1 8 ij> select * from (select * from cv5) x;I |S -----------------------1 |1 ij> -- verify that we can create and drop indexes on underlying tablescreate index i on t1(i);0 rows inserted/updated/deletedij> drop index i;0 rows inserted/updated/deletedij> -- verify the consistency of the indexes on the system catalogsselect tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE('SYS', tablename)from sys.systables where tabletype = 'S' and tablename != 'SYSDUMMY1';TABLENAME |2 --------------------------------------------------------------------------------------------------------------------------------------------SYSCONGLOMERATES |1 SYSTABLES |1 SYSCOLUMNS |1 SYSSCHEMAS |1 SYSCONSTRAINTS |1 SYSKEYS |1 SYSDEPENDS |1 SYSALIASES |1 SYSVIEWS |1 SYSCHECKS |1 SYSFOREIGNKEYS |1 SYSSTATEMENTS |1 SYSFILES |1 SYSTRIGGERS |1 SYSSTATISTICS |1 ij> -- test inserts from a viewinsert into insert_test select * from sv5;3 rows inserted/updated/deletedij> select * from insert_test;F ----------------------1.0 2.0 3.0 ij> -- drop the viewsdrop view cv8;0 rows inserted/updated/deletedij> drop view cv7;0 rows inserted/updated/deletedij> drop view cv6;0 rows inserted/updated/deletedij> drop view cv5;0 rows inserted/updated/deletedij> drop view cv4;0 rows inserted/updated/deletedij> drop view cv3;0 rows inserted/updated/deletedij> drop view cv2;0 rows inserted/updated/deletedij> drop view cv1;0 rows inserted/updated/deletedij> drop view sv5;0 rows inserted/updated/deletedij> drop view sv4;0 rows inserted/updated/deletedij> drop view sv3;0 rows inserted/updated/deletedij> drop view sv2;0 rows inserted/updated/deletedij> drop view sv1;0 rows inserted/updated/deletedij> -- drop the tablesdrop table t1;0 rows inserted/updated/deletedij> drop table t2;0 rows inserted/updated/deletedij> drop table insert_test;0 rows inserted/updated/deletedij> -- verify the consistency of the indexes on the system catalogsselect tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE('SYS', tablename)from sys.systables where tabletype = 'S' and tablename != 'SYSDUMMY1';TABLENAME |2 --------------------------------------------------------------------------------------------------------------------------------------------SYSCONGLOMERATES |1 SYSTABLES |1 SYSCOLUMNS |1 SYSSCHEMAS |1 SYSCONSTRAINTS |1 SYSKEYS |1 SYSDEPENDS |1 SYSALIASES |1 SYSVIEWS |1 SYSCHECKS |1 SYSFOREIGNKEYS |1 SYSSTATEMENTS |1 SYSFILES |1 SYSTRIGGERS |1 SYSSTATISTICS |1 ij> -- bug 2745CREATE TABLE orgtable ( name VARCHAR(255), supervisorname VARCHAR(255), jobtitle VARCHAR(255));0 rows inserted/updated/deletedij> CREATE VIEW orgview AS SELECT name, supervisorname, jobtitle FROM orgtable;0 rows inserted/updated/deletedij> SELECT name,jobtitle FROM orgview WHERE name IN (SELECT supervisorname FROM orgview WHERE name LIKE 'WYATT%');NAME |JOBTITLE -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ij> drop view orgview;0 rows inserted/updated/deletedij> drop table orgtable;0 rows inserted/updated/deletedij> -- reset autocommitautocommit on;ij> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -