Bug 175790 No data retrived in attached report design file[07]
Description: No data retrived in attached report design file[07] Build number: 2.2.0.v20070228-0630 Steps to reproduce: 1, Open the attached report design 2, Double Click Dataset and Click OK button 3, Edit the Dataset and preview the results Expected result: All the row["OFFICECODE"] equal to 1 should be retrieved Actual result: No data retrieved when preview the results Another steps: 1, change the filter to row["OFFICECODE"] equal to 2. The data can be retrieved 2, Edit the filter, in value1 click <Select values...> and select 1. The value is quoted. The data can be retrieved 3, Input 1 and 2 in value1, 2 can retrieve data but 1 can not
data/org.eclipse.birt.data.tests/test/org/eclipse/birt/data/engine/impl/ScriptEvalTest.java
result = ScriptEvalUtil.evalConditionalExpr( 
				new Integer( 10 ),
				IConditionalExpression.OP_BETWEEN, 
				new Double( 9.9 ),
				new BigDecimal( 19.9 ) );
		assertResult( result, true );
		result = ScriptEvalUtil.evalConditionalExpr( 
				new Integer( 10 ),
				IConditionalExpression.OP_BETWEEN, 
				new Double( 10.9 ),
				new BigDecimal( 19.9 ) );
		assertResult( result, false );
		result = ScriptEvalUtil.evalConditionalExpr( 
				new Integer( 10 ),
				IConditionalExpression.OP_BETWEEN, 
				new Double( 20 ),
				new BigDecimal( 9.9 ) );
		assertResult( result, true );
		 
		
		GregorianCalendar calendar = new GregorianCalendar( 2001, 11 - 1, 1 );
		result = ScriptEvalUtil.evalConditionalExpr( calendar.getTime( ),
				IConditionalExpression.OP_BETWEEN,
				"Oct 20, 2001 12:00:00 AM",
				"Nov 20, 2001 12:00:00 AM" );
		assertResult( result, true );
		
		
		result = ScriptEvalUtil.evalConditionalExpr( 
				new Double( 10 ),