| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
 [SA 7.2.338 Pro] - Formatting issue (OBJECT::) [FIXED] |
 |
I've got a formatting issue with statements granting rights. The following statement:
 |
 |
GRANT SELECT ON OBJECT::fohi.fit_get_forgalmi_hir_reszletek TO new_line
|
gets misformatted to:
|
|
GRANT SELECT ON OBJECT : : fohi.fit_get_forgalmi_hir_reszletek TO new_line
|
and the surplus spaces around colons make this syntactically incorrect.
Last edited by gemisigo on Mon Oct 26, 2015 9:17 am; edited 2 times in total |
|
| Fri Jul 31, 2015 4:38 am |
  |
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I'm afraid it doesn't understand OBJECT:: notation and treats : as an operator. To disable extra spacing added, change Operators Spacing option in SQL Assistant settings for the code formatting style you use.
|
|
| Mon Aug 03, 2015 10:21 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
 |
|
To disable extra spacing added, change Operators Spacing option in SQL Assistant settings for the code formatting style you use. |
Unfortunately, that's not an option. The extra spaces added by Operators Spacing are part of the formatting policy.
I tried adding a new rule:
|
|
GRANT ... ON OBJECT::... TO ...
|
but it didn't help.
I've reported a very similar problem two years ago, complaining about :=, +=, -=, etc. being split the same way, you can read it here. Would you check if that fix could be applied to this issue as well, please?
|
|
| Mon Aug 03, 2015 10:37 am |
|
|
michalk
Joined: 29 Aug 2014
Posts: 211
|
|
| |
|
I reported the same issue for postgresql database. The double colon is used here for casting datatypes for example some_variable::INTEGER, NULL::VARCHAR etc
Adding spaces around colons results in syntax error.
|
|
| Wed Aug 05, 2015 6:11 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I located an existing bug report in the system with # SA0026838 for incorrect formatting of :: object notation that should fix both issues. The fix will be available in version 7.3, expected sometime in mid of September (tentative, unconfirmed time so far).
Last edited by SysOp on Mon Aug 10, 2015 11:07 am; edited 1 time in total |
|
| Mon Aug 10, 2015 10:00 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Splendid! Thank you very much!
|
|
| Mon Aug 10, 2015 10:52 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Any hints on the arrival of 7.3?
|
|
| Thu Sep 17, 2015 6:23 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
It's expected by the end of this month, but no specific date is given yet.
|
|
| Thu Sep 17, 2015 10:40 pm |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
That's great. Is a short list of changes/bugfixes/additions available?
|
|
| Fri Sep 18, 2015 2:23 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Sorry, it's not available yet.
|
|
| Fri Sep 18, 2015 9:20 am |
|
|
|
