georgia-tech-db / eva / bf87b408-0480-4d4c-bddd-68ab192138c6
68%
master: 0%

LAST BUILD BRANCH: staging
DEFAULT BRANCH: master
Ran
Jobs 4
Files 0
Run time –
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 0.0%. Remained the same
bf87b408-0480-4d4c-bddd-68ab192138c6

push

circleci

web-flow 
Enhancing INSERT Command to Support Inserting Multiple Values (#1421)

# Problem Statement
INSERT command wasn't inserting multiple values into table. It was only
inserting the first tuple and ignoring everything else.

![image](https://github.com/georgia-tech-db/evadb/assets/42912887/ed8104af-cedb-4453-88ec-1e4d7827fa02)

# Solution
Modified backend of INSERT command by finding out two things:
1. Place where other tuples are dropped except the first one. That
happened inside `parser/lark_visitor/_insert_statements.py`.
2. Place where INSERT command is actually executed, and does it support
inserting multiple tuples and it does, `executor/insert_executor.py`.

After find those two things, I simply captured all the tuples coming
from the tree created by Lark, and passed them to the executor through
the planner. Tried to make sure that there are no issues inside planner
because of that.

I also modified hash functions of InsertTableStatement, InsertPlan and
LogicalInsert classes because value_list member became 2-dimensional
after my change, and couldn't be hashed. So I converted each element of
value_list to tuple, and then hash functions were working.

# Output after enhancing INSERT command

![image](https://github.com/georgia-tech-db/evadb/assets/42912887/c15cac9b-a06f-4835-9b34-b9720efaa432)

---------

Co-authored-by: Anmol Agarwal <aagarwal622@gatech.edu>
Co-authored-by: americast <sayan.sinha@cc.gatech.edu>

0 of 0 relevant lines covered (NaN%)

0.0 hits per line

Jobs
ID Job ID Ran Files Coverage
1 bf87b408-0480-4d4c-bddd-68ab192138c6.1 0
0.0
 CircleCI Job
2 bf87b408-0480-4d4c-bddd-68ab192138c6.2 0
0.0
 CircleCI Job
3 bf87b408-0480-4d4c-bddd-68ab192138c6.3 0
0.0
 CircleCI Job
4 bf87b408-0480-4d4c-bddd-68ab192138c6.4 0
0.0
 CircleCI Job
Source Files on build bf87b408-0480-4d4c-bddd-68ab192138c6
Detailed source file information is not available for this build.