SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[10.1.264 Pro] - Preprocessor

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[10.1.264 Pro] - Preprocessor
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [10.1.264 Pro] - Preprocessor Reply with quote
The SQL: Preprocessor pane has two parts. The upper one contains the Global defines. The lower part seems to be some kind of processing log message container:



However, sometimes there are no messages there even though there's surely some processing done. Is this by design?


Tue Feb 05, 2019 6:48 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
I have asked the team for help with this issue, as I'm unable to explain the result
Tue Feb 05, 2019 1:55 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Turned out that the issue is in the code. There should be no space between -- and # and/or /* and #
that's why the second example didn't produce the expected results.
Wed Feb 06, 2019 1:32 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
You might want to add that info as a Tip to User Guide explicitly stating there must not be any spaces between the comment marker (-- or /*) and the #. Though all the examples are made that way, it doesn't say it cannot have a space in between and adding a space there might be muscle memory for everyone working with MySQL which gets itchy when -- is followed by anything else but space and # in this case (but preprocessor is SA specific thing, not MySQL, so that might not be that obvious).

Also, it seems that SA struggles maintaining a clear view of the status of those macros. Check this short video >>>here<<<. At first, everything is good, but then I introduce an error into the third #define which is caught and it no longer recovers from that error. It requires a reconnect to make things good again.


Last edited by gemisigo on Wed Feb 06, 2019 10:40 am; edited 1 time in total
Wed Feb 06, 2019 5:29 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Many thanks for the video demonstrating the issue and for the tip for the User's Guide.
Wed Feb 06, 2019 10:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
The issue is not specific to SQL Preprocessor. It's caused by a bug in a different place, there is an incorrect handling of SQL warnings, "SHOW WARNINGS" clears only warnings and keeps diagnostic errors, which get stuck somewhere. We are planning a hot fix for this and a couple of other issues, tentatively scheduled for next week.
Thu Feb 07, 2019 9:43 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.