[jira] [Created] (PHOENIX-4139) select distinct with identical aggregations return weird values

["Csaba Skrabak (JIRA)" <ji...@apache.org>]

Csaba Skrabak created PHOENIX-4139:
--------------------------------------

             Summary: select distinct with identical aggregations return weird values 
                 Key: PHOENIX-4139
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4139
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.12.0
         Environment: minicluster
            Reporter: Csaba Skrabak
            Assignee: Csaba Skrabak
            Priority: Minor


From sme-hbase hipchat room:
Pulkit Bhardwaj·10:31

i'm seeing a weird issue with phoenix, appreciate some thoughts

Created a simple table in phoenix
{noformat}
0: jdbc:phoenix:> create table test_select(nam VARCHAR(20), address VARCHAR(20), id BIGINT
. . . . . . . . > constraint my_pk primary key (id));

0: jdbc:phoenix:> upsert into test_select (nam, address,id) values('pulkit','badaun',1);

0: jdbc:phoenix:> select * from test_select;
+---------+----------+-----+
|   NAM   | ADDRESS  | ID  |
+---------+----------+-----+
| pulkit  | badaun   | 1   |
+---------+----------+-----+


0: jdbc:phoenix:> select distinct 'harshit' as "test_column", nam from test_select;
+--------------+---------+
| test_column  |   NAM   |
+--------------+---------+
| harshit      | pulkit  |
+--------------+---------+


0: jdbc:phoenix:> select distinct 'harshit' as "test_column", trim(nam), trim(nam) from test_select;
+--------------+----------------+----------------+
| test_column  |   TRIM(NAM)    |   TRIM(NAM)    |
+--------------+----------------+----------------+
| harshit      | pulkitpulkit  | pulkitpulkit  |
+--------------+----------------+----------------+
{noformat}

When I apply a trim on the nam column and use it multiple times, the output has the cell data duplicated!
{noformat}
0: jdbc:phoenix:> select distinct 'harshit' as "test_column", trim(nam), trim(nam), trim(nam) from test_select;
+--------------+-----------------------+-----------------------+-----------------------+
| test_column  |       TRIM(NAM)       |       TRIM(NAM)       |       TRIM(NAM)       |
+--------------+-----------------------+-----------------------+-----------------------+
| harshit      | pulkitpulkitpulkit  | pulkitpulkitpulkit  | pulkitpulkitpulkit  |
+--------------+-----------------------+-----------------------+-----------------------+
{noformat}

Wondering if someone has seen this before??

One thing to note is, if I remove the —— distinct 'harshit' as "test_column" ——  The issue is not seen
{noformat}
0: jdbc:phoenix:> select trim(nam), trim(nam), trim(nam) from test_select;
+------------+------------+------------+
| TRIM(NAM)  | TRIM(NAM)  | TRIM(NAM)  |
+------------+------------+------------+
| pulkit     | pulkit     | pulkit     |
+------------+------------+------------+
{noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)