Ah, ignore that. It should work, there is probably a bug in propagating
column type information somewhere.
On Sun, 05 Mar 2017 at 12:11, Noel Grandin wrote:
> Case insensitivity in IN statements is a property of the LHS of the
> expression, not the right. You'd need to find away to apply it the c
Case insensitivity in IN statements is a property of the LHS of the
expression, not the right. You'd need to find away to apply it the column
on your MyTable. Either that or submit a patch that implements a case
insensitive version if IN. We have similar special cases for other
operators.
On Sun,
Yes JobStatus column is also case insensitive and works fine when doing
just an equal sign
jobstatus = 'any case value'
On Thursday, February 23, 2017 at 6:42:10 AM UTC-6, Thomas Mueller Graf
wrote:
>
> Hi,
>
> > DATABASE_TO_UPPER=FALSE
>
> This is for identifiers, not for values.
>
> You will
Hi,
> DATABASE_TO_UPPER=FALSE
This is for identifiers, not for values.
You will have to check that the jobstatus column is case insensitive.
Regards,
Thomas
On Tue, Feb 21, 2017 at 8:34 PM, Chris Sunderland
wrote:
> I'm having an issue when using the TABLE function that comparison is case
>
I'm having an issue when using the TABLE function that comparison is case
sensitive.
http://www.h2database.com/html/functions.html#table
Here is the query I'm using:
SET @jobstatus = ?;
SELECT * FROM mytable WHERE jobstatus IN (SELECT jobstatus FROM
table(jobstatus VARCHAR_IGNORECASE = @jobstat
