[teiid-issues] [JBoss JIRA] (TEIID-3555) Like expression in select statement fails against Sybase
Bram Gadeyne (JIRA)
issues at jboss.org
Wed Jun 24 08:58:02 EDT 2015
Bram Gadeyne created TEIID-3555:
-----------------------------------
Summary: Like expression in select statement fails against Sybase
Key: TEIID-3555
URL: https://issues.jboss.org/browse/TEIID-3555
Project: Teiid
Issue Type: Feature Request
Affects Versions: 8.9.1
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
Priority: Minor
Sometimes I use a like statement within the select statement to evaluate whether or not some text contains a certain sub-string. e.g:
select outcome like '%died%' as died
from patients
Some databases support this and return a boolean value but others (like sybase) don't. This results in an exception "Incorrect syntax near keyword 'like'"
Would is be possible to rewrite this for Sybase (and maybe others) to something like:
select case when icuoutcomename like '%overleden%' then cast(1 as bit) else cast(0 as bit) end as mort
from patients
I used cast(1 as bit) and cast(0 as bit) here because it seems like Sybase does not support true and false.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
More information about the teiid-issues
mailing list