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;