From: Tor Didriksen Date: June 8 2011 2:13pm Subject: bzr commit into mysql-trunk branch (tor.didriksen:3167) Bug#12590211 List-Archive: http://lists.mysql.com/commits/138860 X-Bug: 12590211 Message-Id: <20110608141335.E52612A5@atum07.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5091042570915883581==" --===============5091042570915883581== 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 3167 Tor Didriksen 2011-06-08 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-08 14:13:28 +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-06 12:49:55 +0000 +++ b/sql/item.h 2011-06-08 14:13:28 +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) @@ -931,10 +933,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-06 12:49:55 +0000 +++ b/sql/item_cmpfunc.cc 2011-06-08 14:13:28 +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-05-26 15:20:09 +0000 +++ b/sql/item_cmpfunc.h 2011-06-08 14:13:28 +0000 @@ -1538,7 +1538,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-06 12:49:55 +0000 +++ b/sql/item_func.cc 2011-06-08 14:13:28 +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-08 14:13:28 +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-05-06 13:32:53 +0000 +++ b/sql/item_row.cc 2011-06-08 14:13:28 +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-08 14:13:28 +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-05-26 15:20:09 +0000 +++ b/sql/item_strfunc.cc 2011-06-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-05-26 15:20:09 +0000 +++ b/sql/item_sum.cc 2011-06-08 14:13:28 +0000 @@ -3306,7 +3306,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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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,30 @@ 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) + 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); + } + 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()); + } + void set_items_ref_array(Ref_ptr_array ptr) { - memcpy((char*) ref_pointer_array, (char*) ptr, ref_pointer_array_size); + copy_ref_ptr_array(ref_ptrs, ptr); current_ref_pointer_array= ptr; } - inline void init_items_ref_array() + 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 +2103,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 +2292,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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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-08 14:13:28 +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 --===============5091042570915883581== 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\ # igf5t6thfqeqgyr6 # target_branch: file:///export/home/didrik/repo/trunk-bug11765255-\ # arraycheck/ # testament_sha1: 15fdd6a6940f6b5fbc3587ec15a3ab2664f5f9ed # timestamp: 2011-06-08 16:13:35 +0200 # source_branch: bzr+ssh://bk-internal.mysql.com/bzrroot/server/mysql-\ # trunk/ # base_revision_id: olav.sandstaa@stripped\ # dmpg1vuwf6g97141 # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWTHWytgAIsh/gH87+89///// f//+6r////5gNf67zb4rrD773r7Wd8fQU85d3zt3Wn3vX1zgfW2X333ta3t90b6e1Pu7vu3MYNfE 3W+7A6+7uDXe93oPbrg973PbbzuAoG+7w933ZvoO2o67DSs703nrXe7chtU2bY3NO6HHroXGABt3 cTfZ6O2Br09GnXoqtARbaieNuvdqDbzu62AAbyty0wkkTIRkZAZDQJqeQTJPJMNTUfqTamQaMjI0 0NDIGIyYglCBoBFMTQpiYQU/VHqfqgNPUABoAAAAAAADTTQQkI0yCno0SZD1PU9QABo0ABoPUDQA AAGgJNKQIg0QhjVMTPUnoZJ6mnqeSaHqZMQABoZD1N6k0AaGQIpE0BAAQAaEwTRpoEMmkTymyT0h tJkGgA9QAeoJEggJiAE1MRpppNNKbaPSiPU9TRpp+qeUB5TTynqBgTJgh6hvvcQon9MKoe9IRxOJ gadkefwkH5HvTyiI7/IHb/OLmCAMl7Xllr+F0Wwko99JR5nN53uq761A9Pe8cOQbi25t3Ny7uR/5 Jci6cd1Q3VERDIw7l5de4RYisGTK0YpHwNueHdaZNtcUuKew3otDjvHu1+LTMxVeL5riJqyiZ8km EnZcmpgf9P0fZc76qPnkt+hrfu/1P9f33b7/2/9hXVb9ejj9tdHHjxdJF1Xi1/g12zbIGQymXtIH 3ciIY7cEB5/Q49yxRZl2kXDgQNiDBff61KlPoj4LZ0Qp2QE7SnvqfvjSi04VnrXqPVd6s6t/3ovP Rb3s9bJcTu/gLqiWxi5t3fbZffRlZMRaNpX7NOW83bV7JFftifLA4nVRjXUsCJFWgm1InHbI8i25 Px6vH3ZjbVoL868kPIcfFcevADxaYdLFcC4JSkm8HGDpnEScEVRxWbSsQXOphK0l54SnlM7Gk2Q0 N/Sq6oYMMbZbRdu3fXvDTuOdwh3LrZ1pqrZWwxrdjbZEANuFCQgGwSbElwY4JIAA64xuDTRd07bj sSSWESHQMZVTpb6g3jGKd7izEKyKxaFTvfGDaop8O8iHg4fNmYCzL5ME5fFZvcwyY1Vu+IxMzViY 0xfFAwFF6mrkPi0TWpUWnCfIjMPcONCizp8aCEavNqwosWdCFmXC9jpmQdtsWoyMvs5RH9PETu7G NFR2RSBVGqBBQiZCKEQieuBow1YCwmSAsAYKkBYQw2KJCiowgbG0Bvwxlh6agdGiZ2tZM+snCaYo MYLDiZz4OuJMCyAIJkySiSKCK5sfi4kdyXOnVNv+8OTYpY/QMS2cyGgXsLJ7LsidtdaCs4+PsAj4 DrhKP+cKTRDBsW+/XfoiPNDVvkIK2W/2ucVTP2PnMkv0pfMCUCnAHAwT5HGdX/J908CZkbxXvwkz JD0yQQBYoCxSLIsBVhAVVVQUWLAWQWRYLCRCsQgVAm9xSFIwsKg96iPngPTLwl6PTGjwLkGwAOfQ zQzcBHojBEh7cLYynJJ2tRG1vgiKXw4sgYIFGSEKdzQtzjMOIG5jBRGk7kIiy4pIA3pWbWESjmRB mZaZupqsy+svOLwVVXJ/NcES9S7tctM442Y7AqiqMiX1uRgtvBRktvLbjRFw4ciFKEp98uOk4IEk NRbJalhYM3N5Du9VfDFvAEnRojOJuBUOMmToYDgvjEdOgIrYTe220C6io0QSAjZaqwpvwCaFCRG4 iIckkkI2brBQjaNYZ52GH0tIbiJhxo5qFgo0RBGmFONq/LUCcU5VkPgPwHdj+f5UzfeGsKrbGZTh SShSZncZSjA3CkHg8Cq2ORkWmJnUSog5MGyY0s5lZIycmjJksKYgmDiMhUYMXhB8A6zmXN16OXjP W3f63zB6gHqEgUVTDk8YmODafs5u4C3hrRw6Z6XuHh4Scpt4EIrqm8bxLixnyUwpwUSkRN/xPlT+ IufE8lv1ifGLvCRlFm1MXKlMloH+ldBPTwWk/qbD/W/LFYkNYxChDHLApWeOYn7689rUB2kiozwa uXfm/Tkv9kXNeGQ4kNbwvEdml7wJvS6n+lz58NDnopdO63UURySb4wMSfNOu4avxapPB6YgvVzyP rNcKwfbJ+zQ5Y1caWWp0O8K+dKaHgtDv+agrL3RB49r8i4lgzQb6vRkQNwYH6D1JQrdy4929oK9M iMjS+XFTP1y1oD5DOVcnJXEGvhvlYVzi9WMh7AY8oFCefI21nZzkVVl91km29wFZGdMrZqCWFZtG 8GJDYDr2Wwm0vy4RpYvkoWSobIzuS7AvYYM3f19jWz814DjEbuKXS9gr5RSfQ3Z4L6FLHmOX54ZU ER0r58NB62Mhr1Z36SlV5si3ijCSjLDbNw0RS8CJ0pCuA1ccradSK6xJX7wHRJlrLSsYSw1ZdCbq TsUT6lbhNcoz+0+EUq6zNJeR3bSHTUtc8rsgNzDC+VZT5bc/RqOIpnXZyDBm2j3SnDlWqX7nptmp +DWLVIwdhpX1VtCvfjk0khWkQ8oZvm9LFZY+lakKrKzjJ886k+7IKqE4vx9VbXGTfh19E4+7oceO OkPR2BLusjMzAKqM6mMVDGUPR3+z43ebz+l74dDRld398rPc6eWMs8Xl3ix7NjvXm2dG3r7r9OB2 PLf2/L7vcctmv2l7QMbYNMbdiODEmwNG25CWmvVDU66p1A99/jPU2KSaSW9PJekm2cl2avlXYJI0 7XVNAtg6YBlKCSIwwAQwK8X5kJqeCGErI/N29XuePyTAMy+SZzVdDw4jIPWxu6/jH7HnL2e1gRED v0uU3pghgVihKyTuWVBQ+0HzGfgflEH8Umxtwh1xsdDfyr0djmEHA2wlPGjf4LjYgYsnuf5Z45QZ fqXzkrGF2McuHQkfYZQMdto9cyFydJPNom0iPtHvWu6VmcF6XARvGg1vHVPgY0lx+nka1hz+d7N4 NoUx6MMHxnHHZZEik5/Lbn8N12m33pmd/BmH3DbpO57wGgxYGxmp/GlBvvJK50bbW2FJ4ntoiu7X 5DEtqi1khqysJA/n88ijWAxw7ic7qMpEjGIdlhXp4+Nc2d1S6dsAjPtHiN8X1vuEySxMiHc5Isew 8mPguR5ax9Nh1jtgCCIfBol1qOXpGVlFGqyD6mxqXXOCh2XKsmfGwxHCHBhA6u/ephzp+vk6xT0s eV0tSPMmjHiWDtIdOEoCdolPIgHezFwCG7JiPS9lj57JFbe+cpI7wln5pJk5vG2TGSmCMu5tDGmN p41rkq+V/Iz0cyDBV8BstkxsTaCR5wHrQDciGYP7oFh5uF4qU6TQ8Zj6Qnzdm/jp+C2sZmtnYdQg hI7y1rdvrev3Y/K9f0fv33JFZKHtQ4n+eq/dPsD0NhVnAMbCQpCQwmEAEhwCDcpjYEEdisuVqQvW F8UEx7vav0Z95pysVZyQ7ZC5NCBrfKRwG2wfcDRIcAjrI3llJbXgO7T+vpt3HHgEwOeHiNMzfqSN ObfFXet2qBjbROGBvYTh0JCqkBBJWbAgqXXa1MC+d/NpajLmT5T9230UU5PGssaBxYCUK5jnXMtx DePUZSVkzBbeDAbcFYylGmktufotoyVGFqtJk01QopqRMksVcVU1QtbrZUtruiyZKyaKlreohhGF cMOnpJDRned2zjfV3DOxaGkO1NTWKEAqphdA8Xl8SjwIA16LPSZRkhOydl11P/gHc0x1Wz2C9rT4 tJJntnvAV6rk4H4vk+LGPZWh4zGPb3/H5Nd+vycXjzJJ3/oqeBTqQmIyiB5dvQi8VPDl9PppSqnb KhSqW7xs5syJKyGaG52SsgoaoGaapJhKyTemElYBqyTCQwkyzoKaM3oV37a7ts5mwwwNkOlAwgaJ Da03666YO8ZhBTr9BQRMNRTKbd+JkmSJhgSbPF3Aw3EzQAUhJKAcC7MsgpAg5ERPl/Bo+JIl0KYs NwSCYApIBNQJAmWmU5DljFS0qqVdk7ZyYF2hAr1OpuCeEohtAKaoEQpDkWzTX0CKl1M7FtXfoGBZ gGAKZCBlEzAlrlnliGA6hkUkTSg42p0dlrRIiIBAiDI8iEirmD7KyDZMgWBYy0RtrbMNlxscj0iR qK2OHDMzLLVkoNcqXoQEKKDfSUs8UASGihgcYuRHBDCKCURstDgPHv/6CSB0qdTnJwKbOxk6RFOC UsGJTEOLLIGQoCBUX2wmUlHlBgHn4CO7uiexM5is13Tl8hnVAClnnIJsJj0znbNKcFZBFuHl2AHe VtWcyzLZ2idc1LqqsYEm7mqc3inospylSbWpgJlG9FRrgYUsUaBG6rG9ezpcVAHXGuZhMAa7md4Q KXwKBRkXf7bCWroOD5majE+/1nEyWaMq6W6AVNsCSRBrsOQ0pjuVpUYg4zKK8oMIsxR19HbXHFTo L3nls10NHrsxLymkYFh2cgR/Q0cGR00JE9stPhtyvyP41v3KOWe3XbO0XSRUvm++R1Dg/HenbkOK TRwKFBmZo4jC5UKmwds5zJwjMYS2wEDzwiTwcPQu3pJNTveAklXAKEJpBSxkSvcsZFs6JtU0kFD7 3LkX5lS/Fu+co4MgTNBDqWE6yRORBXiQZMPCbG8JzBKygrWR5ImQUI8DAppi6lBrBQgYJPBiI41k YW2CISFKHa3UiaW3SP49UhBdMWgJl1VMKcqaXKfbz3udTqUPBVbPEr+ZOix3CB1AE6kAgObOxzPo la1PZ5oIjSKEyJnmItvNEEkaISNDe3o2z2N5lhEAoZFOxskX9gcxrNnhmDbbpqJURiQKLK3bqjrx 0nJfen1o7SgcCJd7vWdalFVZQvJ3WHQPaxJ8szEMlB7w3IOyDMUkRjykKGSGAEkkM9MCb5cE5JXE oiZOT0GxxmWpwuuV1zNpUiVihx2nAdWQ7KSxO12uBsZ8SobtSiVKIG4YQ0NDSnGBgVxoQDJD0TzD 7T6Sac074tjpIxo9pyITOeyZILkcwsxzKQmeIuCGZjRMVNEIrFz3pdoGTeByhnyzhgfIdIRsMSnI noXAoala3hwE22NlE41kzrWAa8MRJKzWHOLxtzg4DoYzQ35FsvndAoWIlFceJffFWIEPURkS6NOJ HqwACMvU50JbF2kzJ6eAZGEqUNmhTscFzlO6ONGcvFRUWF/eMup658ZpVK1zLxlCQtkps7xlWtZw EfMWFxz7Q7Y6eSfX0g58yG26OJzpZsp2RUl2WUlKDJOkZ0IShGaqylp7b4T8x0NFM4tk99CWtsaN DEff8LpyKlT4Y5Vx4ACbLMu1nGrKnuFYo1DOnD3lixMmU9RmZmU8NasWICLUWgpjfhSskZFSgiIi khbnFoCTFmJ7jJhLEYTSfSctmYOkX4JcGzA5cuUJ5MrK4uDDCkBWIC3rLUyEoClRSqKwp82HuMfF PpSMVMLXELYmXOo8BZDjQOsEViL3FydUHag4cO1ONPQ4h4ujzFhCAQIcEzuOOTOxAoeRlOqdhy6I JAY1UwXPA5mJEFAtMZlMCRMhzqPGZHc4PMo602CWB4GaoUPQFCSM+BuKLqNW5891ZWtI4tKdHwe+ xpnaaIWCFMyXhCKxl5txxbVNZEuH6e3y2G3BUslaVrdMERaYGQD3qIn0OeZSNVMLfhi/HDvo3QRE RZFJTRglY6sJS8eGwyvzKRV3IdiEFgfPDBQahJb83kYJmz+JPUSKUG808E3GNoIBlb3JMQMGrwkt ShUkTkk11wQ0cSxMkjEKCo8oromZII9PRUksTblEPd77Hc8DJsYui2ZsHePhCPQrdce9lO7MuORN FAvkaydUGDIx9XiwbGmNimxESaSNmxzR06bPgkzJ1cU7l8cmDyRhTxKyRqMDnbysmdTcXmgKrTEY FZm7R41Ht6jpPFMpF0riaVm5LQDLOqF+xLApFHfaTm+Oo0b5E9sttutCPGX8Xi2iq1N2aCkZy+n1 etaOJGLxAk5uqvGpyisb0shIm9h43Kj2WZIVBvYSHLNGDYIIphM77QuRFZDSsHS/ExcxGJZKUIWZ BiM9PYqoXit9K2rpK5yMfOfSeSIJ0JlnoVWJdSAeJ8OosDZpAz79jj+NMVOoRgRU23iYoaPWW4gl XUI1OKnUho5BDmx4Fr6sVmX+FBx56L+KSuT7cECNOLGhmknYk5Tc4TkrSax2AEaRIulNC8eB1OU6 eRyWfYKmw+Q0ypI0VGLkj4BM5inUbEeBpLjcNpQmGorO4xcrI6G9tKm8veRo4zIKS7VoYmXVpmPd w2xHVyykTrSONiLr3KkOk3WhbR0krnauKxUEHD3hVsGZohs1DBmWjFicKBjIdCWZar1iTlINjCTE kua5ai07byWWWGlg8sBooMMDBFhBeSPaGq8yaIjkg+b2cJkcfENLHfcjkkXMqPm5wR60SpMuSFld 07KSLOumWscLqSpDsdDrCK4ukC5UcyPBY2uRsqovIzKWNlD7E5Gqq5o68DkYmyZZGGKDuPMuxXZE +KlKDzvyfXfyrtRETIFhwZBPYKeociKZJnCQo5Kw3EDGV0HjWEgXzKeKwmDQUGmjEF4Lrr6lC9vv U4nUdrneRhrfB0sCrWo2OZyoa518G/p5IqJ8G8cd0wg/LWol8yNkVhFGZWg80cXWop3szSTtOUKX 7TiYHB8LcmAJg5I/MeJCo6j06GLeXkwPjIZNGBUmox0JGaDC/NoYthakyR2LMwKHRIV1W91jLmPU U4FCeRednEmyzIiVkSuCETYyMiIIw+CUgbgixBUh4GBA6OwYEmFcmfeow5wbPWkk+hJ50t95kaPJ L7oykTJAinUYcBhoPugyLp7C8mYmZzHI3c9k+pINOzXu5S8md2Dbw1apJ9ODVrZySWVYaTUaCBiH mUYiWkxKXETOEw8gPNBKQKyZWLgtyeG1WHMpTSVlhOX1Et6N/l59XJngc3ku6fpt3VzzqHm3x1Si oOcjHqnInEnRmpVa9tUgEhERLK8S1jAe1U8hQZQSgKHQsxQ0VJxVbKEiEc0yuMiIiNMdcRoVJlp7 UmjsymyefKgqlZyRGdUaQMVcpQ4FzWrliDG4bPdO9a8nBY0LJYHBcpMnrsOWlcUycjxUuKxTcYUM DGgacI0yq8nhwQjOWiObEg9dOTA5IsZFkbL7Ne6RyTFMEBTg4HLGjwNG9DA5eFjYfFPPwCpnr1wW gy+Krch0hJSJOLOrWQeCLrBEdNIacTpoc5su0wuHLF152wAMEAEhBQEbJYw8JNOZYUnEoWGMQoHe T4pJK+CWIxqSe4tyiQNkzMItEV1hQ6XJkZ0FpEj3ymYBguWPEnWjXcWSrs0GQBG29DTtWBKQp4ca C0uVTBQARfWGOS5IsLixImVlQYunhMmam5Ly7FC3gbLkLChdKejQIeBwW0cCjEBTzOTjiRyXMDHU UYUHLDv4Hiq+0Q3x9dK4NeTN5GMBW2dhKwOH5Brr2K68FltumxSZtFSBos6FQtEQwZ0yypHWQNd1 uq0IUkDOySYkDQK8h4DMxxi8yKiKh4nJOWGbzmaGYioeJyRsACdwWxNCd3oPzcPX3v8H87KcYNzA owosrvdImntxt+bwqFrLBwNtcpSJe5oLmBa8eXKQsnkNe9WyQqs8yZ+NmOGo3T3tNidIIL7zaavR /vUnO129iXGYwGz7qEpSiD7EsVtxmtSPB0Vc1l1dXzbZ5CO26/iEm/eUakhf28YOYgqXQV97LNLt 3+b1R1S/3InG/Ty9Tn14jd2AqCkWIxWIoKMUnoWkoSCQMIjDEA76LLQm+BCfvSz28/3HGNAdbEc0 XFk1i1MmVShoEH3LtRD8WXMRSDJJNS9R1GD3wPzEL3J79+Xu3LaEPn+D50DdMtdQO0LA7E8flz1m Iqkgowgqv/f5Aa/uEMJAfpWAPnxSq/+5cyJtoUVwxXdgsqIbASp8JgwiPbAjUM4GH0qNSkcNxBqf rbvrYuCVQRE7RMjrzcAPFBY0rbJuvKBRnw0AlPCS2DlXRA2/XiWbqgiDkosEcDPSwbXM6ydUD95D vO0QkH/mcFiAzxGJzYwnGjOs1oc2erJgpAmiTpkyfxYhYAgiRC8WUwRP7blb3PszrlXZUrn1aUTI H7w/Zn0cmMrVMUYImiV/qEyaRicGVxbMOUF4XPrQi21v7VnXQPqUCp1HG9f+h5tqES0ZwqtkUU9r d8SCD8BK/FZ8qfBcmCwDha5NklaRNsErYHPmw51uRMSwXAXMs7Pmyc+N4IBMzmD7GF97JHz/5cIC PM5T3DsHOZ6zDrhGAHRDGByLJd94kTc2rauFXEBFSZy5amDj369C1gtMbZLjMZfTINLq1MawFZpj ySMUE637vzxjdwhdRXYibLs2N0DzVFPXLlgsWUvAjOaldePAp6DoiI+609sYFkBjyX4T8B2RGCT3 Pd7dwT6v5sKizCcz6Cqycv0REXSOTqA/xRNKmyAPF8Sa8fKFLFRyEMUKROaXC/5dn3pjTcuY938z TYBR7UkDNTOySpEueMJmTFzQyTDJDSMmKF0gzSLoBYUFFQbZLouQUlxLFmdAcF0hiSkoyaE8rINo ShpIds9rdNYdqM0BdQDj458G/XXxkI1m4tDEDIIFTIgxtgZXAtRKIsKMqFJ4WYrpmLBrCqkTDC2j N5yQzACgTADN5xG/G/Ta1rbNCiNzNZy4NQ7spOTjHabYxRjE1NoTAZZlEJsIgFgVGEMRfWY0xYFd zGK5SYNqQZnIPJbCTIYhtEERsJGBSFjQMBaqJpqRRInYo0bpcSHQWoZejNqwqTHWwyhMon9HlFnK WZZ9JofSM+s7T8RtBJULhiJ6/YlJz9R8ZlU5+YnPgPkVxISHQESsoIkq59BScjm/UjkDgoTOp3qZ PWaSoxwUkKxoocDpIwnQsQHyuImwDqzE4PEoMGQ14CgdiLBmbWhAt2dbVjLrnE4QFeNJYOLAxFpo KluV5BW5CNYAUW4PA2nzXpEKoPj5T7B6wN4omZH7X+1v/2X7A9zJxmAuMOAh7EAgDRy9kSnaD2O0 CtamUH9UVcpWzS8evhBsaMhJfVJFfoCqeWrgoBowNFEkk/R5JZIsBGQMJCGzUgBVACfhC3XAZyAr 41yvOkzUGTUxV2N9jJlHs3HYBOeKQMCduoDA9d5DtyVgc1YclQDHKm+wOf73ITYvQCIEVLCAEMhC /wTOvw7TYY3kjZHmM6hx0512lhaMbh446zrKTMqR5V2eP6j+kuckBz8L5yxWtDojogmSpo74KFa+ Cdy450JG/HUbjgZ+WwyMzEzz+IDvF5ei1mRB8K2LQwIMhipaDIuahXjyzFp0cwOMpOUjF5TKw6dR lyFKzZ+d3kTeW1wMfrLXW/UwP83FiiWHQYFMSbjz3azvZ9xvNAo870ZhEGYFFDdu82rzoQxuAjvs VRwAcjeDzxTE950SuYORuIbjcr5jU5QPHjjaGZOJThEePJTWciQrJCBKPJDKQN2ukqMBxREZ5ReL TJYwhkWpav7sL24hGoyE5hOYmOQRWeBnMfSZB5sL5yXQIA0F43ES3TplBY7SWcvlJ2KnpVjEcuRK EmsjbEhXFdAUSRgQVMTcQecrgRvHTER3cCMiAq2trlxVQK97daFEQdmA9/LERXkJJF8WObGNH4Wl 4/igJA0WLzVZIy6Plm/npmPRo73a6FQ9JFbAAQrue5PNzYOzydFz1ryq5TVx8R3LvWPlJ5wNhhDU SUBBdCghwMTCBqnm3SKxC5iEmwXgmfCkKQE20wvQcjjzmOkugasHWYytx0jhxgL5EpMJeMJElIkx AgoaXIRDCXkAdx4kjEq1Fj4tZS02QAU0Kt5WYzEZDF3d1hoPE5zJZGVRcqm/ABUlS2MYZFxabSpI 7DQ7RXLgXlgUMBnIoWLgZlkDKRLleJjAVkC00FamFryzmes3c606YFSG/kV85wQhDrkpcksXR6u2 23lN4h71EJnGK0NWJzT1mt8jS0PMHWJYWvVLKcfbrBQ3PToiGFBgWIFgd5qtNtAMrpU3ymc53I+p w2FOnLZc9XRF79cLv8hOULoQ96vOq+xLc6GoRkovxnZEwI/xsMlWv41ooXWlFZ4qgiM+r/ZGNmRo 33kwUxu2+KBK9Xxx9w3SNpPM6VJ3NcdOG8kZMAohBDIMzIx1VKqnPPV9ma0qNUjLUQQkiK0VIYRd B2m48N86EiRb75T7BaHyKnJ1JHoSKDlhzaQJ8v5tG7N7swl9505nImvRSg+oMuk9ZcyIfImdTse0 cmUGMJpWMcUath2dkxeKyo5Ehdoy2lKey0MhKtCW3WBi0i5pEaVmrR9QAsLgzACUmGCkWgnKYCgk ITGcsN+2RxSER6cFnwIZY9ZjMpWDFAVjG01FhRpKkknCqBedhIXQuEM/Gl2VMWak9m4SRH9pqvIW ItL6KGZkzDBmAUFYQN2603IzdZwMj1jb2+cuJyy45degL+aq9FsQqRONxmSFnU9hruzFyAPSChEE RDCQqmDedk3VseMNrJ0UdGczvh472rqjL6pexegVc4gHpPIIYXyHIakDLAnWwCpo9LHaDEA8DUfn LgCQFSikkVZpx7j07IQN3caHUae9PTMjf0BqaKEIBANzCMlXwfOBzMwYFXLr3GbNn3EEpqNIMWR5 oWkQGr4yyo0JBNIoGjMAvOxaa0s/z+fO56mkAYFjfCmcnkzcdvv12xtrSzRCknEBEmikgtumAcPp dopxDXckpSGcBXELtxqemEr8tVoFQCWKzlezADG5U+4nNBLtmMVbsDDNphQOkZEiEI8pzAh9IoEH uGTgkHqMS499XiLdg5EHQ+IkTElhUi46GJidm6Q8oUh0rUJJeYwECJQHoCBUVmMY7h4xUOJhiouy l8lMzgEJTGIoPq+X8fm6fck1yDKg0l4xmgeaVWYTGVDyUykhJYa3KUWcoElSTHWU5oDuEgvAC4Dt we9R63iamtynTsIBfX9YSiB9/4ypAQUh/GbeftRfh9KLChWi6gInrZXJFX2fSUJul0+LrUdbyOUP diAOqMPGRnwye8VeZ8msdg1udvePzhyPiUaY7RLoq1yZMmUpEpQwyZSlIAmr8ew8jycLO+NoEt+T OCKjvqxB9TmextYCBth0MXGm80vcdjssriBwgVJJn0argjAVZMAG1zl5ku+q19XjEVONudDgPQow 53AL+BY7jxmttxT7O6jj1HLjNBZzKPA8R8RV5Th18Hd1PLDIKqUmoFKKGWO33PO3W222ARDzArH4 TSJO8Pj3y3zO4PS2IIayEX4Y+C7GYxYVyUXndDyX/XBMgVYsCRgwPoe0vfnfk5OAuo2u+4MgqaOt 84Bqa2Z4RW7XtYba3T5CCkYKPGQjVTaeC6TPwoCFqPVaO4DujomZqYUBjBiXxA3bCmmYEbsTISCz R7upIQQ6pqMoklhInu/b587gx9r2auKMpUpDPQAOec0u865wJJEAqHG9xtylAUNLyDtC9RHj6ZAS aj1+Fxoy4kG5m1i6yBCzXQOAUbLl4ABqzN4zMfd7PHnxy2mJunD1QEKZoLNYEampAeJxIdFBEvGQ QD4MSiobxJBFPht5LXktTAbkRDQk24gGTvsjoNx8Xe/VCajkNBCHiShHjOOgAec5mYr2LB0pEoOT k0jhEEpMolDUA8YcpQ827tTxWy5Tp+wT1TTSaWy2y2y/Xz1/H5MetttNrZbZXdnd2dJDzMGwPe/b B84Qd7QS6Ek8UzeIMOY58isDdwUOJ9b9x7W3d65AcTgVf3mXRFUQQe2jmgjvVA7oAlzve4Ce1qPM VlGzYlbFjoJnefLvb3NnGTHqNQ4cJjwGOFNxiTlfVp4zSdUVlW30DzX3m+Lncb5tK3ArCGT7g4CE ba2sB0KOBQxPGZHDK/M7gAvsc7xGp+n5e/Qyb3G3+4FDUw5dz1aXUfOSgiQEmTOWWdJWqOuBCQTM jpc7Wq7+XXidxHu9vjxJqZgKSYsCxgyFAQLGElYv3luMBqmKwImdYypWGQwTrLZ70j0GscCtbjJ5 AJUFZIqQi3wAPMlPzUtFA/ACBDsssFzvKvSQARAO8O11OsttIAgcquYNZPFeQQpEKxjKAOHRBaep vdoQftA+mbWhAELHAJc4naBxLzFh0xjMUiovWuCTvjULUJscDnfB+J6by2DNGsInOfbMkTaUSaxB DNFSUoIYQqJY2bRhKiFabQ6vhIMgmxBIIKQdLIUiMIetnmGieFM0SHbpNVWRqo3lR2MaON4hMuYi phFkGYymzkuwiACTQZWnpBGkAP5xGRzH5Tu27ua1Zm1IeVzvtdbxtTNRveyp1vMaphrFeETpDCwN pvKMgDrkdblahnCKanDztHVnN3RLEe+SdcD9nS3xOzpTYPrjzDqmSR3BwqDhoAUe2hLS/NPUa1Io Ri0RIJoMBoslq+4Od7znZdTN3yHJxCXYoRYcyiHzE9noPjoYjzFLWZ+mlZVWXFarxbHYpvkCpTgJ WqQrIHtJgBjoFJsBRrqKRUiUTAdDoy8JQemxETDDyeCsKCGNHFMLCAvWONnkfP395Y5ktSCISGJR 3vsKjUedlscrpOmHreVtUdzpUd9+gwvQM2sJsoytQkgzxDMREi525EqZYwPRIhFhLIQylJUQohER JmFQlUgUoZn482fRooITKzhbnR051Qskq4r34V9BxZDMqGGZDPkzwVKfIO1J/lVxrxKNmCdDWpp4 2QUJEn9EHjbUpksB1AR+p0Sb6w9jic4J8Gaj6BUKwPYBYrkFUvGA7XYhi0EnSQiFHP1SNRmaIExM AIHMWDUnw9IEZCg9RjFJ01ngP4dnnWE9TIYDyKclW8p/Ti+2dT9aECyUQrCD8kVIAD5NgeD6Pl9d Xvd7omQVHVfYhnkRz5gLXEqrf2/EdSLIULZT1dP+OCmVXE2mIWIYSAzjiUK353G146dLlkpMynym d5sOk+z/XUs9j+FKxEPEMDbsQAnA8U2M8wQGQwg7zW5auTqhC1T2URYVZTSZzSCpQ8XucB53GK8q 4oB5pJ51HxYGgv2mh+BJ7yr5Nb8Xc87Dpr1w6Y5XfAdLVV7ThbC1RCD1pr/Py79yjjcrw3RHEGDL 80LVHxE4i1mVogFyBKwjpfM2O89ZJ7IR3jE2KPY87VtN8+gym5rPkYPU+Aq9Yq1PC8rvFHU+k2Gh 0Ip0BkJCIZDjczkeZRqYGodur4aSpyB7dTwk3UZnsOu45YKLFIM2tSCIzDDr7VakTKQgNjGCcp3Y ST1HrTbn12XYQs3RQjGSAIALJEQBIyA/CBiEkmA4jUFDLvthb+veC06ICoREN9edxIPMYkkQQQly TLmT3TGRaYBwL6G7lXxXuHpdsi9h4Hk+A9qTsaL32ACmm4wm7LBkbsYZfZDDK31/AwyhnJ80LYxb BYNuKQBOxzPs0GzY1SFYYVe8GuzBHnEvLbA4SJmp+fhrpmjER5r4fPsknenSJkTiYM+ioycZ2gXA diqFvSGu9PY1Yna3p0qPQWQjOb4qPsbzMpAZOaCIdsdCnSaqzrcobNXcoUrU4D1u12gaTYSE++CI RIhRIYBBERAIIIBPLA8wPFM4eWMYZpKAwJQKd4gyiCGmDLkIOYGR3j14h2MS0ORybvbm3XPgNPuD 1Dv2hIAVSE1nqcqyDdXUSaQHQgBKt8+3flzNF9MA3Aj1thBp4Dp2KI2cW0liJTQ8qJmRIKZgYLA9 5EEKnpOCqa6Iwxx7aVgTBsCVdTaqTZBoZmSkmud0FhkhkSUhkIROfBJyAGdRHQ3buA0Es1II5Aa+ rb7/vqk2FJha+5h2K1kwzL05yB6mkt7b0wne/z1q48TEGSsEYPWbrc6Ywqe57i+0Egn7Wdp6tq6L iA2B2vD6y0Wob8jIG2OUklB4yfV/HIPdSURyO9k8nj8DQEQI5UXm5G9t+E8rER9CLoADqY9IjarL woSFKI+dSxAeB3kuxTshQ4WK9tw/NZV+UFOw5jMYz26mxC7B1pukJ958y2222222222222221bat tVbaq21bbbbbzGuQMPNtokOKdqQmRA0CzW0alltFFltFFltOQJbMWy1sqadLDwzoDiCHhlU4uZyt fP4YHGQkwGBRjiUirARZnZGNezLN0VADrxO5UOinYqh7PysruACdwiqhhAE5JkiyhT4UzHtfnO5j gseZw9pA8vSFI6wInodk9704UjnzWotAYTCARR2MuHYQAQsUikspJwH8yto0iCQCCUEnZkg7o7Ea cSLMEBHVA1Q0NDIyOZLq3LTzcdCCMLghQRypBrLVuEkqGNRKtuUsMa0soqIAamWGjc0JpVUAE2jj RZMIsmgDkqArKgM3OG9yC7iIZWxWAriRwINMtJEgyYrJqKMLQ+lFgwGQUIyJBEgiRgMgsgJ53Fgn CCX++slCKFIMQEWgT7GkOd4wqrYEXTZeZJSLZAMmGgaNEDCjAIS8IVJQNlPrFWafs8vle+ntbFG2 71tZMCOPfNJwOqhIKNZxsJ8ZRCmwnSbzM3eCr9etAmkyUVGIHwNArCLL91RRAMrwniGUEHdhisBs UoKFV9VRoAgOwDSyIgJxUHsCqU1X7X6DosKy1/QVKhnYV9B5gyUPtfmb8edAyugbYO8g703vEdxH GJfgPsdyjuaeLQ+51PoOxNP8jDqTK41OtscYzNxFwclRgTkDmb6mT9/N0nVwnvjKfga3IJ53U49J 363qNZwqV6lrJqyCUIhIx5iJ0QWkK2hlhF5UkWMpduWizL5LG0TIozWGAhCx+bo9GSj5iEcwYBaQ 8OfgxMHAaFGbrebQ94dDUBaxzb3c3v16DP2R7NMESIlKJy5tb8HqZ5E1BLkAhJvhrYxFcmPO0Goq ADgbjbecRc+a34ENXtBeuw5rvWRrXWH1BsyXS9GbhwI69ZODBcl6VqPYMBLgKr+KUGRMWBYplpIZ VUtCkkAeedyemY1Y1BZqjEWKKoXMsR0rHwHLUuY4FSrVWqrIsKxMFC2LIs67FBDykQ222CV2jVqw WCkvkU1cGoyk95LUOoe6ZMqe5YzQXEpMsA0xnyHMnU5DYnvc+x0Vne8LnanbjggVewvrDp4fV0uO jpMkY+eQmp5uFm5kPOZkze5ug4QgZ61XdZoIqQRiBDRgVkCZpCdAyF2nqhg1ZJPIgmghLkhXYcVz YVe4Ot3nVz7isyvLzvM7jW7drctUiQcBJLMBQlQZjOC3LcqjkZcKjcNl4jzmLGVKGO642pxPMWvF WxADvLkhnMUdRDMMnA3uN33MVGNztpc5TS7ynb0oSD8oD8X4QMokGeCGY/+YK0LhqRn/xdyRThQk DHWytgA= --===============5091042570915883581==--