SQL with CTE (Common Table expression) not supported.

[ChrisBellobuono]

It appears Saviynt does not support SQL containing CTEs (Common Table expression), specifically something as simple as this:

with
  tmp as (
    select USERKEY
    from USERS
    where FIRSTNAME = 'John' and LASTNAME = 'Smith'
  )
select * from tmp

It may related to the parentheses because when I close the error box Current Query line only contains what is in them.  

For example, if I try to execute this:

select version()

It fails as well.

We are currently on 24.1.  Can someone verify whether or not Saviynt does support CTEs, and if it does, tell me what I am doing wrong?

 

[rushikeshvartak · Accepted solution]

Its not supported in v24.1 as well

[ChrisBellobuono]

Which I find really odd since it supports more advanced syntax like:

select
  ...
  count(*) over (partition by FIRSTNAME, LASTNAME) as num_name,
  ...

I also noticed that it will fail if there is any whitespace in front of the select.

I will open a ticket to get both items fixed.