#104 execute strips hints

[Rainer Noack]

Hi.

When executing a ddl like

create or replace view my_view(a, b)
as select /*+ rule */ a, b from my_table;

against oracle, the optimizer hint is removed.

Pretty sure, that this is done by the plugin but
not sure whether it's a bug or a feature...

However, for my needs, this is not the desired
behaviour.

Any workarounds ?

Cheers,

Rainer Noack

[Julen Parra]

Logged In: YES
user_id=180901

Yes, you are right, and it's a bug. I suppose nobody was
aware of the optimizer hints. Comments are stripped from the
queries before sending them to the database driver. I'm also
not sure of the rationale for that. I suppose the positive
thing would be to allow users of databases that don't allow
some kind of comments to have them anyway.

There is at the moment no way of configuring that behaviour.
It'll be provided of course in the next release, as it
should be fairly simple to implement. Sadly, the next
release is not too near, as we are in the middle of some
rather deep changes. If you need the bug corrected fast, you
can send me privately an e-mail address and I'll mail you a
workable release as soon as there is something available.
That can also be some days, and the resulting product can be
unstable, as development versions are usually. But if you
are interested let me know.

Sorry about that.

Julen.

[Rainer Noack]

Logged In: YES
user_id=668096

Julen,

Thx for the quick response.

Company guidelines doesn't allow me to use a 'private'
release. I will use another tool for my (rare)
optimized statements. No problem.

However, many thanks for this very useful plugin.

Rainer

[Julen Parra]

Logged In: YES
user_id=180901
Originator: NO

Fixed. Added a new option (send text query as-is to JDBC driver) at the Bookmark level.

[Julen Parra]

Logged In: YES
user_id=180901
Originator: NO

This should be fixed in 3.0.4