This just started with ADS 12. I'm running in windows 7, connected to a Sybase SQL Anywhere database. When selecting from tables with a bit field, the results always shows "false" (grid and text windows) even if the actual value is a 1. Aqua Data Studio 11 correctly shows a 1 or 0 from the same sql script. I tried this with Sybase SQL Anywhere 10 and 12, and got the same results.
Harry
-- UPDATE --
It only messes up when the bit column it a nullable column. Here's my test:
drop table tempTest
go
create table tempTest
(
bNotNullable bit not null,
bNullable bit null,
)
go
insert into tempTest values (1,1)
go
select * from tempTest
go
/****** This returns:
bNotNullable bNullable
--------------- ------------
true false
*******/
This is caused because of a behavioral change in jConnect7. If you drop to jConnect6 this problem goes away. jConnect6 indicates that a bit column is of type Integer and returns an Integer object.
jConnect7 indicates that a bit column is of type Boolean and returns an Integer object.
I've made a fix so that ADS handles both of these scenarios. SVN #29919
This is caused because of a behavioral change in jConnect7. If you drop to jConnect6 this problem goes away. jConnect6 indicates that a bit column is of type Integer and returns an Integer object.
jConnect7 indicates that a bit column is of type Boolean and returns an Integer object.
I've made a fix so that ADS handles both of these scenarios. SVN #29919
Issue #7862 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 12.0.3 |
No time estimate |
-- UPDATE --
It only messes up when the bit column it a nullable column. Here's my test:
drop table tempTest
go
create table tempTest
(
bNotNullable bit not null,
bNullable bit null,
)
go
insert into tempTest values (1,1)
go
select * from tempTest
go
/****** This returns:
bNotNullable bNullable
--------------- ------------
true false
*******/