[jsr-221-eg] SQL 2016 MATCH RECOGNIZE JDBC parameter Marker / Escape Characters
Lance Andersen
lance.andersen at oracle.com
Tue Oct 9 18:07:59 UTC 2018
>
> I see that that proposal contains some parts not explicitly mentioned in the current proposal (eg escaping \ within the escaped text, see below). Is that still the intent? Or did this change?
>
> --------------------
> {\...\}
>
> expands to the characters between '{\' and '\}'. Doubled backslashes '\' expand to a single backslash.
>
> {\?\} expands to ?
> {\{fn sysdate()}\} expands to {fn sysdate()} and is not further expanded
> {\}\} expands to }
> {\\\}\} expands to \}
>
> —————————
>
Escape processing would be disabled for anything between the {\…\} (or whatever it ends up being)
> I still think using {`..`} would be more readable than having a lot of backslashes.
>
> Mark
> --
> Mark Rotteveel
<http://oracle.com/us/design/oracle-email-sig-198324.gif>
<http://oracle.com/us/design/oracle-email-sig-198324.gif> <http://oracle.com/us/design/oracle-email-sig-198324.gif>
<http://oracle.com/us/design/oracle-email-sig-198324.gif>Lance Andersen| Principal Member of Technical Staff | +1.781.442.2037
Oracle Java Engineering
1 Network Drive
Burlington, MA 01803
Lance.Andersen at oracle.com <mailto:Lance.Andersen at oracle.com>
More information about the jdbc-spec-discuss
mailing list