Bug 142800 TVT3.2:TCT576: AR: BIRT: New Data Set Wizard
OS: Windows XP. Must Fix: YES. Blocking: No. Build Date: 0518 Component: BIRT - New Data Set Wizard. Language: AR Tester Name: Omar Bahy Scenario: 1- Right click on data set and choose "New Data Set". Click Finish 2- Inspect the SQL statement box. Problem: SQL statement box should be unmirrored to maintain readability. This article was reassigned from Category:''TVT/Testing''.
data/org.eclipse.birt.report.data.oda.jdbc.ui/src/org/eclipse/birt/report/data/oda/jdbc/ui/editors/SQLDataSetEditorPage.java
allSchemas.add( schemaRs.getString("TABLE_SCHEM") );
			}
			
			ResultSet rs = null;
			Iterator it = allSchemas.iterator();
			
			while( it.hasNext())
			{
				String schema = it.next().toString();
				rs = metaDataProvider.getAlltables( metaDataProvider.getCatalog( ),
						schema,
						"%",
						new String[]{
								"TABLE", "VIEW"
						} );				
				boolean hasNonSystemTable = false;				
				if ( rs != null )
				{
					while ( rs.next( ) )
					{
						if ( !"SYSTEM TABLE".equalsIgnoreCase( rs.getString( "TABLE_TYPE" ) ) )
						{
							hasNonSystemTable = true;
							break;
						}
					}
				}				
				if ( hasNonSystemTable )
				{
					schemas.add( schema );