| /* |
| * Copyright (C) 2008 The Android Open Source Project |
| * |
| * Licensed under the Apache License, Version 2.0 (the "License"); |
| * you may not use this file except in compliance with the License. |
| * You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, software |
| * distributed under the License is distributed on an "AS IS" BASIS, |
| * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| * See the License for the specific language governing permissions and |
| * limitations under the License. |
| */ |
| |
| package tests.java.sql; |
| |
| import dalvik.annotation.KnownFailure; |
| |
| import junit.extensions.TestSetup; |
| import junit.framework.Test; |
| import junit.framework.TestCase; |
| import junit.framework.TestSuite; |
| |
| import tests.support.DatabaseCreator; |
| import tests.support.Support_SQL; |
| |
| import java.sql.Connection; |
| import java.sql.DatabaseMetaData; |
| import java.sql.ResultSet; |
| import java.sql.ResultSetMetaData; |
| import java.sql.SQLException; |
| import java.sql.Statement; |
| import java.util.HashSet; |
| |
| public class DatabaseMetaDataNotSupportedTest extends TestCase { |
| |
| private static String VIEW_NAME = "myView"; |
| |
| private static String CREATE_VIEW_QUERY = "CREATE VIEW " + VIEW_NAME |
| + " AS SELECT * FROM " + DatabaseCreator.TEST_TABLE1; |
| |
| private static String DROP_VIEW_QUERY = "DROP VIEW " + VIEW_NAME; |
| |
| protected static Connection conn; |
| |
| protected static DatabaseMetaData meta; |
| |
| protected static Statement statement; |
| |
| protected static Statement statementForward; |
| |
| private static int id = 1; |
| |
| public void setUp() throws Exception { |
| super.setUp(); |
| Support_SQL.loadDriver(); |
| try { |
| conn = Support_SQL.getConnection(); |
| meta = conn.getMetaData(); |
| statement = conn.createStatement(); |
| createTestTables(); |
| } catch (SQLException e) { |
| System.out.println("Error in test setup: "+e.getMessage()); |
| } |
| } |
| |
| public void tearDown() throws Exception { |
| try { |
| conn = Support_SQL.getConnection(); |
| meta = conn.getMetaData(); |
| statement = conn.createStatement(); |
| deleteTestTables(); |
| } catch (SQLException e) { |
| System.out.println("Error in teardown: "+e.getMessage()); |
| } finally { |
| try { |
| conn.close(); |
| } catch (SQLException e) { |
| } |
| } |
| super.tearDown(); |
| } |
| |
| private void createTestTables() { |
| try { |
| ResultSet userTab = meta.getTables(null, null, null, null); |
| while (userTab.next()) { |
| String tableName = userTab.getString("TABLE_NAME"); |
| if (tableName.equals(DatabaseCreator.TEST_TABLE1)) { |
| statement.execute(DatabaseCreator.DROP_TABLE1); |
| } else if (tableName |
| .equals(DatabaseCreator.TEST_TABLE3)) { |
| statement.execute(DatabaseCreator.DROP_TABLE3); |
| } else if (tableName.equals(VIEW_NAME)) { |
| statement.execute(DROP_VIEW_QUERY); |
| } |
| } |
| userTab.close(); |
| statement.execute(DatabaseCreator.CREATE_TABLE3); |
| statement.execute(DatabaseCreator.CREATE_TABLE1); |
| statement.execute(CREATE_VIEW_QUERY); |
| meta = conn.getMetaData(); |
| } catch (SQLException e) { |
| fail("Unexpected SQLException " + e.toString()); |
| } |
| } |
| |
| private void deleteTestTables() { |
| try { |
| statement.execute(DatabaseCreator.DROP_TABLE1); |
| statement.execute(DatabaseCreator.DROP_TABLE3); |
| statement.execute(DROP_VIEW_QUERY); |
| } catch (SQLException e) { |
| fail("Unexpected SQLException " + e.toString()); |
| } finally { |
| try { |
| if (! conn.isClosed()) { |
| conn.close(); |
| } |
| } catch (SQLException e) { |
| |
| } |
| } |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#allProceduresAreCallable() |
| */ |
| public void test_allProceduresAreCallable() throws SQLException { |
| assertFalse(meta.allProceduresAreCallable()); |
| } |
| |
| @KnownFailure("Not supported ops applied") |
| public void test_allTablesAreSelectable() throws SQLException { |
| // grant SELECT privileges |
| |
| String query = "GRANT CREATE, SELECT ON " + DatabaseCreator.TEST_TABLE1 |
| + " TO " + Support_SQL.sqlUser; |
| statement.execute(query); |
| Connection userConn = Support_SQL.getConnection(Support_SQL.sqlUrl, |
| Support_SQL.sqlUser, Support_SQL.sqlUser); |
| DatabaseMetaData userMeta = userConn.getMetaData(); |
| ResultSet userTab = userMeta.getTables(null, null, null, null); |
| |
| assertTrue("Tables are not obtained", userTab.next()); |
| assertEquals("Incorrect name of obtained table", |
| DatabaseCreator.TEST_TABLE1.toLowerCase(), userTab.getString( |
| "TABLE_NAME").toLowerCase()); |
| assertTrue("Not all of obtained tables are selectable", userMeta |
| .allTablesAreSelectable()); |
| |
| userTab.close(); |
| // revoke SELECT privileges |
| query = "REVOKE SELECT ON " + DatabaseCreator.TEST_TABLE1 + " FROM " |
| + Support_SQL.sqlUser; |
| statement.execute(query); |
| |
| userTab = userMeta.getTables(null, null, null, null); |
| |
| assertTrue("Tables are not obtained", userTab.next()); |
| assertEquals("Incorrect name of obtained table", |
| DatabaseCreator.TEST_TABLE1.toLowerCase(), userTab.getString( |
| "TABLE_NAME").toLowerCase()); |
| assertFalse("No SELECT privileges", userMeta.allTablesAreSelectable()); |
| |
| userTab.close(); |
| // revoke CREATE privileges |
| query = "REVOKE CREATE ON " + DatabaseCreator.TEST_TABLE1 + " FROM " |
| + Support_SQL.sqlUser; |
| statement.execute(query); |
| userConn.close(); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#dataDefinitionCausesTransactionCommit() |
| */ |
| public void test_dataDefinitionCausesTransactionCommit() throws SQLException { |
| // NOT_FEASIBLE: SQLITE does not implement this functionality |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#dataDefinitionIgnoredInTransactions() |
| */ |
| public void test_dataDefinitionIgnoredInTransactions() throws SQLException { |
| assertFalse(meta.dataDefinitionIgnoredInTransactions()); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#deletesAreDetected(int) |
| */ |
| public void test_deletesAreDetectedI() throws SQLException { |
| assertFalse(meta.deletesAreDetected(0)); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#doesMaxRowSizeIncludeBlobs() |
| */ |
| @KnownFailure("not supported") |
| public void test_doesMaxRowSizeIncludeBlobs() throws SQLException { |
| assertFalse(meta.doesMaxRowSizeIncludeBlobs()); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData #getAttributes(java.lang.String, |
| * java.lang.String, java.lang.String, java.lang.String) |
| */ |
| public void test_getAttributesLjava_lang_StringLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| } |
| |
| public void test_getCatalogs() throws SQLException { |
| ResultSet rs = meta.getCatalogs(); |
| // NOT_FEASIBLE getCatalog is not supported |
| // while (rs.next()) { |
| //if (rs.getString("TABLE_CAT").equalsIgnoreCase(conn.getCatalog())) { |
| // rs.close(); |
| // return; |
| //} |
| // } |
| rs.close(); |
| // fail("Incorrect a set of catalogs"); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getCatalogSeparator() |
| */ |
| public void test_getCatalogSeparator() throws SQLException { |
| assertTrue("Incorrect catalog separator", "".equals(meta |
| .getCatalogSeparator().trim())); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getCatalogTerm() |
| */ |
| public void test_getCatalogTerm() throws SQLException { |
| assertTrue("Incorrect catalog term", "".equals(meta |
| .getCatalogSeparator().trim())); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getExtraNameCharacters() |
| */ |
| public void test_getExtraNameCharacters() throws SQLException { |
| assertNotNull("Incorrect extra name characters", meta |
| .getExtraNameCharacters()); |
| |
| } |
| |
| @KnownFailure("not supported") |
| public void test_getIndexInfoLjava_lang_StringLjava_lang_StringLjava_lang_StringZZ() |
| throws SQLException { |
| boolean unique = false; |
| ResultSet rs = meta.getIndexInfo(conn.getCatalog(), null, |
| DatabaseCreator.TEST_TABLE1, unique, true); |
| ResultSetMetaData rsmd = rs.getMetaData(); |
| assertTrue("Rows do not obtained", rs.next()); |
| int col = rsmd.getColumnCount(); |
| assertEquals("Incorrect number of columns", 13, col); |
| String[] columnNames = { "TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", |
| "NON_UNIQUE", "INDEX_QUALIFIER", "INDEX_NAME", "TYPE", |
| "ORDINAL_POSITION", "COLUMN_NAME", "ASC_OR_DESC", |
| "CARDINALITY", "PAGES", "FILTER_CONDITION" }; |
| for (int c = 1; c <= col; ++c) { |
| assertEquals("Incorrect column name", columnNames[c - 1], rsmd |
| .getColumnName(c)); |
| } |
| |
| assertEquals("Incorrect table catalog", conn.getCatalog(), rs |
| .getString("TABLE_CAT")); |
| assertEquals("Incorrect table schema", null, rs |
| .getString("TABLE_SCHEM")); |
| assertEquals("Incorrect table name", DatabaseCreator.TEST_TABLE1, rs |
| .getString("TABLE_NAME")); |
| assertEquals("Incorrect state of uniquess", unique, rs |
| .getBoolean("NON_UNIQUE")); |
| assertEquals("Incorrect index catalog", "", rs |
| .getString("INDEX_QUALIFIER")); |
| assertEquals("Incorrect index name", "primary", rs.getString( |
| "INDEX_NAME").toLowerCase()); |
| assertEquals("Incorrect index type", DatabaseMetaData.tableIndexOther, |
| rs.getShort("TYPE")); |
| assertEquals("Incorrect column sequence number within index", 1, rs |
| .getShort("ORDINAL_POSITION")); |
| assertEquals("Incorrect column name", "id", rs.getString("COLUMN_NAME")); |
| assertEquals("Incorrect column sort sequence", "a", rs.getString( |
| "ASC_OR_DESC").toLowerCase()); |
| assertEquals("Incorrect cardinality", 1, rs.getInt("CARDINALITY")); |
| assertEquals("Incorrect value of pages", 0, rs.getInt("PAGES")); |
| assertEquals("Incorrect filter condition", null, rs |
| .getString("FILTER_CONDITION")); |
| rs.close(); |
| } |
| |
| @KnownFailure("not supported. Privileges are not supported.") |
| public void test_getColumnPrivilegesLjava_lang_StringLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| ResultSet rs = meta.getColumnPrivileges(conn.getCatalog(), null, |
| DatabaseCreator.TEST_TABLE1, "id"); |
| ResultSetMetaData rsmd = rs.getMetaData(); |
| assertFalse("Rows are obtained", rs.next()); |
| rs.close(); |
| |
| String query = "GRANT REFERENCES(id) ON " + DatabaseCreator.TEST_TABLE1 |
| + " TO " + Support_SQL.sqlLogin; |
| statement.execute(query); |
| |
| rs = meta.getColumnPrivileges(conn.getCatalog(), null, |
| DatabaseCreator.TEST_TABLE1, "id"); |
| rsmd = rs.getMetaData(); |
| assertTrue("Rows do not obtained", rs.next()); |
| int col = rsmd.getColumnCount(); |
| assertEquals("Incorrect number of columns", 8, col); |
| String[] columnNames = { "TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", |
| "COLUMN_NAME", "GRANTOR", "GRANTEE", "PRIVILEGE", |
| "IS_GRANTABLE" }; |
| for (int c = 1; c <= col; ++c) { |
| assertEquals("Incorrect column name", columnNames[c - 1], rsmd |
| .getColumnName(c)); |
| } |
| assertEquals("Incorrect table catalogue", conn.getCatalog(), rs |
| .getString("TABLE_CAT").toLowerCase()); |
| assertEquals("Incorrect table schema", null, rs |
| .getString("TABLE_SCHEM")); |
| assertEquals("Incorrect table name", DatabaseCreator.TEST_TABLE1, rs |
| .getString("TABLE_NAME").toLowerCase()); |
| assertEquals("Incorrect column name", "id", rs.getString("COLUMN_NAME") |
| .toLowerCase()); |
| assertEquals("Incorrect grantor", Support_SQL.sqlLogin + "@" |
| + Support_SQL.sqlHost, rs.getString("GRANTOR").toLowerCase()); |
| assertTrue("Incorrect grantee", |
| rs.getString("GRANTEE").indexOf("root") != -1); |
| assertEquals("Incorrect privilege", "references", rs.getString( |
| "PRIVILEGE").toLowerCase()); |
| |
| query = "REVOKE REFERENCES(id) ON " + DatabaseCreator.TEST_TABLE1 |
| + " FROM " + Support_SQL.sqlLogin; |
| statement.execute(query); |
| rs.close(); |
| } |
| |
| |
| @KnownFailure("not supported") |
| public void test_getExportedKeysLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| ResultSet rs = meta.getExportedKeys(conn.getCatalog(), null, |
| DatabaseCreator.TEST_TABLE3); |
| ResultSetMetaData rsmd = rs.getMetaData(); |
| assertTrue("Rows do not obtained", rs.next()); |
| int col = rsmd.getColumnCount(); |
| assertEquals("Incorrect number of columns", 14, col); |
| String[] columnNames = { "PKTABLE_CAT", "PKTABLE_SCHEM", |
| "PKTABLE_NAME", "PKCOLUMN_NAME", "FKTABLE_CAT", |
| "FKTABLE_SCHEM", "FKTABLE_NAME", "FKCOLUMN_NAME", "KEY_SEQ", |
| "UPDATE_RULE", "DELETE_RULE", "FK_NAME", "PK_NAME", |
| "DEFERRABILITY" }; |
| for (int c = 1; c <= col; ++c) { |
| assertEquals("Incorrect column name", columnNames[c - 1], rsmd |
| .getColumnName(c)); |
| } |
| |
| assertEquals("Incorrect primary key table catalog", conn.getCatalog(), |
| rs.getString("PKTABLE_CAT")); |
| assertEquals("Incorrect primary key table schema", null, rs |
| .getString("PKTABLE_SCHEM")); |
| assertEquals("Incorrect primary key table name", |
| DatabaseCreator.TEST_TABLE3, rs.getString("PKTABLE_NAME")); |
| assertEquals("Incorrect primary key column name", "fk", rs |
| .getString("PKCOLUMN_NAME")); |
| assertEquals("Incorrect foreign key table catalog", conn.getCatalog(), |
| rs.getString("FKTABLE_CAT")); |
| assertEquals("Incorrect foreign key table schema", null, rs |
| .getString("FKTABLE_SCHEM")); |
| assertEquals("Incorrect foreign key table name", |
| DatabaseCreator.TEST_TABLE1, rs.getString("FKTABLE_NAME")); |
| assertEquals("Incorrect foreign key column name", "fkey", rs |
| .getString("FKCOLUMN_NAME")); |
| assertEquals("Incorrect sequence number within foreign key", 1, rs |
| .getShort("KEY_SEQ")); |
| assertEquals("Incorrect update rule value", |
| DatabaseMetaData.importedKeyNoAction, rs |
| .getShort("UPDATE_RULE")); |
| assertEquals("Incorrect delete rule value", |
| DatabaseMetaData.importedKeyNoAction, rs |
| .getShort("DELETE_RULE")); |
| assertNotNull("Incorrect foreign key name", rs.getString("FK_NAME")); |
| assertEquals("Incorrect primary key name", null, rs |
| .getString("PK_NAME")); |
| assertEquals("Incorrect deferrability", |
| DatabaseMetaData.importedKeyNotDeferrable, rs |
| .getShort("DEFERRABILITY")); |
| rs.close(); |
| } |
| |
| public void test_getProcedureColumnsLjava_lang_StringLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| meta.getProcedureColumns("", "", "", ""); |
| } |
| |
| public void test_getProceduresLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| // NOT_FEASIBLE: SQLITE does not implement this functionality |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getProcedureTerm() |
| */ |
| @KnownFailure("Exception test fails") |
| public void test_getProcedureTerm() throws SQLException { |
| assertTrue("Incorrect procedure term", "".equals(meta |
| .getProcedureTerm().trim())); |
| |
| //Exception checking |
| conn.close(); |
| |
| try { |
| meta.getProcedureTerm(); |
| fail("SQLException not thrown"); |
| } catch (SQLException e) { |
| //ok |
| } |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getSchemaTerm() |
| */ |
| @KnownFailure("Exception test fails") |
| public void test_getSchemaTerm() throws SQLException { |
| String term = meta.getSchemaTerm(); |
| assertNotNull("Incorrect schema term", term ); |
| |
| assertTrue("".equals(term)); |
| |
| //Exception checking |
| conn.close(); |
| |
| try { |
| meta.getSchemaTerm(); |
| fail("SQLException not thrown"); |
| } catch (SQLException e) { |
| //ok |
| } |
| } |
| |
| public void test_getSuperTablesLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| // NOT_FEASIBLE: SQLITE does not implement this functionality |
| } |
| |
| public void test_getSuperTypesLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| // NOT_FEASIBLE: SQLITE does not implement this functionality |
| } |
| |
| @KnownFailure("not supported. Privileges are not supported.") |
| public void test_getTablePrivilegesLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| // case 1. Get privileges when no privilegies exist for one table |
| ResultSet privileges = meta.getTablePrivileges(conn.getCatalog(), "%", |
| DatabaseCreator.TEST_TABLE3); |
| assertFalse("Some privilegies exist", privileges.next()); |
| privileges.close(); |
| |
| // case 2. Get privileges when no privilegies exist for all tables |
| privileges = meta.getTablePrivileges(null, null, null); |
| assertFalse("Some privilegies exist", privileges.next()); |
| privileges.close(); |
| |
| // case 3. grant CREATE and SELECT privileges ang get them |
| HashSet<String> expectedPrivs = new HashSet<String>(); |
| expectedPrivs.add("CREATE"); |
| expectedPrivs.add("SELECT"); |
| |
| String query = "GRANT CREATE, SELECT ON " + DatabaseCreator.TEST_TABLE3 |
| + " TO " + Support_SQL.sqlUser; |
| statement.execute(query); |
| |
| privileges = meta.getTablePrivileges(conn.getCatalog(), null, |
| DatabaseCreator.TEST_TABLE3); |
| |
| while (privileges.next()) { |
| assertEquals("Wrong catalog name", Support_SQL.sqlCatalog, |
| privileges.getString("TABLE_CAT")); |
| assertNull("Wrong schema", privileges.getString("TABLE_SCHEM")); |
| assertEquals("Wrong table name", DatabaseCreator.TEST_TABLE3, |
| privileges.getString("TABLE_NAME")); |
| assertTrue("Wrong privilege " + privileges.getString("PRIVILEGE"), |
| expectedPrivs.remove(privileges.getString("PRIVILEGE"))); |
| assertEquals("Wrong grantor", Support_SQL.sqlLogin + "@" |
| + Support_SQL.sqlHost, privileges.getString("GRANTOR")); |
| assertEquals("Wrong grantee", Support_SQL.sqlUser + "@%", |
| privileges.getString("GRANTEE")); |
| assertNull("Wrong value of IS_GRANTABLE", privileges |
| .getString("IS_GRANTABLE")); |
| } |
| privileges.close(); |
| assertTrue("Wrong privileges were returned", expectedPrivs.isEmpty()); |
| |
| query = "REVOKE CREATE, SELECT ON " + DatabaseCreator.TEST_TABLE3 |
| + " FROM " + Support_SQL.sqlUser; |
| statement.execute(query); |
| |
| // case 4. grant all privileges ang get them |
| String[] privs = new String[] { "ALTER", "CREATE", "CREATE VIEW", |
| "DELETE", "DROP", "INDEX", "INSERT", "REFERENCES", "SELECT", |
| "SHOW VIEW", "UPDATE" }; |
| expectedPrivs = new HashSet<String>(); |
| for (int i = 0; i < privs.length; i++) { |
| expectedPrivs.add(privs[i]); |
| } |
| query = "GRANT ALL ON " + DatabaseCreator.TEST_TABLE3 + " TO " |
| + Support_SQL.sqlUser; |
| statement.execute(query); |
| |
| privileges = meta.getTablePrivileges(conn.getCatalog(), null, |
| DatabaseCreator.TEST_TABLE3); |
| |
| while (privileges.next()) { |
| assertEquals("Wrong catalog name", Support_SQL.sqlCatalog, |
| privileges.getString("TABLE_CAT")); |
| assertNull("Wrong schema", privileges.getString("TABLE_SCHEM")); |
| assertEquals("Wrong table name", DatabaseCreator.TEST_TABLE3, |
| privileges.getString("TABLE_NAME")); |
| assertTrue("Wrong privilege " + privileges.getString("PRIVILEGE"), |
| expectedPrivs.remove(privileges.getString("PRIVILEGE"))); |
| assertEquals("Wrong grantor", Support_SQL.sqlLogin + "@" |
| + Support_SQL.sqlHost, privileges.getString("GRANTOR")); |
| assertEquals("Wrong grantee", Support_SQL.sqlUser + "@%", |
| privileges.getString("GRANTEE")); |
| assertNull("Wrong value of IS_GRANTABLE", privileges |
| .getString("IS_GRANTABLE")); |
| } |
| privileges.close(); |
| assertTrue("Wrong privileges were returned", expectedPrivs.isEmpty()); |
| |
| query = "REVOKE ALL ON " + DatabaseCreator.TEST_TABLE3 + " FROM " |
| + Support_SQL.sqlUser; |
| statement.execute(query); |
| |
| // case 5. check no privelegies after revoke |
| privileges = meta.getTablePrivileges(conn.getCatalog(), "%", |
| DatabaseCreator.TEST_TABLE3); |
| assertFalse("Some privilegies exist", privileges.next()); |
| privileges.close(); |
| |
| privileges = meta.getTablePrivileges(null, null, null); |
| assertFalse("Some privilegies exist", privileges.next()); |
| privileges.close(); |
| } |
| |
| public void test_getUDTsLjava_lang_StringLjava_lang_StringLjava_lang_String$I() |
| throws SQLException { |
| // NOT_FEASIBLE: JDBC does not implement this functionality |
| } |
| |
| @KnownFailure("Not supported ops applied") |
| public void test_getVersionColumnsLjava_lang_StringLjava_lang_StringLjava_lang_String() |
| throws SQLException { |
| DatabaseMetaDataTest.insertNewRecord(); |
| |
| String triggerName = "updateTrigger"; |
| String triggerQuery = "CREATE TRIGGER " + triggerName |
| + " AFTER UPDATE ON " + DatabaseCreator.TEST_TABLE1 |
| + " FOR EACH ROW BEGIN INSERT INTO " |
| + DatabaseCreator.TEST_TABLE3 + " SET fk = 10; END;"; |
| statementForward.execute(triggerQuery); |
| |
| String updateQuery = "UPDATE " + DatabaseCreator.TEST_TABLE1 |
| + " SET field1='fffff' WHERE id=1"; |
| statementForward.execute(updateQuery); |
| |
| ResultSet rs = meta.getVersionColumns(conn.getCatalog(), null, |
| DatabaseCreator.TEST_TABLE1); |
| assertTrue("Result set is empty", rs.next()); |
| rs.close(); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#isCatalogAtStart() |
| */ |
| @KnownFailure("Exception test fails") |
| public void test_isCatalogAtStart() throws SQLException { |
| assertFalse( |
| "catalog doesn't appear at the start of a fully qualified table name", |
| meta.isCatalogAtStart()); |
| |
| //Exception checking |
| conn.close(); |
| |
| try { |
| meta.isCatalogAtStart(); |
| fail("SQLException not thrown"); |
| } catch (SQLException e) { |
| //ok |
| } |
| } |
| |
| @KnownFailure("not supported") |
| public void test_locatorsUpdateCopy() throws SQLException { |
| assertFalse(meta.locatorsUpdateCopy()); |
| } |
| |
| public void test_nullPlusNonNullIsNull() throws SQLException { |
| assertFalse(meta.nullPlusNonNullIsNull()); |
| } |
| |
| public void test_nullsAreSortedAtEnd() throws SQLException { |
| assertFalse(meta.nullsAreSortedAtEnd()); |
| } |
| |
| public void test_nullsAreSortedAtStart() throws SQLException { |
| assertFalse(meta.nullsAreSortedAtStart()); |
| } |
| |
| public void test_nullsAreSortedHigh() throws SQLException { |
| assertFalse(meta.nullsAreSortedHigh()); |
| } |
| |
| public void test_nullsAreSortedLow() throws SQLException { |
| assertFalse(meta.nullsAreSortedLow()); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#ownDeletesAreVisible(int) |
| */ |
| public void test_ownDeletesAreVisibleI() throws SQLException { |
| // NOT_FEASIBLE not supported |
| // assertFalse( |
| // "result set's own deletes are visible for TYPE_FORWARD_ONLY type", |
| // meta.ownDeletesAreVisible(ResultSet.TYPE_FORWARD_ONLY)); |
| // assertFalse( |
| // "result set's own deletes are visible for TYPE_SCROLL_INSENSITIVE type", |
| // meta.ownDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)); |
| // assertFalse( |
| // "result set's own deletes are visible for TYPE_SCROLL_SENSITIVE type", |
| // meta.ownDeletesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)); |
| assertFalse("result set's own deletes are visible for unknown type", |
| meta.ownDeletesAreVisible(100)); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#ownInsertsAreVisible(int) |
| */ |
| public void test_ownInsertsAreVisibleI() throws SQLException { |
| // assertFalse( |
| // "result set's own inserts are visible for TYPE_FORWARD_ONLY type", |
| // meta.ownInsertsAreVisible(ResultSet.TYPE_FORWARD_ONLY)); |
| // assertFalse( |
| // "result set's own inserts are visible for TYPE_SCROLL_INSENSITIVE type", |
| // meta.ownInsertsAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)); |
| // assertFalse( |
| // "result set's own inserts are visible for TYPE_SCROLL_SENSITIVE type", |
| // meta.ownInsertsAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)); |
| assertFalse("result set's own inserts are visible for unknown type", |
| meta.ownInsertsAreVisible(100)); |
| } |
| |
| public void test_ownUpdatesAreVisibleI() throws SQLException { |
| assertTrue( |
| "result set's own updates are visible for TYPE_FORWARD_ONLY type", |
| meta.ownUpdatesAreVisible(ResultSet.TYPE_FORWARD_ONLY)); |
| assertTrue( |
| "result set's own updates are visible for TYPE_SCROLL_INSENSITIVE type", |
| meta.ownUpdatesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)); |
| assertTrue( |
| "result set's own updates are visible for TYPE_SCROLL_SENSITIVE type", |
| meta.ownUpdatesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)); |
| assertFalse("result set's own updates are visible for unknown type", |
| meta.ownUpdatesAreVisible(100)); |
| } |
| |
| public void test_storesLowerCaseIdentifiers() throws SQLException { |
| assertFalse(meta.storesLowerCaseIdentifiers()); |
| } |
| |
| public void test_storesLowerCaseQuotedIdentifiers() throws SQLException { |
| assertFalse(meta.storesLowerCaseQuotedIdentifiers()); |
| } |
| |
| public void test_storesUpperCaseIdentifiers() throws SQLException { |
| assertFalse(meta.storesUpperCaseIdentifiers()); |
| } |
| |
| public void test_storesUpperCaseQuotedIdentifiers() throws SQLException { |
| assertFalse(meta.storesUpperCaseQuotedIdentifiers()); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_supportsANSI92EntryLevelSQL() throws SQLException { |
| assertFalse(meta.supportsANSI92EntryLevelSQL()); |
| } |
| |
| public void test_supportsANSI92FullSQL() throws SQLException { |
| assertFalse(meta.supportsANSI92FullSQL()); |
| } |
| |
| public void test_supportsANSI92IntermediateSQL() throws SQLException { |
| assertFalse(meta.supportsANSI92IntermediateSQL()); |
| } |
| |
| public void test_supportsAlterTableWithAddColumn() throws SQLException { |
| assertFalse(meta.supportsAlterTableWithAddColumn()); |
| } |
| |
| public void test_supportsAlterTableWithDropColumn() throws SQLException { |
| assertFalse(meta.supportsAlterTableWithDropColumn()); |
| } |
| |
| public void test_supportsBatchUpdates() throws SQLException { |
| assertTrue(meta.supportsBatchUpdates()); |
| } |
| |
| public void test_supportsCatalogsInDataManipulation() throws SQLException { |
| assertFalse(meta.supportsCatalogsInDataManipulation()); |
| } |
| |
| public void test_supportsCatalogsInIndexDefinitions() throws SQLException { |
| assertFalse(meta.supportsCatalogsInIndexDefinitions()); |
| } |
| |
| public void test_supportsCatalogsInPrivilegeDefinitions() throws SQLException { |
| assertFalse(meta.supportsCatalogsInPrivilegeDefinitions()); |
| } |
| |
| public void test_supportsCatalogsInProcedureCalls() throws SQLException { |
| assertFalse(meta.supportsCatalogsInProcedureCalls()); |
| } |
| |
| public void test_supportsCatalogsInTableDefinitions() throws SQLException { |
| assertFalse(meta.supportsCatalogsInTableDefinitions()); |
| } |
| |
| public void test_supportsConvert() throws SQLException { |
| assertFalse(meta.supportsConvert()); |
| } |
| |
| public void test_supportsConvertII() throws SQLException { |
| assertFalse(meta.supportsConvert()); |
| } |
| |
| public void test_supportsCoreSQLGrammar() throws SQLException { |
| assertFalse(meta.supportsCoreSQLGrammar()); |
| } |
| |
| public void test_supportsCorrelatedSubqueries() throws SQLException { |
| assertFalse(meta.supportsCorrelatedSubqueries()); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_supportsDataDefinitionAndDataManipulationTransactions() throws SQLException { |
| assertFalse(meta.supportsDataDefinitionAndDataManipulationTransactions()); |
| } |
| |
| public void test_supportsDataManipulationTransactionsOnly() throws SQLException { |
| assertFalse(meta.supportsDataManipulationTransactionsOnly()); |
| } |
| |
| public void test_supportsDifferentTableCorrelationNames() throws SQLException { |
| assertFalse(meta.supportsDifferentTableCorrelationNames()); |
| } |
| |
| public void test_supportsExtendedSQLGrammar() throws SQLException { |
| assertFalse(meta.supportsExtendedSQLGrammar()); |
| } |
| |
| public void test_supportsFullOuterJoins() throws SQLException { |
| assertFalse(meta.supportsFullOuterJoins()); |
| } |
| |
| public void test_supportsGetGeneratedKeys() throws SQLException { |
| assertFalse(meta.supportsGetGeneratedKeys()); |
| } |
| |
| public void test_supportsGroupByBeyondSelect() throws SQLException { |
| assertFalse(meta.supportsGroupByBeyondSelect()); |
| } |
| |
| public void test_supportsIntegrityEnhancementFacility() throws SQLException { |
| assertFalse(meta.supportsIntegrityEnhancementFacility()); |
| } |
| |
| public void test_supportsLikeEscapeClause() throws SQLException { |
| assertFalse(meta.supportsLikeEscapeClause()); |
| } |
| |
| public void test_supportsLimitedOuterJoins() throws SQLException { |
| assertFalse(meta.supportsLimitedOuterJoins()); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_supportsMinimumSQLGrammar() throws SQLException { |
| assertFalse(meta.supportsMinimumSQLGrammar()); |
| } |
| |
| public void test_supportsMixedCaseIdentifiers() throws SQLException { |
| assertFalse(meta.supportsMixedCaseIdentifiers()); |
| } |
| |
| public void test_supportsMixedCaseQuotedIdentifiers() throws SQLException { |
| assertFalse(meta.supportsMixedCaseQuotedIdentifiers()); |
| } |
| |
| public void test_supportsMultipleOpenResults() throws SQLException { |
| assertFalse(meta.supportsMultipleOpenResults()); |
| } |
| |
| public void test_supportsMultipleResultSets() throws SQLException { |
| assertFalse(meta.supportsMultipleResultSets()); |
| } |
| |
| public void test_supportsMultipleTransactions() throws SQLException { |
| assertFalse(meta.supportsMultipleTransactions()); |
| } |
| |
| public void test_supportsNamedParameters() throws SQLException { |
| assertFalse(meta.supportsNamedParameters()); |
| } |
| |
| public void test_supportsOpenCursorsAcrossCommit() throws SQLException { |
| assertFalse(meta.supportsOpenCursorsAcrossCommit()); |
| } |
| |
| public void test_supportsOpenCursorsAcrossRollback() throws SQLException { |
| assertFalse(meta.supportsOpenCursorsAcrossRollback()); |
| } |
| |
| public void test_supportsOpenStatementsAcrossCommit() throws SQLException { |
| assertFalse(meta.supportsOpenStatementsAcrossCommit()); |
| } |
| |
| public void test_supportsOpenStatementsAcrossRollback() throws SQLException { |
| assertFalse(meta.supportsOpenStatementsAcrossRollback()); |
| } |
| |
| public void test_supportsOuterJoins() throws SQLException { |
| assertFalse(meta.supportsOuterJoins()); |
| } |
| |
| public void test_supportsPositionedDelete() throws SQLException { |
| assertFalse(meta.supportsPositionedDelete()); |
| } |
| |
| public void test_supportsPositionedUpdate() throws SQLException { |
| assertFalse(meta.supportsPositionedUpdate()); |
| } |
| |
| public void test_supportsResultSetConcurrencyII() throws SQLException { |
| assertFalse(meta.supportsResultSetConcurrency(0,0)); |
| } |
| |
| public void test_supportsResultSetHoldabilityI() throws SQLException { |
| assertFalse(meta.supportsResultSetHoldability(0)); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_supportsResultSetTypeI() throws SQLException { |
| assertTrue("database supports TYPE_FORWARD_ONLY type", meta |
| .supportsResultSetType(ResultSet.TYPE_FORWARD_ONLY)); |
| assertFalse("database doesn't support TYPE_SCROLL_INSENSITIVE type", |
| meta.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE)); |
| assertFalse("database supports TYPE_SCROLL_SENSITIVE type", meta |
| .supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE)); |
| assertFalse("database supports unknown type", meta |
| .supportsResultSetType(100)); |
| } |
| |
| public void test_supportsSavepoints() throws SQLException { |
| assertFalse(meta.supportsSavepoints()); |
| } |
| |
| public void test_supportsSchemasInDataManipulation() throws SQLException { |
| assertFalse(meta.supportsSchemasInDataManipulation()); |
| } |
| |
| public void test_supportsSchemasInIndexDefinitions() throws SQLException { |
| assertFalse(meta.supportsSchemasInIndexDefinitions()); |
| } |
| |
| public void test_supportsSchemasInPrivilegeDefinitions() throws SQLException { |
| // NOT_FEASIBLE: SQLITE does not implement this functionality |
| } |
| |
| public void test_supportsSchemasInProcedureCalls() throws SQLException { |
| assertFalse(meta.supportsSchemasInProcedureCalls()); |
| } |
| |
| public void test_supportsSchemasInTableDefinitions() throws SQLException { |
| assertFalse(meta.supportsSchemasInTableDefinitions()); |
| } |
| |
| public void test_supportsStatementPooling() throws SQLException { |
| assertFalse(meta.supportsStatementPooling()); |
| } |
| |
| public void test_supportsStoredProcedures() throws SQLException { |
| assertFalse(meta.supportsStoredProcedures()); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_supportsSubqueriesInComparisons() throws SQLException { |
| assertFalse(meta.supportsSubqueriesInComparisons()); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_supportsSubqueriesInIns() throws SQLException { |
| assertFalse(meta.supportsSubqueriesInIns()); |
| } |
| |
| public void test_supportsSubqueriesInQuantifieds() throws SQLException { |
| assertFalse(meta.supportsSubqueriesInQuantifieds()); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_supportsTransactions() throws SQLException { |
| assertFalse(meta.supportsTransactions()); |
| } |
| |
| public void test_supportsUnion() throws SQLException { |
| assertTrue(meta.supportsUnion()); |
| } |
| |
| public void test_supportsUnionAll() throws SQLException { |
| assertTrue(meta.supportsUnionAll()); |
| } |
| |
| public void test_usesLocalFilePerTable() throws SQLException { |
| assertFalse(meta.usesLocalFilePerTable()); |
| } |
| |
| @KnownFailure("not supported") |
| public void test_usesLocalFiles() throws SQLException { |
| assertFalse(meta.usesLocalFiles()); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxBinaryLiteralLength() |
| */ |
| public void test_getMaxBinaryLiteralLength() throws SQLException { |
| assertTrue("Incorrect binary literal length", meta |
| .getMaxBinaryLiteralLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxCatalogNameLength() |
| */ |
| public void test_getMaxCatalogNameLength() throws SQLException { |
| assertTrue("Incorrect name length", meta.getMaxCatalogNameLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxCharLiteralLength() |
| */ |
| public void test_getMaxCharLiteralLength() throws SQLException { |
| assertTrue("Incorrect char literal length", meta |
| .getMaxCharLiteralLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxColumnNameLength() |
| */ |
| public void test_getMaxColumnNameLength() throws SQLException { |
| assertTrue("Incorrect column name length", meta |
| .getMaxColumnNameLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxColumnsInGroupBy() |
| */ |
| public void test_getMaxColumnsInGroupBy() throws SQLException { |
| assertTrue("Incorrect number of columns", |
| meta.getMaxColumnsInGroupBy() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxColumnsInIndex() |
| */ |
| public void test_getMaxColumnsInIndex() throws SQLException { |
| assertTrue("Incorrect number of columns", |
| meta.getMaxColumnsInIndex() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxColumnsInOrderBy() |
| */ |
| public void test_getMaxColumnsInOrderBy() throws SQLException { |
| assertTrue("Incorrect number of columns", |
| meta.getMaxColumnsInOrderBy() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxColumnsInSelect() |
| */ |
| public void test_getMaxColumnsInSelect() throws SQLException { |
| assertTrue("Incorrect number of columns", |
| meta.getMaxColumnsInSelect() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxColumnsInTable() |
| */ |
| public void test_getMaxColumnsInTable() throws SQLException { |
| assertTrue("Incorrect number of columns", |
| meta.getMaxColumnsInTable() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxConnections() |
| */ |
| public void test_getMaxConnections() throws SQLException { |
| assertTrue("Incorrect number of connections", |
| meta.getMaxConnections() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxIndexLength() |
| */ |
| public void test_getMaxIndexLength() throws SQLException { |
| assertTrue("Incorrect length of index", meta.getMaxIndexLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxProcedureNameLength() |
| */ |
| public void test_getMaxProcedureNameLength() throws SQLException { |
| assertTrue("Incorrect length of procedure name", meta |
| .getMaxProcedureNameLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxRowSize() |
| */ |
| public void test_getMaxRowSize() throws SQLException { |
| assertTrue("Incorrect size of row", meta.getMaxRowSize() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxSchemaNameLength() |
| */ |
| public void test_getMaxSchemaNameLength() throws SQLException { |
| assertTrue("Incorrect length of schema name", meta |
| .getMaxSchemaNameLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxStatementLength() |
| */ |
| public void test_getMaxStatementLength() throws SQLException { |
| assertTrue("Incorrect length of statement", meta |
| .getMaxStatementLength() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxStatements() |
| */ |
| public void test_getMaxStatements() throws SQLException { |
| assertTrue("Incorrect number of statements", |
| meta.getMaxStatements() == 0); |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxTableNameLength() |
| */ |
| @KnownFailure("Exception test fails") |
| public void test_getMaxTableNameLength() throws SQLException { |
| assertTrue("Now supported", meta |
| .getMaxTableNameLength() == 0); |
| |
| //Exception checking |
| conn.close(); |
| |
| try { |
| meta.getMaxTableNameLength(); |
| fail("SQLException not thrown"); |
| } catch (SQLException e) { |
| //ok |
| } |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxTablesInSelect() |
| */ |
| @KnownFailure("Exception test fails") |
| public void test_getMaxTablesInSelect() throws SQLException { |
| assertTrue("Tables in select is now supported: change test implementation\"", |
| meta.getMaxTablesInSelect() == 0); |
| |
| //Exception checking |
| conn.close(); |
| |
| try { |
| meta.getMaxTablesInSelect(); |
| fail("SQLException not thrown"); |
| } catch (SQLException e) { |
| //ok |
| } |
| } |
| |
| /** |
| * java.sql.DatabaseMetaData#getMaxUserNameLength() |
| */ |
| @KnownFailure("Exception test fails") |
| public void test_getMaxUserNameLength() throws SQLException { |
| assertTrue("Usernames are now supported: change test implementation", |
| meta.getMaxUserNameLength() == 0); |
| |
| //Excpetion checking |
| conn.close(); |
| |
| try { |
| meta.getMaxUserNameLength(); |
| fail("SQLException not thrown"); |
| } catch (SQLException e) { |
| //ok |
| } |
| } |
| |
| |
| } |
