Toad World® Forums

Toad insight broken in 5.5 (again?)


#1

Beta 5.5: Start typing a select statement. In the FROM clause start keying a
table name containing a space by starting with [NameBeforeSpace

Then hit space bar and it does some weird completion thing – but not with
anything you had in the list.

Here’s my example:

I’ve got tables called [Invoice Footer], [Invoice Footer History]

I started typing:

SELECT * FROM [Invoice

Then hit the space bar. As soon as you do, it does this:

SELECT * FROM [Invoice Footer]ylumnsanies]

image004.png

image007.png
image001.png


#2

Great catch Darren !!!
Have you tried it in 5.0.2 which also came out in 30-Nov-2010 or just the Beta ?

Respectfully, Hank Freeman 678-414-0090 Nextel hfreeman@msn.com
image007.png


#3

Great catch Darren !!!
Have you tried it in 5.0.2 which also came out in 30-Nov-2010 or just the Beta ?

Respectfully, Hank Freeman 678-414-0090 Nextel hfreeman@msn.com
image001.png


#4

Hi Darren,

We have CR80314 for this issue. Excuse us for this and please don’t think
that it is still broken – we tried to improve it a little bit J Some sort
of issues in this area were fixed.

Please report in any other issues! Thank you for Beta participating.

regards,

Alexander Maximov
image001.png


#5

Hi Darren,

We have CR80314 for this issue. Excuse us for this and please don’t think
that it is still broken – we tried to improve it a little bit J Some sort
of issues in this area were fixed.

Please report in any other issues! Thank you for Beta participating.

regards,

Alexander Maximov
image007.png


#6

Haven’t tried it in 5.02 – I didn’t need any of the SQL Azure stuff so didn’t bother downloading it.


#7

Understood, I will see If I can get it to work/fail on 5.0.2…

Respectfully, Hank Freeman 678-414-0090 Nextel hfreeman@msn.com


#8

Yes, I was (and still am) working on improving the code completion as the beta
build was made. Another bug in it that I fixed yesterday that I don’t think is
in the beta build is that if you type a . at the end of the editor it will not
show code completion automatically, this will be fixed in the next build.

Some of the improvements that are coming (I am unsure what is actually in this
beta or will be in the next one).

Incrementally generating the code completion items. Before all the data for
the code completion was generated before any was shown. Now we will show
code completion the moment we have anything available and then fill in the
rest as it becomes available. In my test against a slow DB this meant that
code completion showed up in about 0.5 seconds instead of 3 seconds.
You can invoke code completion right before or behind a keyword and it will
generate the correct result (Including the padding space). So if you write
"SELECT |FROM {tablename}" and invoke code completion (| marks cursor) you
will get a list of columns and it will add a space after the inserted
columns.
Better keyboard mappings (This is probably what caused this issue). Space
now inserts the item instead of closing code completion. Shift up/down now
extends the selected columns. You can also control/shift click in the list
to extend selected items.
If you are adding an alias before a column name code completion will not
automatically show after you type the '.' (If there is a column name behind
it).

There are more tweaks too, but these are the big ones that I remember off the
top of my head.

/Henrik
Quest Software
image007.png


#9

Yes, I was (and still am) working on improving the code completion as the beta
build was made. Another bug in it that I fixed yesterday that I don’t think is
in the beta build is that if you type a . at the end of the editor it will not
show code completion automatically, this will be fixed in the next build.

Some of the improvements that are coming (I am unsure what is actually in this
beta or will be in the next one).

Incrementally generating the code completion items. Before all the data for
the code completion was generated before any was shown. Now we will show
code completion the moment we have anything available and then fill in the
rest as it becomes available. In my test against a slow DB this meant that
code completion showed up in about 0.5 seconds instead of 3 seconds.
You can invoke code completion right before or behind a keyword and it will
generate the correct result (Including the padding space). So if you write
"SELECT |FROM {tablename}" and invoke code completion (| marks cursor) you
will get a list of columns and it will add a space after the inserted
columns.
Better keyboard mappings (This is probably what caused this issue). Space
now inserts the item instead of closing code completion. Shift up/down now
extends the selected columns. You can also control/shift click in the list
to extend selected items.
If you are adding an alias before a column name code completion will not
automatically show after you type the '.' (If there is a column name behind
it).

There are more tweaks too, but these are the big ones that I remember off the
top of my head.

/Henrik
Quest Software
image001.png


#10

Good Stuff Henrik !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image007.png


#11

Good Stuff Henrik !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.png


#12

Good Stuff Henrik !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image002.jpeg


#13

Good Stuff Henrik !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.gif


#14

This issue has been fixed for the next release. The issue does not seem related
with the space though (So it is actually worse than initially reported). You can
get this any time while typing in a name while the code completion popup is open
from my testing. It will be fixed in the next drop though.

/Henrik

Quest Software
image001.png


#15

This issue has been fixed for the next release. The issue does not seem related
with the space though (So it is actually worse than initially reported). You can
get this any time while typing in a name while the code completion popup is open
from my testing. It will be fixed in the next drop though.

/Henrik

Quest Software
image007.png


#16

Henrik, Below you said: "Space now inserts the item instead of closing code completion. "

Please, just make sure I can still type table names with spaces without it always assuming space means select the current item.

In 5.0 if I start by typing a [ it assumes that space is part of the table name, not “complete” but if I omit the leading [ it acts like “complete”.

Having to type the opening square bracket but have it not auto-complete is OK as a work around, but to me still not ideal.

To me if you’ve got table names like:
[Invoice]
[Invoice Header]
[Invoice Header History]

It should be smart enough to only use space to auto-complete after there’s no possible other match. In other words, in this example if I type “Invoice” the first item in the list should change from Invoice to “Invoice Header” but I should still be in the list because “Invoice Header History” is still in the list. If I continue to type “Invoice Header” now it would be OK to auto-select “Invoice Header History” because it’s the only possible match remaining.

If I actually wanted a different table name like “Invoice” then my expectation is that it would behave like SSMS where I would just hit tab to proceed with the current selection.
So in this example I’d key: “Invoice” if I wanted [Invoice], “Invoice Header” if I wanted the [Invoice Header] table.

At any point I should be able to select the current match by hitting tab.

So again in this example I could type “Invoice H” and have it auto-select the first match which in this example is [Invoice Header].

Darren


#17

I am assuming this is the same fix:

Box pops up with fields and has first highlighted.

Type a letter and highlights first field with that letter…top is still
highlighted.

Hit Tab to utilize the selected field and you get that field concatenated with
the top field minus the first character.
image003.png


#18

I am assuming this is the same fix:

Box pops up with fields and has first highlighted.

Type a letter and highlights first field with that letter…top is still
highlighted.

Hit Tab to utilize the selected field and you get that field concatenated with
the top field minus the first character.
image007.png


#19

I am assuming this is the same fix:

Box pops up with fields and has first highlighted.

Type a letter and highlights first field with that letter…top is still
highlighted.

Hit Tab to utilize the selected field and you get that field concatenated with
the top field minus the first character.
image004.png


#20

I am assuming this is the same fix:

Box pops up with fields and has first highlighted.

Type a letter and highlights first field with that letter…top is still
highlighted.

Hit Tab to utilize the selected field and you get that field concatenated with
the top field minus the first character.
image001.png