[jira] [Created] (ASTERIXDB-1818) [Windows] hanging order by

["Yingyi Bu (JIRA)" <ji...@apache.org>]

Yingyi Bu created ASTERIXDB-1818:
------------------------------------

             Summary: [Windows] hanging order by
                 Key: ASTERIXDB-1818
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1818
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: Hyracks
            Reporter: Yingyi Bu
            Assignee: Yingyi Bu
         Attachments: mondial.adm

The dataset is attached.

DDLs and LOAD:

{noformat}
// DDL
drop dataverse test if exists;
create dataverse test;
use test;

create type WorldType as {
    id: uuid
}

create dataset world(WorldType) primary key id auto generated;

// DML
use test;
load dataset world using localfs
(("path"="127.0.0.1:////Users/yingyi/mondial.adm"),("format"="adm"));
{noformat}


The following query hangs on a Windows instance:
{noformat}
SELECT z.name as province_name, u.name as city_name
FROM world x, x.mondial.country y, y.province z, 
CASE  
WHEN z.city is missing THEN [] 
WHEN is_array(z.city) THEN z.city 
ELSE  [z.city] 
END u 
WHERE  y.name='Peru'
ORDER BY u.name;
{noformat}

But after removing the ORDER BY, the query works fine.




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)