Support INSERT INTO SELECT

[jiacai2050]

Describe This Problem

Enhance SQL support.

INSERT INTO SELECT is useful to migrate table, benchmark(to quickly generate lots of data).

Proposal

Implement this SQL syntax.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

Additional Context

• https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
• https://www.w3schools.com/mysql/mysql_insert_into_select.asp

[caicancai]

Hi, I'm interested in this let me try, but this one may take a little time. This requirement seems a little difficult for me, but I want to try it

[jiacai2050]

Thanks, assigned.

You need to know how horaedb parse sql, how a plan is created and executed. This is indeed a non-trivial task, feel free to ask any questions when you are in trouble.

[jiacai2050]

@caicancai Hi, a few weeks passed, how's it going? Any problems?

[caicancai]

@caicancai Hi, a few weeks passed, how's it going? Any problems?

There doesn't seem to be any progress. I was busy with work in December. I'm sorry for that. I may start this part of the work on New Year's Day, if this feature is not urgent.

[jiacai2050]

Hi, take your time, just want to know if there is any problems.

[jiacai2050]

You can join our slack channel to discuss with us.

• https://github.com/apache/incubator-horaedb?tab=readme-ov-file#contributing

[caicancai]

@jiacai2050 Hello, I tried it during the holiday. I expected that this feature would take up a lot of my energy. Since I have been busy recently, I may not have so much energy. I chose to give up this feature. I am very sorry for taking up so much time.

[jiacai2050]

Thanks for trying out, This task is a little complex, you need to understand how query and write works at the same time.

PS: I remove the good first issue tag.

[dracoooooo]

Hi @jiacai2050, I'd like to take this task.

[jiacai2050]

👍 Much appreciated.