User: rt      
Date: 2008-06-16 12:30:08+0000
Modified:
   dba/dbaccess/qa/complex/dbaccess/SingleSelectQueryComposer.java

Log:
 INTEGRATION: CWS rptchart02 (1.7.6); FILE MERGED
 2008/05/27 08:57:42 oj 1.7.6.1: i84290 a little advanced error message

File Changes:

Directory: /dba/dbaccess/qa/complex/dbaccess/
=============================================

File [changed]: SingleSelectQueryComposer.java
Url: 
http://dba.openoffice.org/source/browse/dba/dbaccess/qa/complex/dbaccess/SingleSelectQueryComposer.java?r1=1.7&r2=1.8
Delta lines:  +6 -5
-------------------
--- SingleSelectQueryComposer.java      2008-04-10 12:17:31+0000        1.7
+++ SingleSelectQueryComposer.java      2008-06-16 12:30:05+0000        1.8
@@ -196,15 +196,16 @@
     public void testSubQueries() throws Exception
     {
         m_composer.setQuery( "SELECT * from \"" + innerProductsQuery + "\"" );
-        XTablesSupplier suppTables = 
(XTablesSupplier)UnoRuntime.queryInterface(
+        final XTablesSupplier suppTables = 
(XTablesSupplier)UnoRuntime.queryInterface(
             XTablesSupplier.class, m_composer );
-        XNameAccess tables = suppTables.getTables();
+        final XNameAccess tables = suppTables.getTables();
         assure( "a simple SELECT * FROM <query> could not be parsed",
             tables != null && tables.hasByName( innerProductsQuery ) );
 
-        String sInnerCommand = 
m_database.getDatabase().getDataSource().getQueryDefinition( innerProductsQuery 
).getCommand();
-        String sExecutableQuery = m_composer.getQueryWithSubstitution();
-        assure( "simple query containing a sub query improperly parsed to SDBC 
level statement",
+        final String sInnerCommand = 
m_database.getDatabase().getDataSource().getQueryDefinition( innerProductsQuery 
).getCommand();
+        final String sExecutableQuery = m_composer.getQueryWithSubstitution();
+        assure( "simple query containing a sub query improperly parsed to SDBC 
level statement: \n1. " + sExecutableQuery
+        + "\n2. " + "SELECT * FROM ( " + sInnerCommand  + " ) AS \"" + 
innerProductsQuery + "\"",
             sExecutableQuery.equals( "SELECT * FROM ( " + sInnerCommand  + " ) 
AS \"" + innerProductsQuery + "\"") );
     }
 




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to