You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@quickstep.apache.org by "Zhiwei Fan (JIRA)" <ji...@apache.org> on 2017/09/21 16:58:00 UTC

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

Zhiwei Fan  created QUICKSTEP-105:
-------------------------------------

             Summary: 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 


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
(v6.4.14#64029)