| org.hsqldb.test.TestSubselect
| TestSubselect | | public class TestSubselect extends TestCase (Code) | | Test cases for HSQL subselects.
author:
David Moles Apr 30, 2002 |
| TestSubselect | | public TestSubselect(String s)(Code) | | Constructs a new SubselectTest.
|
| testAliasScope | | public void testAliasScope() throws SQLException(Code) | | Inner select reusing alias names from outer select, but using them for different tables
|
| testAndedSubselects | | public void testAndedSubselects() throws SQLException(Code) | | Tests two subselects, anded.
|
| testHiddenCollision | | public void testHiddenCollision() throws SQLException(Code) | | Inner select with two tables having columns with the same name, one of which is referred to in the
subselect, the other of which is not used in the query (both FRUITS and TREES have NAME column,
but we're only selecting FRUITS.NAME and we're not referring to TREES.NAME at all).
|
| testHiddenCollisionWithAliases | | public void testHiddenCollisionWithAliases() throws SQLException(Code) | | As above, with table aliases.
|
| testNestedSubselects | | public void testNestedSubselects() throws SQLException(Code) | | Test nested subselects.
|
| testNotIn | | public void testNotIn() throws SQLException(Code) | | Inner select with "not in" in outer select where clause.
|
| testNotInSameTableAndColumn | | public void testNotInSameTableAndColumn() throws SQLException(Code) | | Inner select with "not in" in outer select where clause and same table in inner select where clause.
|
| testSameTable | | public void testSameTable() throws SQLException(Code) | | Inner select involving same table
|
| testSameTableWithAliases | | public void testSameTableWithAliases() throws SQLException(Code) | | As above with aliases.
|
| testSameTableWithJoin | | public void testSameTableWithJoin() throws SQLException(Code) | | Inner select involving same table as one of two joined tables in outer select
|
| testSimpleJoin | | public void testSimpleJoin() throws SQLException(Code) | | This test is basically a sanity check of the data set.
|
| testWhereClausesColliding | | public void testWhereClausesColliding() throws SQLException(Code) | | Inner select with where clause in outer select having column with same name as where clause in inner select
|
| testWhereClausesCollidingWithAliases | | public void testWhereClausesCollidingWithAliases() throws SQLException(Code) | | As above, with table aliases.
|
| testWhereSelectColliding | | public void testWhereSelectColliding() throws SQLException(Code) | | Inner select with where clause in outer select having column with same name as select clause in inner select
|
| testWhereSelectCollidingWithAliases | | public void testWhereSelectCollidingWithAliases() throws SQLException(Code) | | As above, with aliases.
|
|
|