[jsr-221-eg] SQL 2016 MATCH RECOGNIZE JDBC parameter Marker / Escape Characters

[Douglas Surber]

Correction. Or maybe correction. Reading the SQL spec is challenging.

Anyway, on further pondering, I don’t think ‘{‘ <identifier> is valid SQL or a prefix to any valid SQL. At least not as of SQL 2016. I could definitely be wrong for any meaning of ‘wrong’ in this context. I’m pretty sure my example quoted below is invalid.

Douglas

> On Oct 9, 2018, at 8:50 AM, Douglas Surber <DOUGLAS.SURBER at oracle.com> wrote:
> 
> As I noted in my previous email ‘{q’ and ‘{quote’ are unfortunately valid SQL. 
> 
>  “ . . . {quote {quote}} . . .” 
> 
> does look a bit confusing though admittedly it is the worst case and is unlikely.
>