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
new Object[] {null, "something", Boolean.FALSE },
			new Object[] {null, "", Boolean.TRUE },
			new Object[] {"", null, Boolean.TRUE },
			new Object[] {"", "", Boolean.TRUE },
			
			new Object[] {"aaab", "a%b", Boolean.TRUE },
			new Object[] {"aaab", "a*b", Boolean.FALSE },
			new Object[] {"aaab", "a.*b", Boolean.FALSE },
			new Object[] {"aaab", "a\\%b", Boolean.FALSE },
			new Object[] {"aaab", "aa_b", Boolean.TRUE },
			new Object[] {"aaab", "aa\\_b", Boolean.FALSE },
			new Object[] {"aaab", "a_b", Boolean.FALSE },
			new Object[] {"aaab", "aa.b", Boolean.FALSE },
			new Object[] {"a%b", "a\\%b", Boolean.TRUE },
			new Object[] {"a%b", "a\\\\%b", Boolean.FALSE },
			new Object[] {"aaab", "aaab\\", Boolean.FALSE },
			new Object[] {"aaab", "aa[a]b", Boolean.FALSE },
			new Object[] {"aaab", "aa[[a]b", Boolean.FALSE },
		};
		for ( int i = 0; i < cases.length; i++ )
		{
			Object[] c = (Object[])cases[i];
			String str = (String) c[0];
			String pattern = (String) c[1];
			Boolean expected = (Boolean) c[2];
			Object result = ScriptEvalUtil.evalConditionalExpr( 
					str, IConditionalExpression.OP_LIKE, pattern, null );
			assertEquals( result, expected );
		}
	}