Wrong SQL generation

[c-bik]

trafficstars

The equivalent correct SQL is:

select
    cvalue:SHORTID shortid,
    nth(3,ckey ) contype,
    ckey,
    cvalue
  from
    sbsgui.tpac
  where
      not cvalue:SHORTID in ('''$not_a_value''','')
      and (
          ckey like '["tpac"%"lacon"%'  or
          ckey like '["tpac"%"ipcon"%'  or
          ckey like '["tpac"%"mlcon"%')
    and
    rownum < 1000000

[c-bik]

One more

[walter-weinmann]

I just did a test with sqlparse and it looks okay.

[stoch]

@walter-weinmann Generating SQL from filter settings is quite tricky, especially support for Oracle and imem which have a different type system.

SQL must always be checked by the user after filtering (before storing the DDerl view or running the query by SQL).