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

["Dmitry Lychagin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dmitry Lychagin reassigned ASTERIXDB-1818:
------------------------------------------

    Assignee: Dmitry Lychagin  (was: Yingyi Bu)

> [Windows] hanging order by
> --------------------------
>
>                 Key: ASTERIXDB-1818
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1818
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: HYR - Hyracks
>            Reporter: Yingyi Bu
>            Assignee: Dmitry Lychagin
>              Labels: windows
>         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, but works fine on Linux and MacOS:
> {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.4.14#64029)