June 11th, 2014, 07:37 AM
When I run the following queries (line by line):
I have an out-of-range error (1e39 is bigger than the max limit for Sybase IQ, so normal).
create table #dummy (id int, val float)
insert into #dummy select 1, power(10, 39)
select * from #dummy
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