summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect.test
Commit message (Collapse)AuthorAgeFilesLines
* Fix for bug #18306: MySQL crashes and restarts using subqueryramil@mysql.com2006-03-231-0/+11
|
* Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0evgen@sunlight.local2006-03-141-0/+7
|\ | | | | | | into sunlight.local:/work_local/17336-bug-5.0-mysql
| * Fixed bug#17366: Unchecked Item_int results in server crashevgen@sunlight.local2006-03-131-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | When there is conjunction of conds, the substitute_for_best_equal_field() will call the eliminate_item_equal() function in loop to build final expression. But if eliminate_item_equal() finds that some cond will always evaluate to 0, then that cond will be substituted by Item_int with value == 0. In this case on the next iteration eliminate_item_equal() will get that Item_int and treat it as Item_cond. This is leads to memory corruption and server crash on cleanup phase. To the eliminate_item_equal() function was added DBUG_ASSERT for checking that all items treaten as Item_cond are really Item_cond. The substitute_for_best_equal_field() now checks that if eliminate_item_equal() returns Item_int and it's value is 0 then this value is returned as the result of whole conjunction.
* | Fixes to embedded server to be able to run tests with itmonty@mysql.com2006-02-241-6/+0
|/ | | | (Needed for "list of pushes" web page and autopush)
* Fixed bug #16603.igor@rurik.mysql.com2006-02-131-0/+22
| | | | | | A subquery transformation changes the HAVING clause of the embedding query if the subquery contains a GROUP BY clause. Yet the split_sum_func2 function was not applied to the modified HAVING clause. This could result in wrong answers.
* Fixed bug #12762:igor@rurik.mysql.com2005-10-151-0/+83
| | | | allowed set functions aggregated in outer subqueries, allowed nested set functions.
* fixes after merge of 4.1.guilhem@mysql.com2005-10-131-3/+2
|
* Merge mysql.com:/home/mysql_src/mysql-4.1guilhem@mysql.com2005-10-121-2/+8
|\ | | | | | | | | into mysql.com:/home/mysql_src/mysql-5.0; a very bad automerge (issues with non-ascii chars), plus some hard conflicts I'll fix by hand in a next cset
| * sql_yacc.yy:grog@mysql.com2005-10-121-0/+6
| | | | | | | | | | | | | | | | Bug #10308: Parse 'purge master logs' with subselect correctly. subselect.test: Bug #10308: Test for 'purge master logs' with subselect. subselect.result: Bug #10308: Test result for 'purge master logs' with subselect.
* | WL#2486 - natural and using join according to SQL:2003timour@mysql.com2005-08-231-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | * Provide backwards compatibility extension to name resolution of coalesced columns. The patch allows such columns to be qualified with a table (and db) name, as it is in 4.1. Based on a patch from Monty. * Adjusted tests accordingly to test both backwards compatible name resolution of qualified columns, and ANSI-style resolution of non-qualified columns. For this, each affected test has two versions - one with qualified columns, and one without.
* | Manual mergeigor@rurik.mysql.com2005-08-151-0/+18
|\ \ | |/
| * subselect.result:igor@rurik.mysql.com2005-08-151-0/+2
| | | | | | | | | | | | Added missing drop statement subselect.test: Added missing drop statement.
| * sql_select.cc:igor@rurik.mysql.com2005-08-151-0/+16
| | | | | | | | | | | | | | | | | | | | Fixed bug #11479. The JOIN::reinit method cannot call setup_tables after the optimization phase since this function removes some optimization settings for joined tables. E.g. it resets values of the null_row flag to 0. subselect.result, subselect.test: Added a test case for bug #11479.
* | Merge abelkin@bk-internal.mysql.com:/home/bk/mysql-4.1sanja@hasky.mysql.fi2005-08-131-1/+12
|\ \ | |/ | | | | into hasky.mysql.fi:/home/sanja/work-merge-5.0
| * fixed convertion and handling IN subqueries with rows (BUG#11867)bell@50.0.168.192.in-addr.arpa2005-08-131-1/+12
| |
* | Merge mysql.com:/home/timka/mysql/src/5.0-virgintimour@mysql.com2005-08-121-4/+4
|\ \ | | | | | | | | | into mysql.com:/home/timka/mysql/src/5.0-2486-merge
| * | Implementation of WL#2486 -timour@mysql.com2005-08-121-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | "Process NATURAL and USING joins according to SQL:2003". * Some of the main problems fixed by the patch: - in "select *" queries the * expanded correctly according to ANSI for arbitrary natural/using joins - natural/using joins are correctly transformed into JOIN ... ON for any number/nesting of the joins. - column references are correctly resolved against natural joins of any nesting and combined with arbitrary other joins. * This patch also contains a fix for name resolution of items inside the ON condition of JOIN ... ON - in this case items must be resolved only against the JOIN operands. To support such 'local' name resolution, the patch introduces a stack of name resolution contexts used at parse time. NOTICE: - This patch is not complete in the sense that - there are 2 test cases that still do not pass - one in join.test, one in select.test. Both are marked with a comment "TODO: WL#2486". - it does not include a new test specific for the task
* | | Merge xiphis.org:/usr/home/antony/work2/mysql-4.1acurtis@xiphis.org2005-08-111-0/+15
|\ \ \ | | |/ | |/| | | | into xiphis.org:/usr/home/antony/work2/merge-5.0
| * | Merge rurik.mysql.com:/home/igor/mysql-4.1igor@rurik.mysql.com2005-08-081-0/+11
| |\ \ | | | | | | | | | | | | into rurik.mysql.com:/home/igor/dev/mysql-4.1-0
| | * | subselect.test, subselect.result:igor@rurik.mysql.com2005-08-081-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added a test case for bug #12392. item_cmpfunc.cc: Fixed bug #12392. Missing handling of rows containing NULL components when evaluating IN predicates caused a crash.
| * | | Review of new pushed codemonty@mysql.com2005-08-091-0/+4
| |/ / | | | | | | | | | | | | | | | - Fixed some error condtion when handling dates with 'T' - Added extra test for bug #11867 (Wrong result with "... WHERE ROW( a, b ) IN ( SELECT DISTINCT a, b WHERE ...)" to show it's not yet fixed - Safety fixes and cleanups
* | | Manual mergeigor@rurik.mysql.com2005-08-071-1/+49
|\ \ \ | |/ / | | / | |/ |/|
| * subselect.result:igor@rurik.mysql.com2005-08-071-0/+15
| | | | | | | | | | | | | | | | | | | | | | | | Added test case for bug #11867. Fixed results for two existing test cases. subselect.test: Added test case for bug #11867. item_subselect.cc: Fixed bug #11867. Added missing code in Item_in_subselect::row_value_transformer that caused problems for queries with ROW(elems) IN (SELECT DISTINCT cols FROM ...).
* | Merge mysql.com:/home/my/mysql-4.1monty@mysql.com2005-07-281-0/+2
|\ \ | |/ | | | | into mysql.com:/home/my/mysql-5.0
| * Added end marker for tests to make future merges easiermonty@mysql.com2005-07-281-0/+2
| |
* | Fix for BUG#11821 manually mergedsergefp@mysql.com2005-07-121-0/+8
|\ \ | |/
| * Fix for BUG#11821: Make Item_type_holder be able to work with MIN(field), sergefp@mysql.com2005-07-121-0/+8
| | | | | | | | MAX(field).
* | opt_range.cc:igor@rurik.mysql.com2005-06-231-0/+22
| | | | | | | | | | | | | | | | | | Fixed buf #11487. Added a call of QUICK_RANGE_SELECT::init to the QUICK_RANGE_SELECT::reset method. Without it the second evaluation of a subquery employing the range access failed. subselect.result, subselect.test: Added a test case for bug #11487.
* | Add missing test resultmonty@mysql.com2005-05-201-1/+2
| |
* | do not try to use equal field from outer query as field of local join (BUG#6384)bell@sanja.is.com.ua2005-05-201-1/+15
| |
* | Resolve merge from 4.1jimw@mysql.com2005-05-181-0/+23
|\ \ | |/
| * relaxed DBUG_ASSERT in Item_int_with_ref::new_item() to "any constant" ↵bell@book.sanja.is.com.ua2005-05-161-0/+24
| | | | | | | | (BUG#10020)
* | subselect.result, subselect.test:igor@rurik.mysql.com2005-04-151-0/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | Added a test case for bug #9516. item_subselect.h: Fixed bug #9516. The bug was due to that fact that the class Item_subselect inherited the generic implementation of the function not_null_tables that was not valid for the objects of this class. As a result evaluation of the not_null_tables attribute was not correct for subqueries. This caused invalid transformations of outer joins into inner joins.
* | subselect.result, subselect.test:igor@rurik.mysql.com2005-04-151-0/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added a test case for bug #9338. sql_select.cc: Fixed bug #9338. When an occurence of a field reference has to be replaced by another field reference the whole Item_field must be replaced. item.cc: Fixed bug #9338. The method Item_field::replace_equal_field_processor was replaced by Item_field::replace_equal_field. The new method is used to replace the occurences of Item_field objects. item.h: Fixed bug #9338. The virtual function replace_equal_field_processor was replaced by replace_equal_field. The latter is supposed to be used as a callback function in calls of the method transform.
* | Merge bk-internal.mysql.com:/home/bk/mysql-5.0monty@mysql.com2005-04-011-2/+2
|\ \ | | | | | | | | | into mysql.com:/home/my/mysql-5.0
| * | Invalid DEFAULT values for CREATE TABLE now generates errors. (Bug #5902)monty@mysql.com2005-04-011-2/+2
| | | | | | | | | | | | | | | | | | CAST() now produces warnings when casting a wrong INTEGER or CHAR values. This also applies to implicite string to number casts. (Bug #5912) ALTER TABLE now fails in STRICT mode if it generates warnings. Inserting a zero date in a DATE, DATETIME or TIMESTAMP column during TRADITIONAL mode now produces an error. (Bug #5933)
* | | postmerge 4.1->5.0 fixesbell@sanja.is.com.ua2005-04-011-1/+1
| | |
* | | merge 4.1->5.0bell@sanja.is.com.ua2005-03-311-2/+188
|\ \ \ | |/ / |/| / | |/
| * postreview changesbell@sanja.is.com.ua2005-03-301-0/+176
| | | | | | | | fixed bug in IN/ALL/ANY subqeries with HAVING clause (BUG#9350)
| * fixed left expression of IN/ALL/ANY subquery transformation support (BUG#8888)bell@sanja.is.com.ua2005-03-101-2/+10
| |
| * Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1sergefp@mysql.com2005-02-141-0/+101
| |\ | | | | | | | | | into mysql.com:/home/psergey/mysql-4.1-bug8218
* | | Tests modified to coved decimal-related codehf@deer.(none)2005-02-211-0/+23
| | |
* | | Merge mysql.com:/home/psergey/mysql-4.1-bug8218sergefp@mysql.com2005-02-141-0/+101
|\ \ \ | | |/ | |/| | | | into mysql.com:/home/psergey/mysql-5.0-bug8218
| * | Remove redundant DROP TABLE from test casesergefp@mysql.com2005-02-141-1/+0
| | |
| * | Fix for BUG#8218:sergefp@mysql.com2005-02-121-0/+102
| | | | | | | | | | | | | | | | | | Remove TMP_TABLE_PARAM::copy_funcs_it. TMP_TABLE_PARAM is a member of JOIN which is copied via memcpy, and List_iterator_fast TMP_TABLE_PARAM::copy_funcs_it ends up pointing to the wrong List.
* | | Merge with 4.1monty@mysql.com2005-02-101-29/+1
|\ \ \ | | |/ | |/|
| * | reverted patch for BUG#7351 (because of performance ussie)bell@sanja.is.com.ua2005-02-091-29/+1
| |/
* | Merge sanja.is.com.ua:/home/bell/mysql/bk/work-4.1bell@sanja.is.com.ua2005-02-061-14/+0
|\ \ | |/ | | | | into sanja.is.com.ua:/home/bell/mysql/bk/work-5.0
| * fixed test 'subselect' in case when innodb is not compiled in (thanks HF who ↵bell@sanja.is.com.ua2005-02-061-14/+0
| | | | | | | | niticed it)
* | 4.1 -> 5.0 mergemonty@mysql.com2005-02-031-0/+56
|\ \ | |/
View Lorry Controller Status