[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