[9.0.157 BETA] Join suggestions missing?

I can confirm this one. PK-FK pairs are (still) shown in dark red and name matches were shown in light gray. The latter now does not seem to work anymore.

	gemisigo wrote:
	I can confirm this one. PK-FK pairs are (still) shown in dark red and name matches were shown in light gray. The latter now does not seem to work anymore.

Thank you for the confirmation.

I'm really unsure and have to ask dev team for help. On my end everything works fine, I get suggestions for matching column names, I can attach my screenshot if you want.

Can you please tell me what kind of collation is used by that database? You can look it up in SSMS in database properties?
Is that SQL_Latin1_General_CP1_Cl_AS or something else?

	SysOp wrote:
	I'm really unsure and have to ask dev team for help. On my end everything works fine, I get suggestions for matching column names, I can attach my screenshot if you want. Can you please tell me what kind of collation is used by that database? You can look it up in SSMS in database properties? Is that SQL_Latin1_General_CP1_Cl_AS or something else?

SQL_Latin1_General_CP1_CI_AS

The database collation is SQL_Hungarian_CP1250_CI_AS here. But I guess it should not matter, the column names contain nothing special and this was working in 7.x.

EDIT:If it works for you then it must be something in our settings. The question is where to look...

	gemisigo wrote:
	The database collation is SQL_Hungarian_CP1250_CI_AS here. But I guess it should not matter, the column names contain nothing special and this was working in 7.x. EDIT:If it works for you then it must be something in our settings. The question is where to look...

My settings are bone stock from install now. It seems more likely at this point he has it working because he's got an older config file or something. That's how it feels to me since it doesn't work on a factory fresh install.

Or a newer one. SysOp, what's your build number? Is it 9.0.0157?

Or a newer one. SysOp, what's your build number? Is it 9.0.0157?

	gemisigo wrote:
	Or a newer one. SysOp, what's your build number? Is it 9.0.0157?

You'd hope he'd admit it works in a version we don't have access to if that were the case.

Hope this can be sorted and not delay the RTM version.

The last one available to download is 9.0.157

	Quote:
	The database collation is SQL_Hungarian_CP1250_CI_AS here. But I guess it should not matter

It actually might because of code conversion to Unicode. Internally everything is now Unicode.

Last edited by SysOp on Thu Oct 06, 2016 7:00 pm; edited 1 time in total

	Mindflux wrote:
	You'd hope he'd admit it works in a version we don't have access to if that were the case.

Of course I'd hope it's already fixed and we'd only have to wait for the new build to be available for download. There's nothing wrong with that. But I'm afraid that's not the case.

	SysOp wrote:
	It actually might because of code conversation to Unicode. Internally everything is now Unicode.

No luck in a database with SQL_Latin1_General_CP1_CI_AS either.

My build is the same as yours, no magic here. I hope I can get some help from the team with troubleshooting this issue as I ran out of ideas

Just for the record. I was able to reproduce this issue on a different server.

	SysOp wrote:
	Just for the record. I was able to reproduce this issue on a different server.

Well that's good. At least we have something to go on.

Did your dev team have any clues as to a cause?

They didn't explain in detail. All I can see in the tracking system that is a regression, that feature worked fine up to build 9.0.14S. It's tagged as fixed in 9.0.159. So please expect it working in the RTM version.