into  mysql.com:/home/mydev/mysql-5.0-bug10932

into  mysql.com:/home/dlenev/src/mysql-5.0-merges

into  mysql.com:/home/dlenev/src/mysql-5.0-merges

into  mysql.com:/home/mydev/mysql-5.0-bug10932

into  mysql.com:/home/dlenev/src/mysql-5.0-merges

into  mysql.com:/home/dlenev/src/mysql-5.0-merges

into  mysql.com:/home/jimw/my/mysql-5.0-release

into  mysql.com:/opt/local/work/mysql-5.0-root

into  mysql.com:/home/dlenev/src/mysql-5.0-merges

into  mysql.com:/home/alik/Documents/AllProgs/MySQL/devel/5.0-sp-vars-merge-2

according to the standard.

The idea is to use Field-classes to implement stored routines
variables. Also, we should provide facade to Item-hierarchy
by Item_field class (it is necessary, since SRVs take part
in expressions).

The patch fixes the following bugs:
  - BUG#8702: Stored Procedures: No Error/Warning shown for inappropriate data 
    type matching; 
 
  - BUG#8768: Functions: For any unsigned data type, -ve values can be passed 
    and returned; 
 
  - BUG#8769: Functions: For Int datatypes, out of range values can be passed 
    and returned; 
 
  - BUG#9078: STORED PROCDURE: Decimal digits are not displayed when we use 
    DECIMAL datatype; 
 
  - BUG#9572: Stored procedures: variable type declarations ignored; 
 
  - BUG#12903: upper function does not work inside a function; 
 
  - BUG#13705: parameters to stored procedures are not verified; 
 
  - BUG#13808: ENUM type stored procedure parameter accepts non-enumerated
    data; 
 
  - BUG#13909: Varchar Stored Procedure Parameter always BINARY string (ignores 
    CHARACTER SET); 
 
  - BUG#14161: Stored procedure cannot retrieve bigint unsigned;

  - BUG#14188: BINARY variables have no 0x00 padding;

  - BUG#15148: Stored procedure variables accept non-scalar values;

current SP tables locking make impossible view security" with main tree.

into  mysql.com:/data0/mysqldev/my/mysql-5.0

into  mysql.com:/space/my/mysql-5.0

into  mysql.com:/home/dlenev/src/mysql-5.0-bg11555-2

into  mysql.com:/space/my/mysql-5.0

into  mysql.com:/home/dlenev/src/mysql-5.0-bg11555-2

into  mysql.com:/space/my/mysql-5.0-merg

impossible view security".

We should not expose names of tables which are explicitly or implicitly (via
routine or trigger) used by view even if we find that they are missing.
So during building of list of prelocked tables for statement we track which
routines (and therefore tables for these routines) are used from views. We
mark elements of LEX::routines set which correspond to routines used in views
by setting Sroutine_hash_entry::belong_to_view member to point to TABLE_LIST
object for topmost view which uses routine. We propagate this mark to all
routines which are used by this routine and which we add to this set. We also
mark tables used by such routine which we add to the list of tables for
prelocking as belonging to this view.

into  mysql.com:/home/mydev/mysql-5.0-bug10932

into  mysql.com:/home/timka/mysql/src/5.0-2486

into  mysql.com:/space/my/mysql-4.1

into  mysql.com:/home/jimw/my/mysql-5.0-clean

statement that generated a warning. (Bug #15510)

into  mysql.com:/home/jimw/my/mysql-5.0-clean

 prepared statement execute

into serg.mylan:/usr/home/serg/Abk/mysql-5.0

into  mysql.com:/home/alexi/innodb-ss/mysql-5.0-ss52

 to crash".
 Changes from snapshot innodb-5.0-ss52.
 Note that buf_block_t::index should be protected by btr_search_latch
 or an s-latch or x-latch on the index page.
 btr_search_drop_page_hash_index(): Read block->index while holding
 btr_search_latch and use the cached value in the loop. Remove some
 redundant assertions.
 Also fix 13778. When FOREIGN_KEY_CHECKS=0 we still need to check that
 datatypes between foreign key references are compatible.
 Also added test cases to 9802.

into  mysql.com:/home/mydev/mysql-5.0-bug10932

into  mysql.com:/home/timka/mysql/src/5.0-2486

Changed variable type and added comment in sp.c.