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

[Lance Andersen]

As I indicated previously, this issue came up for discussion in 2013 and was tabled due to lack of overall support

Since then, the SQL Standard has been updated to include the  MATCH RECOGNIZE operator which is why this issue has come to light once again.  

Things are not added without some form of discussion


> On Oct 9, 2018, at 12:02 PM, Mark Rotteveel <mark at lawinegevaar.nl> wrote:
> 
> On 9-10-2018 17:30, Douglas Surber wrote:
>> Oracle Database JDBC has supported ‘{\ … \}’ as an escape sequence since 2013. 
> 
> Don't take this the wrong way, but I can't help but notice that it looks like Oracle regularly makes its own interpretation of the JDBC specification(*), or does things that are later added to JDBC under the guise of "we already do this in Oracle", instead of discussing it upfront.
> 
> Oracle may be the steward of JDBC, but it is not their personal playground.
> 
> This is especially troubling because a similar problem was discussed back in 2013 for PostgreSQL, and the response back then was along the lines of "there is nothing in JDBC or SQL, so you're on your own", and now it turns out that Oracle invented its own syntax around that same time and now wants to standardize it.
> 
> This could and should have been raised back then, and it should have been discussed in the expert group or on spec-discuss before it was implemented, even if only to avoid different drivers having to invent their own syntax.
> 
It is being discussed, that is what this thread is about.  Yes Oracle has added this extension to their driver has they at the time needed to move forward.  All vendors have extensions.

Alternate proposals/ideas are welcome as part of the discussion 

> You're now essentially forcing us to accept your syntax, because that is what you already have (or we end up with https://xkcd.com/927/).
> 
> *: eg see https://community.oracle.com/message/13952214
> 
> -- 
> 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>