Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 355908

Summary: bug in the 3.7 runtime with the sample derby database
Product: z_Archived Reporter: cbr125x <cbr125x>
Component: BIRTAssignee: Birt-Data-inbox <Birt-Data-inbox>
Status: NEW --- QA Contact: weiming tang <weiming.tang>
Severity: normal    
Priority: P3 CC: bluesoldier, weiming.tang
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description cbr125x CLA 2011-08-25 22:40:37 EDT 
Build Identifier: Eclipse Helios 2.6.1, BIRT Runtime 3.7

if i add sql query like : 
select *
from
CLASSICMODELS.ORDERS,
CLASSICMODELS.CUSTOMERS,
CLASSICMODELS.ORDERDETAILS,
CLASSICMODELS.PRODUCTS
where
CLASSICMODELS.ORDERS.ORDERNUMBER=CLASSICMODELS.ORDERDETAILS.ORDERNUMBER
and
CLASSICMODELS.ORDERDETAILS.PRODUCTCODE=CLASSICMODELS.PRODUCTS.PRODUCTCODE
and
CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER=CLASSICMODELS.ORDERS.CUSTOMERNUMBER
and
CLASSICMODELS.ORDERS.STATUS = 'Shipped'

And just add a table using the dataset it will fail in the 3.7 runtime

Reproducible: Always