phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yuan Kang (JIRA)" <>
Subject [jira] [Created] (PHOENIX-3465) order by incorrect when array column be used
Date Tue, 08 Nov 2016 10:20:59 GMT
Yuan Kang created PHOENIX-3465:

             Summary: order by incorrect when array column be used
                 Key: PHOENIX-3465
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.8.0
            Reporter: Yuan Kang

when I create a table like that:
create table "TABLE_A"
task_id varchar not null,
date varchar not null,
dim varchar not null,
valueArray double array,
dimNameArray varchar array,
constraint pk primary key (task_id, date, dim)

upsert some data ,when I query a sql blew :

select date, sum(valueArray[16]) as val1
from TABLE_A 
where date = '2016-11-01' and task_id = '4692' order by val1 desc limit 50;"

the result is incorrert.the similer issus was announced be fix in 4.5.0,this issus is happened
in 4.8.0

This message was sent by Atlassian JIRA

View raw message