summaryrefslogtreecommitdiff
path: root/sql/sql_tvc.cc
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-14835 Server crashes in Field_iterator_table::create_item when number ofGalina Shalygina2018-02-201-1/+1
| | | | | | | | | | | elements of BIGINT or YEAR type in the IN list reaches in_predicate_conversion_threshold The bug appears at the prepare stage when IN-predicate with the long list of values is converted into IN-subquery. It happens because values in the right operand of the IN-predicate that have BIGINT or YEAR types are converted into the Item_int_with_ref. To fix it in the procedure Item_func_in::create_value_list_for_tvc real_item() is taken for each value in the right operand of the IN-predicate.
* Bug fixGalina Shalygina2018-01-251-2/+2
| | | | Wrong conversion
* System Versioning 1.0pre2Aleksey Midenkov2017-11-231-2/+6
|\ | | | | | | Merge branch '10.3' into trunk
| * Handle failures from mallocMichael Widenius2017-11-171-2/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Most "new" failures fixed in the following files: - sql_select.cc - item.cc - item_func.cc - opt_subselect.cc Other things: - Allocate udf_handler strings in mem_root - Required changes in sql_string.h - Add mem_root as argument to some new [] calls - Mark udf_handler strings as thread specific - Removed some comment blocks with code
* | SQL: VIEW of UNION [fixes #293]Aleksey Midenkov2017-11-131-1/+1
|/
* Fixed mdev-14281 Wrong result from query with NOT IN predicate in WHEREIgor Babaev2017-11-051-4/+10
| | | | | | | Conversion of NOT IN predicates into NOT IN subqueries did not work correctly: the predicates actually were converted into IN subqueries. As a result if the conversion was applied for the query with a NOT IN predicate the query could return a wrong result set.
* Remove a type castMarko Mäkelä2017-11-021-2/+2
|
* Fixed compilation failuresMonty2017-11-021-2/+17
| | | | - Also added missing copyright notices
* Merge remote-tracking branch 'shagalla/10.3-mdev12172' into 10.3Igor Babaev2017-11-011-24/+27
| | | | | | | As a result of this merge the code for the following tasks appears in 10.3: - MDEV-12172 Implement tables specified by table value constructors - MDEV-12176 Transform [NOT] IN predicate with long list of values INTO [NOT] IN subquery.
* Mistakes corrected.Galina Shalygina2017-10-281-0/+97
| | | | | TVC can be used in IN subquery and in PARTITION BY struct now. Special variable to control working of optimization added.
* New tests on errors added. Comments corrected. Some procedures corrected.Galina Shalygina2017-09-041-81/+142
|
* Post review changes for the optimization of IN predicates into IN subqueries.Galina Shalygina2017-09-021-119/+170
|
* Memory allocation corrected. New tests added.Galina Shalygina2017-09-011-88/+68
|
* Mistakes corrected. Now all tests in opt_tvc.test file work correctlyGalina Shalygina2017-08-291-1/+0
|
* Mistakes corrected, new error messages addedGalina Shalygina2017-08-291-2/+9
|
* Summarized results of two previous commits (26 July, 25 August)Galina Shalygina2017-08-291-31/+539
|
* New structure Table Value Constructor added in grammar.Galina Shalygina2017-06-291-0/+128
TVC can be used in UNION-statement, in view and in subquery. Files where TVC is defined and its methods are stored added. Methods exec and prepare for TVC added. Tests for TVC added.