select * from super except sub1;
이라는 쿼리가 오류나네요.
큐브리드매니저 버전은 현재 홈페이지에 있는 버전입니다.
테이블 테스트 쿼리입니다.
create table supertable
(
superkey char(1),
superkey2 char(3),
superkey3 int
);
create table subtable1 under supertable;
create table subtable2 under supertable;
create table subtable3 under supertable;
create table subtable4 under supertable;
create table subtable5 under supertable;
insert into subtable1 values (\'1\',\'123\',1234);
insert into subtable1 values (\'1\',\'123\',1234);
insert into subtable1 values (\'1\',\'123\',1234);
insert into subtable1 values (\'1\',\'123\',1234);
insert into subtable1 values (\'1\',\'123\',1234);
insert into subtable2 values (\'2\',\'123\',1234);
insert into subtable2 values (\'2\',\'123\',1234);
insert into subtable2 values (\'2\',\'123\',1234);
insert into subtable2 values (\'2\',\'123\',1234);
insert into subtable2 values (\'2\',\'123\',1234);
insert into subtable3 values (\'3\',\'123\',1234);
insert into subtable3 values (\'3\',\'123\',1234);
insert into subtable3 values (\'3\',\'123\',1234);
insert into subtable3 values (\'3\',\'123\',1234);
insert into subtable3 values (\'3\',\'123\',1234);
insert into subtable4 values (\'4\',\'123\',1234);
insert into subtable4 values (\'4\',\'123\',1234);
insert into subtable4 values (\'4\',\'123\',1234);
insert into subtable4 values (\'4\',\'123\',1234);
insert into subtable4 values (\'4\',\'123\',1234);
insert into subtable5 values (\'5\',\'123\',1234);
insert into subtable5 values (\'5\',\'123\',1234);
insert into subtable5 values (\'5\',\'123\',1234);
insert into subtable5 values (\'5\',\'123\',1234);
insert into subtable5 values (\'5\',\'123\',1234);
select * from all supertable except subtable3;
//drop table subtable1;
//drop table subtable2;
//drop table subtable3;
//drop table subtable4;
//drop table subtable5;
//drop table supertable;
|