simoc

In CsvJdbc, column names in SQL queries are case insensitive and users of CsvJdbc are depending on this. It is not possible to simply change CsvJdbc to be case sensitive....

Setting the CsvJdbc database connection property `quotechar` to an empty string disables handling of quoting in the CSV file. This is described in the CsvJdbc documentation file `doc.md`. Is that...

The following test program works correctly for me. Is this what you are trying to do? ```java package org.relique.jdbc.csv; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import...

My example works correctly with CsvJdbc version 1.0.36, as well as with the most recent version 1.0.40. My example also works correctly when `Java.sql.Statement.execute()` is called instead of `executeQuery()`. In...

Thank you for the hint about where the problem is. I get the following exception if I add a `ResultSetMetaData meta = results.getMetaData();` call after executing the query in my...

In this situation, CsvJdbc does not correctly determine what data types are passed to, and returned from, the Java method used as an SQL function. A workaround for this problem...

Yes, a TO_DATE(str, format) SQL function (like in PostgreSQL or Oracle) would be welcome. I created #73 for this work.

Yes, a TO_CHAR(date/timestamp, format) SQL function (like in PostgreSQL or Oracle) would be welcome. I created #74 for this work.

CsvJdbc normally keeps only one row in memory. If `ORDER BY`, `GROUP BY`, SQL aggregrate functions or JDBC scrollable result sets are used, then all rows are held in memory,...

Good idea. If you implement TO_NUMBER() yourself, then I will accept the changes into CsvJdbc. Alternatively, if you wait "a couple of weeks", then I will have time to implement...