summaryrefslogtreecommitdiff
path: root/mysql-test/main/insert_returning.test
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-23178: Qualified asterisk not supported in INSERT .. RETURNINGRucha Deodhar2021-07-221-0/+20
| | | | | | | | | | | | Analysis: When we have INSERT/REPLACE returning with qualified asterisk in the RETURNING clause, '*' is not resolved properly because of wrong context. context->table_list is NULL or has incorrect table because context->table_list has tables from the FROM clause. For INSERT/REPLACE...SELECT...RETURNING, context->table_list has table we are inserting from. While in other INSERT/REPLACE syntax, context->table_list is NULL because there is no FROM clause. Fix: If filling fields instead of '*' for qualified asterisk in RETURNING, use first_name_resolution_table for correct resolution of item.
* MDEV-10014 Add RETURNING to INSERTSergei Golubchik2019-10-141-4/+32
| | | | | | | | post-review fixes: * test for dependent subqueries * test for triggers and routines * disallow INSERT...RETURNING in triggers and stored functions * don't return anything if INSERT IGNORE ignored an error
* MDEV-10014 Add RETURNING to INSERTRucha Deodhar2019-10-141-0/+280
Closes #1384