[Info-ingres] Error on drop view

[Karl and Betty Schendel]

This sounds familiar.  I think it's fixed in ingres11.  Maybe open a support issue to see
if the fix can be back-ported to ingres 10.

Karl

> On Jun 6, 2018, at 7:22 AM, Martin Bowes <martin.bowes at ndph.ox.ac.uk> wrote:
> 
> 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
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> http://lists.planetingres.org/mailman/listinfo/info-ingres