Print Thread
Beautifier problem
#52021 08/26/15 09:06 AM
Joined: Jun 2015
Posts: 7
A
Member
OP Offline
Member
A
Joined: Jun 2015
Posts: 7
When I use more then one WITH clauses in query they're beutified in strange mode:
Code
WITH query1 AS(query1line1
               ...
               query1lineN), query2 AS(query2line1
                                       ...
                                       query2lineN), query3 ...
SELECT ...
                 

Re: Beautifier problem
AWegierski #52022 08/26/15 09:15 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
We'll check it out.


Marco Kalter
Allround Automations
Re: Beautifier problem
Marco Kalter #52023 08/26/15 09:16 AM
Joined: Jun 2015
Posts: 7
A
Member
OP Offline
Member
A
Joined: Jun 2015
Posts: 7
Thx

Re: Beautifier problem
AWegierski #52024 08/26/15 09:31 AM
Joined: Jun 2015
Posts: 7
A
Member
OP Offline
Member
A
Joined: Jun 2015
Posts: 7
Now, simple workaround is to insert comment -- between the WITH clauses

Re: Beautifier problem
AWegierski #53904 08/19/16 09:33 AM
Joined: Aug 2016
Posts: 1
Z
Member
Offline
Member
Z
Joined: Aug 2016
Posts: 1
the same issue


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.036s Queries: 14 (0.013s) Memory: 2.5157 MB (Peak: 3.0434 MB) Data Comp: Off Server Time: 2024-05-18 05:28:55 UTC
Valid HTML 5 and Valid CSS