summaryrefslogtreecommitdiff
path: root/sql/sql_derived.cc
Commit message (Collapse)AuthorAgeFilesLines
* Patch two (the final one) for Bug#7306 "the server side preparedStatementkonstantin@mysql.com2005-06-071-5/+3
| | | | | | | error for LIMIT placeholder". The patch adds grammar support for LIMIT ?, ? and changes the type of ST_SELECT_LEX::select_limit,offset_limit from ha_rows to Item*, so that it can point to Item_param.
* Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0bell@sanja.is.com.ua2005-04-011-3/+6
|\ | | | | | | into sanja.is.com.ua:/home/bell/mysql/bk/work-multi-5.0
| * fixed mechanism of detection selection from table wich we updatebell@sanja.is.com.ua2005-03-281-3/+6
| | | | | | | | | | (BUG##9398, BUG#8703) fixed wrong join view detection in multi-delete which lead to server crash
* | 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-1/+1
|\ \ | |/ |/|
| * fixed union types merging and table related metadata (BUG#8824)bell@sanja.is.com.ua2005-03-231-2/+2
| |
* | Merge with 4.1monty@mysql.com2005-02-221-1/+7
|\ \ | |/
| * removed wrong distinct UNION detection (BUG#6565)bell@sanja.is.com.ua2005-02-141-2/+8
| |
* | WL#2130: Table locking for stored FUNCTIONspem@mysql.comhem.se2005-02-081-0/+5
| | | | | | | | | | | | | | Collect all tables and SPs refered by a statement, and open all tables with an implicit LOCK TABLES. Do find things refered by triggers and views, we open them first (and then repeat this until nothing new is found), before doing the actual lock tables.
* | First stage of table definition cachemonty@mysql.com2005-01-061-3/+3
| | | | | | | | | | | | | | | | | | | | Split TABLE to TABLE and TABLE_SHARE (TABLE_SHARE is still allocated as part of table, will be fixed soon) Created Field::make_field() and made Field_num::make_field() to call this Added 'TABLE_SHARE->db' that points to database name; Changed all usage of table_cache_key as database name to use this instead Changed field->table_name to point to pointer to alias. This allows us to change alias for a table by just updating one pointer. Renamed TABLE_SHARE->real_name to table_name Renamed TABLE->table_name to alias Renamed TABLE_LIST->real_name to table_name
* | Merge with 4.1monty@mishka.local2004-12-221-1/+0
|\ \ | |/
| * 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.
* | Small cleanup of derived tables handling.dlenev@brandersnatch.localdomain2004-12-191-5/+0
| | | | | | | | | | | | | | We should not call free_tmp_table() for derived table in mysql_derived_filling(), since by this moment this table is already registered in THD::derived_tables list and thus free_tmp_table() will be called for it automatically in close_thread_tables().
* | Fix for bug#7212: information_schema: "Can't find file" errors if storage ↵gluh@gluh.mysql.r18.ru2004-12-161-0/+12
| | | | | | | | engine gone(after review)
* | After merge fixesmonty@mysql.com2004-12-061-3/+3
| | | | | | | | | | Fixed compiler warnings Fix core dump when sending SIGHUP to mysqld
* | new lock for multiupdate:bell@sanja.is.com.ua2004-11-051-101/+135
| | | | | | | | | | | | | | - open and create derived tables - detect which tables should be locked for write - lock and fill derived tables some unitialized variables fixed
* | merge with 4.1monty@mysql.com2004-10-291-0/+3
|\ \ | |/
| * 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.
* | memory leaks fixedbell@sanja.is.com.ua2004-09-041-3/+5
| |
* | VIEWbell@sanja.is.com.ua2004-07-161-12/+10
| | | | | | | | two TABLE_LIST copy eliminated
* | Merge with 4.1.3-betamonty@mysql.com2004-07-071-1/+0
|\ \ | |/
| * Unused variables removed (many files).konstantin@mysql.com2004-06-211-1/+0
| |
* | PS and SP made compatible in mechanism used for preparing query for ↵bell@sanja.is.com.ua2004-05-201-1/+1
|/ | | | rexecutions (Bug #2266)
* 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
| |\
View Lorry Controller Status