Common table expressions preserved as view.

classic Classic list List threaded Threaded
2 messages Options
kresimir.horvat kresimir.horvat
Reply | Threaded
Open this post in threaded view
|

Common table expressions preserved as view.

Hi, I noticed that some common table expressions defined in queries are left
preserved as views. The first time I noticed this is when I managed to run
query when CTE name was changed. Seems that in some cases they are kept and
can be referenced from different sessions (I can see them when I run select
from INFORMATION_SCHEMA.VIEWS).
This rises a bit of concern if other users can get data from another user if
queries are run in parallel, ie. they will both read from view.

In few latest test seems that CTEs preserved as view are all created when
query is run over rest.
Can someone, please, give me some explanation how its handled in Ignite?

Thanks in advance!
Kresimir



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
aealexsandrov aealexsandrov
Reply | Threaded
Open this post in threaded view
|

Re: Common table expressions preserved as view.

Hi,

At the moment SQL views and temporary tables (CTE) don't fully supported
in Ignite. The CTE syntax will just set the sub-query inside your SQL
request.

BR,
Andrei

9/5/2019 4:36 PM, kresimir.horvat пишет:

> Hi, I noticed that some common table expressions defined in queries are left
> preserved as views. The first time I noticed this is when I managed to run
> query when CTE name was changed. Seems that in some cases they are kept and
> can be referenced from different sessions (I can see them when I run select
> from INFORMATION_SCHEMA.VIEWS).
> This rises a bit of concern if other users can get data from another user if
> queries are run in parallel, ie. they will both read from view.
>
> In few latest test seems that CTEs preserved as view are all created when
> query is run over rest.
> Can someone, please, give me some explanation how its handled in Ignite?
>
> Thanks in advance!
> Kresimir
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/