[Info-Ingres] Strange ADF error in sql-query

Hi.

First. Our old production version is the good old one
Ingres SPARC SOLARIS Version II 2.5/0011 (su4.us5/00).

One simple sql-query in that system:
__ Tue Jan 12 07:27:10 2010
___________________________________________________
1> select kpaiva,count(sotu),sum(oppisteet) from opsuor1 where
kpaiva like '2010%' and lts='KIE'
group by kpaiva



+--------------+-------------+-----------+
|kpaiva |col2 |col3 |
+--------------+-------------+-----------+
|20100102 10:12| 9| 18.000|
|20100104 08:43| 1| 4.000|
|20100107 09:54| 16| 32.000|
....

kpaiva is c14, sotu c10, oppisteet float4. Yes, simple.


But... The same query in
Ingres Linux Version II 9.3.0 (int.lnx/138)NPTL gets:

1> select kpaiva,count(sotu),sum(oppisteet) from opsuor1 where
kpaiva like '2010%' and lts='KIE'
group by kpaiva


********************************************************************
Tue Jan 12 07:19:55 2010 E_OP078C_ADC_COMPARE consistency check
- ADF compare routine failed

********************************************************************
E_AD5001 Datatype is not a string datatype.
(Tue Jan 12 07:19:55 2010)


End of Request - Terminated by Errors

If I try that either without count or sum it works:

1> select kpaiva,sum(oppisteet) from opsuor1 where
kpaiva like '2010%' and lts='KIE'
group by kpaiva



+--------------+-----------+
|kpaiva |col2 |
+--------------+-----------+
|20100102 10:12| 18.000|
|20100104 08:43| 4.000|
|20100107 09:54| 32.000|
....

1> select kpaiva,count(sotu) from opsuor1 where
kpaiva like '2010%' and lts='KIE'
group by kpaiva



+--------------+-------------+
|kpaiva |col2 |
+--------------+-------------+
|20100102 10:12| 9|
|20100104 08:43| 1|
|20100107 09:54| 16|
....



Whats going on?

-Jukka-

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


--
hanal04
------------------------------------------------------------------------
hanal04's Profile: http://community.ingres.com/forum/member.php?userid=443
View this thread: http://community.ingres.com/forum/showthread.php?t=11549