Hi all,

When I run the following queries (line by line):

create table #dummy (id int, val float)
insert into #dummy select 1, power(10, 39)
select * from #dummy
I have an out-of-range error (1e39 is bigger than the max limit for Sybase IQ, so normal).

Now, if I run the whole script, I don't get any error, the select returns zero line (but the correct columns), and a rollback is applied (since the table doesn't exist afterwards). I don't understand why. Is it a server-side or client-side issue?

I am using Aqua Data Studio, and autocommit is supposed to be on (according to the preferences), but I don't know how to check.

Thank you very much for your feedbacks