From: Tor Didriksen Date: June 9 2011 8:45am Subject: bzr commit into mysql-trunk branch (tor.didriksen:3170) Bug#12590211 List-Archive: http://lists.mysql.com/commits/138931 X-Bug: 12590211 Message-Id: <20110609084549.058F02A6@atum07.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============8816226366192118440==" --===============8816226366192118440== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///export/home/didrik/repo/trunk-bug11765255-arraycheck/ based on revid:olav.sandstaa@stripped 3170 Tor Didriksen 2011-06-09 Bug#12590211 - ADD BOUNDS CHECK ON REF_POINTER_ARRAY AND FRIENDS Cleanup the Item** and Item*** code for ref_pointer_array. Wrap the array(s) in a container, so we can do bounds checks. @ sql/item.cc Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item.h Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_cmpfunc.cc Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_cmpfunc.h Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_func.cc Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_func.h Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_row.cc Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_row.h Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_strfunc.cc Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_strfunc.h Introduce Ref_ptr_array for split_sum_funcN functions. @ sql/item_subselect.cc Don't use select_lex->ref_pointer_array, use the "slice" owned by the JOIN instance instead. @ sql/sql_array.h New, templatized, array class. @ sql/sql_derived.cc Remove ref_pointer_array from mysql_select() function signature. @ sql/sql_lex.cc In setup_ref_array(), add sanity check that that the size of ref_pointer_array does not change. @ sql/sql_parse.cc Remove ref_pointer_array from mysql_select() function signature. @ sql/sql_select.cc Changed several functions from xx_(.. Item ** ..) to xx_(.. Ref_ptr_array ..) Remove ref_pointer_array from mysql_select() function signature. @ sql/sql_select.h Document usage of ref_pointer_array. Change from Item** to Ref_ptr_array. Re-wrote setter functions. @ sql/sql_union.cc For UNION, the 'n_sum_items' are accumulated in the "global_parameters" select_lex. This number must be propagated to setup_ref_array() When preparing a 'fake_select_lex' we need to use global_parameters->order_list rather than fake_select_lex->order_list (see comments inside st_select_lex_unit::cleanup) @ unittest/gunit/bounds_checked_array-t.cc New unit test. added: unittest/gunit/bounds_checked_array-t.cc modified: sql/item.cc sql/item.h sql/item_cmpfunc.cc sql/item_cmpfunc.h sql/item_func.cc sql/item_func.h sql/item_row.cc sql/item_row.h sql/item_strfunc.cc sql/item_strfunc.h sql/item_subselect.cc sql/item_sum.cc sql/sql_array.h sql/sql_base.cc sql/sql_base.h sql/sql_derived.cc sql/sql_do.cc sql/sql_insert.cc sql/sql_lex.cc sql/sql_lex.h sql/sql_load.cc sql/sql_parse.cc sql/sql_prepare.cc sql/sql_select.cc sql/sql_select.h sql/sql_union.cc sql/sql_update.cc unittest/gunit/CMakeLists.txt === modified file 'sql/item.cc' --- a/sql/item.cc 2011-06-06 12:49:55 +0000 +++ b/sql/item.cc 2011-06-09 08:45:37 +0000 @@ -1489,7 +1489,7 @@ public: thd->fatal_error() may be called if we are out of memory */ -void Item::split_sum_func2(THD *thd, Item **ref_pointer_array, +void Item::split_sum_func2(THD *thd, Ref_ptr_array ref_pointer_array, List &fields, Item **ref, bool skip_registered) { @@ -1526,7 +1526,7 @@ void Item::split_sum_func2(THD *thd, Ite ref_pointer_array[el]= real_itm; if (!(item_ref= new Item_aggregate_ref(&thd->lex->current_select->context, - ref_pointer_array + el, 0, name))) + &ref_pointer_array[el], 0, name))) return; // fatal_error is set if (type() == SUM_FUNC_ITEM) item_ref->depended_from= ((Item_sum *) this)->depended_from(); @@ -4345,7 +4345,7 @@ resolve_ref_in_select_and_group(THD *thd return NULL; } DBUG_ASSERT((*select_ref)->fixed); - return (select->ref_pointer_array + counter); + return &select->ref_pointer_array[counter]; } if (group_by_ref) return group_by_ref; @@ -6233,13 +6233,13 @@ Item *Item_field::update_value_transform type() != Item::TRIGGER_FIELD_ITEM) { List *all_fields= &select->join->all_fields; - Item **ref_pointer_array= select->ref_pointer_array; + Ref_ptr_array &ref_pointer_array= select->ref_pointer_array; int el= all_fields->elements; Item_ref *ref; ref_pointer_array[el]= (Item*)this; all_fields->push_front((Item*)this); - ref= new Item_ref(&select->context, ref_pointer_array + el, + ref= new Item_ref(&select->context, &ref_pointer_array[el], table_name, field_name); return ref; } === modified file 'sql/item.h' --- a/sql/item.h 2011-06-09 06:22:39 +0000 +++ b/sql/item.h 2011-06-09 08:45:37 +0000 @@ -23,6 +23,7 @@ #include "unireg.h" // REQUIRED: for other includes #include "thr_malloc.h" /* sql_calloc */ #include "field.h" /* Derivation */ +#include "sql_array.h" class Protocol; struct TABLE_LIST; @@ -30,6 +31,7 @@ void item_init(void); /* Init item fun class Item_field; class user_var_entry; +typedef Bounds_checked_array Ref_ptr_array; static inline uint32 char_to_byte_length_safe(uint32 char_length_arg, uint32 mbmaxlen_arg) @@ -932,10 +934,11 @@ public: void print_item_w_name(String *, enum_query_type query_type); virtual void update_used_tables() {} - virtual void split_sum_func(THD *thd, Item **ref_pointer_array, + virtual void split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, List &fields) {} /* Called for items that really have to be split */ - void split_sum_func2(THD *thd, Item **ref_pointer_array, List &fields, + void split_sum_func2(THD *thd, Ref_ptr_array ref_pointer_array, + List &fields, Item **ref, bool skip_registered); virtual bool get_date(MYSQL_TIME *ltime,uint fuzzydate); virtual bool get_time(MYSQL_TIME *ltime); === modified file 'sql/item_cmpfunc.cc' --- a/sql/item_cmpfunc.cc 2011-06-09 06:22:39 +0000 +++ b/sql/item_cmpfunc.cc 2011-06-09 08:45:37 +0000 @@ -4591,7 +4591,7 @@ void Item_cond::traverse_cond(Cond_trave that have or refer (HAVING) to a SUM expression. */ -void Item_cond::split_sum_func(THD *thd, Item **ref_pointer_array, +void Item_cond::split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, List &fields) { List_iterator li(list); === modified file 'sql/item_cmpfunc.h' --- a/sql/item_cmpfunc.h 2011-06-09 06:22:39 +0000 +++ b/sql/item_cmpfunc.h 2011-06-09 08:45:37 +0000 @@ -1540,7 +1540,8 @@ public: table_map used_tables() const; void update_used_tables(); virtual void print(String *str, enum_query_type query_type); - void split_sum_func(THD *thd, Item **ref_pointer_array, List &fields); + void split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, + List &fields); friend int setup_conds(THD *thd, TABLE_LIST *tables, TABLE_LIST *leaves, Item **conds); void top_level_item() { abort_on_null=1; } === modified file 'sql/item_func.cc' --- a/sql/item_func.cc 2011-06-09 06:22:39 +0000 +++ b/sql/item_func.cc 2011-06-09 08:45:37 +0000 @@ -392,7 +392,7 @@ Item *Item_func::compile(Item_analyzer a See comments in Item_cmp_func::split_sum_func() */ -void Item_func::split_sum_func(THD *thd, Item **ref_pointer_array, +void Item_func::split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, List &fields) { Item **arg, **arg_end; === modified file 'sql/item_func.h' --- a/sql/item_func.h 2011-05-05 07:41:53 +0000 +++ b/sql/item_func.h 2011-06-09 08:45:37 +0000 @@ -135,7 +135,8 @@ public: void set_arguments(List &list); inline uint argument_count() const { return arg_count; } inline void remove_arguments() { arg_count=0; } - void split_sum_func(THD *thd, Item **ref_pointer_array, List &fields); + void split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, + List &fields); virtual void print(String *str, enum_query_type query_type); void print_op(String *str, enum_query_type query_type); void print_args(String *str, uint from, enum_query_type query_type); === modified file 'sql/item_row.cc' --- a/sql/item_row.cc 2011-06-09 06:22:39 +0000 +++ b/sql/item_row.cc 2011-06-09 08:45:37 +0000 @@ -1,4 +1,4 @@ -/* Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -113,7 +113,7 @@ void Item_row::cleanup() } -void Item_row::split_sum_func(THD *thd, Item **ref_pointer_array, +void Item_row::split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, List &fields) { Item **arg, **arg_end; === modified file 'sql/item_row.h' --- a/sql/item_row.h 2010-10-15 10:32:50 +0000 +++ b/sql/item_row.h 2011-06-09 08:45:37 +0000 @@ -66,7 +66,8 @@ public: void fix_after_pullout(st_select_lex *parent_select, st_select_lex *removed_select, Item **ref); void cleanup(); - void split_sum_func(THD *thd, Item **ref_pointer_array, List &fields); + void split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, + List &fields); table_map used_tables() const { return used_tables_cache; }; bool const_item() const { return const_item_cache; }; enum Item_result result_type() const { return ROW_RESULT; } === modified file 'sql/item_strfunc.cc' --- a/sql/item_strfunc.cc 2011-06-09 06:22:39 +0000 +++ b/sql/item_strfunc.cc 2011-06-09 08:45:37 +0000 @@ -2540,7 +2540,8 @@ String *Item_func_elt::val_str(String *s } -void Item_func_make_set::split_sum_func(THD *thd, Item **ref_pointer_array, +void Item_func_make_set::split_sum_func(THD *thd, + Ref_ptr_array ref_pointer_array, List &fields) { item->split_sum_func2(thd, ref_pointer_array, fields, &item, TRUE); === modified file 'sql/item_strfunc.h' --- a/sql/item_strfunc.h 2011-04-15 09:04:21 +0000 +++ b/sql/item_strfunc.h 2011-06-09 08:45:37 +0000 @@ -556,7 +556,8 @@ public: item->check_cols(1) || Item_func::fix_fields(thd, ref)); } - void split_sum_func(THD *thd, Item **ref_pointer_array, List &fields); + void split_sum_func(THD *thd, Ref_ptr_array ref_pointer_array, + List &fields); void fix_length_and_dec(); void update_used_tables(); const char *func_name() const { return "make_set"; } === modified file 'sql/item_subselect.cc' --- a/sql/item_subselect.cc 2011-05-24 09:36:11 +0000 +++ b/sql/item_subselect.cc 2011-06-09 08:45:37 +0000 @@ -1,4 +1,4 @@ -/* Copyright (c) 2002, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2002, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -1126,7 +1126,7 @@ Item_in_subselect::single_value_transfor (ALL && (> || =>)) || (ANY && (< || =<)) for ALL condition is inverted */ - item= new Item_sum_max(*select_lex->ref_pointer_array); + item= new Item_sum_max(join->ref_ptrs[0]); } else { @@ -1134,11 +1134,11 @@ Item_in_subselect::single_value_transfor (ALL && (< || =<)) || (ANY && (> || =>)) for ALL condition is inverted */ - item= new Item_sum_min(*select_lex->ref_pointer_array); + item= new Item_sum_min(join->ref_ptrs[0]); } if (upper_item) upper_item->set_sum_test(item); - *select_lex->ref_pointer_array= item; + join->ref_ptrs[0]= item; { List_iterator it(select_lex->item_list); it++; @@ -1220,7 +1220,8 @@ Item_in_subselect::single_value_transfor DBUG_RETURN(RES_OK); /* Perform the IN=>EXISTS transformation. */ - DBUG_RETURN(single_value_in_to_exists_transformer(join, func)); + const trans_res retval= single_value_in_to_exists_transformer(join, func); + DBUG_RETURN(retval); } @@ -1274,8 +1275,7 @@ Item_in_subselect::single_value_in_to_ex Item *item= func->create(expr, new Item_ref_null_helper(&select_lex->context, this, - select_lex-> - ref_pointer_array, + &join->ref_ptrs[0], (char *)"", this->full_name())); if (!abort_on_null && left_expr->maybe_null) @@ -1318,7 +1318,7 @@ Item_in_subselect::single_value_in_to_ex select_lex->item_list.push_back(new Item_int("Not_used", (longlong) 1, MY_INT64_NUM_DECIMAL_DIGITS)); - select_lex->ref_pointer_array[0]= select_lex->item_list.head(); + join->ref_ptrs[0]= select_lex->item_list.head(); item= func->create(expr, item); if (!abort_on_null && orig_item->maybe_null) @@ -1393,7 +1393,7 @@ Item_in_subselect::single_value_in_to_ex Item *new_having= func->create(expr, new Item_ref_null_helper(&select_lex->context, this, - select_lex->ref_pointer_array, + &join->ref_ptrs[0], (char *)"", (char *)"")); if (!abort_on_null && left_expr->maybe_null) @@ -1554,11 +1554,11 @@ Item_in_subselect::row_value_in_to_exist for (uint i= 0; i < cols_num; i++) { DBUG_ASSERT((left_expr->fixed && - select_lex->ref_pointer_array[i]->fixed) || - (select_lex->ref_pointer_array[i]->type() == REF_ITEM && - ((Item_ref*)(select_lex->ref_pointer_array[i]))->ref_type() == + join->ref_ptrs[i]->fixed) || + (join->ref_ptrs[i]->type() == REF_ITEM && + ((Item_ref*)(join->ref_ptrs[i]))->ref_type() == Item_ref::OUTER_REF)); - if (select_lex->ref_pointer_array[i]-> + if (join->ref_ptrs[i]-> check_cols(left_expr->element_index(i)->cols())) DBUG_RETURN(RES_ERROR); Item *item_eq= @@ -1570,14 +1570,14 @@ Item_in_subselect::row_value_in_to_exist (char *)in_left_expr_name), new Item_ref(&select_lex->context, - select_lex->ref_pointer_array + i, + &join->ref_ptrs[i], (char *)"", (char *)"") ); Item *item_isnull= new Item_func_isnull(new Item_ref(&select_lex->context, - select_lex->ref_pointer_array+i, + &join->ref_ptrs[i], (char *)"", (char *)"") ); @@ -1592,8 +1592,7 @@ Item_in_subselect::row_value_in_to_exist Item *item_nnull_test= new Item_is_not_null_test(this, new Item_ref(&select_lex->context, - select_lex-> - ref_pointer_array + i, + &join->ref_ptrs[i], (char *)"", (char *)"")); if (!abort_on_null && left_expr->element_index(i)->maybe_null) @@ -1632,11 +1631,11 @@ Item_in_subselect::row_value_in_to_exist { Item *item, *item_isnull; DBUG_ASSERT((left_expr->fixed && - select_lex->ref_pointer_array[i]->fixed) || - (select_lex->ref_pointer_array[i]->type() == REF_ITEM && - ((Item_ref*)(select_lex->ref_pointer_array[i]))->ref_type() == + join->ref_ptrs[i]->fixed) || + (join->ref_ptrs[i]->type() == REF_ITEM && + ((Item_ref*)(join->ref_ptrs[i]))->ref_type() == Item_ref::OUTER_REF)); - if (select_lex->ref_pointer_array[i]-> + if (join->ref_ptrs[i]-> check_cols(left_expr->element_index(i)->cols())) DBUG_RETURN(RES_ERROR); item= @@ -1648,8 +1647,7 @@ Item_in_subselect::row_value_in_to_exist (char *)in_left_expr_name), new Item_direct_ref(&select_lex->context, - select_lex-> - ref_pointer_array+i, + &join->ref_ptrs[i], (char *)"", (char *)"") ); @@ -1659,7 +1657,7 @@ Item_in_subselect::row_value_in_to_exist new Item_is_not_null_test(this, new Item_ref(&select_lex->context, - select_lex->ref_pointer_array + i, + &join->ref_ptrs[i], (char *)"", (char *)"")); @@ -1667,8 +1665,7 @@ Item_in_subselect::row_value_in_to_exist item_isnull= new Item_func_isnull(new Item_direct_ref(&select_lex->context, - select_lex-> - ref_pointer_array+i, + &join->ref_ptrs[i], (char *)"", (char *)"") ); @@ -2155,8 +2152,7 @@ bool subselect_single_select_engine::pre prepared= 1; SELECT_LEX *save_select= thd->lex->current_select; thd->lex->current_select= select_lex; - if (join->prepare(&select_lex->ref_pointer_array, - select_lex->table_list.first, + if (join->prepare(select_lex->table_list.first, select_lex->with_wild, select_lex->where, select_lex->order_list.elements + === modified file 'sql/item_sum.cc' --- a/sql/item_sum.cc 2011-06-09 06:22:39 +0000 +++ b/sql/item_sum.cc 2011-06-09 08:45:37 +0000 @@ -3308,7 +3308,8 @@ bool Item_func_group_concat::setup(THD * tmp table columns. */ if (arg_count_order && - setup_order(thd, args, context->table_list, list, all_fields, *order)) + setup_order(thd, Ref_ptr_array(args, arg_count), + context->table_list, list, all_fields, *order)) DBUG_RETURN(TRUE); count_field_types(select_lex, tmp_table_param, all_fields, 0); === modified file 'sql/sql_array.h' --- a/sql/sql_array.h 2011-05-18 13:12:02 +0000 +++ b/sql/sql_array.h 2011-06-09 08:45:37 +0000 @@ -1,7 +1,7 @@ #ifndef SQL_ARRAY_INCLUDED #define SQL_ARRAY_INCLUDED -/* Copyright (c) 2003, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2003, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -18,6 +18,61 @@ #include +/** + A wrapper class which provides array bounds checking. + We do *not* own the array, we simply have a pointer to the first element, + and a length. + + @remark + We want the compiler-generated versions of: + - the copy CTOR (memberwise initialization) + - the assignment operator (memberwise assignment) + + @param Element_type The type of the elements of the container. + */ +template class Bounds_checked_array +{ +public: + Bounds_checked_array() : m_array(NULL), m_size(0) {} + + Bounds_checked_array(Element_type *el, size_t size) + : m_array(el), m_size(size) + {} + + void reset() { m_array= NULL; m_size= 0; } + + Element_type &operator[](size_t n) + { + DBUG_ASSERT(n < m_size); + return m_array[n]; + } + + const Element_type &operator[](size_t n) const + { + DBUG_ASSERT(n < m_size); + return m_array[n]; + } + + size_t element_size() const { return sizeof(Element_type); } + size_t size() const { return m_size; } + + // operator bool() const { return m_array != NULL; } + bool is_empty() const { return m_array == NULL; } + + void pop_front() + { + DBUG_ASSERT(m_size > 0); + m_array+= 1; + m_size-= 1; + } + + Element_type *array() const { return m_array; } + +private: + Element_type *m_array; + size_t m_size; +}; + /* A typesafe wrapper around DYNAMIC_ARRAY */ === modified file 'sql/sql_base.cc' --- a/sql/sql_base.cc 2011-05-26 15:20:09 +0000 +++ b/sql/sql_base.cc 2011-06-09 08:45:37 +0000 @@ -8022,7 +8022,7 @@ int setup_wild(THD *thd, TABLE_LIST *tab ** Check that all given fields exists and fill struct with current data ****************************************************************************/ -bool setup_fields(THD *thd, Item **ref_pointer_array, +bool setup_fields(THD *thd, Ref_ptr_array ref_pointer_array, List &fields, enum_mark_columns mark_used_columns, List *sum_func_list, bool allow_sum_func) { @@ -8052,8 +8052,11 @@ bool setup_fields(THD *thd, Item **ref_p TODO: remove it when (if) we made one list for allfields and ref_pointer_array */ - if (ref_pointer_array) - memset(ref_pointer_array, 0, sizeof(Item *) * fields.elements); + if (!ref_pointer_array.is_empty()) + { + DBUG_ASSERT(ref_pointer_array.size() >= fields.elements); + memset(ref_pointer_array.array(), 0, sizeof(Item *) * fields.elements); + } /* We call set_entry() there (before fix_fields() of the whole list of field @@ -8071,7 +8074,7 @@ bool setup_fields(THD *thd, Item **ref_p while ((var= li++)) var->set_entry(thd, FALSE); - Item **ref= ref_pointer_array; + Ref_ptr_array ref= ref_pointer_array; thd->lex->current_select->cur_pos_in_select_list= 0; while ((item= it++)) { @@ -8084,8 +8087,11 @@ bool setup_fields(THD *thd, Item **ref_p DBUG_PRINT("info", ("thd->mark_used_columns: %d", thd->mark_used_columns)); DBUG_RETURN(TRUE); /* purecov: inspected */ } - if (ref) - *(ref++)= item; + if (!ref.is_empty()) + { + ref[0]= item; + ref.pop_front(); + } if (item->with_sum_func && item->type() != Item::SUM_FUNC_ITEM && sum_func_list) item->split_sum_func(thd, ref_pointer_array, *sum_func_list); === modified file 'sql/sql_base.h' --- a/sql/sql_base.h 2011-05-04 07:51:15 +0000 +++ b/sql/sql_base.h 2011-06-09 08:45:37 +0000 @@ -1,4 +1,4 @@ -/* Copyright (c) 2006, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2006, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -184,7 +184,7 @@ bool insert_fields(THD *thd, Name_resolu List_iterator *it, bool any_privileges); int setup_wild(THD *thd, TABLE_LIST *tables, List &fields, List *sum_func_list, uint wild_num); -bool setup_fields(THD *thd, Item** ref_pointer_array, +bool setup_fields(THD *thd, Ref_ptr_array ref_pointer_array, List &item, enum_mark_columns mark_used_columns, List *sum_func_list, bool allow_sum_func); bool fill_record(THD *thd, Field **field, List &values, @@ -350,7 +350,7 @@ inline TABLE_LIST *find_table_in_local_l } -inline bool setup_fields_with_no_wrap(THD *thd, Item **ref_pointer_array, +inline bool setup_fields_with_no_wrap(THD *thd, Ref_ptr_array ref_pointer_array, List &item, enum_mark_columns mark_used_columns, List *sum_func_list, === modified file 'sql/sql_derived.cc' --- a/sql/sql_derived.cc 2011-03-08 19:14:42 +0000 +++ b/sql/sql_derived.cc 2011-06-09 08:45:37 +0000 @@ -286,7 +286,7 @@ bool mysql_derived_filling(THD *thd, LEX first_select->options&= ~OPTION_FOUND_ROWS; lex->current_select= first_select; - res= mysql_select(thd, &first_select->ref_pointer_array, + res= mysql_select(thd, first_select->table_list.first, first_select->with_wild, first_select->item_list, first_select->where, === modified file 'sql/sql_do.cc' --- a/sql/sql_do.cc 2010-07-27 15:01:56 +0000 +++ b/sql/sql_do.cc 2011-06-09 08:45:37 +0000 @@ -1,4 +1,4 @@ -/* Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -28,7 +28,7 @@ bool mysql_do(THD *thd, List &valu List_iterator li(values); Item *value; DBUG_ENTER("mysql_do"); - if (setup_fields(thd, 0, values, MARK_COLUMNS_NONE, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), values, MARK_COLUMNS_NONE, 0, 0)) DBUG_RETURN(TRUE); while ((value = li++)) value->val_int(); === modified file 'sql/sql_insert.cc' --- a/sql/sql_insert.cc 2011-05-30 06:25:47 +0000 +++ b/sql/sql_insert.cc 2011-06-09 08:45:37 +0000 @@ -256,7 +256,7 @@ static int check_insert_fields(THD *thd, */ table_list->next_local= 0; context->resolve_in_table_list_only(table_list); - res= setup_fields(thd, 0, fields, MARK_COLUMNS_WRITE, 0, 0); + res= setup_fields(thd, Ref_ptr_array(), fields, MARK_COLUMNS_WRITE, 0, 0); /* Restore the current context. */ ctx_state.restore_state(context, table_list); @@ -347,7 +347,8 @@ static int check_update_fields(THD *thd, } /* Check the fields we are going to modify */ - if (setup_fields(thd, 0, update_fields, MARK_COLUMNS_WRITE, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), + update_fields, MARK_COLUMNS_WRITE, 0, 0)) return -1; if (insert_table_list->effective_algorithm == VIEW_ALGORITHM_MERGE && @@ -762,7 +763,7 @@ bool mysql_insert(THD *thd,TABLE_LIST *t my_error(ER_WRONG_VALUE_COUNT_ON_ROW, MYF(0), counter); goto abort; } - if (setup_fields(thd, 0, *values, MARK_COLUMNS_READ, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), *values, MARK_COLUMNS_READ, 0, 0)) goto abort; } its.rewind (); @@ -1377,7 +1378,8 @@ bool mysql_prepare_insert(THD *thd, TABL table_list->next_local= 0; context->resolve_in_table_list_only(table_list); - res= (setup_fields(thd, 0, *values, MARK_COLUMNS_READ, 0, 0) || + res= (setup_fields(thd, Ref_ptr_array(), + *values, MARK_COLUMNS_READ, 0, 0) || check_insert_fields(thd, context->table_list, fields, *values, !insert_into_view, 0, &map)); @@ -1393,7 +1395,8 @@ bool mysql_prepare_insert(THD *thd, TABL } if (!res) - res= setup_fields(thd, 0, update_values, MARK_COLUMNS_READ, 0, 0); + res= setup_fields(thd, Ref_ptr_array(), + update_values, MARK_COLUMNS_READ, 0, 0); if (!res && duplic == DUP_UPDATE) { @@ -3231,7 +3234,7 @@ select_insert::prepare(List &value /* Errors during check_insert_fields() should not be ignored. */ lex->current_select->no_error= FALSE; - res= (setup_fields(thd, 0, values, MARK_COLUMNS_READ, 0, 0) || + res= (setup_fields(thd, Ref_ptr_array(), values, MARK_COLUMNS_READ, 0, 0) || check_insert_fields(thd, table_list, *fields, values, !insert_into_view, 1, &map)); @@ -3279,7 +3282,7 @@ select_insert::prepare(List &value table_list->next_name_resolution_table= ctx_state.get_first_name_resolution_table(); - res= res || setup_fields(thd, 0, *info.update_values, + res= res || setup_fields(thd, Ref_ptr_array(), *info.update_values, MARK_COLUMNS_READ, 0, 0); if (!res) { === modified file 'sql/sql_lex.cc' --- a/sql/sql_lex.cc 2011-05-26 15:20:09 +0000 +++ b/sql/sql_lex.cc 2011-06-09 08:45:37 +0000 @@ -1757,7 +1757,7 @@ void st_select_lex::init_query() parent_lex->push_context(&context); cond_count= between_count= with_wild= 0; max_equal_elems= 0; - ref_pointer_array= 0; + ref_pointer_array.reset(); select_n_where_fields= 0; select_n_having_items= 0; subquery_in_having= explicit_limit= 0; @@ -2132,20 +2132,43 @@ ulong st_select_lex::get_table_join_opti bool st_select_lex::setup_ref_array(THD *thd, uint order_group_num) { - if (ref_pointer_array) - return 0; +#ifdef DBUG_OFF + if (!ref_pointer_array.is_empty()) + return false; +#endif + + // find_order_in_list() may need some extra space, so multiply by two. + order_group_num*= 2; /* We have to create array in prepared statement memory if it is prepared statement */ Query_arena *arena= thd->stmt_arena; - return (ref_pointer_array= - (Item **)arena->alloc(sizeof(Item*) * (n_child_sum_items + - item_list.elements + - select_n_having_items + - select_n_where_fields + - order_group_num)*5)) == 0; + uint n_elems= (n_child_sum_items + + item_list.elements + + select_n_having_items + + select_n_where_fields + + order_group_num) * 5; + DBUG_PRINT("info", ("setup_ref_array this %p %4u : %4u %4u %4u %4u %4u %4u", + this, + n_elems, + // + n_sum_items, + n_child_sum_items, + item_list.elements, + select_n_having_items, + select_n_where_fields, + order_group_num)); + if (!ref_pointer_array.is_empty()) + { + DBUG_ASSERT(ref_pointer_array.size() == n_elems); + return false; + } + Item **array= static_cast(arena->alloc(sizeof(Item*) * n_elems)); + ref_pointer_array= Ref_ptr_array(array, n_elems); + + return array == NULL; } === modified file 'sql/sql_lex.h' --- a/sql/sql_lex.h 2011-05-12 17:29:19 +0000 +++ b/sql/sql_lex.h 2011-06-09 08:45:37 +0000 @@ -24,6 +24,7 @@ #include "sql_trigger.h" #include "item.h" /* From item_subselect.h: subselect_union_engine */ #include "thr_lock.h" /* thr_lock_type, TL_UNLOCK */ +#include "sql_array.h" /* YACC and LEX Definitions */ @@ -602,6 +603,7 @@ public: }; typedef class st_select_lex_unit SELECT_LEX_UNIT; +typedef Bounds_checked_array Ref_ptr_array; /* SELECT_LEX - store information of parsed SELECT statment @@ -655,8 +657,9 @@ public: SQL_I_List order_list; /* ORDER clause */ SQL_I_List *gorder_list; Item *select_limit, *offset_limit; /* LIMIT clause parameters */ - // Arrays of pointers to top elements of all_fields list - Item **ref_pointer_array; + + /// Array of pointers to top elements of all_fields list + Ref_ptr_array ref_pointer_array; /* number of items in select_list and HAVING clause used to get number @@ -666,7 +669,7 @@ public: uint select_n_having_items; uint cond_count; /* number of arguments of and/or/xor in where/having/on */ uint between_count; /* number of between predicates in where/having/on */ - uint max_equal_elems; /* maximal number of elements in multiple equalities */ + uint max_equal_elems; /* maximal number of elements in multiple equalities */ /* Number of fields used in select list or where clause of current select and all inner subselects. === modified file 'sql/sql_load.cc' --- a/sql/sql_load.cc 2011-05-26 15:20:09 +0000 +++ b/sql/sql_load.cc 2011-06-09 08:45:37 +0000 @@ -268,15 +268,18 @@ int mysql_load(THD *thd,sql_exchange *ex Let us also prepare SET clause, altough it is probably empty in this case. */ - if (setup_fields(thd, 0, set_fields, MARK_COLUMNS_WRITE, 0, 0) || - setup_fields(thd, 0, set_values, MARK_COLUMNS_READ, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), + set_fields, MARK_COLUMNS_WRITE, 0, 0) || + setup_fields(thd, Ref_ptr_array(), set_values, MARK_COLUMNS_READ, 0, 0)) DBUG_RETURN(TRUE); } else { // Part field list /* TODO: use this conds for 'WITH CHECK OPTIONS' */ - if (setup_fields(thd, 0, fields_vars, MARK_COLUMNS_WRITE, 0, 0) || - setup_fields(thd, 0, set_fields, MARK_COLUMNS_WRITE, 0, 0) || + if (setup_fields(thd, Ref_ptr_array(), + fields_vars, MARK_COLUMNS_WRITE, 0, 0) || + setup_fields(thd, Ref_ptr_array(), + set_fields, MARK_COLUMNS_WRITE, 0, 0) || check_that_all_fields_are_given_values(thd, table, table_list)) DBUG_RETURN(TRUE); /* @@ -295,7 +298,7 @@ int mysql_load(THD *thd,sql_exchange *ex } } /* Fix the expressions in SET clause */ - if (setup_fields(thd, 0, set_values, MARK_COLUMNS_READ, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), set_values, MARK_COLUMNS_READ, 0, 0)) DBUG_RETURN(TRUE); } === modified file 'sql/sql_parse.cc' --- a/sql/sql_parse.cc 2011-05-30 06:25:47 +0000 +++ b/sql/sql_parse.cc 2011-06-09 08:45:37 +0000 @@ -3143,7 +3143,7 @@ end_with_restore_list: if (!thd->is_fatal_error && (del_result= new multi_delete(aux_tables, lex->table_count))) { - res= mysql_select(thd, &select_lex->ref_pointer_array, + res= mysql_select(thd, select_lex->get_table_list(), select_lex->with_wild, select_lex->item_list, === modified file 'sql/sql_prepare.cc' --- a/sql/sql_prepare.cc 2011-05-26 15:20:09 +0000 +++ b/sql/sql_prepare.cc 2011-06-09 08:45:37 +0000 @@ -1294,7 +1294,7 @@ static bool mysql_test_insert(Prepared_s my_error(ER_WRONG_VALUE_COUNT_ON_ROW, MYF(0), counter); goto error; } - if (setup_fields(thd, 0, *values, MARK_COLUMNS_NONE, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), *values, MARK_COLUMNS_NONE, 0, 0)) goto error; } } @@ -1373,7 +1373,8 @@ static int mysql_test_update(Prepared_st table_list->register_want_access(want_privilege); #endif thd->lex->select_lex.no_wrap_view_item= TRUE; - res= setup_fields(thd, 0, select->item_list, MARK_COLUMNS_READ, 0, 0); + res= setup_fields(thd, Ref_ptr_array(), + select->item_list, MARK_COLUMNS_READ, 0, 0); thd->lex->select_lex.no_wrap_view_item= FALSE; if (res) goto error; @@ -1384,7 +1385,8 @@ static int mysql_test_update(Prepared_st (SELECT_ACL & ~table_list->table->grant.privilege); table_list->register_want_access(SELECT_ACL); #endif - if (setup_fields(thd, 0, stmt->lex->value_list, MARK_COLUMNS_NONE, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), + stmt->lex->value_list, MARK_COLUMNS_NONE, 0, 0)) goto error; /* TODO: here we should send types of placeholders to the client. */ DBUG_RETURN(0); @@ -1530,7 +1532,8 @@ static bool mysql_test_do_fields(Prepare if (open_normal_and_derived_tables(thd, tables, MYSQL_OPEN_FORCE_SHARED_MDL)) DBUG_RETURN(TRUE); - DBUG_RETURN(setup_fields(thd, 0, *values, MARK_COLUMNS_NONE, 0, 0)); + DBUG_RETURN(setup_fields(thd, Ref_ptr_array(), + *values, MARK_COLUMNS_NONE, 0, 0)); } === modified file 'sql/sql_select.cc' --- a/sql/sql_select.cc 2011-06-07 16:28:07 +0000 +++ b/sql/sql_select.cc 2011-06-09 08:45:37 +0000 @@ -203,7 +203,7 @@ static int remove_dup_with_hash_index(TH static bool cmp_buffer_with_ref(THD *thd, TABLE *table, TABLE_REF *tab_ref); static bool setup_new_fields(THD *thd, List &fields, List &all_fields, ORDER *new_order); -static ORDER *create_distinct_group(THD *thd, Item **ref_pointer_array, +static ORDER *create_distinct_group(THD *thd, Ref_ptr_array ref_pointer_array, ORDER *order, List &fields, List &all_fields, bool *all_order_by_fields_used); @@ -213,12 +213,12 @@ static void calc_group_buffer(JOIN *join static bool make_group_fields(JOIN *main_join, JOIN *curr_join); static bool alloc_group_fields(JOIN *join,ORDER *group); // Create list for using with tempory table -static bool change_to_use_tmp_fields(THD *thd, Item **ref_pointer_array, +static bool change_to_use_tmp_fields(THD *thd, Ref_ptr_array ref_pointer_array, List &new_list1, List &new_list2, uint elements, List &items); // Create list for using with tempory table -static bool change_refs_to_tmp_fields(THD *thd, Item **ref_pointer_array, +static bool change_refs_to_tmp_fields(THD *thd, Ref_ptr_array ref_pointer_array, List &new_list1, List &new_list2, uint elements, List &items); @@ -384,7 +384,7 @@ bool handle_select(THD *thd, LEX *lex, s every PS/SP execution new, we will not need reset this flag if setup_tables_done_option changed for next rexecution */ - res= mysql_select(thd, &select_lex->ref_pointer_array, + res= mysql_select(thd, select_lex->table_list.first, select_lex->with_wild, select_lex->item_list, select_lex->where, @@ -460,7 +460,7 @@ bool handle_select(THD *thd, LEX *lex, s bool fix_inner_refs(THD *thd, List &all_fields, SELECT_LEX *select, - Item **ref_pointer_array, ORDER *group_list) + Ref_ptr_array ref_pointer_array, ORDER *group_list) { Item_outer_ref *ref; @@ -477,7 +477,7 @@ fix_inner_refs(THD *thd, List &all existing one. The change will lead to less operations for copying fields, smaller temporary tables and less data passed through filesort. */ - if (ref_pointer_array && !ref->found_in_select_list) + if (!ref_pointer_array.is_empty() && !ref->found_in_select_list) { int el= all_fields.elements; ref_pointer_array[el]= item; @@ -487,7 +487,7 @@ fix_inner_refs(THD *thd, List &all If it's needed reset each Item_ref item that refers this field with a new reference taken from ref_pointer_array. */ - item_ref= ref_pointer_array + el; + item_ref= &ref_pointer_array[el]; } if (ref->in_sum_func) @@ -546,7 +546,7 @@ fix_inner_refs(THD *thd, List &all /** Function to setup clauses without sum functions. */ -inline int setup_without_group(THD *thd, Item **ref_pointer_array, +inline int setup_without_group(THD *thd, Ref_ptr_array ref_pointer_array, TABLE_LIST *tables, TABLE_LIST *leaves, List &fields, @@ -600,8 +600,7 @@ inline int setup_without_group(THD *thd, 0 on success */ int -JOIN::prepare(Item ***rref_pointer_array, - TABLE_LIST *tables_init, +JOIN::prepare(TABLE_LIST *tables_init, uint wild_num, Item *conds_init, uint og_num, ORDER *order_init, ORDER *group_init, Item *having_init, @@ -647,18 +646,28 @@ JOIN::prepare(Item ***rref_pointer_array table_ptr= table_ptr->next_leaf) tables++; - if (setup_wild(thd, tables_list, fields_list, &all_fields, wild_num) || - select_lex->setup_ref_array(thd, og_num) || - setup_fields(thd, (*rref_pointer_array), fields_list, MARK_COLUMNS_READ, - &all_fields, 1) || - setup_without_group(thd, (*rref_pointer_array), tables_list, + if (setup_wild(thd, tables_list, fields_list, &all_fields, wild_num)) + DBUG_RETURN(-1); + if (select_lex->setup_ref_array(thd, og_num)) + DBUG_RETURN(-1); + /* + Item and Item_field CTORs will both increment some counters + in current_select, based on the current parsing context. + We are not parsing anymore: any new Items created now are due to + query rewriting, so stop incrementing counters. + */ + select_lex->parsing_place= NO_MATTER; + ref_ptrs= ref_ptr_array_slice(0); + + if (setup_fields(thd, ref_ptrs, fields_list, MARK_COLUMNS_READ, + &all_fields, 1)) + DBUG_RETURN(-1); + if (setup_without_group(thd, ref_ptrs, tables_list, select_lex->leaf_tables, fields_list, all_fields, &conds, order, group_list, &hidden_group_fields)) - DBUG_RETURN(-1); /* purecov: inspected */ + DBUG_RETURN(-1); - ref_pointer_array= *rref_pointer_array; - if (having) { nesting_map save_allow_sum_func= thd->lex->allow_sum_func; @@ -712,15 +721,15 @@ JOIN::prepare(Item ***rref_pointer_array real_order= TRUE; if (item->with_sum_func && item->type() != Item::SUM_FUNC_ITEM) - item->split_sum_func(thd, ref_pointer_array, all_fields); + item->split_sum_func(thd, ref_ptrs, all_fields); } if (!real_order) order= NULL; } if (having && having->with_sum_func) - having->split_sum_func2(thd, ref_pointer_array, all_fields, - &having, TRUE); + having->split_sum_func2(thd, ref_ptrs, + all_fields, &having, TRUE); if (select_lex->inner_sum_func_list) { Item_sum *end=select_lex->inner_sum_func_list; @@ -728,13 +737,13 @@ JOIN::prepare(Item ***rref_pointer_array do { item_sum= item_sum->next; - item_sum->split_sum_func2(thd, ref_pointer_array, + item_sum->split_sum_func2(thd, ref_ptrs, all_fields, item_sum->ref_by, FALSE); } while (item_sum != end); } if (select_lex->inner_refs_list.elements && - fix_inner_refs(thd, all_fields, select_lex, ref_pointer_array, + fix_inner_refs(thd, all_fields, select_lex, ref_ptrs, group_list)) DBUG_RETURN(-1); @@ -753,9 +762,9 @@ JOIN::prepare(Item ***rref_pointer_array { Item_field *field= new Item_field(thd, *(Item_field**)ord->item); int el= all_fields.elements; - ref_pointer_array[el]= field; + ref_ptrs[el]= field; all_fields.push_front(field); - ord->item= ref_pointer_array + el; + ord->item= &ref_ptrs[el]; } } } @@ -824,7 +833,6 @@ JOIN::prepare(Item ***rref_pointer_array /* Init join struct */ count_field_types(select_lex, &tmp_table_param, all_fields, 0); - ref_pointer_array_size= all_fields.elements*sizeof(Item*); this->group= group_list != 0; unit= unit_arg; @@ -2247,7 +2255,7 @@ JOIN::optimize() if (order) skip_sort_order= test_if_skip_sort_order(tab, order, m_select_limit, 1, &tab->table->keys_in_use_for_order_by); - if ((group_list=create_distinct_group(thd, select_lex->ref_pointer_array, + if ((group_list=create_distinct_group(thd, ref_ptrs, order, fields_list, all_fields, &all_order_fields_used))) { @@ -2750,7 +2758,7 @@ void JOIN::reset() filesort_free_buffers(exec_tmp_table2,0); } clear_sj_tmp_tables(this); - if (items0) + if (!items0.is_empty()) set_items_ref_array(items0); if (join_tab_save) @@ -3032,9 +3040,9 @@ JOIN::exec() /* Change sum_fields reference to calculated fields in tmp_table */ if (curr_join != this) curr_join->all_fields= *curr_all_fields; - if (!items1) + if (items1.is_empty()) { - items1= items0 + all_fields.elements; + items1= ref_ptr_array_slice(2); if (sort_and_group || curr_tmp_table->group || tmp_table_param.precomputed_group_by) { @@ -3197,9 +3205,9 @@ JOIN::exec() curr_join->join_tab[0].table= 0; // Table is freed // No sum funcs anymore - if (!items2) + if (items2.is_empty()) { - items2= items1 + all_fields.elements; + items2= ref_ptr_array_slice(3); if (change_to_use_tmp_fields(thd, items2, tmp_fields_list2, tmp_all_fields2, fields_list.elements, tmp_all_fields1)) @@ -3252,11 +3260,11 @@ JOIN::exec() { DBUG_VOID_RETURN; } - if (!items3) + if (items3.is_empty()) { - if (!items0) + if (items0.is_empty()) init_items_ref_array(); - items3= ref_pointer_array + (all_fields.elements*4); + items3= ref_ptr_array_slice(4); setup_copy_fields(thd, &curr_join->tmp_table_param, items3, tmp_fields_list3, tmp_all_fields3, curr_fields_list->elements, *curr_all_fields); @@ -3486,7 +3494,7 @@ JOIN::exec() We also need to do this when we have temp table(s). Otherwise we would not be able to print the query correctly. */ - if (items0 && (thd->lex->describe & DESCRIBE_EXTENDED) && + if (!items0.is_empty() && (thd->lex->describe & DESCRIBE_EXTENDED) && (select_lex->linkage == DERIVED_TABLE_TYPE || exec_tmp_table1 || exec_tmp_table2)) set_items_ref_array(items0); @@ -3568,7 +3576,6 @@ void JOIN::cleanup_item_list(List An entry point to single-unit select (a select without UNION). @param thd thread handler - @param rref_pointer_array a reference to ref_pointer_array of the top-level select_lex for this query @param tables list of all tables used in this query. The tables have been pre-opened. @@ -3609,7 +3616,7 @@ void JOIN::cleanup_item_list(List */ bool -mysql_select(THD *thd, Item ***rref_pointer_array, +mysql_select(THD *thd, TABLE_LIST *tables, uint wild_num, List &fields, Item *conds, uint og_num, ORDER *order, ORDER *group, Item *having, ORDER *proc_param, ulonglong select_options, @@ -3649,7 +3656,7 @@ mysql_select(THD *thd, Item ***rref_poin } else { - err= join->prepare(rref_pointer_array, tables, wild_num, + err= join->prepare(tables, wild_num, conds, og_num, order, group, having, proc_param, select_lex, unit); if (err) @@ -3667,7 +3674,7 @@ mysql_select(THD *thd, Item ***rref_poin DBUG_RETURN(TRUE); /* purecov: inspected */ THD_STAGE_INFO(thd, stage_init); thd->used_tables=0; // Updated by setup_fields - err= join->prepare(rref_pointer_array, tables, wild_num, + err= join->prepare(tables, wild_num, conds, og_num, order, group, having, proc_param, select_lex, unit); if (err) @@ -21112,7 +21119,7 @@ cp_buffer_from_ref(THD *thd, TABLE *tabl */ static bool -find_order_in_list(THD *thd, Item **ref_pointer_array, TABLE_LIST *tables, +find_order_in_list(THD *thd, Ref_ptr_array ref_pointer_array, TABLE_LIST *tables, ORDER *order, List &fields, List &all_fields, bool is_group_field) { @@ -21136,7 +21143,7 @@ find_order_in_list(THD *thd, Item **ref_ order_item->full_name(), thd->where); return TRUE; } - order->item= ref_pointer_array + count - 1; + order->item= &ref_pointer_array[count - 1]; order->in_field_list= 1; order->counter= count; order->counter_used= 1; @@ -21197,7 +21204,7 @@ find_order_in_list(THD *thd, Item **ref_ 'shadowed' a table field with the same name, the table field will be chosen over the derived field. */ - order->item= ref_pointer_array + counter; + order->item= &ref_pointer_array[counter]; order->in_field_list=1; return FALSE; } @@ -21255,7 +21262,7 @@ find_order_in_list(THD *thd, Item **ref_ uint el= all_fields.elements; all_fields.push_front(order_item); /* Add new field to field list. */ ref_pointer_array[el]= order_item; - order->item= ref_pointer_array + el; + order->item= &ref_pointer_array[el]; return FALSE; } @@ -21267,7 +21274,7 @@ find_order_in_list(THD *thd, Item **ref_ the field list. */ -int setup_order(THD *thd, Item **ref_pointer_array, TABLE_LIST *tables, +int setup_order(THD *thd, Ref_ptr_array ref_pointer_array, TABLE_LIST *tables, List &fields, List &all_fields, ORDER *order) { thd->where="order clause"; @@ -21308,7 +21315,7 @@ int setup_order(THD *thd, Item **ref_poi */ int -setup_group(THD *thd, Item **ref_pointer_array, TABLE_LIST *tables, +setup_group(THD *thd, Ref_ptr_array ref_pointer_array, TABLE_LIST *tables, List &fields, List &all_fields, ORDER *order, bool *hidden_group_fields) { @@ -21439,13 +21446,14 @@ setup_new_fields(THD *thd, List &f */ ORDER * -create_distinct_group(THD *thd, Item **ref_pointer_array, +create_distinct_group(THD *thd, Ref_ptr_array ref_pointer_array, ORDER *order_list, List &fields, List &all_fields, bool *all_order_by_fields_used) { List_iterator li(fields); - Item *item, **orig_ref_pointer_array= ref_pointer_array; + Item *item; + Ref_ptr_array orig_ref_pointer_array= ref_pointer_array; ORDER *order,*group,**prev; *all_order_by_fields_used= 1; @@ -21499,7 +21507,7 @@ create_distinct_group(THD *thd, Item **r int el= all_fields.elements; orig_ref_pointer_array[el]= new_item; all_fields.push_front(new_item); - ord->item= orig_ref_pointer_array + el; + ord->item= &orig_ref_pointer_array[el]; } else { @@ -21508,14 +21516,14 @@ create_distinct_group(THD *thd, Item **r simple indexing of ref_pointer_array (order in the array and in the list are same) */ - ord->item= ref_pointer_array; + ord->item= &ref_pointer_array[0]; } ord->direction= ORDER::ORDER_ASC; *prev=ord; prev= &ord->next; } next_item: - ref_pointer_array++; + ref_pointer_array.pop_front(); } *prev=0; return group; @@ -21830,7 +21838,7 @@ int test_if_item_cache_changed(List &res_selected_fields, List &res_all_fields, uint elements, List &all_fields) { @@ -22111,7 +22119,7 @@ bool JOIN::make_sum_func_list(List */ static bool -change_to_use_tmp_fields(THD *thd, Item **ref_pointer_array, +change_to_use_tmp_fields(THD *thd, Ref_ptr_array ref_pointer_array, List &res_selected_fields, List &res_all_fields, uint elements, List &all_fields) @@ -22202,7 +22210,7 @@ change_to_use_tmp_fields(THD *thd, Item */ static bool -change_refs_to_tmp_fields(THD *thd, Item **ref_pointer_array, +change_refs_to_tmp_fields(THD *thd, Ref_ptr_array ref_pointer_array, List &res_selected_fields, List &res_all_fields, uint elements, List &all_fields) @@ -22577,15 +22585,20 @@ bool JOIN::rollup_init() */ tmp_table_param.group_parts= send_group_parts; - if (!(rollup.null_items= (Item_null_result**) thd->alloc((sizeof(Item*) + - sizeof(Item**) + - sizeof(List) + - ref_pointer_array_size) - * send_group_parts ))) - return 1; - - rollup.fields= (List*) (rollup.null_items + send_group_parts); - rollup.ref_pointer_arrays= (Item***) (rollup.fields + send_group_parts); + Item_null_result **null_items= + static_cast(thd->alloc(sizeof(Item*)*send_group_parts)); + + rollup.null_items= Item_null_array(null_items, send_group_parts); + rollup.ref_pointer_arrays= + static_cast + (thd->alloc((sizeof(Ref_ptr_array) + + all_fields.elements * sizeof(Item*)) * send_group_parts)); + rollup.fields= + static_cast*>(thd->alloc(sizeof(List) * send_group_parts)); + + if (!null_items || !rollup.ref_pointer_arrays || !rollup.fields) + return true; + ref_array= (Item**) (rollup.ref_pointer_arrays+send_group_parts); /* @@ -22597,7 +22610,7 @@ bool JOIN::rollup_init() rollup.null_items[i]= new (thd->mem_root) Item_null_result(); List *rollup_fields= &rollup.fields[i]; rollup_fields->empty(); - rollup.ref_pointer_arrays[i]= ref_array; + rollup.ref_pointer_arrays[i]= Ref_ptr_array(ref_array, all_fields.elements); ref_array+= all_fields.elements; } for (i= 0 ; i < send_group_parts; i++) @@ -22743,11 +22756,11 @@ bool JOIN::rollup_make_fields(List bool real_fields= 0; Item *item; List_iterator new_it(rollup.fields[pos]); - Item **ref_array_start= rollup.ref_pointer_arrays[pos]; + Ref_ptr_array ref_array_start= rollup.ref_pointer_arrays[pos]; ORDER *start_group; /* Point to first hidden field */ - Item **ref_array= ref_array_start + fields_arg.elements-1; + uint ref_array_ix= fields_arg.elements-1; /* Remember where the sum functions ends for the previous level */ sum_funcs_end[pos+1]= *func; @@ -22764,7 +22777,7 @@ bool JOIN::rollup_make_fields(List if (item == first_field) { real_fields= 1; // End of hidden fields - ref_array= ref_array_start; + ref_array_ix= 0; } if (item->type() == Item::SUM_FUNC_ITEM && !item->const_item() && @@ -22808,15 +22821,15 @@ bool JOIN::rollup_make_fields(List } } } - *ref_array= item; + ref_array_start[ref_array_ix]= item; if (real_fields) { (void) new_it++; // Point to next item new_it.replace(item); // Replace previous - ref_array++; + ref_array_ix++; } else - ref_array--; + ref_array_ix--; } } sum_funcs_end[0]= *func; // Point to last function @@ -22848,9 +22861,7 @@ int JOIN::rollup_send_data(uint idx) for (i= send_group_parts ; i-- > idx ; ) { /* Get reference pointers to sum functions in place */ - memcpy((char*) ref_pointer_array, - (char*) rollup.ref_pointer_arrays[i], - ref_pointer_array_size); + copy_ref_ptr_array(ref_ptrs, rollup.ref_pointer_arrays[i]); if ((!having || having->val_int())) { if (send_records < unit->select_limit_cnt && do_send_rows && @@ -22890,9 +22901,7 @@ int JOIN::rollup_write_data(uint idx, TA for (i= send_group_parts ; i-- > idx ; ) { /* Get reference pointers to sum functions in place */ - memcpy((char*) ref_pointer_array, - (char*) rollup.ref_pointer_arrays[i], - ref_pointer_array_size); + copy_ref_ptr_array(ref_ptrs, rollup.ref_pointer_arrays[i]); if ((!having || having->val_int())) { int write_error; @@ -23556,7 +23565,7 @@ bool mysql_explain_union(THD *thd, SELEC { thd->lex->current_select= first; unit->set_limit(unit->global_parameters); - res= mysql_select(thd, &first->ref_pointer_array, + res= mysql_select(thd, first->table_list.first, first->with_wild, first->item_list, first->where, === modified file 'sql/sql_select.h' --- a/sql/sql_select.h 2011-05-26 15:20:09 +0000 +++ b/sql/sql_select.h 2011-06-09 08:45:37 +0000 @@ -1598,12 +1598,14 @@ typedef struct st_position : public Sql_ } POSITION; +typedef Bounds_checked_array Item_null_array; + typedef struct st_rollup { enum State { STATE_NONE, STATE_INITED, STATE_READY }; State state; - Item_null_result **null_items; - Item ***ref_pointer_arrays; + Item_null_array null_items; + Ref_ptr_array *ref_pointer_arrays; List *fields; } ROLLUP; @@ -1879,10 +1881,19 @@ public: FirstMatch strategy. */ JOIN_TAB *return_tab; - Item **ref_pointer_array; ///ref_pointer_array contains five "slices": + |========|========|========|========|========| + ref_ptrs items0 items1 items2 items3 + */ + Ref_ptr_array ref_ptrs; + // Copy of the initial slice above, to be used with different lists + Ref_ptr_array items0, items1, items2, items3; + // Used by rollup, to restore ref_ptrs after overwriting it. + Ref_ptr_array current_ref_pointer_array; + const char *zero_result_cause; ///< not 0 if exec must return zero result bool union_part; ///< this subselect is part of union @@ -1958,8 +1969,11 @@ public: hidden_group_fields= 0; /*safety*/ error= 0; return_tab= 0; - ref_pointer_array= items0= items1= items2= items3= 0; - ref_pointer_array_size= 0; + ref_ptrs.reset(); + items0.reset(); + items1.reset(); + items2.reset(); + items3.reset(); zero_result_cause= 0; optimized= 0; cond_equal= 0; @@ -1979,7 +1993,7 @@ public: first_select= sub_select; } - int prepare(Item ***rref_pointer_array, TABLE_LIST *tables, uint wind_num, + int prepare(TABLE_LIST *tables, uint wind_num, Item *conds, uint og_num, ORDER *order, ORDER *group, Item *having, ORDER *proc_param, SELECT_LEX *select, SELECT_LEX_UNIT *unit); @@ -1994,15 +2008,41 @@ public: bool make_sum_func_list(List &all_fields, List &send_fields, bool before_group_by, bool recompute= FALSE); - inline void set_items_ref_array(Item **ptr) + /// Initialzes a slice, see comments for ref_ptrs above. + Ref_ptr_array ref_ptr_array_slice(size_t slice_num) + { + size_t slice_sz= select_lex->ref_pointer_array.size() / 5U; + DBUG_ASSERT(select_lex->ref_pointer_array.size() % 5 == 0); + DBUG_ASSERT(slice_num < 5U); + return Ref_ptr_array(&select_lex->ref_pointer_array[slice_num * slice_sz], + slice_sz); + } + + /** + Overwrites one slice with the contents of another slice. + In the normal case, dst and src have the same size(). + However: the rollup slices may have smaller size than slice_sz. + */ + void copy_ref_ptr_array(Ref_ptr_array dst_arr, Ref_ptr_array src_arr) + { + DBUG_ASSERT(dst_arr.size() >= src_arr.size()); + void *dest= dst_arr.array(); + const void *src= src_arr.array(); + memcpy(dest, src, src_arr.size() * src_arr.element_size()); + } + + /// Overwrites 'ref_ptrs' and remembers the the source as 'current'. + void set_items_ref_array(Ref_ptr_array src_arr) { - memcpy((char*) ref_pointer_array, (char*) ptr, ref_pointer_array_size); - current_ref_pointer_array= ptr; + copy_ref_ptr_array(ref_ptrs, src_arr); + current_ref_pointer_array= src_arr; } - inline void init_items_ref_array() + + /// Initializes 'items0' and remembers that it is 'current'. + void init_items_ref_array() { - items0= ref_pointer_array + all_fields.elements; - memcpy(items0, ref_pointer_array, ref_pointer_array_size); + items0= ref_ptr_array_slice(1); + copy_ref_ptr_array(items0, ref_ptrs); current_ref_pointer_array= items0; } @@ -2074,7 +2114,7 @@ void free_tmp_table(THD *thd, TABLE *ent void count_field_types(SELECT_LEX *select_lex, TMP_TABLE_PARAM *param, List &fields, bool reset_with_sum_func); bool setup_copy_fields(THD *thd, TMP_TABLE_PARAM *param, - Item **ref_pointer_array, + Ref_ptr_array ref_pointer_array, List &new_list1, List &new_list2, uint elements, List &fields); void copy_fields(TMP_TABLE_PARAM *param); @@ -2263,17 +2303,17 @@ Item *remove_eq_conds(THD *thd, Item *co int get_quick_record(SQL_SELECT *select); SORT_FIELD * make_unireg_sortorder(ORDER *order, uint *length, SORT_FIELD *sortorder); -int setup_order(THD *thd, Item **ref_pointer_array, TABLE_LIST *tables, +int setup_order(THD *thd, Ref_ptr_array ref_pointer_array, TABLE_LIST *tables, List &fields, List &all_fields, ORDER *order); -int setup_group(THD *thd, Item **ref_pointer_array, TABLE_LIST *tables, +int setup_group(THD *thd, Ref_ptr_array ref_pointer_array, TABLE_LIST *tables, List &fields, List &all_fields, ORDER *order, bool *hidden_group_fields); bool fix_inner_refs(THD *thd, List &all_fields, SELECT_LEX *select, - Item **ref_pointer_array, ORDER *group_list= NULL); + Ref_ptr_array ref_pointer_array, ORDER *group_list= NULL); bool handle_select(THD *thd, LEX *lex, select_result *result, ulong setup_tables_done_option); -bool mysql_select(THD *thd, Item ***rref_pointer_array, +bool mysql_select(THD *thd, TABLE_LIST *tables, uint wild_num, List &list, Item *conds, uint og_num, ORDER *order, ORDER *group, Item *having, ORDER *proc_param, ulonglong select_type, === modified file 'sql/sql_union.cc' --- a/sql/sql_union.cc 2011-05-26 15:20:09 +0000 +++ b/sql/sql_union.cc 2011-06-09 08:45:37 +0000 @@ -1,4 +1,4 @@ -/* Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -10,8 +10,8 @@ GNU General Public License for more details. You should have received a copy of the GNU General Public License - along with this program; if not, write to the Free Software Foundation, - 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA */ + along with this program; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ /* @@ -270,8 +270,7 @@ bool st_select_lex_unit::prepare(THD *th can_skip_order_by= is_union_select && !(sl->braces && sl->explicit_limit); - saved_error= join->prepare(&sl->ref_pointer_array, - sl->table_list.first, + saved_error= join->prepare(sl->table_list.first, sl->with_wild, sl->where, (can_skip_order_by ? 0 : @@ -419,23 +418,38 @@ bool st_select_lex_unit::prepare(THD *th init_prepare_fake_select_lex(thd); /* Should be done only once (the only item_list per statement) */ DBUG_ASSERT(fake_select_lex->join == 0); - if (!(fake_select_lex->join= new JOIN(thd, item_list, thd->variables.option_bits, - result))) + if (!(fake_select_lex->join= + new JOIN(thd, item_list, thd->variables.option_bits, result))) { fake_select_lex->table_list.empty(); DBUG_RETURN(TRUE); } + + /* + Fake st_select_lex should have item list for correct ref_array + allocation. + */ fake_select_lex->item_list= item_list; - thd_arg->lex->current_select= fake_select_lex; + thd_arg->lex->current_select= fake_select_lex; + + /* + We need to add up n_sum_items in order to make the correct + allocation in setup_ref_array(). + */ + fake_select_lex->n_child_sum_items+= global_parameters->n_sum_items; + saved_error= fake_select_lex->join-> - prepare(&fake_select_lex->ref_pointer_array, - fake_select_lex->table_list.first, - 0, 0, - fake_select_lex->order_list.elements, - fake_select_lex->order_list.first, - NULL, NULL, NULL, - fake_select_lex, this); + prepare(fake_select_lex->table_list.first, // tables_init + 0, // wild_num + 0, // conds_init + global_parameters->order_list.elements, // og_num + global_parameters->order_list.first, // order + NULL, // group_init + NULL, // having_init + NULL, // proc_param_init + fake_select_lex, // select_lex_arg + this); // unit_arg fake_select_lex->table_list.empty(); } } @@ -607,18 +621,35 @@ bool st_select_lex_unit::exec() fake_select_lex->join->no_const_tables= true; /* - Fake st_select_lex should have item list for correctref_array + Fake st_select_lex should have item list for correct ref_array allocation. */ fake_select_lex->item_list= item_list; - saved_error= mysql_select(thd, &fake_select_lex->ref_pointer_array, - &result_table_list, - 0, item_list, NULL, - global_parameters->order_list.elements, - global_parameters->order_list.first, - NULL, NULL, NULL, - fake_select_lex->options | SELECT_NO_UNLOCK, - result, this, fake_select_lex); + + /* + We need to add up n_sum_items in order to make the correct + allocation in setup_ref_array(). + Don't add more sum_items if we have already done JOIN::prepare + for this (with a different join object) + */ + if (fake_select_lex->ref_pointer_array.is_empty()) + fake_select_lex->n_child_sum_items+= global_parameters->n_sum_items; + + saved_error= + mysql_select(thd, + &result_table_list, // tables + 0, // wild_num + item_list, // fields + NULL, // conds + global_parameters->order_list.elements, // og_num + global_parameters->order_list.first, // order + NULL, // group + NULL, // having + NULL, // proc_param + fake_select_lex->options | SELECT_NO_UNLOCK, + result, // result + this, // unit + fake_select_lex); // select_lex } else { @@ -634,7 +665,7 @@ bool st_select_lex_unit::exec() to reset them back, we re-do all of the actions (yes it is ugly): */ join->init(thd, item_list, fake_select_lex->options, result); - saved_error= mysql_select(thd, &fake_select_lex->ref_pointer_array, + saved_error= mysql_select(thd, &result_table_list, 0, item_list, NULL, global_parameters->order_list.elements, === modified file 'sql/sql_update.cc' --- a/sql/sql_update.cc 2011-05-26 15:20:09 +0000 +++ b/sql/sql_update.cc 2011-06-09 08:45:37 +0000 @@ -1,4 +1,4 @@ -/* Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -328,7 +328,8 @@ int mysql_update(THD *thd, table_list->grant.want_privilege= table->grant.want_privilege= want_privilege; table_list->register_want_access(want_privilege); #endif - if (setup_fields_with_no_wrap(thd, 0, fields, MARK_COLUMNS_WRITE, 0, 0)) + if (setup_fields_with_no_wrap(thd, Ref_ptr_array(), + fields, MARK_COLUMNS_WRITE, 0, 0)) DBUG_RETURN(1); /* purecov: inspected */ if (table_list->view && check_fields(thd, fields)) { @@ -359,7 +360,7 @@ int mysql_update(THD *thd, table_list->grant.want_privilege= table->grant.want_privilege= (SELECT_ACL & ~table->grant.privilege); #endif - if (setup_fields(thd, 0, values, MARK_COLUMNS_READ, 0, 0)) + if (setup_fields(thd, Ref_ptr_array(), values, MARK_COLUMNS_READ, 0, 0)) { free_underlaid_joins(thd, select_lex); DBUG_RETURN(1); /* purecov: inspected */ @@ -1148,7 +1149,8 @@ int mysql_multi_update_prepare(THD *thd) UPDATE_ACL, SELECT_ACL)) DBUG_RETURN(TRUE); - if (setup_fields_with_no_wrap(thd, 0, *fields, MARK_COLUMNS_WRITE, 0, 0)) + if (setup_fields_with_no_wrap(thd, Ref_ptr_array(), + *fields, MARK_COLUMNS_WRITE, 0, 0)) DBUG_RETURN(TRUE); for (tl= table_list; tl ; tl= tl->next_local) @@ -1337,7 +1339,7 @@ bool mysql_multi_update(THD *thd, List total_list; - res= mysql_select(thd, &select_lex->ref_pointer_array, + res= mysql_select(thd, table_list, select_lex->with_wild, total_list, conds, 0, (ORDER *) NULL, (ORDER *)NULL, (Item *) NULL, @@ -1422,7 +1424,8 @@ int multi_update::prepare(List &no reference tables */ - int error= setup_fields(thd, 0, *values, MARK_COLUMNS_READ, 0, 0); + int error= setup_fields(thd, Ref_ptr_array(), + *values, MARK_COLUMNS_READ, 0, 0); for (table_ref= leaves; table_ref; table_ref= table_ref->next_leaf) { === modified file 'unittest/gunit/CMakeLists.txt' --- a/unittest/gunit/CMakeLists.txt 2011-05-18 08:29:46 +0000 +++ b/unittest/gunit/CMakeLists.txt 2011-06-09 08:45:37 +0000 @@ -205,6 +205,7 @@ ENDIF() # Add tests (link them with gunit library) SET(TESTS bounded_queue + bounds_checked_array dbug dynarray mdl === added file 'unittest/gunit/bounds_checked_array-t.cc' --- a/unittest/gunit/bounds_checked_array-t.cc 1970-01-01 00:00:00 +0000 +++ b/unittest/gunit/bounds_checked_array-t.cc 2011-06-09 08:45:37 +0000 @@ -0,0 +1,117 @@ +/* Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved. + + This program is free software; you can redistribute it and/or modify + it under the terms of the GNU General Public License as published by + the Free Software Foundation; version 2 of the License. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with this program; if not, write to the Free Software + Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ + +// First include (the generated) my_config.h, to get correct platform defines, +// then gtest.h (before any other MySQL headers), to avoid min() macros etc ... +#include "my_config.h" +#include + +#include "sql_array.h" + +namespace { + +typedef Bounds_checked_array Int_array; + +class BoundsCheckedArray : public ::testing::Test +{ +public: + BoundsCheckedArray() : some_integer(0) {} + + virtual void SetUp() + { + for (int ix= 0; ix < c_array_size; ++ix) + c_array[ix]= ix; + } + + static const int c_array_size= 5; + int c_array[c_array_size]; + + int some_integer; + Int_array int_array; +}; + +TEST_F(BoundsCheckedArray, Empty) +{ + EXPECT_EQ(sizeof(int), int_array.element_size()); + EXPECT_EQ(0U, int_array.size()); + EXPECT_TRUE(int_array.is_empty()); + int *pi= NULL; + EXPECT_EQ(pi, int_array.array()); +} + +#if !defined(DBUG_OFF) + +// Google Test recommends DeathTest suffix for classes used in death tests. +typedef BoundsCheckedArray BoundsCheckedArrayDeathTest; + +TEST_F(BoundsCheckedArrayDeathTest, BoundsCheckRead) +{ + ::testing::FLAGS_gtest_death_test_style = "threadsafe"; + int_array= Int_array(c_array, 2); + EXPECT_DEATH_IF_SUPPORTED(some_integer= int_array[5], + ".*Assertion .*n < m_size.*"); +} + +TEST_F(BoundsCheckedArrayDeathTest, BoundsCheckAssign) +{ + ::testing::FLAGS_gtest_death_test_style = "threadsafe"; + int_array= Int_array(c_array, 2); + EXPECT_DEATH_IF_SUPPORTED(int_array[5]= some_integer, + ".*Assertion .*n < m_size.*"); +} + +TEST_F(BoundsCheckedArrayDeathTest, BoundsCheckPopFront) +{ + ::testing::FLAGS_gtest_death_test_style = "threadsafe"; + int_array= Int_array(c_array, 1); + int_array.pop_front(); + EXPECT_DEATH_IF_SUPPORTED(int_array.pop_front(), + ".*Assertion .*m_size > 0.*"); +} + +#endif // !defined(DBUG_OFF) + +TEST_F(BoundsCheckedArray, Indexing) +{ + int_array= Int_array(c_array, c_array_size); + EXPECT_EQ(0, int_array[0]); + int_array[0]= 42; + EXPECT_EQ(42, int_array[0]); +} + + +TEST_F(BoundsCheckedArray, Reset) +{ + int_array= Int_array(c_array, c_array_size); + EXPECT_EQ(c_array, int_array.array()); + EXPECT_FALSE(int_array.is_empty()); + int_array.reset(); + int *pi= NULL; + EXPECT_EQ(pi, int_array.array()); + EXPECT_TRUE(int_array.is_empty()); +} + + +TEST_F(BoundsCheckedArray, PopFront) +{ + int_array= Int_array(c_array, c_array_size); + for (int ix= 0; ix < c_array_size; ++ix) + { + EXPECT_EQ(ix, int_array[0]); + int_array.pop_front(); + } +} + +} // namespace --===============8816226366192118440== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/tor.didriksen@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: tor.didriksen@stripped\ # 9grn3lym23vjpfcv # target_branch: file:///export/home/didrik/repo/trunk-bug11765255-\ # arraycheck/ # testament_sha1: d07baca597895060517e57a3cda407e0a7d96cfc # timestamp: 2011-06-09 10:45:48 +0200 # source_branch: bzr+ssh://bk-internal.mysql.com/bzrroot/server/mysql-\ # trunk/ # base_revision_id: olav.sandstaa@stripped\ # 4w7ssunpxaapjruj # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWSaNdLIAIwZ/gH87+89///// f//+6r////5gNn68Xvtb73XHfd6265echT77z1S6PR9x99yD77O63Xvld97vpPcvazNvfbr2w9bv nfQ777nQe3cG96950O5g97uLt5Ad2B33vH33sVyF9tHbsc9vU929y8uuIenVPWu9jHLu21V54aOw 6NB1HK7ldAdZH0ychr1oDiWYzffM+9vt0Hd4+5559aA7jbblruEkggJpoNGmSemkyRkT2qemqeU8 NQ1PSZqB6j1GgNANAaepoZBKCaATQgiZNNJk1MppjU0D1GgAAAAAAAAAaaaBEkQ9TU9PUnqMp6nl D1AAaAaAAAAAAAAASaUQiZTU2FNMKeU9TyR5NT0T1NHlDTINqANDQAHqNAANNBFJAJhDQEGhkAE1 ME0Jmp6hoMpkHplMho0A9Q0GQSJBAmECZTEyNJiejKZPRMpmpPKeUepkB5TTyIPUekH6poB6TifA gFP7IEE+RIRubmBo7o8vRIP5HyJ64iPHsDtj+5nMKIMl3eOXP7XSNWSj31GT7a8rnZvRnUTz+h44 6Cc04zj01tqfFjGOhuKdfXM585zmYc2234UsRWDJi0YpH2W3bDvtMttcUuKeZvatDjeO/b0a6GKr w+G4ibMomnUkwk67lqYMf2+j6sHfT9H/SH1e73fV/jTh/73VfXv78z9Ge//e3qqn6envuhF1Xe3f Y2GO+AkNJl9lA+iQhDu/HWgPde8cf9sWWZdpF44EDggwX2edSpT7IqY9l1bEKt0BOwp5lPzDSi05 KzvXWdV3TXIze1FB0zdTHvMPtOfkTyCWhhXM0/1y0URYkewi0bSv2GnHebtq+ORX8onxwOBy0GMO Z8y1ETLGggshD+WR5Fy7H5+GOmRvVoL866oeQ4+C488APFph3kV8KwpEOq4VsLGmaKOLRDwTSgWE JLBh6mO/ZM8uTo1m5DU5O+q7IYMMbZbRe92bb6WnjdIkw8dtZ1pqrZiWaqxqsrEANuFCBANgkpJO CUVADpzx4k0V1xZxeCqwzoXAxpVO18KoN5mU73FmIVkVloVPU+YbVFPjvIh4OPqzMBal9GCdPOq5 MMMa3bvkZMzViY2xfKBgKL3NXIfLRraWqcJ0M1D3twRRZ6atxyVLLNrPRZNVB7suV7nXaA7bsXoy MvryiV89Y7K5F6ALriiBAWeBRQiYhASISHz0mjDZgLCZQFgDBUgLCGGpsYiiowhNjaA34apYeWoH MxTXS1k0feZsYkgxgsODObB0CTAsgCCZZJSBYgUz16OvsKd69zLNHD+QdsY1U/5kFW3pSKDJlhSa 7alx6HY9aCykenoAjsO/CUf76qTRDBsW/DC/CDfBlSvoQHlTH3WY4q/vex2p/qif1AiQbaD5Grdo OCw9H5XULWK8bYfEhKgkeUSGANpsBsUiyLIqwgKqqoKLFIKQWRYLCLJFgGQh1/jUkHhsZDykILsY eiO2Pi9D2dro5WAG7NKaWRPzzuZQiyCWDpKCSdWoji3wiKXv4sgYQK5UhAt3N4XfW4cQMYwUQXfZ CIsuKSAN7Vm1iJR1IgzMtKkSiLM17NFKuqrsfz4RBMWuLgvBxxuZ7iKoyJu5uqYV1y7JlUws1N5M MpJ5uQ7bQxwtlCFDUW0WpYsM3qsd3eqvry3gCTs0RpRUBY+9vRQwOC+ZHf2BFcarfBSFTG42QSAj ZaqxTfrhM4TxtxyImXJJJCOHL0UIyN4zzwMfa2hyImHGEylZRkiCNMKccV+WoE5TlWQ9RtHsx/R9 VNsay1xVbgZlOFIUKTNt5REnN3o9X0gTs4MFJiZ1EqIOGDZMaW9StEaOjRkyWFMQTByNBUYMXiD4 DvWpo5fu/D6x9RvV9r8YeMC5mCQyTDk8YmOhtv/OP2gLujcjo8M9T3Dw+5Dpm4AUUvjX5TC9kGzT fRfhdUUjH8Gapgm7B7sZiq3OM1NMvzzaq3zp3pIplaB760EavRy3E/oVp+7DR1ENVE2kDT6WJFT0 6yXtrstUwOsgmbGadPekv4Mr/W7vRVWmdySB6uFyfv9r/1loAWn3n1Hue++WcTZrt5ehjXdPqrQ2 KVty7iLuu6TK6jl1Se+1cTymWjgPbS172/LGsDRs1Op7Ht5TeJ9l90sHn95x6q1ZqL0s3VWIQSm7 NnnuJk9QiPniRKFbuXDq3tBXmyIyNL5cFHGh+6mxAfKaStzcleQbOHJKwrpF6sZD2gx5wKE+I8jt R4XzcmlL2o6qq9wOSdkVPOuSkcnzC/mKSMQdRquJuamGqsaaV8KlZmFQUVPfrH9yEr9WtSpzszep zKWeXc4agr/Wru1zNn1L5KXPIqY54ZUESqX8uGetrmQ16ebvSemRbyRhERtr9ZKyoM8cgPEtibpc B/HVY80J8iIl+4GWmlDEsO9bu85taOpPCK2Lb25fvt1+BnzzDzw2sPO3PeblR6uVduZZrx1jGNvD LyvAlxBadhaXZiibNxeXQmjP49hBEzLuvxnR+itcz7DrwzU+7aWnuRKzDL2lRda4y+BY26dThIFa B7PrG2KXLRn7C2HssXqMnvnYn4sgqoTlXn6LXwWcmHbd3jj4tjjjSyHe3Al32Rl0RQVUf4MmTMhj UHl9Hn9DvN0we/zQbsld5/RK088zmlmhI8w7+nHF3ya8fBv5cKM2s3Nl14/B6/lNmjP5ChgGYZMh mZNKjWwAzCv3+tCW2TCPNM8wiOrh0zVtXPPCaeWGqE2/qXZzfOvEqmjK6JgCuDrgGUoJIjDABDAr y/jQkkfQhiWdfw9XZ9Xb6bQG1+u2H0azrmdQxeQaD+Jnb9f8pju42817KIiB7FLmciYIYFYoSsJU 8WJUFD2w/8aey/7EH70m43elDpGx1OTlXn3aDByHEIlPVRv6bjYgYsnuf4z1ZQZe9fpJWMLtUceT nJH7DKBjttHrmQuLpJ5tE2kR+Q9613SszgvS5BG8aDW9WM+Q1Ulw+3ia1h3v0vZvQEx6MMHwnHDZ ZEik5nutz9N12m3rmZ38jMPQbdJ3PeA0GpgbGYvqSg33klc6Ntp7WSeo9dEV3a+c1FtUWsIFrp2Y A/W86EluAWLnQiNSRLoEmqE93sfDrSnxmWlxZwks/2V5NpV7tsRCqirBJmWylPyGaGl2wzppb9Rv aZwgCCIfI0S76jj5RlSUUarIPubGEu/OCh0XKsmv2tEk5MM2hB+PxR+LRrZ92Owp6uPT77Uj1U1j zMLNC4pjGTFmdMXQyPUkLgEN2zEfeeyx8toVnohJh6AF3vMmIiDyxEELIQ5e8sEYix4668s17r9p Pk9gpwmvyhTdhFibQSPEA9aBbWJEeEaPLlZbWkolJVpKl1PpI+nw25w2nxQtE1UooYTKkzxnLW96 fStv05fVi36P3K7wnCsPAjSv0t/WdgcpyE9YBimhpDQ00YMAkNoQcBL2FBPN27niUfpC0aGAfzep nEkvxW8DbqYzWkDtgYJoxNz3vNYzMwNwBkPGcCMB2oli/S1I0+f2abDXY8DnZbTQ82QQ2ivXLqSA 5WpeSBsYTkzqNKgSJmrPIpLLMzOBknybWSyGyGVxHx7JJPX8RZ0zKJTLpLmidTAShpmPCu8uJH5D pP0qVVFULho+GobT554fvOKR9LE5BVJkiSFqEtDIQE3DaFNDSMbWPOVo2g9pgzMMbYBBg8KtNbvI QKilZcasIxrZZNQmpqhCqqqwkIDPkjB9ZhvwfDFgM+YrzQIsPE0sJZ54/KCadkjrOf2SeZB9RIAn mnnAo/vuXBZfR/H0Yx7S0PiHv9VH8/3y0y/0p9MUAWYsx40joQPEJzMLdbwQlt7ezHt7YxhHyuiR IcPDLz50ITmSJWCdkzJDMGqBlNUJhKyTkTCSoAVIVJjNBTRnIhXfu25N2k0YYYG5DvoGEDVIbrS9 IbH2iAQVTt6DAhAaInJVtg0ijkg2HVT5LggN5oAKETaS0HmYwhkiVhNI+L9V51k9tk7ozKBcAKSA TUCQJmMoejoWHmPsLFO62ne7qBHQYTdJngD7OzKqAJQgZkccrJi2AfdZrD2zsW3dy1oGYALIQOBy 3JMihkKJppLaXjKFVeXkGRnOy5u+SvEIJE4WRcGFChxsaFDUg0TOtDRiFxpDDjtyCGRqXNpFRERO cFSVjApcpaSJaQCAwO32CtcrCAI+jYqWMlURC4qBRG0z8h38P/QSAuWOoxabDYcBmZmQcN+0qbhj KFxiYOpUg2lCR+9Lu7qngTOQVmd05e4yqAClllIJsJj45ztmlOBwDbvDsAOhXGtQzPw7KNeGS9Vw MEnBcyYe6zpRYpEVm16ZCZRvYqNgDKlyjOSwLLFu1UwMgFY1ryl4ApKE+gGBJEFQT/TrHWcC7uYq Lj4bjYYOVMKc1cswFJokKpIz1G0hZyLGwrGHqMyi1h2EVKrLzo+uOOpfxnQy930NLtorDQ7SMFh2 cx/M0cMjv8xYoV4qavDJPmfu5cdqjx1Hk65Hnfl1eGvS0EjLb5dk6G7uktlc0dE9jkjkV3cwhGYz gMntgIHrziWMEO0u3pJNTweEioMBhFEOtFckLiWJE+BASPY6dBAzgnOtP4iHDLuiLM0Sm5AqQpBP kc0ocz0Ob7IyZjqs32S0xGF1NgiYwl1NNcKHWuxSyiwNJLC4cJCkdRcHfGCelx2l+PhHdbqJtRVo pyoaXCfXz48mTudCpyqtriM+ROi3ZjqAJwOjlTc8I6p1rU9eUJOsLx5OSjjOZ81pZKNC9IUpqMxI ERjQXb5zN1PXJgRAKm5udjPr1fSzcQTG1Zyh5SqQMaLPbt2Qu/niOi/JPrfEo5oTT6jNVrQskyuD NCytNweCCs8YiCWJqLbpTDghsSY08UoCTDACSSGdJvlJnjFxKImXL0HAxqct1zcm02SJUFDNpyjA Ne3bE7HE5TO5XlZvoMKMo2RCjOiCMbFHm0nNhUsjO4VH9KCEG0l7j5RV+UrcbNdVua8oL8puM66m 4xi8qLo1Gkg8xckaye94NrjOr5KHzplIHXmp4SRrIyIpZh5yZmPAi8t1ctR7bjA6qqiqQis57k3C 0uOGoKq7MbCwXclIcxyUSX5eihQlDq/HCttKdCRJtdqxgmxsWsTPjAASn6WKgpgnweMD/AmUVpoZ mRcWjNDMZoa1wXNwNDWZFviGuzlXXrOZZFjMuRSkLGUx3jLOtxzJfCSk5diGLr+a3mkfucQ8Yckm S8RN858kqhHkiUk7VcVYUqKJcie8PPHkUDRPOLZPjQjSmRT4/TxdOBUqfPLhSjACaCxpdPZlT4Cs lFq9TYqHxME8HYqvoRMgYnFr4uxnlWZQTwHcMxz2XTTTWgyY8TC+SKjLyQqYMJsO8ydpxuUMyZJV 3I3KnwKlzqUG0bLJ8C4UUYVjJJrxqZEOKFUVPbhPsp9CWypi7WxLfKIiJGTuWHgqDSOwpOsqbLh+ HbOSw6WKjjg6WYmIWqckpTWOw5IHuVPEqUqWGO5g9hsndFKbhlEEkcEh5C1NFDofMi5NaDQxnNBS TFNpJpUdxkeD1Crc71HFLlrDtLmhQsoSNokk1prJFFymPEfe3VlawXBpTo9732NM8TRWO4UzBeEH is09W48DboWRKQXf7fLYbAqXSdMJkcVSMuiB8VBPlokeRSLKYWfDF99612NE3knmVSOTOsqtLcxM crVVW4zSPe8iYrThVW+94MEzY/iTRBSg3B5JI8jonNKZcQOF2NiHNHDOtSCpgnCTXgaBERNzmMTI JpWRFRUeZBgZKFZ+apNYLFEPh8fA3MmTQ5cXhmyRJpT68IpqKnfJotK2zMiliDYyLOv1MGxpjYzY JKRRLTOZycrKTiqolRslGCk2DTlKLBjOWG9rL6Sc62syhgYGQvKDvHco9/WdR6WGd8HsLlV0q5lr WRflS3KCFJvuJzfJgbNsC1oNr2MOwZ26/cVWpuzQUjR0+q1rR9aRl5Da1lVen3EHitiBamCkp1WQ 4oNYmVZ3b1zJGa/yqFkabiomipbGTSzRMVf3knEOBiBT6felkMSXG6thJXNjl/l1S4FWcVZjrORR zlpfVhVqoCUgi7ITGYyoXadHkU8KXsbyxEG7eI5tU0epjh0nVQlOxex3H0coIc4OhjOLlpmO1CpW ejHsPFJ5KePI5KvODcZomQUKbzecK0NY7gCNM8DvUqXSOBenY2tY6J2udTka/IKnIfUOUMlw4JHJ IUwcaPnhOxyVlPIz8BaoETKZhiBKeErxTjitCnIKkpW5RVZ5W5jgdXg73Tp3O/i9TkhFTa6YwWk8 zBqRkmZBXO1cVlQQce8VJNkvoqhFwL6AwF0GNpuQhIOigIFvM8qHvsRna+9BdsCorDAySZEYaRwR udo3vzNpWEFQUj09fE6JTW/C458SWjMxTSlyjd4ShuQQWokHtkZddmWssLtCpeWjqd3hdtk0bFTc qPjY2uqos+B3UuaPtpm91Xjetlc0WImXRS1alrFaCle5ckE5lJ7FCC3J9G/sxpRETQJiWhAjoGTD nMC4qMsNajyLmJG0vOxYEw4nVtJiC7WayTOHLy1t+t6mx2nc4PKw0vodbSo1N2N1sB2Keni5+uYX c3qz21CD+Le4l8kcIrEUcqKm4zlqReUM01i0VacTpjvOhgoIiJZbZW5QATJySWKk45KGF8fFq3z7 jRkVJqMdDahQXz0O5fKuSOxbJg80QS01XtO+7mDQujc9zD9jHAz4dccbF0LfY0EiDhhaBeoIcQVI eA6Gu4SLCro7C461AVKmhmeBVXiVmOT1ct9Dir8qw8niQ5JDwFPAUOBfgxkgtGSx0NjR5HBd/NED f12p2P5qsMm/jffCe7LfuZySWlV1G02kTQONQxIWlxKSEhaPKDmwmIl44vJywpT1xXOnhvV5xUpg C0nmWMJM1n39E6neR3aFZnbdVacutZNFGrJlZ1rUofMtSKxVGanR60trtq8grVymDZEPBRBVJqHJ VqrosTdVkoWHzGa5m0yi43oTLxpSEozKbloN6xJEait4jFqjEz2C1rWDgdjAiIljBUdiehT4WzTR cuK6uXKlM0KcnLFi8UFJKMxYViJygsQdAm0qXXSZG6Tlk2KdMkw91upsWIMjm5uOxrzqTODqWMHC nIx0MDEDCjqQOdDr9LdOfMb6vDwNpz2k8BdSkiBUPheyD1J1hJaVkMncpQ7auFKL51+FVFcIZYwC qTAUYLEVeNxR71WpA4hd2EREWCx0GMvAeNIe4qV6lTYnOMlxyZWhBSCZs0bj0FHn13Jkp0FcpLvY 0PdTJwbniTzMUbYyX2AExQlRqcQKb5Cst+WMFABGG9MZIOmEbO5k5KmFmxpB16QOcP49yDJbgUKp Hkzj7kzW5wXJG5B5DnJgFO4ow7FixxxY8KHkIiI7+9E3+iutFvJm7GOGZaGtZJXh0fGNjToxpC7Z twuUNe3MgaRnRzC7UQwaZzmDtIG2+3ZaEKQhpZJMSBqK9B4DMxzL1IqIqHidE6YavWpoaiKh4nRH MAJ3BbExDu8Z+PDzfA/p+plOEG5gUaosrvrkTT26rf0eKoWssHA21xlIl9bEXMC16uPGQsnkNdFb JCqzwpn4M1Ox4Ym6W9tidYIMMDaY/B/hUnO118y7JyAIg9qLNNKR+xbnNdO3p2RQ05XDj4/z6J8B Ktvb8Mhv31GpAv7mcnMgVMILXfcu0d/H2+ktUx+LI4vsZ8PNscDf0hUFIsRisUVBRFk3yiSQSBhE YYgHiRZYpxAQn9yVfHv+o3EIG6BOJLCqduhnJylZQgh52XkvZIshZCwqtRL95+8mPtA/nEl2P2y/ h4SnrRP4/t/jAFjPtsB2BYHTPb608bEVSKQGEFV/78AG37BC2QH1rAHzXSn/jz5kTZQUK23Wdwsq ENYJY/PaGYj6AK6DgGSxVdFOB+QHj/w/l1s74WJjcrRGS36coLnZYqVVklvzAopc1AIlhCVgsq4w Nf03LM6YIg5qFgjjZtDBsczqJp4H9JDtdghIP/c4LEB/xjKL3PgE0aMVmWg34z5clyMhNEnTJk/e xCwBBEiF3Zi5E/xyK2uOzFcy7J1cdWlEwD9wfbnx57ylUui1Exlk9YmGgYkzK4tmHegvC59CEW2t //LOugfcoFTlOF6/IOrahEuS0M10FIntdxkIoNzfYJZJVs1p8V1MFwHevkxqlWRM1CUsDjnt4LYi XLBYBYyxZt+HC95mhQw/7YvyaR+33wgq0CfwQrugjLrOGsz6aVoB4UaAOdZLxO5E6Wta1tn5QInT OWLOwbuKnFaQWi9qluLzJRgNFlKl6wFJoj2JF0E1L9f5IvekQsoV1omuzNe4j0TlHtlzwVLKXmRn NKvp9TgafMO1ER87T6wwLIDHqX9J9w64jBJ7vn5YkLu+nCZZhKR7idko/Q27oOjxgf6oRtSORgfG vSPSwxCMqizxDCcnkIJa6Ph0eZQGTMPuGs9TJkA0ehJA0U0skqRLpjCaExdEMphkhrGTFC6wZrF1 AsKCioNsl1XIUlwFizSgOC6wxJSUZNSenkN0JQpU4z4WNScTDSERUAXXP7clVXvEYlDYSkEyE4IT siC9qDK2laJQiwoyoKJrarrJjOEmEoVHVBmYVLmyEAAwCOAqXMF3vPda1tmpRG6G05cGweKUnU4j um7GKMYmxahSCegJBJNJAFgTMGm76t4o1YFbk+O+QwE3JBmkg9S2EmRiG6IIjYSNBAiE0DAWNE01 IoCnYo0bpcSHQWIy9GbVhUmOthlCZRP7PAlnKWZZ9pofad8g+86T85Ykl6ziOQlKTGQYY+Xt2EpM foKT2ntGHk5elJlDR/InvJEEFmLnJNKJQ9pQOCp7koMbEjIxONpoZDMiRmTLTkLTrWgL+3iaEy4v OkFxKyc0CeOJSLXAWHMWl5LQbSIjmRB38T0Oc04YZioyBYTiykB5tLy4iZCmm82nMWLnVaDU5CNQ ARVod8tPv0JDlImZr95+wawDMh0FlPc3uiP/pWfaHuZm8uFsvDrIe7TAASA0dPdESmyK9hsE0kzL mn7HTvmZgO8QeBL2gm00lIX6thJPaDOOrnp0kNWBqokknv+iWSLARkDECJXEoUAngBP1wtlgGcgK THcuZ3pOTDLcDn8KvsUKUenccQJz1JAwJ24gYHbeQ7cGoOJqNrQDdlXiYHP+lwJmMirEEQIqVDIE GUZL7rzkHWYG4enLSdZ4LV4uwvLjgPHHYdhqVfZ15jMfwKDEzm8zbioppkLClIXiJiotqKiiixWl IxSSFe+BlJCeftA6Bb61aUmwedi5lWZBxgVOszmR6bm0pqKg7quA2k5MSILH2Np4cRjiXOjT3O9E 1rW2l/sK3U/Bgfu47olacC0ouTgeVmo8XwNrOE7zu/MAgzAeFKhyb+jr1+SEMcAIrrVSQAVnMdhW TWZJu00Vh2G83uh7DAkWbw2MFCYwxg9SZ9iDoMUJEzJU5OSx3JmjBYxoKCCcrNZjqgSANa8X+kD8 KQpwNJjkMxcbzI9gVtB3mcsM5kDse4QDmJwkDhpKSs82bqchWBG2e0ibSY2+MQlcV5wUSFymRYeA ncPeeGIjv2IyICfS1uF08Cvg2VhQiD22j3+FwlPASSL4LHNjGj6mB6v1QEgaLF4askZcq7tP2UZj 0Y+TscVQ8yKWAAhXve1Oznt+8jVGzpRX2Marnte5uZ249R1PY5eBPjIiAtlDKZkEiyTKccOBJihg Zp1qa2ztEJFCeCJ5JCYAzEMBWh4Hd4GMFxz0HNYesxLSQVneXF5sMhUWegZQLDaVGVOJvVhqI0TQ uw9JBkklQ1GZg+prKrjbABRpVbjKXSMCbKbyymMii5FNsAEkJIqiihkuUOA7nuEolCpBYqclTsdy haTStAaDaqiYpJCg2FilFzaqbRqDQnmPUuvrwM6R+4p3nJCEF0lLElf0+vxrr5E9ACEjlFZzTa5Z tRqfYYtB2dq1Fb1y5jdpQQ6DpzxDCgwLECwOxnqddAODiptKMx1t7623UUcMtVj19MZI+4yfL2kn ZPMZe6XPK9ETssGwhpGvmVGkA38NCNMtvxrkhMLWqtaSoIjV1f7UpXZGljfYyUpne+/FQiZm9n3z TiX1nF31tPNCs+uw2jjk65bXsR00CohJDMIiFBraJzM2ZT3fXSlLSpvg0qMaIHahJDTQltOsyPCc TaUL6eyFIr2naQWWm4ZZePz+fJYv9swS4Rz5HW/o3MeDN8sRJPs+ESJQ3gtJeDtunwOxSZRHvk5A 1nEmJC43LWOKseBabdspqmKSkrsNpIyFBHmc27dymLNDuhF0ou/nAwhSyFJaqZ0qL6gCYsHIAO6h hHKgjBUDJIip5Hz8HuMgRHpwW+1DLMVWDLHUbjOMRNZExKcqSUDgDvgUfY9VGrsvloYNfGzRHXPS Tew48iPGYm0yIqZmTMMFoCkUC0wRZyO+aHrON6uBeGu84ctoZNFfLGcbh7e3ea1HY7zAylYgPSCh EEQyZDIBUKY771qtWIbE5WRWmsrXLxYW4Nl7XeVLoFXOIB8R6whhfWOBpQMsCdzAKmPoSJ4gihOz Mnum8AoGYiySKs147zooEDf4Gh8Br9ieAycnZDY1UREgCE3xJwQJJJeRdgHSpAs9/hNeu/mGZTKK WkGLI6YVYhY+ks0sIEkFEioTZgF51LbVFnv/NrWuesZVgai1YNIoSWWnf12u7k9s9+Dnai7a0iFU BwqJEBbfIA5vWuAkc4q3IiIFJhVtLjikehor8m+sCcBKlZvdNazgBg5k+smmATJtwFXJcate5pAe MUKBoH6qTmA12iQDPWUpBpQNRMqXJPmqOPMSJHcSLju7rBJarjuOgfcd3kgMhdq9hkTMA6NDWfIT JEGwgyGbzoocLEhCUFhWVHd8/xebl8cMYDKg2FBoLR5sWBWaTMTzG05CSXEHRS1jtMBWw4jyNs5m 5SDIAFgHla3qPc7mdpcp17CAX4/pCUQPzffKiAgoh++ZyH3Ivd70WFClF0gRNqZWJE/5fwlBM6HR 6XUo6nmcofJcgdkW+mRntw531NA6hoczY8vkG58yhourEsn6cBZZbVoWWW2gGJJ7nhPIeWcNvlvW AvXrNBE54z3fBzPa1sQNcOLFhoyGh7ztddVMQNsCpJM+OmwIhtANjnMhhZ7K31emInb2xxbR4KMO dtDzFW3kWPA9My2ZCj8vhQ4ajowNBVvUeR3GJt1X+DoWLA4IRi9ICMUgyt1eRc6nmmmlAZlvBWD7 JkiQbAPi8JbT3tr1tSCGohQPwX8dl5eLCuFC8HF5sn0wzNQSLWB83wMj8z73DjLKGt4m1kE7Q6n0 AGlpZjzil2Pgw10uj1gCkWqO4hIaTQdjyTn5ECTed9ZEFgHCbkYMrOFAQQECH2BB+Ki++sE34wih t4/y8oCFHjXdvEksyp/H/70ryDT+j5YblA1BDIEUqAGtaKMhoEJhufA2YFCCGh5h2BYoju6pASZz 29txry5CDazYxd8gQszmDeFGy5eQAMczeMzH1en1dHDLaajdOHjAQpmgs1gRi1ID1HAh0UES9Ugg HyMSiob0kginot4rXksWA3IiGhRVQlnYlO+d49ydf3mHSdznUYHkKwnbO3oAHjO7MEk8MierBqdz udBOApbK1mQJ2w6Sh5OrvL5IhRNeL5hdZWqrEKIhREKPzUs/m/CXZbarYiW2W2W2XGMHghN3nfB9 0fEYLd2DGOrjGLnaTmOZI1BqeSAcdsTBeRfgPKpuPkcBgqSH0FehoMwx7qHNBHkgh4wBI4Pk2r7m c7SkoataUtSEoDEmPI8Wxy5iGD5zkJEhg+BB1XcpneQVZnOI9SvORzHXMpFv848x7jg06qLi0kVJ IDJy8wXjI10tIDio2lBc7jBtyvzPAAMlTneU0v4fh8uKhXrFX+1Ag3JrqXj2rcP5hscAQoUoylSL Eh1QISCYvcXM0quS+q2LGPC2S0k4EQLNJCTCQpICAJMCux+42ZwIywZgaTU7TK7DQYWOnZ+ieZDm JArS3k2AEqBWSKkIuSAB6Eo/HRWKB9gECHdqrrFxeZeogAiAdqbXU6yusgCBzAmcNZNfkIIUiFYw KAG3phrPW5HaEH3AfhmaUIAgCORSxudoGpecqOmLy6ROZFpgk8Qzizqa206H0PqGSe4beTgVOZ6w OMY9bBTE00hiRRmISQtSGEN4q0E2VnaWEnIVp4g6/okE4NYkCGDYh1hIgTGhHbSgVZ62UQhrvbzL k4VkqVDAmHanv6V0Jaaxk00JQFDWaHe8E8IhJmiIQwrO4EzyAj61wOUjgdWjTxt+U0KO9zvM6g52 dmUcjzTup4zTMGoV5BOq2oNhtUZAHbI7XKzjNAqaW3yaHTnOHTK4+WSdsD+fM+nXmmcPnHuBzmSR 0DhUHDQAo/GhLTC7Ieqre6FA8ucSCZBgMapaZCr/NvfE3sutmeIhw5VyXQiwZwEPlJtfme/FiOwo rZj6KKSeksKVXl1utTaQJIpykWpDSUJLrJABjQKSTChWZRzQlEwToPmgvCUHlsREww5/IrCghjRw TCwYZFjlZsHy8fEqcyVpBEJDnJTR4vtKDSeTLW5nS9UGSO0524TIo8HSo8b+AvuQLdYTMozM5Chy MNBESLpamSKZxgeeRCLCUJDMoKZEJAVswGSGaSQ0OrPb7vNz8+ghMUnI2PH4bG501PY/VRn7zshI hugiEiafZQ3s05LlZvY7jmuUarU6WlTRuZBQSJP54PTXOphUjpAj9TjJyUh7W5zgnzsyj5qoUge0 GoAwFUyDCd7rQuxJOghEKHPR1zGkzNKBIRgA0tDiPE/q8wFZmJ7jaKfmzPnJfB8XsWZ7miAPibCp 4F/13fomnfpQhWQCFIQfyRUgAPSpQ5L3/T8kPX6HSFgsnvUsRth4GDwWgXuJlof2/MTJtouee+jx 8P9epsc3K2FwsQwkBnG9QqqfmcGoyr8CzhI/XM0PomdhcOw93vsID2/3wQ0xh7BoK86AOY9zWUUB ADIYQeJpcs/P2QhWp8dCLCrKZJjfIJ1D1Pi2jwbxXoW6Ad8knFX0KPqYGlT6jF+gk+RP8Gl970vG JwZOmrXDpjneMBzs8/uOVqKwUIPamv8mHFYo3uV5LIjlC1l+OFnj3rylbSqAWIFFRHU9jU7WYTuJ nvhHaXNCj3O9n2HEfOZTg0nwLXrZPE7nWebofSajO50U4XkhELzlcrg86jOwM469H0d5O8vm6Z2j E6Tqzwng3nLBRYpBm6liQRGYYdAqpEwBAaMYJyng5proaa1ohZwihGMkAQAWSIwBIyA/qAxCKzBY UhCF+1qK/s2BWcICdRENqnQ9l6D0F6SIIIWZh4M0qzF4qA6S1I9jn638h80t1MyYA9j8J9PPrur6 7ABTXeYTfnBk34wy/SWYZDj0fG0TRQD8f5IStTuZaK7GACVq1r5JG04cFRQJJg0kvOCsrgx7BkZx CDRJlGz7M7K0ZDBBGaXt6JKvg9QmCbmDPjOYcx7gLAPNRCvrHVkT42e52OQetR6iqEZu8VZ31KPx tpnUgMpwgiHbHWp2Gqk73MGzVlUKKVOM9rsdhDoHrCQ95FhBZCCwCCIjAIIIBOsB6knmmkOtEFYa JKAwJQKeMQ1AwYVkTxS9oiKgUO07lI4JpqcM3LmTunhHqXbY0wz0hm9g8UgBWcid+tHaTqLSdCcC TUQBqAAlbPr8l+01NEvtgG6yPPwIMvAdOxRHDi2ksRKaHlRMyJBTMDBYHuMEKnEpk5JbHhi/bSoE gVgRWatAUlGxSMqQqyio2ibCYlAiYwTNchLEApDGOpddmOiVtQI3dQJuvn9nsVRvKitqXMXP0uZM My7rSJ8LQc7l7N9WE8f+NK4+gxBkrBGDzt2ulMYVPP516UCCfsZ0nm2rmXABsDpeH3losRvnZA2x xJJQeqT6/6JB8lEojmduHsd3mYxCLlRejmcjX73VNEfkRdQAdjB6pG1Wo+lQkKUR7lKzByPeHdSS 6mSW1NIWzicd0rvsYI9RvH5io8tihA34OeY3yE+2+pbbbbbbbbbbbbbbbattW2qttVbattttt6pn IMO3bRIcJ2JCZIGoWbWjUstoostoostp1AlsxbLWypqd9A8s7QcAh5ZVPrEOPM6WvX7vNkc6CTAY FGOJSKsBFm1kacOqhXpqATrxPEqHOp2KofH/kyu8AJ3CKsoCQE8yyRZQp794lOJ7n5zxY5aw4N3u IHzcASfSACubdq6fMfDI7Oxbi0BWCGEgizwacOwgAhVSKS0knAf0praNogkAglBJ2ZIO6PBG3Eiz BARsgCyBQoQIHfIey8V5F3KCioM4gwKLJhjkqkjECJFNnvicUhIQAamWGbc0JUnMAJBRakJQmhKF QBYzAqTBZ9QcekXiIhlbFYCuJG8g0y0kSDJi2zLohuD34bDAZBQjIkESCJGAyCyAnc4YMJCGeT6N KkkDROIDobgJ+9phzu4J6mBF0VVmEpNcgGTDQOOMDCjAIS84AZQpUUST7fX8LH4u9/Mo12e1pCYB sLjSXqyI4IqQwTI9LmZI1j4vWKetgQ+bUgJkmJROXIeZiKwiy/ZOUIBleQ9WUQHhbdsE2kNAIZ5M 5OcBJ4AOiUUMOQ8ubiSP4n5zpqKSt9ZOqGdhX0HYGFB+h+VyX50DK4jXB4kHim34h4EblyWj7Xgo 8Gj4mg+p0vmdyaP6WHSmVvU7WpvGY4EWc05aTSBzOSdk/q6Oo6+Q+SMp+s1OCB5Olv0Hjqes1HIp TpWkmVkEoRCRfmImoQWiFawywi86SKmUu/LWJSs5stmWJCYKMywwEIVvy9PnZTS9hCOZbQsIeTPx 1sHGYqMzqejF8elvACgGEWxl0bfBtfpxMfhfr3McDiHKPBivcvGpZI3JjI6AGiSr270zUewmem5K UUSAAbVeJJZC6owKF0z8kMqWQUrE2rvKssWP6bMqwoRWzmcIzD8SldS+BbjtMpLxEVmfJpmBkTj7 7lOtxJrWdblCADzzOB6ZjGxRVuY0HE0tzzOY8XRqJPK9R1mZzuZ5c2lytxaycXAq3WKCHlIhttsE rtGrVgsFJfMpq4Oc3l16XORke6ZViHGXxrSXmBMTqsaYtoOKdYYp1az61okOtcjnZ3ZfBAq95kpD q5OluncS+LuiQmiMuEmyFO2zKHI6Oo4ZANNqK77NRFSCMQIasCsgTRITsjIXdPWwbIAfuQhzDDek K6itpJvkex1vt38Ckwebe87wNLQKuvW8ryUKCwClKUsNQLFYqs6SzKpNo1h3x5zkqdGJVPOa05Hm KzkpCIQdg4RNMqOPYSZwy8ba4PE5yZktitLloblxBdfiQQH72HvX52KHAUkIoMPiYK0LhqDP/i7k inChIE0a6WQ= --===============8816226366192118440==--