You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/08/10 11:12:33 UTC

[GitHub] [incubator-doris] yangzhg opened a new issue #4314: [BUG] distinct in subquery may casue NPE

yangzhg opened a new issue #4314:
URL: https://github.com/apache/incubator-doris/issues/4314


   **Describe the bug**
   Predicate push down where sub query has distinct may throw NPE
   
   **To Reproduce**
   Steps to reproduce the behavior:
   1.  create table like 
   ```
   +--------------+--------------+------+-------+---------+---------+
   | Field        | Type         | Null | Key   | Default | Extra   |
   +--------------+--------------+------+-------+---------+---------+
   | event_day    | DATETIME     | No   | true  | NULL    |         |
   | title        | VARCHAR(600) | No   | true  | NULL    |         |
   | report_value | VARCHAR(50)  | No   | false | NULL    | REPLACE |
   +--------------+--------------+------+-------+---------+---------+
   ```
   2. exec query 
   ```
   
   ```SELECT
       *
   FROM
       (
           SELECT
               DISTINCT event_day,
               title
           FROM
               click_show_window
       ) a
   WHERE
       a.title IS NOT NULL
   4. See error
   ```
   ERROR 1064 (HY000): errCode = 2, detailMessage = Unexpected exception: null
   ```
   
   this is because DISTINCT generate grouping exprs in agginfo, but this clause dosn`t have a group by clause
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [incubator-doris] yangzhg closed issue #4314: [BUG] distinct in subquery may casue NPE

Posted by GitBox <gi...@apache.org>.
yangzhg closed issue #4314:
URL: https://github.com/apache/incubator-doris/issues/4314


   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org