SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[11.1.125 Pro] - BUG: Formatting operators (MariaDB)

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[11.1.125 Pro] - BUG: Formatting operators (MariaDB)
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post [11.1.125 Pro] - BUG: Formatting operators (MariaDB) Reply with quote
When formatting code in MariaDB, the assignment operator := gets its parts separated, thus
Code:

SET `lv_reply_to_caller` := 111;


becomes
Code:

SET `lv_reply_to_caller` : = 111; -- surplus space between : and =


resulting in a syntax error.
Wed May 06, 2020 1:47 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
I believe this has been fixed in version 11.2.x which is not yet released. I tested with a couple of very simple procedures and it formatted the code correctly without adding extra spaces within unary operators and assignments.
Wed May 06, 2020 2:35 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
Great news! Can you provide an ETA for that version?
Thu May 07, 2020 5:50 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
Version 11.2 is now available
Mon Jun 29, 2020 8:17 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
Still happens in [11.2.246 Pro].
Thu Jul 09, 2020 10:54 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
I'm not able to reproduce it. Is there any specific context in which I need to try it?



Thu Jul 09, 2020 2:33 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
No, nothing special. I've tried it with Operators Spacing set to Don't Modify, Compact, and Space Before and After Operator. None of those helped, there was always something wrong with them.

Check this short video here.
Mon Jul 13, 2020 6:49 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.