This is probably a string folding bug. Does the problem reproduce
against the latest open source download?


--
hanal04

On Jan 12, 2010, at 9:14 AM, Ian Kirkham wrote:


He didn't specify nullability though.

Karl

Not null, all. If I change the 'like' in the original query
select kpaiva,count(sotu),sum(oppisteet) from opsuor1 where
kpaiva like '2010%' and lts='KIE'
group by kpaiva

to '"', '>', 'between ... and' and so on, the query goes well.
With like, no if there are both 'sum' and 'count' in the query.

Could this be 9.3.0/138 bug number 121841: "Query fails with
E_AD5001_BAD_STRING_TYPE when a
non-unicode column is compared with a unicode string"? Thus,
the only thing I compare is the kpaiva itself, is it like 'something%'?

-Jukka-

Hi Jukka,
I am unable to reproduce the bug on any of my builds so I expect that
this has been fixed though I don't see a clear matching bug.
The problem might be a result of constant folding and if this is the
case, casting the pattern as c('2010%') might make a difference.
Regards,
Ian
-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Jukka Hartikainen
Sent: 13 January 2010 06:12
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Strange ADF error in sql-query

Not null, all. If I change the 'like' in the original query
select kpaiva,count(sotu),sum(oppisteet) from opsuor1 where
kpaiva like '2010%' and lts='KIE'
group by kpaiva

to '"', '>', 'between ... and' and so on, the query goes well.
With like, no if there are both 'sum' and 'count' in the query.

Could this be 9.3.0/138 bug number 121841: "Query fails with
E_AD5001_BAD_STRING_TYPE when a
non-unicode column is compared with a unicode string"? Thus,
the only thing I compare is the kpaiva itself, is it like 'something%'?

-Jukka-










_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres