delta/mariadb-git.git/sql/select_handler.cc, branch preview-10.8-MDEV-14425-innodb github.com: MariaDB/server.git MDEV-23825 Join select_handler and Pushdown_select + XPand changes 2020-09-27T06:30:23+00:00 Alexander Barkov bar@mariadb.com 2020-09-26T14:04:17+00:00 080522dcd7177a0008824802cd58a36ee8048d8f 






Merge 10.4 into 10.5
2020-03-27T07:39:15+00:00

Marko Mäkelä
marko.makela@mariadb.com

2020-03-27T07:39:15+00:00

53aabda6b5ac6af989a97a00ff97efda9ff8772e












MDEV-21887: federatedx crashes on SELECT ... INTO query in select_handler code
2020-03-26T12:01:44+00:00

Sergei Petrunia
psergey@askmonty.org

2020-03-26T12:01:44+00:00

af4b2ae8588bd51cc17e66cfc8210c3225992fbe

Backport to 10.4:

- Don't try to push down SELECTs that have a side effect

- In case the storage engine did support pushdown of SELECT with an INTO
  clause, write the rows we've got from it into select->join->result,
  and not thd->protocol.  This way, SELECT ... INTO ... FROM
  smart_engine_table will put the result into where instructed, and
  NOT send it to the client.





Backport to 10.4:

- Don't try to push down SELECTs that have a side effect

- In case the storage engine did support pushdown of SELECT with an INTO
  clause, write the rows we've got from it into select->join->result,
  and not thd->protocol.  This way, SELECT ... INTO ... FROM
  smart_engine_table will put the result into where instructed, and
  NOT send it to the client.







MDEV-21887: federatedx crashes on SELECT ... INTO query in select_handler code
2020-03-06T22:14:41+00:00

Sergei Petrunia
psergey@askmonty.org

2020-03-06T22:14:41+00:00

cbbe4971b6b26a5017a7da5ebfd89e3aee9f4387

- Don't try to push down SELECTs that have a side effect

- In case the storage engine did support pushdown of SELECT with an INTO
  clause, write the rows we've got from it into select->join->result,
  and not thd->protocol.  This way, SELECT ... INTO ... FROM
  smart_engine_table will put the result into where instructed, and
  NOT send it to the client.





- Don't try to push down SELECTs that have a side effect

- In case the storage engine did support pushdown of SELECT with an INTO
  clause, write the rows we've got from it into select->join->result,
  and not thd->protocol.  This way, SELECT ... INTO ... FROM
  smart_engine_table will put the result into where instructed, and
  NOT send it to the client.







MDEV-18553: MDEV-16327 pre-requisits part 3: move kill check in one place
2019-10-13T07:40:41+00:00

Oleksandr Byelkin
sanja@mariadb.com

2019-09-30T15:20:28+00:00

a6de6408042267558d9fb1f8efa884f8d09d1a34

Kill check moved from send_data() methids in its wrapper:
send_data_with_check().





Kill check moved from send_data() methids in its wrapper:
send_data_with_check().







MDEV-19831 find_select_handler() now tries its best to find a
2019-08-24T17:49:15+00:00

Roman Nozdrin
roman.nozdrin@mariadb.com

2019-08-24T17:47:24+00:00

9fce94287827eee4c1bcddd70a4aacff96314871

handlerton that is able to processes the whole query. For that it
traverses tables from subqueries.

Select_handler now cleans up temporary table structures on dctor call.





handlerton that is able to processes the whole query. For that it
traverses tables from subqueries.

Select_handler now cleans up temporary table structures on dctor call.







MDEV-17096 Pushdown of simple derived tables to storage engines
2019-02-13T06:56:24+00:00

Igor Babaev
igor@askmonty.org

2019-02-13T06:56:24+00:00

27c3abde3071ad2010cbcda5b07435ad15364a70

MDEV-17631 select_handler for a full query pushdown

Added comments and file headers for files introduced in these tasks.





MDEV-17631 select_handler for a full query pushdown

Added comments and file headers for files introduced in these tasks.







MDEV-17096 Pushdown of simple derived tables to storage engines
2019-02-10T06:54:26+00:00

Igor Babaev
igor@askmonty.org

2019-02-10T06:54:26+00:00

d11be23933def394585fae83a6f1ab561e3736f2

Resolved the problem of forming a proper query string for FEDERATEDX.
Added test cases.

Cleanup of extra spaces.





Resolved the problem of forming a proper query string for FEDERATEDX.
Added test cases.

Cleanup of extra spaces.







MDEV-17096 Pushdown of simple derived tables to storage engines
2019-02-07T01:02:44+00:00

Igor Babaev
igor@askmonty.org

2018-10-09T09:36:09+00:00

16327fc2e76e9215059894b461e8aca7f989da00

MDEV-17631 select_handler for a full query pushdown

Interfaces + Proof of Concept for federatedx with test cases.

The interfaces have been developed for integration of ColumnStore engine.





MDEV-17631 select_handler for a full query pushdown

Interfaces + Proof of Concept for federatedx with test cases.

The interfaces have been developed for integration of ColumnStore engine.