Activity for Simon Chenery
-
Simon Chenery committed [e3ea55] on Code
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.46
-
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.45
-
Refactor Placeholder into two classes, removing global nextIndex
-
Add unit test testTooManyParameters
-
Implement arithmetic involving time columns
-
Document arithmetic involving date, timestamp values
-
Update "Working With Eclipse" steps in doc
-
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.44
-
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.43
-
Add a line containing escaped quotes to Hutchenson_011020182.txt
-
Also consider quoteStyle when counting quote characters
-
Added unit test testFileSetInputStreamMultilinePrepend
-
Track quoting in FileSetInputStream to skip file tail for multiline values
-
Use https for repository URL, as suggested by CodeQL
-
Move license.txt to root dir for auto GitHub detection
-
Replace empty LinkedLists with List.of()
-
Return immutable list from unit test helper TableReaderTester.getTableNames()
-
Accept immutable list from TableReader.getTableNames() implementation
-
Update CsvJdbc version in develop.md pom example
-
Fix XORCipher.toString() to include seed contents
-
Update release.md to state Java 11 required
-
Update Maven Compiler Plugin to Java 11
-
Update doc to state Java 11 required
-
Fix XORCipher.toString() to include seed contents
-
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.42
-
Extended testRandomFunction to check second access
-
Merge branch 'master' of https://github.com/simoc/csvjdbc into add-random-function
-
Merge branch 'master' of https://github.com/simoc/csvjdbc into add-line-number-function
-
LINE_NUMBER() should return NULL if GROUP BY
-
Check LINE_NUMBER() returns NULL in test if agg function used
-
Clarify LINE_NUMBER() returns NULL if no corresponding row in CSV
-
Refactor adding line number to env into new addLineNumberEnvironment()
-
Added test testLineNumbersWhereOrderBy
-
Added test testLineNumbersWhereOrderBy
-
Clarify LINE_NUMBER() function returning 0 in documentation
-
Add LINE_NUMBER() to list of functions in documentation
-
Added test testLineNumbersScrollable
-
Add member CsvResultSet.nonMatchingRows to count rows not matching WHERE
-
Remove duplicate asserts in testLineNumbersOrderBy
-
Remove commented out line
-
Added LINE_NUMBER() SQL function
-
Added unit test testOrderByRandomFunction
-
Re-add ROUND definition in where.jj
-
Re-add ROUND definition in where.jj
-
Added RANDOM() SQL function
-
update actions to use Node.js 20, as suggested by GitHub
-
Document non-obvious modulo, string concatenation operators
-
Include array indexes of mismatching elements in SQLException
-
Throw SQLException if type mismatch in array
-
Merge branch 'master' of https://github.com/simoc/csvjdbc into fix-array-in-where-clause
-
Add distribution temurin to GitHub actions
-
update GitHub actions to current version 3
-
Set DatabaseMetaData PRECISION for new Array type
-
ResultSetMetaData.getColumnType returns ARRAY
-
Add Array to type list so nested Arrays understood
-
Add Array to type list so nested Arrays understood
-
Add testToArrayWithDateData to test array with date values
-
Deduce base type of array from types of array elements
-
Implement Comparable for SqlArray
-
Added more tests for TO_ARRAY with WHERE/ORDER BY
-
Added unit test testToArrayInWhereClause
-
Note that java.sql.Array.getResultSet() is implemented too
-
Implement java.sql.Array.getResultSet()
-
Move JUnit 5 from Eclipse Modulepath to Classpath
-
Recreate .classpath for JUnit 5 in Eclipse
-
Merge branch 'master' of https://github.com/simoc/csvjdbc into migrate-to-junit5
-
Update maven-surefire-plugin to current version 3.2.1
-
Add JUnit 5 dependencies to pom.xml
-
Setup class RunTests as JUnit 5 test suite
-
Convert org.relique.jdbc.csv.Test* classes from JUnit 4 to 5
-
Join short message lines
-
Remove excess ": " from exception message
-
Add more bounds checks in SqlArray.getArray(index, count)
-
Convert spaces to tabs in checkFreed()
-
Throw SQLException if accessing freed Array
-
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.41
-
The SQL REPLACE function is included in CsvJdbc version 1.0-40.
-
Add REPLACE SQL function to replace one string with another
-
Included in CsvJdbc version 1.0-40.
-
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.40
-
Add REPLACE SQL function
-
The SQL REPLACE function would be generally useful in CsvJdbc. So, I created Feature Request #106 "Add REPLACE SQL function to replace one string with another". I will implement this as a built-in function in CsvJdbc.
-
Currently, there is no built-in SQL REPLACE function in CsvJdbc. However, you can define your own SQL function that calls a Java method. Here is how you do it: Properties props = new Properties(); props.put("function.REPLACE", "org.relique.jdbc.csv.StringFunctions.replace(String s, String from, String to)"); Connection conn1 = DriverManager.getConnection("jdbc:relique:csv:c:/temp", props); ResultSet results1 = conn1.createStatement().executeQuery("SELECT REPLACE(name, 'on', '_O_N_') FROM sample1");...
-
Add REPLACE SQL function to replace one string with another
-
[maven-release-plugin] prepare for next development iteration
-
[maven-release-plugin] prepare release csvjdbc-1.0.39
-
Avoid warnings for ignored return values
-
Avoid static DateFormat members
-
Throw SQLException for bad dir name in CsvConnection
-
Interpret empty headerline string as unset
-
fix evaluation of Long column plus Date column
-
Throw IOException for bad dir name in FileSetInputStream
-
Remove unnecessary casts
1 >
