You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select
case when 'ab' SIMILAR TO 'ab|cd|efg' then 'ok' else 'bad' end as ab,
case when 'efg' SIMILAR TO 'ab|cd|efg' then 'ok' else 'bad' end as efg,
case when 'a' SIMILAR TO 'ab|cd|efg' then 'bad' else 'ok' end as a
from rdb$database
Submitted by: @hvlad
Is related to QA424
The query, based on sample from doc
select
case when 'ab' SIMILAR TO 'ab|cd|efg' then 'ok' else 'bad' end as ab,
case when 'efg' SIMILAR TO 'ab|cd|efg' then 'ok' else 'bad' end as efg,
case when 'a' SIMILAR TO 'ab|cd|efg' then 'bad' else 'ok' end as a
from rdb$database
returns 'bad' at second column
Commits: 3c6b6dc 772a5a9
The text was updated successfully, but these errors were encountered: