Java Doc for TestDQLMisc.java in  » Database-DBMS » axion » org » axiondb » functional » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » axion » org.axiondb.functional   Source Cross Reference   Class Diagram   Java Document (Java Doc)   org.axiondb.functional.AbstractFunctionalTest    org.axiondb.functional.TestDQLMisc TestDQLMisc public class TestDQLMisc extends AbstractFunctionalTest (Code) Database Query Language tests. version:    $Revision: 1.15 $ $Date: 2005/07/06 18:47:40 $ author:    Amrish Lal author:    Chris Johnston author:    Ritesh Adval author:    Jonathan Giron author:    Ahimanikya Satapathy Constructor Summary public   TestDQLMisc(String testName)      Method Summary public  void setUp()      public static  Test suite()      public  void tearDown()      public  void testAliasAsColumnName()      public  void testAnsiInnerJoinWithIndexBug1()      public  void testAnsiInnerJoinWithIndexBug2()      public  void testColumnBindingInCorrelatedQuery()      public  void testFourTableJoinWithRightAsNestedTableView()      public  void testIsNullUsingIntBtreeIndex()      public  void testIsNullUsingStringBtreeIndex()      public  void testLeftOuterJoinHavingRightTableColumnIndexed()      public  void testLikeWithFilePath()      public  void testLikeWithFilePathAndEscapeChar()      public  void testMultiStatementInsertWithWhenClauseEvaluatingToNull()      public  void testQueryOptimizerProcessWhereTree()      public  void testQueryOptimizerProcessWhereTreeWithBTreeIndex()      public  void testResolveColumnWithTableAlias()      public  void testRightOuterJoinIndexonLeft()      public  void testRightOuterJoinIndexonLeft2()      public  void testThreeTableJoinHavingTwoTableColumnIndexed()      public  void testThreeTableJoinWithComparisonConditionAppliedAtJoinAndAfterJoin()      public  void testThreeTableJoinWithExplainCommand()      public  void testThreeTableJoinWithRightTableViewHavingTwoTableColumnIndexed()      public  void testTwoTableAnsiJoinWithCompositeCondition()      public  void testTwoTableAnsiJoinWithCompositeOnAndWhereConditions()      public  void testTwoTableInnerJoinWithComparisionCondition()      public  void testTwoTableInnerJoinWithCompositeOnConditions()      public  void testTwoTableJoinWithComparisionWhereCondition()      public  void testTwoTableLeftOuterJoinWithCompositeOnAndWhereConditions()      public  void testTwoTableRightOuterJoinWithCompositeOnAndWhereConditions()      public  void testTwoTableRightOuterJoinWithNonEqualJoin()      public  void test_select_str_from_x_inner_y_inner_z()      public  void test_select_str_from_x_inner_y_loj_z()      public  void test_select_str_from_x_inner_y_roj_z()      public  void test_select_str_from_x_loj_y_inner_z()      public  void test_select_str_from_x_loj_y_loj_z()      public  void test_select_str_from_x_loj_y_roj_z()      public  void test_select_str_from_x_roj_y_inner_z()      public  void test_select_str_from_x_roj_y_loj_z()      public  void test_select_str_from_x_roj_y_roj_z()      Constructor Detail TestDQLMisc public TestDQLMisc(String testName)(Code) Method Detail setUp public void setUp() throws Exception(Code) suite public static Test suite()(Code) tearDown public void tearDown() throws Exception(Code) testAliasAsColumnName public void testAliasAsColumnName() throws SQLException(Code) testAnsiInnerJoinWithIndexBug1 public void testAnsiInnerJoinWithIndexBug1() throws Exception(Code) testAnsiInnerJoinWithIndexBug2 public void testAnsiInnerJoinWithIndexBug2() throws Exception(Code) testColumnBindingInCorrelatedQuery public void testColumnBindingInCorrelatedQuery() throws Exception(Code) testFourTableJoinWithRightAsNestedTableView public void testFourTableJoinWithRightAsNestedTableView() throws Exception(Code) testIsNullUsingIntBtreeIndex public void testIsNullUsingIntBtreeIndex() throws Exception(Code) testIsNullUsingStringBtreeIndex public void testIsNullUsingStringBtreeIndex() throws Exception(Code) testLeftOuterJoinHavingRightTableColumnIndexed public void testLeftOuterJoinHavingRightTableColumnIndexed() throws Exception(Code) testLikeWithFilePath public void testLikeWithFilePath() throws Exception(Code) testLikeWithFilePathAndEscapeChar public void testLikeWithFilePathAndEscapeChar() throws Exception(Code) testMultiStatementInsertWithWhenClauseEvaluatingToNull public void testMultiStatementInsertWithWhenClauseEvaluatingToNull() throws Exception(Code) testQueryOptimizerProcessWhereTree public void testQueryOptimizerProcessWhereTree() throws Exception(Code) testQueryOptimizerProcessWhereTreeWithBTreeIndex public void testQueryOptimizerProcessWhereTreeWithBTreeIndex() throws Exception(Code) testResolveColumnWithTableAlias public void testResolveColumnWithTableAlias() throws SQLException(Code) testRightOuterJoinIndexonLeft public void testRightOuterJoinIndexonLeft() throws Exception(Code) testRightOuterJoinIndexonLeft2 public void testRightOuterJoinIndexonLeft2() throws Exception(Code) testThreeTableJoinHavingTwoTableColumnIndexed public void testThreeTableJoinHavingTwoTableColumnIndexed() throws Exception(Code) testThreeTableJoinWithComparisonConditionAppliedAtJoinAndAfterJoin public void testThreeTableJoinWithComparisonConditionAppliedAtJoinAndAfterJoin() throws Exception(Code) testThreeTableJoinWithExplainCommand public void testThreeTableJoinWithExplainCommand() throws Exception(Code) testThreeTableJoinWithRightTableViewHavingTwoTableColumnIndexed public void testThreeTableJoinWithRightTableViewHavingTwoTableColumnIndexed() throws Exception(Code) testTwoTableAnsiJoinWithCompositeCondition public void testTwoTableAnsiJoinWithCompositeCondition() throws Exception(Code) testTwoTableAnsiJoinWithCompositeOnAndWhereConditions public void testTwoTableAnsiJoinWithCompositeOnAndWhereConditions() throws Exception(Code) testTwoTableInnerJoinWithComparisionCondition public void testTwoTableInnerJoinWithComparisionCondition() throws Exception(Code) testTwoTableInnerJoinWithCompositeOnConditions public void testTwoTableInnerJoinWithCompositeOnConditions() throws Exception(Code) testTwoTableJoinWithComparisionWhereCondition public void testTwoTableJoinWithComparisionWhereCondition() throws Exception(Code) testTwoTableLeftOuterJoinWithCompositeOnAndWhereConditions public void testTwoTableLeftOuterJoinWithCompositeOnAndWhereConditions() throws Exception(Code) testTwoTableRightOuterJoinWithCompositeOnAndWhereConditions public void testTwoTableRightOuterJoinWithCompositeOnAndWhereConditions() throws Exception(Code) testTwoTableRightOuterJoinWithNonEqualJoin public void testTwoTableRightOuterJoinWithNonEqualJoin() throws Exception(Code) test_select_str_from_x_inner_y_inner_z public void test_select_str_from_x_inner_y_inner_z() throws Exception(Code) test_select_str_from_x_inner_y_loj_z public void test_select_str_from_x_inner_y_loj_z() throws Exception(Code) test_select_str_from_x_inner_y_roj_z public void test_select_str_from_x_inner_y_roj_z() throws Exception(Code) test_select_str_from_x_loj_y_inner_z public void test_select_str_from_x_loj_y_inner_z() throws Exception(Code) test_select_str_from_x_loj_y_loj_z public void test_select_str_from_x_loj_y_loj_z() throws Exception(Code) test_select_str_from_x_loj_y_roj_z public void test_select_str_from_x_loj_y_roj_z() throws Exception(Code) test_select_str_from_x_roj_y_inner_z public void test_select_str_from_x_roj_y_inner_z() throws Exception(Code) test_select_str_from_x_roj_y_loj_z public void test_select_str_from_x_roj_y_loj_z() throws Exception(Code) test_select_str_from_x_roj_y_roj_z public void test_select_str_from_x_roj_y_roj_z() throws Exception(Code) Fields inherited from org.axiondb.functional.AbstractFunctionalTest final protected static int NUM_ROWS_IN_BAR(Code)(Java Doc) final protected static int NUM_ROWS_IN_FOO(Code)(Java Doc) final protected static int NUM_ROWS_IN_X(Code)(Java Doc) final protected static int NUM_ROWS_IN_Y(Code)(Java Doc) final protected static int NUM_ROWS_IN_Z(Code)(Java Doc) protected AxionConnection _conn(Code)(Java Doc) protected ResultSet _rset(Code)(Java Doc) protected Statement _stmt(Code)(Java Doc) Methods inherited from org.axiondb.functional.AbstractFunctionalTest protected void assertException(String query)(Code)(Java Doc) protected void assertExceptionOnRead(String query) throws SQLException(Code)(Java Doc) protected void assertNRows(int n, String query) throws SQLException(Code)(Java Doc) protected void assertNRows(int n, ResultSet rset) throws SQLException(Code)(Java Doc) protected void assertNoRows(String query) throws SQLException(Code)(Java Doc) protected void assertNoRows(ResultSet rset) throws SQLException(Code)(Java Doc) protected void assertNullResult(String query) throws SQLException(Code)(Java Doc) protected void assertObjectResult(Object expected, ResultSet rset) throws SQLException(Code)(Java Doc) protected void assertObjectResult(Object expected, String query) throws SQLException(Code)(Java Doc) protected void assertOneRow(String query) throws SQLException(Code)(Java Doc) protected void assertResult(Object[] expected, ResultSet rset) throws SQLException(Code)(Java Doc) protected void assertResult(Object[] expected, String query) throws SQLException(Code)(Java Doc) protected void assertResult(String expected, ResultSet rset) throws SQLException(Code)(Java Doc) protected void assertResult(String expected, String query) throws SQLException(Code)(Java Doc) protected void assertResult(int expected, ResultSet rset) throws SQLException(Code)(Java Doc) protected void assertResult(int expected, String query) throws SQLException(Code)(Java Doc) protected void assertResult(float expected, String query) throws SQLException(Code)(Java Doc) protected void assertResult(boolean expected, String query) throws SQLException(Code)(Java Doc) protected void createAndPopulateDual() throws Exception(Code)(Java Doc) protected void createIndexOnFoo() throws Exception(Code)(Java Doc) protected void createSequenceFooSeq() throws Exception(Code)(Java Doc) protected void createTableBar() throws Exception(Code)(Java Doc) protected void createTableFoo(boolean includeIndex) throws Exception(Code)(Java Doc) protected void createTableFoo() throws Exception(Code)(Java Doc) protected void createTableStates() throws Exception(Code)(Java Doc) protected void createTableWords() throws Exception(Code)(Java Doc) protected void createTableX() throws Exception(Code)(Java Doc) protected void createTableY() throws Exception(Code)(Java Doc) protected void createTableZ() throws Exception(Code)(Java Doc) protected boolean deleteFile(File file) throws Exception(Code)(Java Doc) protected void dropSequenceFooSeq() throws Exception(Code)(Java Doc) protected void dropTableX() throws Exception(Code)(Java Doc) protected void dropTableY() throws Exception(Code)(Java Doc) protected void dropTableZ() throws Exception(Code)(Java Doc) protected String getConnectString()(Code)(Java Doc) protected File getDatabaseDirectory()(Code)(Java Doc) protected void populateTableBar() throws Exception(Code)(Java Doc) protected void populateTableFoo() throws Exception(Code)(Java Doc) protected void populateTableStates() throws Exception(Code)(Java Doc) protected void populateTableWords() throws Exception(Code)(Java Doc) protected void populateTableX() throws Exception(Code)(Java Doc) protected void populateTableY() throws Exception(Code)(Java Doc) protected void populateTableZ() throws Exception(Code)(Java Doc) public void setUp() throws Exception(Code)(Java Doc) public void tearDown() throws Exception(Code)(Java Doc)