apache / apache/drill

Drill | mongoDB | Issue with Alias naming conventions

Open
#2,858 15 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
2k
Forks
990
Avg merge
1d 8h
Merged PRs (30d)
5

Description

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
1
2
3
4

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.