📄 simplescroll.out
字号:
ij> -- simple scroll cursor testscreate table t (a int);0 rows inserted/updated/deletedij> insert into t values (1),(2),(3),(4),(5);5 rows inserted/updated/deletedij> get scroll insensitive cursor c1 as 'select * from t';ij> -- should be 1first c1;A -----1 ij> -- should be 2next c1;A -----2 ij> -- should be 1previous c1;A -----1 ij> -- should be 5last c1;A -----5 ij> -- should be 2absolute 2 c1;A -----2 ij> -- should be 4relative 2 c1;A -----4 ij> close c1;ij> -- since JCC gets 64 results and then scrolls within them----- lets try each positioning command as the first command for the cursorget scroll insensitive cursor c1 as 'select * from t';ij> -- should be 1next c1;A -----1 ij> close c1;ij> get scroll insensitive cursor c1 as 'select * from t';ij> -- should be 5last c1;A -----5 ij> close c1;ij> get scroll insensitive cursor c1 as 'select * from t';ij> -- should be 3absolute 3 c1;A -----3 ij> -- should be 4next c1;A -----4 ij> close c1;ij> -- let's try a table with more than 64 rowscreate table t1 (a int);0 rows inserted/updated/deletedij> insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);10 rows inserted/updated/deletedij> insert into t1 values (11),(12),(13),(14),(15),(16),(17),(18),(19),(20);10 rows inserted/updated/deletedij> insert into t1 values (21),(22),(23),(24),(25),(26),(27),(28),(29),(30);10 rows inserted/updated/deletedij> insert into t1 values (31),(32),(33),(34),(35),(36),(37),(38),(39),(40);10 rows inserted/updated/deletedij> insert into t1 values (41),(42),(43),(44),(45),(46),(47),(48),(49),(50);10 rows inserted/updated/deletedij> insert into t1 values (51),(52),(53),(54),(55),(56),(57),(58),(59),(60);10 rows inserted/updated/deletedij> insert into t1 values (61),(62),(63),(64),(65),(66),(67),(68),(69),(70);10 rows inserted/updated/deletedij> get scroll insensitive cursor c1 as 'select * from t1';ij> -- should be 1first c1;A -----1 ij> -- should be 70last c1;A -----70 ij> -- should be 65absolute 65 c1;A -----65 ij> -- should be 70absolute -1 c1;A -----70 ij> close c1;ij> -- try sensitive scroll cursors bug 4677get scroll sensitive cursor c1 as 'select * from t';ij> close c1;ij> get scroll sensitive cursor c1 as 'select * from t for update';ij> close c1;ij> drop table t1;0 rows inserted/updated/deletedij> -- defect 5225, outer joins returning NULLscreate table t1 (i1 bigint not null, c1 varchar(64) not null);0 rows inserted/updated/deletedij> create table t2 (i2 bigint not null, c2 varchar(64) not null);0 rows inserted/updated/deletedij> insert into t1 values (1, 'String 1');1 row inserted/updated/deletedij> insert into t1 values (2, 'String 2');1 row inserted/updated/deletedij> insert into t2 values (1, 'String 1');1 row inserted/updated/deletedij> insert into t2 values (3, 'String 3');1 row inserted/updated/deletedij> -- Outer joins can return NULLs on the non-outer side of the joinselect c1 from t1 right outer join t2 on (i1=i2);C1 -----String 1 NULL ij> select c2 from t1 right outer join t2 on (i1=i2);C2 -----String 1 String 3 ij> -- Left outer joinselect c1 from t1 left outer join t2 on (i1=i2);C1 -----String 1 String 2 ij> select c2 from t1 left outer join t2 on (i1=i2);C2 -----String 1 NULL ij> drop table t1;0 rows inserted/updated/deletedij> drop table t2;0 rows inserted/updated/deletedij> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -