Java Doc for TestDQL.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.TestDQL All known Subclasses:   org.axiondb.functional.TestDQLWithArrayIndex,  org.axiondb.ext.indexes.ttree.TestDQLWithTTreeIndex,  org.axiondb.functional.TestDQLDisk,  org.axiondb.functional.TestDQLWithBTreeIndex, TestDQL public class TestDQL extends AbstractFunctionalTest (Code) Database Query Language tests. version:    $Revision: 1.77 $ $Date: 2005/12/20 18:32:45 $ author:    Chuck Burdick author:    Rodney Waldhoff author:    Dave Pekarek Krohn author:    Jonathan Giron Constructor Summary public   TestDQL(String testName)      Method Summary protected  void helpTestStringResults(String sql, String[] expected)      public  void setUp()      public static  Test suite()      public  void tearDown()      public  void testAnsiStyleInnerJoin()      public  void testAnsiStyleInnerJoinWithWhere()      public  void testCrossproductStyleInnerJoin()      public  void testCrossproductStyleInnerJoinWithWhere()      public  void testGetRow()      public  void testGetRow2()      public  void testGetRow3()      public  void testGetRowWithDot()      public  void testLimitByMaxRows()      public  void testNullPlusNonNullIsNull()      public  void testPreparedStatement()      public  void testPreparedStatementAfterRollback()      public  void testSelectDuplicateRows()      public  void testSelectDuplicateRows2()      public  void testSelectWithAutocommitTurnedOff()      public  void testSingleRowButNotEqualFromIndexBug()      public  void test_select_char_of_num_from_foo()      public  void test_select_concat_literal_descr2_from_bar()      public  void test_select_contains_fieldval_from_foo()      public  void test_select_contains_literal_from_foo()      public  void test_select_count_num_from_empty_table()      public  void test_select_count_star_from_foo_where_num_lt_n()      public  void test_select_distinct()      public  void test_select_f_star_from_foo_f_bar_b_where_id_eq_num()      public  void test_select_foo_dot_asterisk_from_foo_bar_where_num_gt_literal_and_id_eq_num()      public  void test_select_foostr_foonum_from_foo_where_foonum_eq_literal()      public  void test_select_from_foo_where_contains_fieldval_eq_true()      public  void test_select_from_foo_where_contains_fieldval_unary()      public  void test_select_literal_from_foo()      public  void test_select_lower_of_descr2_from_bar()      public  void test_select_max_num_from_empty_table()      public  void test_select_max_num_from_foo()      public  void test_select_min_num_from_empty_table()      public  void test_select_min_num_from_foo()      public  void test_select_min_num_from_foo_with_null()      public  void test_select_order_by_offset_limit()      public  void test_select_rownum()      public  void test_select_rownum_with_orderby()      public  void test_select_sequence_nextval()      public  void test_select_sequence_nextval_from_foo()      public  void test_select_star_from_foo_f_bar_b_where_id_eq_num()      public  void test_select_star_from_foo_where_id_in_list()      public  void test_select_state_where_matches_caret_a()      public  void test_select_state_where_matches_north()      public  void test_select_state_where_state_like_a_percent_a()      public  void test_select_state_where_state_like_al_percent()      public  void test_select_str_descr_from_foo_bar_where_id_eq_num_and_num_lt_literal_join_w_bind()      public  void test_select_str_descr_from_foo_bar_where_num_gt_literal_and_id_eq_num()      public  void test_select_str_from_foo()      public  void test_select_str_from_foo_order_by_num()      public  void test_select_str_from_foo_order_by_num_asc()      public  void test_select_str_from_foo_order_by_num_desc()      public  void test_select_str_from_foo_order_by_upper_str_desc()      public  void test_select_str_from_foo_semicolon()      public  void test_select_str_from_foo_where_literal_lt_num()      public  void test_select_str_from_foo_where_num_bewtween_literal_and_literal()      public  void test_select_str_from_foo_where_num_eq_literal()      public  void test_select_str_from_foo_where_num_eq_literal_or_num_gt_literal()      public  void test_select_str_from_foo_where_num_gteq_literal()      public  void test_select_str_from_foo_where_num_lt_literal()      public  void test_select_str_from_foo_where_rownum_lt_5()      public  void test_select_str_from_foo_where_str_gt_literal()      public  void test_select_str_num_from_foo()      public  void test_select_str_num_from_foo_where_num_eq_literal()      public  void test_select_sum_num_from_empty_table()      public  void test_select_sum_num_from_foo()      public  void test_select_upper_of_descr2_from_bar()      public  void test_select_where_int_eq_null()      public  void test_select_where_int_is_not_null()      public  void test_select_where_int_is_null()      public  void test_select_where_not_int_is_null()      public  void test_select_where_string_eq_null()      public  void test_select_where_string_is_not_null()      public  void test_select_where_string_is_null()      public  void test_select_with_bindvar_limit()      public  void test_select_with_bindvar_offset()      public  void test_select_with_literal_limit()      public  void test_select_with_literal_offset()      public  void test_select_word_where_word_like_b()      public  void test_select_word_where_word_like_b_t()      public  void test_select_word_where_word_like_c_percent()      public  void test_select_word_where_word_not_like_b_t()      Constructor Detail TestDQL public TestDQL(String testName)(Code) Method Detail helpTestStringResults protected void helpTestStringResults(String sql, String[] expected) throws Exception(Code) setUp public void setUp() throws Exception(Code) suite public static Test suite()(Code) tearDown public void tearDown() throws Exception(Code) testAnsiStyleInnerJoin public void testAnsiStyleInnerJoin() throws Exception(Code) testAnsiStyleInnerJoinWithWhere public void testAnsiStyleInnerJoinWithWhere() throws Exception(Code) testCrossproductStyleInnerJoin public void testCrossproductStyleInnerJoin() throws Exception(Code) testCrossproductStyleInnerJoinWithWhere public void testCrossproductStyleInnerJoinWithWhere() throws Exception(Code) testGetRow public void testGetRow() throws Exception(Code) testGetRow2 public void testGetRow2() throws Exception(Code) testGetRow3 public void testGetRow3() throws Exception(Code) testGetRowWithDot public void testGetRowWithDot() throws Exception(Code) testLimitByMaxRows public void testLimitByMaxRows() throws Exception(Code) testNullPlusNonNullIsNull public void testNullPlusNonNullIsNull() throws Exception(Code) testPreparedStatement public void testPreparedStatement() throws Exception(Code) testPreparedStatementAfterRollback public void testPreparedStatementAfterRollback() throws Exception(Code) testSelectDuplicateRows public void testSelectDuplicateRows() throws Exception(Code) testSelectDuplicateRows2 public void testSelectDuplicateRows2() throws Exception(Code) testSelectWithAutocommitTurnedOff public void testSelectWithAutocommitTurnedOff() throws Exception(Code) testSingleRowButNotEqualFromIndexBug public void testSingleRowButNotEqualFromIndexBug() throws Exception(Code) test_select_char_of_num_from_foo public void test_select_char_of_num_from_foo() throws Exception(Code) test_select_concat_literal_descr2_from_bar public void test_select_concat_literal_descr2_from_bar() throws Exception(Code) test_select_contains_fieldval_from_foo public void test_select_contains_fieldval_from_foo() throws Exception(Code) test_select_contains_literal_from_foo public void test_select_contains_literal_from_foo() throws Exception(Code) test_select_count_num_from_empty_table public void test_select_count_num_from_empty_table() throws Exception(Code) test_select_count_star_from_foo_where_num_lt_n public void test_select_count_star_from_foo_where_num_lt_n() throws Exception(Code) test_select_distinct public void test_select_distinct() throws Exception(Code) test_select_f_star_from_foo_f_bar_b_where_id_eq_num public void test_select_f_star_from_foo_f_bar_b_where_id_eq_num() throws Exception(Code) test_select_foo_dot_asterisk_from_foo_bar_where_num_gt_literal_and_id_eq_num public void test_select_foo_dot_asterisk_from_foo_bar_where_num_gt_literal_and_id_eq_num() throws Exception(Code) test_select_foostr_foonum_from_foo_where_foonum_eq_literal public void test_select_foostr_foonum_from_foo_where_foonum_eq_literal() throws Exception(Code) test_select_from_foo_where_contains_fieldval_eq_true public void test_select_from_foo_where_contains_fieldval_eq_true() throws Exception(Code) test_select_from_foo_where_contains_fieldval_unary public void test_select_from_foo_where_contains_fieldval_unary() throws Exception(Code) test_select_literal_from_foo public void test_select_literal_from_foo() throws Exception(Code) test_select_lower_of_descr2_from_bar public void test_select_lower_of_descr2_from_bar() throws Exception(Code) test_select_max_num_from_empty_table public void test_select_max_num_from_empty_table() throws Exception(Code) test_select_max_num_from_foo public void test_select_max_num_from_foo() throws Exception(Code) test_select_min_num_from_empty_table public void test_select_min_num_from_empty_table() throws Exception(Code) test_select_min_num_from_foo public void test_select_min_num_from_foo() throws Exception(Code) test_select_min_num_from_foo_with_null public void test_select_min_num_from_foo_with_null() throws Exception(Code) test_select_order_by_offset_limit public void test_select_order_by_offset_limit() throws Exception(Code) test_select_rownum public void test_select_rownum() throws Exception(Code) test_select_rownum_with_orderby public void test_select_rownum_with_orderby() throws Exception(Code) test_select_sequence_nextval public void test_select_sequence_nextval() throws Exception(Code) test_select_sequence_nextval_from_foo public void test_select_sequence_nextval_from_foo() throws Exception(Code) test_select_star_from_foo_f_bar_b_where_id_eq_num public void test_select_star_from_foo_f_bar_b_where_id_eq_num() throws Exception(Code) test_select_star_from_foo_where_id_in_list public void test_select_star_from_foo_where_id_in_list() throws Exception(Code) test_select_state_where_matches_caret_a public void test_select_state_where_matches_caret_a() throws Exception(Code) test_select_state_where_matches_north public void test_select_state_where_matches_north() throws Exception(Code) test_select_state_where_state_like_a_percent_a public void test_select_state_where_state_like_a_percent_a() throws Exception(Code) test_select_state_where_state_like_al_percent public void test_select_state_where_state_like_al_percent() throws Exception(Code) test_select_str_descr_from_foo_bar_where_id_eq_num_and_num_lt_literal_join_w_bind public void test_select_str_descr_from_foo_bar_where_id_eq_num_and_num_lt_literal_join_w_bind() throws Exception(Code) test_select_str_descr_from_foo_bar_where_num_gt_literal_and_id_eq_num public void test_select_str_descr_from_foo_bar_where_num_gt_literal_and_id_eq_num() throws Exception(Code) test_select_str_from_foo public void test_select_str_from_foo() throws Exception(Code) test_select_str_from_foo_order_by_num public void test_select_str_from_foo_order_by_num() throws Exception(Code) test_select_str_from_foo_order_by_num_asc public void test_select_str_from_foo_order_by_num_asc() throws Exception(Code) test_select_str_from_foo_order_by_num_desc public void test_select_str_from_foo_order_by_num_desc() throws Exception(Code) test_select_str_from_foo_order_by_upper_str_desc public void test_select_str_from_foo_order_by_upper_str_desc() throws Exception(Code) test_select_str_from_foo_semicolon public void test_select_str_from_foo_semicolon() throws Exception(Code) test_select_str_from_foo_where_literal_lt_num public void test_select_str_from_foo_where_literal_lt_num() throws Exception(Code) test_select_str_from_foo_where_num_bewtween_literal_and_literal public void test_select_str_from_foo_where_num_bewtween_literal_and_literal() throws Exception(Code) test_select_str_from_foo_where_num_eq_literal public void test_select_str_from_foo_where_num_eq_literal() throws Exception(Code) test_select_str_from_foo_where_num_eq_literal_or_num_gt_literal public void test_select_str_from_foo_where_num_eq_literal_or_num_gt_literal() throws Exception(Code) test_select_str_from_foo_where_num_gteq_literal public void test_select_str_from_foo_where_num_gteq_literal() throws Exception(Code) test_select_str_from_foo_where_num_lt_literal public void test_select_str_from_foo_where_num_lt_literal() throws Exception(Code) test_select_str_from_foo_where_rownum_lt_5 public void test_select_str_from_foo_where_rownum_lt_5() throws Exception(Code) test_select_str_from_foo_where_str_gt_literal public void test_select_str_from_foo_where_str_gt_literal() throws Exception(Code) test_select_str_num_from_foo public void test_select_str_num_from_foo() throws Exception(Code) test_select_str_num_from_foo_where_num_eq_literal public void test_select_str_num_from_foo_where_num_eq_literal() throws Exception(Code) test_select_sum_num_from_empty_table public void test_select_sum_num_from_empty_table() throws Exception(Code) test_select_sum_num_from_foo public void test_select_sum_num_from_foo() throws Exception(Code) test_select_upper_of_descr2_from_bar public void test_select_upper_of_descr2_from_bar() throws Exception(Code) test_select_where_int_eq_null public void test_select_where_int_eq_null() throws Exception(Code) test_select_where_int_is_not_null public void test_select_where_int_is_not_null() throws Exception(Code) test_select_where_int_is_null public void test_select_where_int_is_null() throws Exception(Code) test_select_where_not_int_is_null public void test_select_where_not_int_is_null() throws Exception(Code) test_select_where_string_eq_null public void test_select_where_string_eq_null() throws Exception(Code) test_select_where_string_is_not_null public void test_select_where_string_is_not_null() throws Exception(Code) test_select_where_string_is_null public void test_select_where_string_is_null() throws Exception(Code) test_select_with_bindvar_limit public void test_select_with_bindvar_limit() throws Exception(Code) test_select_with_bindvar_offset public void test_select_with_bindvar_offset() throws Exception(Code) test_select_with_literal_limit public void test_select_with_literal_limit() throws Exception(Code) test_select_with_literal_offset public void test_select_with_literal_offset() throws Exception(Code) test_select_word_where_word_like_b public void test_select_word_where_word_like_b() throws Exception(Code) test_select_word_where_word_like_b_t public void test_select_word_where_word_like_b_t() throws Exception(Code) test_select_word_where_word_like_c_percent public void test_select_word_where_word_like_c_percent() throws Exception(Code) test_select_word_where_word_not_like_b_t public void test_select_word_where_word_not_like_b_t() 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)