Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
6.5.0
-
Untriaged
-
Unknown
Description
When applying the new 6.5 "format" feature in the N1QL query editor complex queries are sometimes not indented correctly to the proper level.
The two example N1QL files ( indents_fine.n1ql and indents_bad.n1ql ) are almost identical.
BUT the format differently WRT indenting see attached image where the last three lines are incorrectly indented and additional level.
This query is also problematic:
SELECT city,
COUNT(1) hotel_count,
(TOSTR(ROUND(RATIO_TO_REPORT(COUNT(1)) OVER ( ) * 100,
0)) || "%") AS hotels_percent
FROM `travel-sample`WHERE type = 'hotel'GROUP BY city
ORDER BY hotel_count DESC
LIMIT 30;