asa9.1250 not contain error correction (old bugs):
1. - odbc return blob with extra bad data (good odbc lib is 9.1216)
2. - OLEDB appends extra blanks when using RecordSet.Update
3. - asa crash when executing query that contain constant in select list
with name
like field in table and with group by this field


real example 3:

select
count1 as p1
, count2 as p2
, '---' as wdep2
, (select wdep_h from wdep where ic = j.wdep ) as wdep
, sum(summa) as summa
, j.who as w
from jd j
where
data>='2003-10-1'
and data <'2003-11-1'
and j.count1 like '70%'
group by j.count1, j.count2 , wdep2, j.wdep , j.who
having summa<>0

result: asa crash wo messages (1216 not)

if GROUP BY make like this :
group by j.count1, j.count2 , j.wdep , j.who
----------------------------^ wdep2 remove
asa not crash
(table jd contain fields wdep and wdep2)

sorry, forget one bug:

dbexpand don`t work:
assertion failed: 201129
file is shorter than expected

(any build of asa9) asa8 - work fine

Can you provide the schema needed to reproduce the problem with example 3?


"Cache" <cache (AT) chat (DOT) ru> wrote