Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
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
*******/