User: vg Date: 2007/01/15 06:29:38 Modified: dba/dbaccess/qa/complex/dbaccess/QueryInQuery.java
Log: INTEGRATION: CWS dba22b (1.2.98); FILE MERGED 2006/12/13 11:02:51 fs 1.2.98.1: #i69460# test case for SDB-level statements supporting QiQ File Changes: Directory: /dba/dbaccess/qa/complex/dbaccess/ ============================================= File [changed]: QueryInQuery.java Url: http://dba.openoffice.org/source/browse/dba/dbaccess/qa/complex/dbaccess/QueryInQuery.java?r1=1.2&r2=1.3 Delta lines: +22 -4 -------------------- --- QueryInQuery.java 10 Jul 2006 14:59:08 -0000 1.2 +++ QueryInQuery.java 15 Jan 2007 14:29:35 -0000 1.3 @@ -45,6 +45,8 @@ import connectivity.tools.HsqlColumnDescriptor; import connectivity.tools.HsqlTableDescriptor; import connectivity.tools.RowSet; +import com.sun.star.sdbc.XStatement; +import com.sun.star.sdbc.XResultSet; public class QueryInQuery extends complexlib.ComplexTestCase { @@ -58,7 +60,8 @@ "executeSimpleSelect", "executeAliasedSelect", "checkNameCollisions", - "checkCyclicReferences" + "checkCyclicReferences", + "checkStatementQiQSupport" }; } @@ -192,6 +195,7 @@ caughtExpected ); } + // -------------------------------------------------------------------------------------------------------- public void checkCyclicReferences() throws ElementExistException, WrappedTargetException, IllegalArgumentException { // some queries which create a cycle in the sub query tree @@ -207,5 +211,19 @@ catch ( SQLException e ) { caughtExpected = e.SQLState.equals( "OB001" ); } assure( "executing a query with cyclic nested sub queries should fail!", caughtExpected ); + } + + // -------------------------------------------------------------------------------------------------------- + public void checkStatementQiQSupport() + { + try + { + XStatement statement = m_database.getConnection().createStatement(); + XResultSet resultSet = statement.executeQuery( "SELECT * FROM \"query products\"" ); + } + catch( SQLException e ) + { + assure( "SDB level statements do not allow for queries in queries", false ); + } } } --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
