Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 315579 - Better support for IN clause in SQL
Summary: Better support for IN clause in SQL
Status: CLOSED DUPLICATE of bug 212063
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: Future   Edit
Assignee: xiaofeng zhang CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-03 09:12 EDT by john mcteague CLA
Modified: 2010-08-04 05:11 EDT (History)
3 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description john mcteague CLA 2010-06-03 09:12:44 EDT 
Build Identifier: Birt 2.5.2

It should be trivial to provide better support for IN clause in queries that are bound to multi select parameters.

It should be possible to connect the fact a multiselect parameter is bound to a parameter in a dataset, and when that is identified, rewrite the query to replace a single ? with a serious of ?'s, one per entry selected in the list and then bind the values from the list.

Reproducible: Always
Comment 1 Xiaoying Gu CLA 2010-08-04 05:11:38 EDT 

*** This bug has been marked as a duplicate of bug 212063 ***