BUG [SA 6 and 7] Column picker gets out of whack.

Funny. Pressing ctrl+space after selecting the first column now reopens a popup with the filter condition preserved. But that filter was for the table name.

	gemisigo wrote:
	Funny. Pressing ctrl+space after selecting the first column now reopens a popup with the filter condition preserved. But that filter was for the table name.

It's doing the same thing it did for me, yes it's the table name filter.. but it still show the data type after the column name if you hit right arrow to pick the column again.

My bad. Of course there seems to be a filter. When I pressed ctrl+space the cursor was right after the column selected (no comma after it) so it just tried to resume where it left off, that is, it showed the two possible columns with name match but this time the name was the one selected in the previous run.

Regarding the data type issue, I'm still unable to reproduce that. I've got no idea what's the cause of it. I did everything exactly as it was in your screencast.

	gemisigo wrote:
	Regarding the data type issue, I'm still unable to reproduce that. I've got no idea what's the cause of it. I did everything exactly as it was in your screencast.

Yeah I'm not sure either. All I can narrow it down to is two similar column names in a table with a similar name too.

In this case:
Table: BottleOrder
Columns: BottleOrder, BottleOrderStamp.

I'm curious if the devs have been able to reproduce it. My posted table DDL should get them there. As I said I have a few other tables with similar naming conventions that I can reproduce this behavior with. And if I'm picking columns not of similar name, such as ClientID (vs BottleOrder) the picker is 'just fine'.

So far we have failed to reproduce this one

Here is what we get using build 6.4.208

Last edited by SysOp on Mon Jul 07, 2014 11:11 pm; edited 1 time in total

	SysOp wrote:
	So far we have failed to reproduce this one Here is what we get using build 6.4.208

Any thoughts on what else it could be? I tried it SSMS, Notepad and NP++ to eliminate the editor side.

Could it be one of the child tables associated with it?

I have:

BottleOrder
BottleOrderCooler
BottleOrderGroup
BottleOrderSupples
BottleOrderTest
BottleOrderTracking

I think it's worth testing that. Would you be able to provide DDL for all objects having names starting with Bottle? Or if you don't want to post it here, email it to our support account?

Last edited by SysOp on Fri Jun 07, 2013 11:46 am; edited 1 time in total

	SysOp wrote:
	I think it's worse testing that. Would you be able to provide DDL for all objects having names starting with Bottle? Or if you don't want to post it here, email it to our support account?

I'll email it over. I just referenced this thread in the email.

Ok. I'm just losing my mind now..

SSMS, NP++ and Notepad.exe are behaving today. None of these are exhibiting this issue.

Hmm... A cache refresh issue?

	gemisigo wrote:
	Hmm... A cache refresh issue?

Yes. I was wondering when I initially loaded 6.4 if it had kept my 6.3 cache, and once I happened to strike F5 on the popup it cleared the issue.

Still exists in 7.0.136. Is this a regression? The datatype on the end of the column is still fixed, but the columns that are outside of the filter criteria (clientID, QuoteID) still appear after selecting BottleOrder (which we were filtered on BottleO I believe)

I asked our developer to take another look. This looks like a bug to me.

Go another one here.

Working on a where clause.

I start typing "AND WorkOrder"... the moment I hit F to start going to WorkOrderFinancial

You can see after the column name Workorder is the word "inancial"

Then the further I type "Financial" the weirder it gets