---

drop table if exists x1;
drop table if exists  x2;
drop view if exists  v1;
drop view if exists  v2;
drop view if exists  v12;

create table x1(user_sk int);
create table x2(user_sk int);
create table x3(user_sk int);

create view v1 as select distinct user_sk from (select user_sk from x1 union all select user_sk from x2) x;
create view v2 as select distinct user_sk from (select user_sk from x2 union all select user_sk from x3) x;

create view v12 as select distinct user_sk from (select user_sk from v1 union all select user_sk from v2) x;
\g

select * from v12;
\g

---

---

E_SC0206 An internal error prevents further processing of this query.
    Associated error messages which provide more detailed information about
    the problem can be found in the error log, II_LOG:errlog.log
    (Thu May 17 04:41:29 2012)

E_SC0206 An internal error prevents further processing of this query.
    Associated error messages which provide more detailed information about
    the problem can be found in the error log, II_LOG:errlog.log
    (Thu May 17 04:41:29 2012)

Exiting session because of communications failure.

---

---

HD-SM            ::[18731            , 9968      ,  0000000003e14200, psyview.c:3840        ]: Thu May 17 04:41:29 2012 E_PS0C04_BAD_TREE    Bad query tree.
HD-SM            ::[18731            , 9968      ,  0000000003e14200, scsqncr.c:4304        ]: Thu May 17 04:41:29 2012 E_PS0002_INTERNAL_ERROR      Internal error in PSF
HD-SM            ::[18731            , 9968      ,  0000000003e14200, scsqncr.c:4305        ]: Thu May 17 04:41:29 2012 E_SC0215_PSF_ERROR    Error returned by PSF.
HD-SM            ::[18731            , 9968      ,  0000000003e14200, scdnote.c:161        ]: Thu May 17 04:41:29 2012 E_SC0220_SESSION_ERROR_MAX    Too many errors for this session.

---

---

$ echo 'select 1, 2; \g' | sql -S testdb
col1  |col2 
    1|    2

---

---

$ cat test_select
echo 'select 1, 2; \g' | sql -S testdb
$ ./test_select
col1  col2 
    1      2

---