summaryrefslogtreecommitdiff
path: root/sql/sql_view.cc
Commit message (Collapse)AuthorAgeFilesLines
* Fix for bug #9841 "Unexpected read lock when trying to update a view indlenev@brandersnatch.localdomain2005-05-051-14/+15
| | | | | | | | a stored procedure" (version 2). To handle updates and inserts into view in SP properly we should set lock types for tables of the view's main select when we are opening view for prelocking purproses.
* Fix for BUG#10107: Memory leak in view over subquery:sergefp@mysql.com2005-04-231-2/+4
| | | | | | In mysql_make_view when joining subquery lists, take into account that both lists can have length > 1 (see also fix for BUG#8490) (note to bk trigger: this commit is about BUG#10107)
* Fix for BUG#8490: In mysql_make_view for join algorithm views we need sergefp@mysql.com2005-04-231-3/+11
| | | | | | to insert view's subqueries into select_lex->slave(->next)* chain. In case a join has several such views, don't add the same subqueries several times (this forms a loop on the above chain which breaks many parts of the code)
* Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0bell@sanja.is.com.ua2005-04-031-6/+6
|\ | | | | | | into sanja.is.com.ua:/home/bell/mysql/bk/work-multi-5.0
| * postreview patchbell@sanja.is.com.ua2005-04-021-4/+4
| |
| * fix of required privileges for altering view VIEW (DELETE->DROP) (BUG#9260)bell@sanja.is.com.ua2005-04-021-3/+3
| |
* | - stackoverflow check added for view of view processingbell@sanja.is.com.ua2005-04-031-4/+4
|/ | | | | - fixed bug in join view processing - postreview fixes (BUG#9398 & BUG#8703)
* postmerge 4.1->5.0 fixesbell@sanja.is.com.ua2005-04-011-1/+1
|
* Fix for memory leak which was introduced by patch improving locking in SP.dlenev@brandersnatch.localdomain2005-03-041-0/+1
| | | | | Made mysql_make_view() to call destructor for st_lex_local objects before throwing them away (this happens in case of error).
* Manual merge SP-locking improvements patch with current tree.dlenev@mysql.com2005-03-041-42/+30
|\
| * Better approach for prelocking of tables for stored routines executiondlenev@brandersnatch.localdomain2005-03-041-42/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | and some SP-related cleanups. - We don't have separate stage for calculation of list of tables to be prelocked and doing implicit LOCK/UNLOCK any more. Instead we calculate this list at open_tables() and do implicit LOCK in lock_tables() (and UNLOCK in close_thread_tables()). Also now we support cases when same table (with same alias) is used several times in the same query in SP. - Cleaned up execution of SP. Moved all common code which handles LEX and does preparations before statement execution or complex expression evaluation to auxilary sp_lex_keeper class. Now all statements in SP (and corresponding instructions) that evaluate expression which can contain subquery have their own LEX.
* | Mergebell@sanja.is.com.ua2005-02-091-0/+3
|\ \ | |/ |/|
| * fixed QC invaluidation and processing with view (BUG#8050) (BUG#8054)bell@sanja.is.com.ua2005-01-271-0/+3
| |
* | WL#2130: Table locking for stored FUNCTIONspem@mysql.comhem.se2005-02-081-18/+23
|/ | | | | | | 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.
* Fix accesses to uninitialized memory (found by valgrind)monty@mysql.com2005-01-131-2/+3
|
* Merge bk-internal.mysql.com:/home/bk/mysql-5.0monty@mysql.com2005-01-061-21/+21
|\ | | | | | | into mysql.com:/home/my/mysql-5.0
| * First stage of table definition cachemonty@mysql.com2005-01-061-21/+21
| | | | | | | | | | | | | | | | | | | | 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
* | fixed bugs in view code with prepared statemntsbell@sanja.is.com.ua2005-01-041-12/+12
|/
* After merge fixesmonty@mysql.com2004-12-311-1/+0
|
* After merge fixesmonty@mysql.com2004-12-061-2/+3
| | | | | Fixed compiler warnings Fix core dump when sending SIGHUP to mysqld
* fixed redifinition of variablebell@sanja.is.com.ua2004-11-261-1/+1
|
* spelling fixed/comments added (postreview fixes)bell@sanja.is.com.ua2004-11-251-1/+1
|
* post-merge fixbell@sanja.is.com.ua2004-11-251-6/+7
|
* mergebell@sanja.is.com.ua2004-11-211-32/+78
|\
| * mergebell@sanja.is.com.ua2004-11-111-32/+79
| |\
| | * mergebell@sanja.is.com.ua2004-10-071-25/+45
| | |\
| | * \ mergebell@sanja.is.com.ua2004-10-051-28/+78
| | |\ \
| | | * | support of join view updateability (WL#1809)bell@sanja.is.com.ua2004-09-151-21/+32
| | | | |
| | | * | fixed merged view fields names (BUG#5147)bell@sanja.is.com.ua2004-09-141-26/+65
| | | | | | | | | | | | | | | | | | | | support of merged VIEW over several tables added (WL#1809)
* | | | | mergebell@sanja.is.com.ua2004-11-211-1/+28
|\ \ \ \ \
| * | | | | VIEW support for CHECK TABLE command (WL#1984)bell@sanja.is.com.ua2004-10-281-1/+28
| | | | | |
* | | | | | changed field names, fields order according to WL descriptiongluh@gluh.mysql.r18.ru2004-11-201-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | fixed bug: "create view v7 as select * from information_schema.tables;" failed
* | | | | | fixing compiler warningsbell@sanja.is.com.ua2004-11-171-2/+5
| | | | | |
* | | | | | margebell@sanja.is.com.ua2004-11-131-48/+35
|\ \ \ \ \ \
| * | | | | | now my_printf_error is not better then my_error, but my_error call is shorterbell@sanja.is.com.ua2004-11-131-34/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | used only one implementation of format parser of (printf) fixed multistatement
| * | | | | | mergebell@sanja.is.com.ua2004-11-121-41/+47
| |\ \ \ \ \ \ | | |_|/ / / / | |/| | | | |
| | * | | | | post-review fixesbell@sanja.is.com.ua2004-11-121-13/+23
| | |/ / / /
| | * | | | errors without code removedbell@sanja.is.com.ua2004-10-201-28/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | net_printf/send_error calls replaced by my_error family functions -1/1 (sent/unsent) error reporting removed (WL#2133)
* | | | | | WL#1629: SHOW with WHERE(partially) &gluh@gluh.mysql.r18.ru2004-11-131-2/+3
|/ / / / / | | | | | | | | | | | | | | | WL#173: Create Data Dictionary Tables for SHOW Commands
* | | | | Merge bk-internal.mysql.com:/home/bk/mysql-5.0monty@mysql.com2004-11-091-4/+4
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | into mysql.com:/home/my/mysql-5.0
| * | | | | After merge fixesmonty@mysql.com2004-11-091-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added push_back(void *, MEM_ROOT *) to make some list-handling code easier that needs to be allocated in a different mem-root (Before one had to change thd->mem_root ; push_back(); restore mem_root.
* | | | | | Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0bell@sanja.is.com.ua2004-11-061-4/+5
|\ \ \ \ \ \ | |/ / / / / | | | | | | | | | | | | into sanja.is.com.ua:/home/bell/mysql/bk/work-view-5.0
| * | | | | Fixes after merge with 4.1monty@mysql.com2004-11-031-4/+5
| |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FOUND is not a reserved keyword anymore Added Item_field::set_no_const_sub() to be able to mark fields that can't be substituted Added 'simple_select' method to be able to quickly determinate if a select_result is a normal SELECT Note that the 5.0 tree is not yet up to date: Sanja will have to fix multi-update-locks for this merge to be complete
* | | | | fixed detection of updating table on which we select (BUG#6032)bell@sanja.is.com.ua2004-10-251-10/+30
|/ / / /
* | | | allow merging views with subqueries in WHERE clause (BUG#5504)bell@sanja.is.com.ua2004-10-071-2/+20
| | | |
* | | | test of DELETE privilege and cyclic reference added in case of altering view ↵bell@sanja.is.com.ua2004-10-071-5/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | (BUG#5148) fixed ALTER VIEW syntax fixed WITH CHECK OPTION clause printing in SHOW CREATE VIEW
* | | | sql_updatable_view_key replaced with updatable_views_with_limitbell@sanja.is.com.ua2004-10-071-23/+19
| |_|/ |/| | | | | | | | | | | | | | now default behaviour do not prevent any updates of view. Also updating VIEWs of queries without LIMIT clause will not be checked at all (there will not be even warning) (changes according to discussion on last dev-conf)
* | | fixed & added comments (according to Igor's review and a bit more)bell@sanja.is.com.ua2004-10-071-23/+45
|/ /
* | mergebell@sanja.is.com.ua2004-09-291-7/+18
|\ \
| * | post review changes:bell@sanja.is.com.ua2004-09-291-3/+3
| | | | | | | | | | | | | | | CHECK OPTION moved to one function view name added to error messages
View Lorry Controller Status