Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 127234 - Support boolean data type for parameter and column
Summary: Support boolean data type for parameter and column
Status: CLOSED FIXED
Alias: None
Product: Data Tools
Classification: Tools
Component: Open Data Access (show other bugs)
Version: 0.9.1   Edit
Hardware: PC Windows 2000
: P3 enhancement (vote)
Target Milestone: 1.5M6   Edit
Assignee: Linda Chan CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 152443
  Show dependency tree
 
Reported: 2006-02-10 03:45 EST by jluo CLA
Modified: 2008-07-01 17:34 EDT (History)
0 users

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description jluo CLA 2006-02-10 03:45:02 EST
Hi, i am trying to execute a simple query with a boolean as a parameter.

select * from client where check = ?

Where check is of type bool in postgresql. I have created a parameters 
for my query but boolean is not in the dropdown list. If y try auto or 
any, I have the following error 'Error: operator does not exist: boolean 
= character varying)

I have also tried to execute the query with Integer instead of boolean 
but postgres does not accept the sql.

<from BIRT newsgroup>
Comment 1 Gary Xue CLA 2006-02-13 17:39:17 EST
Boolean data type is not supported in BIRT 2.0. This is a known limitation. Need to enhance ODA to support Boolean data type. Talked to Wenfeng - agreed that this can be addressed post BIRT 2.1.
Comment 2 Linda Chan CLA 2007-03-16 21:20:00 EDT
Added new interface methods and support in ODA framework.
For details of API changes, see http://wiki.eclipse.org/index.php/Connectivity_Europa_Features#Open_Data_Access 
Comment 3 Brian Fitzpatrick CLA 2008-07-01 17:34:39 EDT
Closing bugs