hengfeiyang commented on issue #1850:
URL:
https://github.com/apache/datafusion-sqlparser-rs/issues/1850#issuecomment-3281365296
For this sql, the format also not correct:
```sql
SELECT cid,COUNT(*)AS cnt FROM tbl WHERE hostname
IN('www.google.com','www.abc.com')AND cid IN(SELECT DISTINCT cid FROM tbl2
WHERE hostname='www.abc.com' AND graphqlop='test' AND status IN(SELECT DISTINCT
status FROM tbl3)ORDER BY cid LIMIT 1000)GROUP BY cid ORDER BY cid;
```
currently version output is:
```sql
SELECT
cid,
COUNT(*) AS cnt
FROM
tbl
WHERE
hostname IN ('www.google.com', 'www.abc.com') AND cid IN (SELECT DISTINCT
cid FROM tbl2 WHERE hostname = 'www.abc.com' AND graphqlop = 'test' AND status
IN (SELECT DISTINCT status FROM tbl3) ORDER BY cid LIMIT 1000)
GROUP BY
cid ORDER BY cid
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
