temprestrictions.out

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

ij> -- Tests for temporary restrictions in the language
-- create a table
create table t1(c1 int);
0 rows inserted/updated/deleted
ij> -- No aggregates in the where clause
-- (Someday will will allow correlated aggregates ...)
select c1 from t1 where max(c1) = 1;
ERROR 42903: Invalid use of an aggregate function.
ij> -- drop the table
drop table t1;
0 rows inserted/updated/deleted
ij>