Here is some feedback and potential bugs on build 817 for you guys. Hopefully there aren’t many repeats of comments from others, since I haven’t had time to read the whole forum yet.
the Debug menu is currently empty
when trying to extract ddl for a user I get
“Task “Extract DDL for 1 object(s)” in DoTerminate(): Interface not supported”
Similar error when pressing the “Script” button on the user editor
I can’t seem to reproduce this one yet, but I had a case where I was creating a user and when the Save As box comes up, there were quotes around the name I had provided. Of course, this causes case to be respected, and I then got an error “13:27:43 Oracle Dictionary: CMM569560 not found” when saving since it actually saved it as “cmm569560”
in the SQL Editor I can’t control-click on a tablename in my query. In Sqlnav 5, I could do this and it was very convenient
I can’t find an option to turn off the “synonyms” node in the db navigator. While it may be useful in a production environment, it’s really just kind of annoying in dev.
code completion for the following example is not working:
select * from kvsr_temp
where exists (select 1 from kpi_user_value kuv
where kuv.kpi_sid = kvsr_temp.currency_cd
It seems to work when trying to complete columns for the outer table, but not the inner query. i.e. when I type “kvsr_temp.” it completes, but if I type “kuv.” it flashes that it’s populating the list and then nothing.
find / replace does not seem to be working at all. Paste the same query from above in an editor and search for “kvsr” Should be found, but focus goes away entirely when you press the “Find” button
this is more usability, but I find it very distracting when the editor is always switching tabs on me. I tried setting “cursor focus stays in the sql query after exec” in the preference, but it only seems to apply to when there is just 1 statement in the editor. I routinely have a bunch of sql in the editor and run just one piece of it, but this makes me do a lot of clicking I didn’t have to do before
when at the end of a line, the right-arrow at end of line does not take you to the beginning of the next line
bracket matching should not match with brackets inside a comment. For example, with this piece of SQL:
select * from kvsr_temp
WHERE EXISTS (
FROM kpi_user_value kuv
WHERE kuv.kpi_sid = kvsr_temp.kpi_sid
AND kuv.time_period_sid = kvsr_temp.time_period_sid
AND (kuv.unit_lookup_id =
inner join global_constant gc
WHERE kpi_class_sid = kvsr_temp.kpi_class_sid
AND currency_cd = coalesce(kvsr_temp.currency_cd, gc.currency_cd)
– OR (kvsr_temp.currency_cd is null and kuv.unit_lookup_id is null)
If you put your cursor on the bracket in line 7, you will notice that it is matching with the close bracket in the commented out line. This was ok in Sqlnav 5
if I right-click on a table and select Quick Metadata I get the message
“Task “Quick Metadata for 1 object(s)” in DoTerminate(): Interface not supported”
Same thing for Extract DDL
if I click on the script icon in table edit I get: “Interface not supported”
if I’m in the script editor and I click on the drop down next to the connect button, this used to let me change the user that I run the script as. Now it just sends me to the db navigator for that separate session meaning I’ve got to keep a script window open for each session I have.
last thing…I promise. I can’t seem to find the SQL Editor button, or any button to bring up the editor. I’ve been using File -> New File -> SQL Script. Can you point out the obvious thing I must be overlooking?
That’s all for now. Hope this helps.