[Info-ingres] Error on drop view

[Martin Bowes]

OK, sussed it....

sql bowtest
set session authorization ace\g
create table base(id integer4 not null not default, a_value integer4 not null not default) with nojournaling\g
insert into base values(1, 8009), (2, 8010), (3, 8009), (4, 8010), (5, 8009)\g
create view base_view_8009 as select * from base where a_value=8009\g
grant select on base_view_8009 to user ukb8009\g
commit\g

set session authorization ukb8009\g
create view base as select * from "ace".base_view_8009\g
commit\g
\q

sql bowtest
set session authorization ace\g
drop view if exists base_view_8009\g
Executing . . .

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
    (Wed Jun  6 12:18:19 2018)

continue
\q

I'll go and see if this also fails on 11

Marty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180606/20b7f794/attachment.html>