[jira] Created: (DERBY-4340) Make it possible to do optimizer overrides in bracketed comments

[Bernt M. Johnsen (JIRA)]

Make it possible to do optimizer overrides in bracketed comments
----------------------------------------------------------------

                 Key: DERBY-4340
                 URL: https://issues.apache.org/jira/browse/DERBY-4340
             Project: Derby
          Issue Type: Improvement
          Components: SQL
            Reporter: Bernt M. Johnsen


Implement optimzier overrides (or --DERBY-PROPERTIES clause) in brackted 
comments.

Instead of

SELECT * FROM --DERBY-PROPERTIES joinOrder=FIXED 
t1 a, t1 b --DERBY-PROPERTIES joinStrategy=NESTEDLOOP
WHERE a.c1=b.c1

I want to be able to write e.g.:

SELECT * FROM /*DERBY-PROPERTIES joinOrder=FIXED*/ t1 a, t1 b 
/*DERBY-PROPERTIES joinStrategy=NESTEDLOOP*/ WHERE a.c1=b.c1;

or
 
SELECT * FROM /*--DERBY-PROPERTIES joinOrder=FIXED*/ t1 a, t1 b 
/*--DERBY-PROPERTIES joinStrategy=NESTEDLOOP*/ WHERE a.c1=b.c1;

or something similar.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.