summaryrefslogtreecommitdiff
path: root/mysql-test/t/table_value_constr.test
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-1046/+0
|
* Fixed mdev-14281 Wrong result from query with NOT IN predicate in WHEREIgor Babaev2017-11-051-1/+1
| | | | | | | 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.
* Mistakes corrected.Galina Shalygina2017-10-281-11/+181
| | | | | 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-0/+21
|
* Summarized results of two previous commits (26 July, 25 August)Galina Shalygina2017-08-291-100/+711
|
* Queries where TVCs are used are processed successufully.Galina Shalygina2017-07-261-0/+244
TVCs can be used separately, with UNION/UNION ALL, in derived tables, in views and in common table expressions. Tests corrected. Test results added.