summaryrefslogtreecommitdiff
path: root/sql/sql_derived.cc
Commit message (Collapse)AuthorAgeFilesLines
* fixed union types merging and table related metadata (BUG#8824)bell@sanja.is.com.ua2005-03-231-2/+2
|
* removed wrong distinct UNION detection (BUG#6565)bell@sanja.is.com.ua2005-02-141-2/+8
|
* Fix for bug #6765 "Implicit access to time zone description dlenev@brandersnatch.localdomain2004-12-091-1/+0
| | | | | | | | | | tables requires privileges for them if some table or column level grants present" (with after-review fixes). We should set SELECT_ACL for implicitly opened tables in my_tz_check_n_skip_implicit_tables() to be able to bypass privilege checking in check_grant(). Also we should exclude those tables from privilege checking in multi-update.
* postreview fixes (BUG#5618 & BUG#5590)bell@sanja.is.com.ua2004-09-251-1/+1
|
* fixed error handling if creating derived table failedbell@sanja.is.com.ua2004-09-171-0/+3
| | | | single row subquery always can return NULL (no rows found) (BUG#5590)
* memory leak fixedbell@sanja.is.com.ua2004-09-051-3/+5
|
* Fix for bug#4912 "mysqld crashs in case a statement is executedkonstantin@mysql.com2004-08-211-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | a second time". The bug was caused by incompatibility of negations elimination algorithm and PS: during first statement execute a subtree with negation was replaced with equivalent subtree without NOTs. The problem was that although this transformation was permanent, items of the new subtree were created in execute-local memory. The patch adds means to check if it is the first execute of a prepared statement, and if this is the case, to allocate items in memory of the prepared statement. The implementation: - backports Item_arena from 5.0 - adds Item_arena::is_stmt_prepare(), Item_arena::is_first_stmt_execute(). - deletes THD::allocate_temporary_pool_for_ps_preparing(), THD::free_temporary_pool_for_ps_preparing(); they were redundant. and adds a few invariants: - thd->free_list never contains junk (= freed items) - thd->current_arena is never null. If there is no prepared statement, it points at the thd. The rest of the patch contains mainly mechanical changes and cleanups.
* Unused variables removed (many files).konstantin@mysql.com2004-06-211-1/+0
|
* fixed subquery in the FROM clause with parameter (BUG#3020)bell@sanja.is.com.ua2004-04-081-29/+35
|
* Fixed many compiler warningsmonty@mysql.com2004-04-051-1/+0
| | | | | | Fixed bugs in group_concat with ORDER BY and DISTINCT (Bugs #2695, #3381 and #3319) Fixed crash when doing rollback in slave and the io thread catched up with the sql thread Set locked_in_memory properly
* correct support for a mix of UNION/UNION ALL in the same query.serg@serg.mylan2004-03-231-1/+1
| | | | Bug#1428
* DBUG_ASSERT(fixed == 0) added to fix_fields()bell@sanja.is.com.ua2004-03-171-1/+5
|
* after merge & valgrind test fixes (BUG#2120)bell@sanja.is.com.ua2004-02-101-0/+2
|
* ufter revview fix (BUG#2120)bell@sanja.is.com.ua2004-02-091-8/+8
|
* make JOIN::prepare, JOIN::optimize only once for EXPLAIN of derived tablebell@sanja.is.com.ua2004-02-011-0/+9
| | | | (BUG#2120 sfter merge)
* now all tables of query are locked in one place (including derived tables)bell@sanja.is.com.ua2004-02-011-127/+110
| | | | fixed BUG#2120 and other problem with EXPLAINing derived tables
* Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1bell@sanja.is.com.ua2004-01-171-8/+11
|\ | | | | | | into sanja.is.com.ua:/home/bell/mysql/bk/work-insert-4.1
| * assigned correct lex->current_select for derived tables (BUG#2349)bell@sanja.is.com.ua2004-01-141-8/+11
| | | | | | | | moved LIMIT initialialization, because it is need only for single select derived table
* | Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1bell@sanja.is.com.ua2004-01-171-0/+3
|\ \ | | | | | | | | | into sanja.is.com.ua:/home/bell/mysql/bk/work-ft_derived-4.1
| * | As far as we cut off derived table branch, we have to close JOINs (BUG#2141)bell@sanja.is.com.ua2004-01-061-0/+3
| |/ | | | | | | (test case is absend because it is multi-thread and very big)
* | fixed unlocking tables during subquery execution (BUG#2048)bell@sanja.is.com.ua2003-12-101-1/+1
|/
* Mergemonty@mysql.com2003-11-281-3/+3
|\
| * Added missing SSL library (Should be in source distribution)monty@mysql.com2003-11-281-7/+6
| | | | | | | | | | | | | | Fixed compiler warnings (a lot of hidden variables detected by the Forte compiler) Added a lot of 'version_xxx' strings to 'show variables' Prevent copying of TMP_TABLE_PARAM (This caused core dump bug on Solaris) Fixed problem with printing sub selects to debug log
* | removed unused variablebell@sanja.is.com.ua2003-11-271-2/+1
| |
* | avoiding coping tmptable_parambell@sanja.is.com.ua2003-11-261-5/+4
|/
* after review fixesbell@sanja.is.com.ua2003-11-231-1/+1
|
* Fixed UNION fields type/length detectingbell@sanja.is.com.ua2003-11-231-86/+66
|
* Mergebell@sanja.is.com.ua2003-10-221-4/+0
|\
| * subqueries made printablebell@sanja.is.com.ua2003-10-161-4/+0
| | | | | | | | | | new EXPLAIN parameter to show real query as it was interpreted (SCRUM) (WL#1274)
* | fixed deleting derived table tree after using (BUG#1536)bell@sanja.is.com.ua2003-10-171-1/+1
|/
* Mergebell@laptop.sanja.is.com.ua2003-10-061-6/+8
|\
| * Mergehf@deer.(none)2003-09-261-3/+7
| |\
| | * SCRUM:hf@deer.(none)2003-09-261-3/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | WL#604 Privileges in embedded library code added to check privileges in embedded library NO_EMBEDDED_ACCESS_CHECKS macros inserted in code so we can exclude access-checking parts. Actually we now can exclude these parts from standalone server as well. Do we need it? Access checks are disabled in embedded server by default. One should edit libmysqld/Makefile manually to get this working. We definitely need the separate configure for embedded server
| * | Remove 'extern' references from .cc filesmonty@mashka.mysql.fi2003-09-131-2/+0
| |/
| * Fix for bug 1176gluh@gluh.mysql.r18.ru2003-09-041-1/+1
| |
* | fixed bug of lack of fix_fields call (after merge bugfix (SCRUM))bell@laptop.sanja.is.com.ua2003-08-231-0/+3
|/ | | | | | fixed bug in Item_sum fixed bug in dependence remover after merge fix
* Code cleanupbell@laptop.sanja.is.com.ua2003-08-161-5/+3
|
* Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1bell@sanja.is.com.ua2003-08-131-1/+2
|\ | | | | | | into sanja.is.com.ua:/home/bell/mysql/bk/work-simple_in-4.1
| * fixed problem with reference on derived table fields (BUG#1031)bell@sanja.is.com.ua2003-08-121-1/+2
| |
* | mergebell@sanja.is.com.ua2003-08-111-0/+10
|\ \ | |/
| * mergeSinisa@sinisa.nasamreza.org2003-08-061-0/+10
| |\
| | * MergeSinisa@sinisa.nasamreza.org2003-07-191-0/+10
| | |\
| | | * Derived tables bug fix .......Sinisa@sinisa.nasamreza.org2003-06-121-2/+10
| | | |
| | | * Merge sinisa@bk-internal.mysql.com:/home/bk/mysql-4.1Sinisa@sinisa.nasamreza.org2003-05-311-0/+2
| | | |\ | | | | | | | | | | | | | | | into sinisa.nasamreza.org:/mnt/work/mysql-4.1
| | | | * Fix for the optimiser problem caused by the fact that with derivedSinisa@sinisa.nasamreza.org2003-05-311-0/+2
| | | | | | | | | | | | | | | | | | | | tables one (or more tables) is opened / closed twice.
* | | | | mergebell@sanja.is.com.ua2003-08-051-1/+2
|\ \ \ \ \ | |/ / / /
| * | | | count HAVING clause elements with select list elements, because agregate ↵bell@sanja.is.com.ua2003-07-291-1/+2
| |/ / / | | | | | | | | | | | | | | | | | | | | function can be present in it (BUG#922) removerd unused loop_id
* | | | (SCRUM)bell@sanja.is.com.ua2003-07-031-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | It looks like samll revolution in SELECT_LEX tree, but it was only natural way to solve problem with name resolution of external fields inside subselect which belongs to global order of union also it have following advantages: - removed mess with current_select type conversion - type checking/converting - a lot of virtual methods - fake select for union execution allocated only once (it was allocated for every subselect with union executing) changes: fixed bug with outer fields name resolution of subqueries which belong to global ORDER BY clause remuved select_lex() function, now thd->lex.current_select always have type SELECT_LEX new SELECT_LEX (fake_select_lex) will be allocated in case of UNION for using in UNION processing fake_select_lex allocated for union hold global ORDER BY & LIMIT clauses and have linkage equal to GLOBAL_OPTIONS_TYPE new description of SELECT_LEX tree (SCRUM)
* | | | mergedbell@sanja.is.com.ua2003-06-251-1/+1
|\ \ \ \ | |/ / /
| * | | mergingbell@sanja.is.com.ua2003-05-261-1/+1
| |\ \ \ | | |/ / | |/| |