|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.ObjectTestCase
org.hsqldb.test.TestSubselect
Test cases for HSQL subselects.
Field Summary | |
static java.lang.String |
datasetPath
|
Constructor Summary | |
TestSubselect(java.lang.String s)
Constructs a new SubselectTest. |
Method Summary | |
static void |
main(java.lang.String[] args)
|
void |
testAliasScope()
Inner select reusing alias names from outer select, but using them for different tables |
void |
testAndedSubselects()
Tests two subselects, anded. |
void |
testHiddenCollision()
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). |
void |
testHiddenCollisionWithAliases()
As above, with table aliases. |
void |
testNestedSubselects()
Test nested subselects. |
void |
testNotIn()
Inner select with "not in" in outer select where clause. |
void |
testNotInSameTableAndColumn()
Inner select with "not in" in outer select where clause and same table in inner select where clause. |
void |
testSameTable()
Inner select involving same table |
void |
testSameTableWithAliases()
As above with aliases. |
void |
testSameTableWithJoin()
Inner select involving same table as one of two joined tables in outer select |
void |
testSimpleJoin()
This test is basically a sanity check of the data set. |
void |
testWhereClausesColliding()
Inner select with where clause in outer select having column with same name as where clause in inner select |
void |
testWhereClausesCollidingWithAliases()
As above, with table aliases. |
void |
testWhereSelectColliding()
Inner select with where clause in outer select having column with same name as select clause in inner select |
void |
testWhereSelectCollidingWithAliases()
As above, with aliases. |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static final java.lang.String datasetPath
Constructor Detail |
public TestSubselect(java.lang.String s)
Method Detail |
public void testSimpleJoin() throws java.sql.SQLException
java.sql.SQLException
public void testWhereClausesColliding() throws java.sql.SQLException
java.sql.SQLException
public void testWhereClausesCollidingWithAliases() throws java.sql.SQLException
java.sql.SQLException
public void testHiddenCollision() throws java.sql.SQLException
java.sql.SQLException
public void testHiddenCollisionWithAliases() throws java.sql.SQLException
java.sql.SQLException
public void testWhereSelectColliding() throws java.sql.SQLException
java.sql.SQLException
public void testWhereSelectCollidingWithAliases() throws java.sql.SQLException
java.sql.SQLException
public void testSameTable() throws java.sql.SQLException
java.sql.SQLException
public void testSameTableWithAliases() throws java.sql.SQLException
java.sql.SQLException
public void testSameTableWithJoin() throws java.sql.SQLException
java.sql.SQLException
public void testAndedSubselects() throws java.sql.SQLException
java.sql.SQLException
public void testNestedSubselects() throws java.sql.SQLException
java.sql.SQLException
public void testNotIn() throws java.sql.SQLException
java.sql.SQLException
public void testNotInSameTableAndColumn() throws java.sql.SQLException
java.sql.SQLException
public void testAliasScope() throws java.sql.SQLException
java.sql.SQLException
public static void main(java.lang.String[] args) throws java.io.IOException
java.io.IOException
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |