[ https://issues.apache.org/jira/browse/IGNITE-12704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Steshin updated IGNITE-12704: -------------------------------------- Description: {code:java} // Got a connection Connection conn = ...; // Get all the tables. execute() - is just a helper function. Creates prepared statement, pass params... List<List<?>> lst = execute(conn, "select SCHEMA_NAME, TABLE_NAME from SYS.TABLES"); for( List<?> row : lst ){ String schemaName = (String)row.get(0); String tableName = (String)row.get(1); // Shows: "schema: default, table: PERSON" System.out.println("schema: " + schemName + ", table: " + tableName)); // Fails with with: java.sql.SQLException: Failed to parse query. Схема "DEFAULT" не найдена execute( conn, "drop table "+schemaName + "."+tableName+"'" ); } {code} I think this case should fail with error like "only cache created tables can be removed with drop table. ", not with "scheme not found." SQL-engine is supposed to accept and understand values it returns itself. was: {code:java} // Got a connection Connection conn = ...; // Get all the tables. execute() - is just a helper function. Creates prepared statement, pass params... List<List<?>> lst = execute(conn, "select SCHEMA_NAME, TABLE_NAME from SYS.TABLES"); for( List<?> row : lst ){ String schemaName = (String)row.get(0); String tableName = (String)row.get(1); // Shows: "schema: default, table: PERSON" System.out.println("schema: " + schemName + ", table: " + tableName)); // Fails with with: java.sql.SQLException: Failed to parse query. Схема "DEFAULT" не найдена execute( conn, "drop table "+schemaName + "."+tableName+"'" ); } {code} I think this case should fail with error like "only cache created tables can be removed with drop table. ", not with "scheme not found." SQL-engine is supposed to accept and understand values it returns itself. > Fail of recognition of default scheme in SQL queries. > ----------------------------------------------------- > > Key: IGNITE-12704 > URL: https://issues.apache.org/jira/browse/IGNITE-12704 > Project: Ignite > Issue Type: Bug > Reporter: Vladimir Steshin > Priority: Minor > > {code:java} > // Got a connection > Connection conn = ...; > // Get all the tables. execute() - is just a helper function. Creates > prepared statement, pass params... > List<List<?>> lst = execute(conn, "select SCHEMA_NAME, TABLE_NAME from > SYS.TABLES"); > for( List<?> row : lst ){ > String schemaName = (String)row.get(0); > String tableName = (String)row.get(1); > // Shows: "schema: default, table: PERSON" > System.out.println("schema: " + schemName + ", table: " + tableName)); > // Fails with with: java.sql.SQLException: Failed to parse query. Схема > "DEFAULT" не найдена > execute( conn, "drop table "+schemaName + "."+tableName+"'" ); > } > {code} > I think this case should fail with error like "only cache created tables > can be removed with drop table. ", not with "scheme not found." > SQL-engine is supposed to accept and understand values it returns itself. -- This message was sent by Atlassian Jira (v8.3.4#803005)