[Info-ingres] Error on drop view

[Martin Bowes]

I've just raised a patch request.

Marty

-----Original Message-----
From: Karl and Betty Schendel [mailto:schendel at kbcomputer.com] 
Sent: 06 June 2018 12:38
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Error on drop view

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

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres