Sybase db query question

[sky]

I'm using Adaptive Server Anywhere Version 9.0 and running into a problem which only happens in this version.

I have a query with union. Each block of the query works fine with out the union until I join them using the union. The value on entered_value column is set to zero with union. Without union the column value is non zero. This same query works fine in v7 database. Any help that you can be provide would be appreciated.

Thanks


select

entered_value from

v_test where

parent_id is not null

union

select

entered_value from

v_test where

parent_id is null

[sky]

Installing the latest patch and upgrading db server to 9.0.1 fixed the problem.