dynamobi/dynamobi — Issue #773: [FRG-97] Support for JDBC escape syntax is incomplete
Author: dynamobi-build
Created: 2011-12-30 03:48:22+00:00
State: open
Labels: FRG, JDBC Client Driver

[reporter="jhyde", created="Wed, 22 Mar 2006 13:11:09 -0500 (GMT-05:00)"]
JDBC has 5 escape sequences:

* {fn ...} for function calls

* {escape ...} as in "SELECT * FROM emp WHERE name LIKE 'Fred%' {escape '\'}"

* {call ...} for procedure calls

* {d, t, ts} for date/time/timestamp constants

* {oj ...} for outer joins

We currently support 'fn' and 'd/t/ts'. Need to support the 'escape', 'call', 'oj'.

All need to be implemented as pseudo-functions in the parser, and expanded in the validator. If we expand them in the parser, error messages won't make much sense.

See http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/statement.html#1004825.

Also, escape sequences should only work if Statement.setEscapeProcessing(true) has been called. (I haven't checked whether this works.)