I have an issue with displaying multiple array contents using a single runtool
script.
These are the steps that might help you to recreate the issue i encountered.
1. using runtool, against a database, in which, there is a column which is an
Array. Containing at least 4-6 values.
2. Now, try to perform a csvwrite against this database, and print a range of
array values, say from array[0] to array[5].
3. It seems like it is not possible yet....as the tutorial on the website, did
not provide much information about fetching range values.
I expected to see a csv file, which would have printed the array contents from
position 0 to position 5 on each row.
Instead, saw an error
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Syntax error in SQL
statement "SELECT
TIME,SYMBOL,CP,Array1[1,[*]2],Array2[1,2],Array3[1,2],Array4[1,2] FROM Table
WHERE Search='XYZ' "; expected "[, ::, *, /, %, +, -, ||, ~, !~, NOT, LIKE,
REGEXP, IS, IN, BETWEEN, AND, OR, ]"; SQL statement:
I am Using version H2 1.4.180
Any help would be appreciated.
thanks.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
