You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2012/09/30 03:16:08 UTC
[jira] [Updated] (DERBY-4340) Make it possible to do optimizer
overrides in bracketed comments
[ https://issues.apache.org/jira/browse/DERBY-4340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mamta A. Satoor updated DERBY-4340:
-----------------------------------
Urgency: Normal
Labels: derby_triage10_10 (was: )
> 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
> Labels: derby_triage10_10
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira