CsvJdbc - CSV file JDBC driver / Bugs / #120 Sub-queries cannot be used when column types are inferred

Sub-queries cannot be used when column types are inferred

#120 Sub-queries cannot be used when column types are inferred

Status: open

Owner: nobody

Labels: None

Priority: 5

Updated: 2016-01-27

Created: 2016-01-27

Creator: Simon Chenery

Private: No

Using a sub-query when column types are inferred (connection property columnTypes="") causes the following exception:

java.sql.SQLException: Cannot infer column types until first row is fetched
at org.relique.jdbc.csv.CsvReader.inferColumnTypes(CsvReader.java:300)
at org.relique.jdbc.csv.CsvReader.getColumnTypes(CsvReader.java:292)
at org.relique.jdbc.csv.CsvResultSet.getMetaData(CsvResultSet.java:1405)
at org.relique.jdbc.csv.SubQueryExpression.evalList(SubQueryExpression.java:84)
at org.relique.jdbc.csv.InExpression.isTrue(InExpression.java:60)
at org.relique.jdbc.csv.ParsedExpression.isTrue(ParsedExpression.java:52)
at org.relique.jdbc.csv.CsvResultSet.next(CsvResultSet.java:925)
at org.relique.jdbc.csv.CsvDriver.writeToCsv(CsvDriver.java:307)
at org.relique.jdbc.csv.Runner2.main(Runner2.java:70)

SQL statement being executed is:

SELECT A FROM TEST WHERE A IN (SELECT B FROM TEST)

Discussion

Simon Chenery - 2016-01-27

Originally reported in csvjdbc-develop forum topic Sub-queries cannot be used when column types are inferred.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sub-queries cannot be used when column types are inferred

Group

Searches

Help

#120 Sub-queries cannot be used when column types are inferred

Discussion