db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4340) Make it possible to do optimizer overrides in bracketed comments
Date Thu, 06 Aug 2009 13:02:15 GMT
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.


Mime
View raw message