#94 Automatically add column LINENUM to each row

[Simon Chenery]

This column will contain the line number that this row starts in the CSV file (counting from 1 for the first row of data after the header). Some example queries are:

SELECT LINENUM, START_TIME FROM t0 WHERE IDX = 5135

SELECT * FROM t1 WHERE LINENUM = 3

The LINENUM column is not included in SELECT *, the following SQL query will add this column:

SELECT LINENUM, * FROM t1

In situations with no line number, LINENUM will be SQL NULL.

Originally requested in CsvJdbc Open Discussion *Data direct path access (for Indexing) *