nonreserved.out

来自「derby database source code.good for you.」· OUT 代码 · 共 459 行

OUT
459 行
字号 
ij> -- This tests that SQL92 formally reserved words are now unreserved---- INTERVALcreate table interval(interval int);0 rows inserted/updated/deletedij> prepare interval as 'select * from interval';ij> execute interval;INTERVAL   -----------ij> create index interval on interval(interval);0 rows inserted/updated/deletedij> drop table interval;0 rows inserted/updated/deletedij> remove interval;ij> -- MODULEcreate table module(module int);0 rows inserted/updated/deletedij> prepare module as 'select * from module';ij> execute module;MODULE     -----------ij> create index module on module(module);0 rows inserted/updated/deletedij> drop table module;0 rows inserted/updated/deletedij> remove module;ij> -- NAMEScreate table names(names int);0 rows inserted/updated/deletedij> prepare names as 'select * from names';ij> execute names;NAMES      -----------ij> create index names on names(names);0 rows inserted/updated/deletedij> drop table names;0 rows inserted/updated/deletedij> remove names;ij> -- PRECISIONcreate table precision(precision int);0 rows inserted/updated/deletedij> prepare precision as 'select * from precision';ij> execute precision;PRECISION  -----------ij> create index precision on precision(precision);0 rows inserted/updated/deletedij> drop table precision;0 rows inserted/updated/deletedij> remove precision;ij> -- POSITIONcreate table position(position int);0 rows inserted/updated/deletedij> prepare position as 'select * from position';ij> execute position;POSITION   -----------ij> create index position on position(position);0 rows inserted/updated/deletedij> drop table position;0 rows inserted/updated/deletedij> remove position;ij> -- SECTIONcreate table section(section int);0 rows inserted/updated/deletedij> prepare section as 'select * from section';ij> execute section;SECTION    -----------ij> create index section on section(section);0 rows inserted/updated/deletedij> drop table section;0 rows inserted/updated/deletedij> remove section;ij> -- VALUEcreate table value(value int);0 rows inserted/updated/deletedij> prepare value as 'select * from value';ij> execute value;VALUE      -----------ij> create index value on value(value);0 rows inserted/updated/deletedij> drop table value;0 rows inserted/updated/deletedij> remove value;ij> -- DATEcreate table date (date date);0 rows inserted/updated/deletedij> insert into date(date) values (date('2001-01-01'));1 row inserted/updated/deletedij> select date from date;DATE      ----------2001-01-01ij> select date( '2001-02-02'), date "2001-02-02" from date;1         |2001-02-02---------------------2001-02-02|2001-01-01ij> select date date from date;DATE      ----------2001-01-01ij> select date as date from date;DATE      ----------2001-01-01ij> select date.date as date from date date;DATE      ----------2001-01-01ij> select date.date as date from date as date;DATE      ----------2001-01-01ij> delete from date where date = date('2001-01-01');1 row inserted/updated/deletedij> create index date on date(date);0 rows inserted/updated/deletedij> drop table date;0 rows inserted/updated/deletedij> remove date;IJ ERROR: Unable to establish prepared statement DATEij> -- TIMEcreate table time (time time);0 rows inserted/updated/deletedij> insert into time(time) values (time('01:01:01'));1 row inserted/updated/deletedij> select time from time;TIME    --------01:01:01ij> select time( '02:02:02'), time "02:02:02" from time;1       |02:02:02-----------------02:02:02|01:01:01ij> select time time from time;TIME    --------01:01:01ij> select time as time from time;TIME    --------01:01:01ij> select time.time as time from time time;TIME    --------01:01:01ij> select time.time as time from time as time;TIME    --------01:01:01ij> delete from time where time = time('01:01:01');1 row inserted/updated/deletedij> create index time on time(time);0 rows inserted/updated/deletedij> drop table time;0 rows inserted/updated/deletedij> remove time;IJ ERROR: Unable to establish prepared statement TIMEij> -- TIMESTAMPcreate table timestamp (timestamp timestamp);0 rows inserted/updated/deletedij> insert into timestamp(timestamp) values (timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx'));1 row inserted/updated/deletedij> select timestamp from timestamp;TIMESTAMP                 --------------------------xxxxxxFILTERED-TIMESTAMPxxxxxij> select timestamp( 'xxxxxxFILTERED-TIMESTAMPxxxxx'), timestamp "xxxxxxFILTERED-TIMESTAMPxxxxx" from timestamp;1                         |xxxxxxFILTERED-TIMESTAMPxxxxx-----------------------------------------------------xxxxxxFILTERED-TIMESTAMPxxxxx|xxxxxxFILTERED-TIMESTAMPxxxxxij> select timestamp timestamp from timestamp;TIMESTAMP                 --------------------------xxxxxxFILTERED-TIMESTAMPxxxxxij> select timestamp as timestamp from timestamp;TIMESTAMP                 --------------------------xxxxxxFILTERED-TIMESTAMPxxxxxij> select timestamp.timestamp as timestamp from timestamp timestamp;TIMESTAMP                 --------------------------xxxxxxFILTERED-TIMESTAMPxxxxxij> select timestamp.timestamp as timestamp from timestamp as timestamp;TIMESTAMP                 --------------------------xxxxxxFILTERED-TIMESTAMPxxxxxij> delete from timestamp where timestamp = timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');1 row inserted/updated/deletedij> create index timestamp on timestamp(timestamp);0 rows inserted/updated/deletedij> drop table timestamp;0 rows inserted/updated/deletedij> remove timestamp;IJ ERROR: Unable to establish prepared statement TIMESTAMPij> -- create table DOMAIN (domain int);0 rows inserted/updated/deletedij> insert into domain values (1);1 row inserted/updated/deletedij> select domain from domain where domain > 0;DOMAIN     -----------1          ij> select domain from domain domain where domain > 0;DOMAIN     -----------1          ij> select domain.domain from domain domain where domain.domain > 0;DOMAIN     -----------1          ij> prepare domain as 'select * from domain';ij> execute domain;DOMAIN     -----------1          ij> create index domain on domain(domain);0 rows inserted/updated/deletedij> drop table DOMAIN;0 rows inserted/updated/deletedij> remove domain;ij> create table CATALOG (catalog int);0 rows inserted/updated/deletedij> insert into catalog values (1);1 row inserted/updated/deletedij> select catalog from catalog where catalog > 0;CATALOG    -----------1          ij> select catalog from catalog catalog where catalog > 0;CATALOG    -----------1          ij> prepare catalog as 'select * from catalog';ij> execute catalog;CATALOG    -----------1          ij> create index catalog on catalog(catalog);0 rows inserted/updated/deletedij> drop table CATALOG;0 rows inserted/updated/deletedij> remove catalog;ij> create table TIME (time int);0 rows inserted/updated/deletedij> insert into time values (1);1 row inserted/updated/deletedij> select time from time where time > 0;TIME       -----------1          ij> select time from time time where time > 0;TIME       -----------1          ij> prepare time as 'select * from time';ij> execute time;TIME       -----------1          ij> create index time on time(time);0 rows inserted/updated/deletedij> drop table TIME;0 rows inserted/updated/deletedij> remove time;ij> create table ACTION (action int);0 rows inserted/updated/deletedij> insert into action values (1);1 row inserted/updated/deletedij> select action from action where action > 0;ACTION     -----------1          ij> select action from action action where action > 0;ACTION     -----------1          ij> prepare action as 'select * from action';ij> create index action on action(action);0 rows inserted/updated/deletedij> drop table ACTION;0 rows inserted/updated/deletedij> create table DAY (day int);0 rows inserted/updated/deletedij> insert into day values (1);1 row inserted/updated/deletedij> select day from day where day > 0;DAY        -----------1          ij> select day from day day where day > 0;DAY        -----------1          ij> prepare day as 'select * from day';ij> create index day on day(day);0 rows inserted/updated/deletedij> drop table DAY;0 rows inserted/updated/deletedij> create table MONTH (month int);0 rows inserted/updated/deletedij> insert into month values (1);1 row inserted/updated/deletedij> select month from month where month > 0;MONTH      -----------1          ij> select month from month month where month > 0;MONTH      -----------1          ij> select month.month from month month where month.month > 0;MONTH      -----------1          ij> prepare month as 'select * from month';ij> execute month;MONTH      -----------1          ij> create index month on month(month);0 rows inserted/updated/deletedij> drop table MONTH;0 rows inserted/updated/deletedij> remove month;ij> create table USAGE (usage int);0 rows inserted/updated/deletedij> insert into usage values (1);1 row inserted/updated/deletedij> select usage from usage where usage > 0;USAGE      -----------1          ij> select usage from usage usage where usage > 0;USAGE      -----------1          ij> select usage.usage from usage usage where usage.usage > 0;USAGE      -----------1          ij> prepare usage as 'select * from usage';ij> create index usage on usage(usage);0 rows inserted/updated/deletedij> drop table USAGE;0 rows inserted/updated/deletedij> remove usage;ij> create table LANGUAGE (language int);0 rows inserted/updated/deletedij> insert into language values (1);1 row inserted/updated/deletedij> select language from language where language > 0;LANGUAGE   -----------1          ij> select language from language language where language > 0;LANGUAGE   -----------1          ij> select language.language from language language where language.language > 0;LANGUAGE   -----------1          ij> prepare language as 'select * from language';ij> create index language on language(language);0 rows inserted/updated/deletedij> drop table LANGUAGE;0 rows inserted/updated/deletedij> remove language;ij> -- making LOCKS keyword nonreserved as fix for Derby-38create table LOCKS (c11 int);0 rows inserted/updated/deletedij> drop table LOCKS;0 rows inserted/updated/deletedij> create table t1 (LOCKS int);0 rows inserted/updated/deletedij> drop table t1;0 rows inserted/updated/deletedij> create table LOCKS (locks int);0 rows inserted/updated/deletedij> insert into locks values (1);1 row inserted/updated/deletedij> select locks from locks where locks > 0;LOCKS      -----------1          ij> select locks from locks locks where locks > 0;LOCKS      -----------1          ij> select locks.locks from locks locks where locks.locks > 0;LOCKS      -----------1          ij> prepare locks as 'select * from locks';ij> create index locks on locks(locks);0 rows inserted/updated/deletedij> drop table LOCKS;0 rows inserted/updated/deletedij> remove locks;ij> -- making COUNT keyword nonreserved as fix for Derby-create table count(i int);0 rows inserted/updated/deletedij> drop table count;0 rows inserted/updated/deletedij> create table t1 (count int);0 rows inserted/updated/deletedij> drop table t1;0 rows inserted/updated/deletedij> create table count(count int);0 rows inserted/updated/deletedij> insert into count values (1);1 row inserted/updated/deletedij> select * from count;COUNT      -----------1          ij> select count from count;COUNT      -----------1          ij> select count from count where count=1;COUNT      -----------1          ij> select count.count from count;COUNT      -----------1          ij> prepare count as 'select * from count';ij> create index count on count(count);0 rows inserted/updated/deletedij> drop table count;0 rows inserted/updated/deletedij> remove count;ij> create table t1(i int);0 rows inserted/updated/deletedij> insert into t1 values -1,2,-3,4,-5,6,-7,8,-9,0;10 rows inserted/updated/deletedij> create function count(i int) returns int no sqlexternal name 'java.lang.Math.abs' language java parameter style java;0 rows inserted/updated/deletedij> select count(*) from t1;1          -----------10         ij> select count(i) from t1;1          -----------10         ij> select * from t1 where count(i)=i;ERROR 42903: Invalid use of an aggregate function.ij> drop table t1;0 rows inserted/updated/deletedij>

nonreserved.out - 源码说明

本页面展示了「derby database source code.good for you.」中的 nonreserved.out 源码文件，采用 OUT 编程语言编写，共 459 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与database相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?