piyushShama opened a new issue, #2858:
URL: https://github.com/apache/drill/issues/2858
Bug Description:
When using an alias with special characters in a Superset SQL query, the
query returns null instead of the expected result.
Steps to Reproduce:
1. Use the following SQL query as an example:
`SELECT COUNT(*) AS `COUNT(*)`
FROM
(SELECT name,
grade
FROM mongo.test.`data`) AS virtual_table
WHERE grade = 'A'
LIMIT 50000;`
2. Observe that the query returns null when the alias contains special
characters.
Expected Behavior:
The SQL query should return the count of records satisfying the condition,
and not null, regardless of whether the alias contains special characters.
Actual Behavior:
The query returns null when an alias with special characters is used.
Additional Information:
Version of Apache Superset: 3.0.0
Database type and version: MongoDB 6.0
<img width="1277" alt="1"
src="https://github.com/apache/drill/assets/90260638/9ea6b05f-50cb-424a-9c8b-409e5809e420";>
<img width="1278" alt="2"
src="https://github.com/apache/drill/assets/90260638/2adc464e-647f-497f-a7c1-6a33230e33cd";>
<img width="1280" alt="3"
src="https://github.com/apache/drill/assets/90260638/fddbeef4-c04b-467e-9999-facec60cb728";>
<img width="1279" alt="4"
src="https://github.com/apache/drill/assets/90260638/ab676cec-8053-4ddf-85fc-b76f0b054999";>
--
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: dev-unsubscr...@drill.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
