Drill | mongoDB | Issue with Alias naming conventions

Open
#2,858 15 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
30/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
java, mongodb, sql
Domain
backend, databases

Research direction

No source file, test, or entry point is named. First reproduce the supplied query with Apache Drill, Superset 3.0.0, and MongoDB 6.0, then trace the handling of aliases containing special characters; done means the query returns the expected count instead of null.

Written by the indexing model from the issue text.

Description

bug

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

Dominant language
Java
Stars
2k
Forks
989
Avg merge
1d 8h
Merged PRs (30d)
5

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from apache/drill

All issues in apache/drill

Similar issues

More Java issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.