You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@quickstep.apache.org by "Zuyu Zhang (JIRA)" <ji...@apache.org> on 2018/04/21 21:04:00 UTC

[jira] [Commented] (QUICKSTEP-105) quickstep_client reports "QUERY EXECUTION ERROR"

    [ https://issues.apache.org/jira/browse/QUICKSTEP-105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16446992#comment-16446992 ] 

Zuyu Zhang commented on QUICKSTEP-105:
--------------------------------------

Ping [~Hacker0912], does this issue still exist?

> quickstep_client reports "QUERY EXECUTION ERROR" 
> -------------------------------------------------
>
>                 Key: QUICKSTEP-105
>                 URL: https://issues.apache.org/jira/browse/QUICKSTEP-105
>             Project: Apache Quickstep
>          Issue Type: Bug
>          Components: CLI, Query Execution
>         Environment: MAC OS
>            Reporter: Zhiwei Fan 
>            Priority: Major
>
> 1. first launch the quickstep_cli_shell with network mode:
> ./quickstep_cli_shell -mode=network -intialize_db
> 2. then using quicktep_client to pass query:
> ./quickstep_client <<< "CREATE TABLE Assign (src INTEGER, dest INTEGER);"
> CREATE TABLE Assign (src INTEGER, dest INTEGER);
> Time: 0.0612 ms
> ./quickstep_client <<< "CREATE TABLE Assign (src INTEGER, dest INTEGER);"
> CREATE TABLE TEMP_TABLE (src INTEGER, dest INTEGER);
> Time: 0.0261 ms
> ./quickstep_client <<< "CREATE TABLE Assign (src INTEGER, dest INTEGER);"
> COPY TEMP_TABLE FROM '/tmp/Assign.tbl' WITH  (DELIMITER ',');
> Time: 89.508 ms
> ./quickstep_client <<< "INSERT INTO TEMP_TABLE SELECT * FROM Assign;"
> Time: 0.100 ms
> QUERY EXECUTION ERROR: unordered_map::at: key not found
> * After multiple tests, it seems that when inserting tuples into a table from another "empty" table, the query will be successfully executed but "QUERY EXECUTION ERROR" will still be reported out of some reasons. The corner case is used in "recursive query" experiments and thus may not have been detected before. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)