Re: how to query data in index table?

2017-07-05 Thread James Taylor
You shouldn't need to query an index table directly as Phoenix will use an index automatically based on a determination by the optimizer that it's more efficient to do so. If for diagnostic purposes you need to query the index table directly (or any table that uses special characters in the column

Re: Exception ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 4

2017-07-05 Thread Josh Mahonin
Hi, >From the logs you attached, it appears that you're getting the exception on the following query: SELECT trid, tid, frtp, frno, gzid, ontm, onty, onlt, onln, oftm, ofty, oflt, ofln, onwk, onhr, wday, dist, drtn, delf, sntf, cdtm, udtm FROM trp WHERE tid = ? AND delf = FALSE ORDER BY oftm DE