[SA 9.0.176 Pro] - Delimiters vs Prefixes

[SA 9.0.176 Pro] - Delimiters vs Prefixes

Ignore Name Prefixes doesn't work properly when Always Add Delimiters is set to Always add brackets [ ]. I suppose it's because after adding delimiters '[' is considered part of the name. Selecting from the popup the view named v_nyomvonal_tetelek_insert in schema xform became

	Code:
	[xform].[v_nyomvonal_tetelek_insert] AS vnti

even though Ignore Name Prefixes had 'v_' to ignore. After adding '[v_' to the list, the code turned into

	Code:
	[xform].[v_nyomvonal_tetelek_insert] AS nti

as expected.

I haven't checked but I guess it affects other types of delimiters as well.

Unfortunately it seems to affect all delimiters. I can reproduce this issue too. It looks like the Always Add Delimiters options cannot be used along Ignore Name Prefixes.
I'm going to raise this issue and ask if that can be fixed.

Thank you very much. Meanwhile, I'm going to add delimited versions of prefixes. That should work until there's a fix.

One more issue with adding delimiters: setting that option to Always add brackets [ ] will add those delimiters to variable names too when selecting a stored procedure from popup for EXECUTE, ending with something like:

	Code:
	EXECUTE [logs].[usp_bekeres_logolas] [@ip_v4] = NULL ,[@ip_v6] = NULL ,[@debug] = NULL

Parsing such statements will fail because of the syntax error. Selecting variables from popup is unaffected.

Thank you very much. I'm logging this issue too. Hope it can be fixed quickly.

Adding delimiters to parameter variable names for a stored procedure is no longer an issue. Ignoring name prefixes with added delimiters still is.

Could you post a short list of intended bugfixes so that we don't spam the forum re-reporting issues that are known as not fixed yet?

	Quote:
	Could you post a short list of intended bugfixes so that we don't spam the forum re-reporting issues that are known as not fixed yet?

Certainly. We will post them ASAP.

	Quote:
	Ignoring name prefixes with added delimiters still is

Prefixes with delimiters aren't currently supported it seems. No changes in the release notes for this and previous internal builds refer to that one.