ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: usr / include / mysql / server / private

#ifndef SQL_ANALYSE_INCLUDED
#define SQL_ANALYSE_INCLUDED

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., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335  USA */

/* Analyse database */

#ifdef USE_PRAGMA_INTERFACE
#pragma interface				/* gcc class implementation */
#endif

#include "procedure.h"                          /* Procedure */

#define my_thd_charset	default_charset_info

#define DEC_IN_AVG 4

typedef struct st_number_info
{
  // if zerofill is true, the number must be zerofill, or string
  bool	    negative, is_float, zerofill, maybe_zerofill;
  int8	    integers;
  int8	    decimals;
  double    dval;
  ulonglong ullval;
} NUM_INFO;

typedef struct st_extreme_value_number_info
{
  ulonglong ullval;
  longlong  llval;
  double    max_dval, min_dval;
} EV_NUM_INFO;

typedef struct st_tree_info
{
  bool	 found;
  String *str;
  Item	 *item;
} TREE_INFO;

uint check_ulonglong(const char *str, uint length);
bool get_ev_num_info(EV_NUM_INFO *ev_info, NUM_INFO *info, const char *num);
bool test_if_number(NUM_INFO *info, const char *str, uint str_len);
int compare_double(const double *s, const double *t);
int compare_double2(void *, const void *s, const void *t);
int compare_longlong(const longlong *s, const longlong *t);
int compare_longlong2(void *, const void *s, const void *t);
int compare_ulonglong(const ulonglong *s, const ulonglong *t);
int compare_ulonglong2(void *, const void *s, const void *t);
int compare_decimal2(void *len, const void *s, const void *t);
Procedure *proc_analyse_init(THD *thd, ORDER *param, select_result *result,
			     List<Item> &field_list);
int free_string(void* str, TREE_FREE, void*);
class analyse;

class field_info :public Sql_alloc
{
protected:
  ulong   treemem, tree_elements, empty, nulls, min_length, max_length;
  uint	  room_in_tree;
  bool found;
  TREE	  tree;
  Item	  *item;
  analyse *pc;

public:
  field_info(Item* a, analyse* b) : treemem(0), tree_elements(0), empty(0),
    nulls(0), min_length(0), max_length(0), room_in_tree(1),
    found(0),item(a), pc(b) {};

virtual ~field_info() { delete_tree(&tree, 0); }
  virtual void	 add() = 0;
  virtual void	 get_opt_type(String*, ha_rows) = 0;
  virtual String *get_min_arg(String *) = 0;
  virtual String *get_max_arg(String *) = 0;
  virtual String *avg(String*, ha_rows) = 0;
  virtual String *std(String*, ha_rows) = 0;
  virtual tree_walk_action collect_enum() = 0;
  virtual uint decimals() { return 0; }
  friend  class analyse;
};

int collect_string(void *element, element_count count, void *info);

int sortcmp2(void *, const void *a, const void *b);

class field_str :public field_info
{
  String      min_arg, max_arg;
  ulonglong   sum;
  bool	      must_be_blob, was_zero_fill, was_maybe_zerofill,
	      can_be_still_num;
  NUM_INFO    num_info;
  EV_NUM_INFO ev_num_info;

public:
  field_str(Item* a, analyse* b) :field_info(a,b), 
    min_arg("",0,default_charset_info),
    max_arg("",0,default_charset_info), sum(0),
    must_be_blob(0), was_zero_fill(0),
    was_maybe_zerofill(0), can_be_still_num(1)
    {
      init_tree(&tree, 0, 0, sizeof(String), sortcmp2, free_string, NULL,
                MYF(MY_THREAD_SPECIFIC));
    };

void	 add() override;
  void	 get_opt_type(String*, ha_rows) override;
  String *get_min_arg(String *not_used __attribute__((unused))) override
  { return &min_arg; }
  String *get_max_arg(String *not_used __attribute__((unused))) override
  { return &max_arg; }
  String *avg(String *s, ha_rows rows) override
  {
    if (!(rows - nulls))
      s->set_real((double) 0.0, 1,my_thd_charset);
    else
      s->set_real((ulonglong2double(sum) / ulonglong2double(rows - nulls)),
	     DEC_IN_AVG,my_thd_charset);
    return s;
  }
  friend int collect_string(String *element, element_count count,
			    TREE_INFO *info);
  tree_walk_action collect_enum() override
  { return collect_string; }
  String *std(String *s __attribute__((unused)),
	      ha_rows rows __attribute__((unused))) override
  { return (String*) 0; }
};

int collect_decimal(void *element, element_count count, void *info);

class field_decimal :public field_info
{
  my_decimal min_arg, max_arg;
  my_decimal sum[2], sum_sqr[2];
  int cur_sum;
  int bin_size;
public:
  field_decimal(Item* a, analyse* b) :field_info(a,b)
  {
    bin_size= my_decimal_get_binary_size(a->max_length, a->decimals);
    init_tree(&tree, 0, 0, bin_size, compare_decimal2, 0, (void *) &bin_size,
              MYF(MY_THREAD_SPECIFIC));
  };

void	 add() override;
  void	 get_opt_type(String*, ha_rows) override;
  String *get_min_arg(String *) override;
  String *get_max_arg(String *) override;
  String *avg(String *s, ha_rows rows) override;
  friend int collect_decimal(uchar *element, element_count count,
                             TREE_INFO *info);
  tree_walk_action collect_enum() override
  { return collect_decimal; }
  String *std(String *s, ha_rows rows) override;
};

int collect_real(void *element, element_count count, void *info);

class field_real: public field_info
{
  double min_arg, max_arg;
  double sum, sum_sqr;
  uint	 max_notzero_dec_len;

public:
  field_real(Item* a, analyse* b) :field_info(a,b),
    min_arg(0), max_arg(0),  sum(0), sum_sqr(0), max_notzero_dec_len(0)
    {
      init_tree(&tree, 0, 0, sizeof(double), compare_double2, NULL, NULL,
                MYF(MY_THREAD_SPECIFIC));
    }

void	 add() override;
  void	 get_opt_type(String*, ha_rows) override;
  String *get_min_arg(String *s) override
  {
    s->set_real(min_arg, item->decimals, my_thd_charset);
    return s;
  }
  String *get_max_arg(String *s) override
  {
    s->set_real(max_arg, item->decimals, my_thd_charset);
    return s;
  }
  String *avg(String *s, ha_rows rows) override
  {
    if (!(rows - nulls))
      s->set_real((double) 0.0, 1,my_thd_charset);
    else
      s->set_real(((double)sum / (double) (rows - nulls)), item->decimals,my_thd_charset);
    return s;
  }
  String *std(String *s, ha_rows rows) override
  {
    double tmp = ulonglong2double(rows);
    if (!(tmp - nulls))
      s->set_real((double) 0.0, 1,my_thd_charset);
    else
    {
      double tmp2 = ((sum_sqr - sum * sum / (tmp - nulls)) /
		     (tmp - nulls));
      s->set_real(((double) tmp2 <= 0.0 ? 0.0 : sqrt(tmp2)), item->decimals,my_thd_charset);
    }
    return s;
  }
  uint	 decimals() override { return item->decimals; }
  friend int collect_real(double *element, element_count count,
			  TREE_INFO *info);
  tree_walk_action collect_enum() override
  { return collect_real;}
};

int collect_longlong(void *element, element_count count, void *info);

class field_longlong: public field_info
{
  longlong min_arg, max_arg;
  longlong sum, sum_sqr;

public:
  field_longlong(Item* a, analyse* b) :field_info(a,b), 
    min_arg(0), max_arg(0), sum(0), sum_sqr(0)
  {
    init_tree(&tree, 0, 0, sizeof(longlong), compare_longlong2, NULL, NULL,
              MYF(MY_THREAD_SPECIFIC));
  }

void	 add() override;
  void	 get_opt_type(String*, ha_rows) override;
  String *get_min_arg(String *s) override { s->set(min_arg,my_thd_charset); return s; }
  String *get_max_arg(String *s) override { s->set(max_arg,my_thd_charset); return s; }
  String *avg(String *s, ha_rows rows) override
  {
    if (!(rows - nulls))
      s->set_real((double) 0.0, 1,my_thd_charset);
    else
      s->set_real(((double) sum / (double) (rows - nulls)), DEC_IN_AVG,my_thd_charset);
    return s;
  }
  String *std(String *s, ha_rows rows) override
  {
    double tmp = ulonglong2double(rows);
    if (!(tmp - nulls))
      s->set_real((double) 0.0, 1,my_thd_charset);
    else
    {
      double tmp2 = ((sum_sqr - sum * sum / (tmp - nulls)) /
		    (tmp - nulls));
      s->set_real(((double) tmp2 <= 0.0 ? 0.0 : sqrt(tmp2)), DEC_IN_AVG,my_thd_charset);
    }
    return s;
  }
  friend int collect_longlong(longlong *element, element_count count,
			      TREE_INFO *info);
  tree_walk_action collect_enum() override
  { return collect_longlong;}
};

int collect_ulonglong(void *element, element_count count, void *info);

class field_ulonglong: public field_info
{
  ulonglong min_arg, max_arg;
  ulonglong sum, sum_sqr;

public:
  field_ulonglong(Item* a, analyse * b) :field_info(a,b),
    min_arg(0), max_arg(0), sum(0),sum_sqr(0)
  {
    init_tree(&tree, 0, 0, sizeof(ulonglong), compare_ulonglong2, NULL, NULL,
              MYF(MY_THREAD_SPECIFIC));
  }
  void	 add() override;
  void	 get_opt_type(String*, ha_rows) override;
  String *get_min_arg(String *s) override { s->set(min_arg,my_thd_charset); return s; }
  String *get_max_arg(String *s) override { s->set(max_arg,my_thd_charset); return s; }
  String *avg(String *s, ha_rows rows) override
  {
    if (!(rows - nulls))
      s->set_real((double) 0.0, 1,my_thd_charset);
    else
      s->set_real((ulonglong2double(sum) / ulonglong2double(rows - nulls)),
	     DEC_IN_AVG,my_thd_charset);
    return s;
  }
  String *std(String *s, ha_rows rows) override
  {
    double tmp = ulonglong2double(rows);
    if (!(tmp - nulls))
      s->set_real((double) 0.0, 1,my_thd_charset);
    else
    {
      double tmp2 = ((ulonglong2double(sum_sqr) - 
		     ulonglong2double(sum * sum) / (tmp - nulls)) /
		     (tmp - nulls));
      s->set_real(((double) tmp2 <= 0.0 ? 0.0 : sqrt(tmp2)), DEC_IN_AVG,my_thd_charset);
    }
    return s;
  }
  friend int collect_ulonglong(ulonglong *element, element_count count,
			       TREE_INFO *info);
  tree_walk_action collect_enum() override
  { return collect_ulonglong; }
};

Procedure *proc_analyse_init(THD *thd, ORDER *param,
			     select_result *result,
			     List<Item> &field_list);

class analyse: public Procedure
{
protected:
  Item_proc    *func_items[10];
  List<Item>   fields, result_fields;
  field_info   **f_info, **f_end;
  ha_rows      rows;
  uint	       output_str_length;

public:
  uint max_tree_elements, max_treemem;

analyse(select_result *res) :Procedure(res, PROC_NO_SORT), f_info(0),
    rows(0), output_str_length(0) {}

~analyse()
  {
    if (f_info)
    {
      for (field_info **f=f_info; f != f_end; f++)
	delete (*f);
    }
  }
  void add() override {}
  bool change_columns(THD *thd, List<Item> &fields) override;
  int  send_row(List<Item> &field_list) override;
  void end_group(void) override {}
  int end_of_records(void) override;
  friend Procedure *proc_analyse_init(THD *thd, ORDER *param,
				      select_result *result,
				      List<Item> &field_list);
};

#endif /* SQL_ANALYSE_INCLUDED */

[+] ..
[-] sql_manager.h [open]
[-] create_tmp_table.h [open]
[-] lex_ident.h [open]
[-] semisync_slave.h [open]
[-] sql_cache.h [open]
[-] events.h [open]
[-] my_rnd.h [open]
[-] lex_hash.h [open]
[-] discover.h [open]
[-] item_geofunc.h [open]
[-] wsrep_applier.h [open]
[-] my_apc.h [open]
[-] log_event.h [open]
[-] wsrep_thd.h [open]
[-] threadpool_generic.h [open]
[-] my_json_writer.h [open]
[-] mysys_err.h [open]
[-] semisync_master_ack_receiver.h [open]
[-] sql_udf.h [open]
[-] opt_trace_context.h [open]
[-] violite.h [open]
[-] rpl_mi.h [open]
[-] thr_timer.h [open]
[-] bounded_queue.h [open]
[-] item_sum.h [open]
[-] cset_narrowing.h [open]
[-] wsrep_xid.h [open]
[-] my_bitmap.h [open]
[-] table_cache.h [open]
[-] sql_locale.h [open]
[-] sql_plugin.h [open]
[-] handle_connections_win.h [open]
[-] sql_array.h [open]
[-] sql_expression_cache.h [open]
[-] password.h [open]
[-] waiting_threads.h [open]
[-] my_virtual_mem.h [open]
[-] privilege.h [open]
[-] rpl_filter.h [open]
[-] event_db_repository.h [open]
[-] thr_malloc.h [open]
[-] rpl_injector.h [open]
[-] sql_const.h [open]
[-] lex_charset.h [open]
[-] my_cpu.h [open]
[-] sql_rename.h [open]
[-] sp_cache.h [open]
[-] sql_prepare.h [open]
[-] mdl.h [open]
[-] event_scheduler.h [open]
[-] my_md5.h [open]
[-] probes_mysql.h [open]
[-] item_subselect.h [open]
[-] sql_type_geom.h [open]
[-] sql_sequence.h [open]
[-] sql_type_fixedbin.h [open]
[-] wsrep_storage_service.h [open]
[-] item_windowfunc.h [open]
[-] sql_command.h [open]
[-] uniques.h [open]
[-] rpl_record.h [open]
[-] sql_priv.h [open]
[-] sql_digest_stream.h [open]
[-] sql_callback.h [open]
[-] item_row.h [open]
[-] table.h [open]
[-] sql_profile.h [open]
[-] item_create.h [open]
[-] item_jsonfunc.h [open]
[-] sys_vars_shared.h [open]
[-] opt_trace.h [open]
[-] wsrep_types.h [open]
[-] sql_help.h [open]
[-] wsrep_on.h [open]
[-] myisamchk.h [open]
[-] my_compare.h [open]
[-] item_strfunc.h [open]
[-] proxy_protocol.h [open]
[-] wsrep.h [open]
[-] my_stack_alloc.h [open]
[-] my_nosys.h [open]
[-] sql_analyze_stmt.h [open]
[-] datadict.h [open]
[-] wqueue.h [open]
[-] mysqld_suffix.h [open]
[-] protocol.h [open]
[-] wsrep_allowlist_service.h [open]
[-] my_user.h [open]
[-] myisam.h [open]
[-] sql_trigger.h [open]
[-] json_table.h [open]
[-] sql_signal.h [open]
[-] filesort.h [open]
[-] embedded_priv.h [open]
[-] sql_type_json.h [open]
[-] sql_alter.h [open]
[-] heap.h [open]
[-] sql_delete.h [open]
[-] partition_info.h [open]
[-] message.h [open]
[-] sql_sort.h [open]
[-] wsrep_utils.h [open]
[-] rijndael.h [open]
[-] set_var.h [open]
[-] my_minidump.h [open]
[-] compat56.h [open]
[-] client_settings.h [open]
[-] thr_alarm.h [open]
[-] xa.h [open]
[-] assume_aligned.h [open]
[-] my_libwrap.h [open]
[+] atomic
[-] wsrep_status.h [open]
[-] innodb_priv.h [open]
[-] sql_load.h [open]
[-] sql_plugin_compat.h [open]
[-] sp_rcontext.h [open]
[-] wsrep_sst.h [open]
[-] sql_acl.h [open]
[-] procedure.h [open]
[-] pfs_transaction_provider.h [open]
[-] my_atomic.h [open]
[-] item_vers.h [open]
[-] sql_repl.h [open]
[-] sql_do.h [open]
[-] hash_filo.h [open]
[-] pfs_statement_provider.h [open]
[-] service_versions.h [open]
[-] sql_cmd.h [open]
[-] sql_type_string.h [open]
[-] item_timefunc.h [open]
[-] my_handler_errors.h [open]
[-] sql_crypt.h [open]
[-] scheduler.h [open]
[-] pfs_socket_provider.h [open]
[-] tzfile.h [open]
[-] rpl_rli.h [open]
[-] wsrep_mutex.h [open]
[-] keycaches.h [open]
[-] my_time.h [open]
[-] rpl_record_old.h [open]
[-] welcome_copyright_notice.h [open]
[-] item.h [open]
[-] wsrep_server_service.h [open]
[-] t_ctype.h [open]
[-] sql_debug.h [open]
[-] mysqld.h [open]
[-] item_xmlfunc.h [open]
[-] pfs_metadata_provider.h [open]
[-] gstream.h [open]
[-] sql_reload.h [open]
[-] session_tracker.h [open]
[-] config.h [open]
[-] multi_range_read.h [open]
[-] ha_handler_stats.h [open]
[-] my_counter.h [open]
[-] sql_type.h [open]
[-] probes_mysql_nodtrace.h [open]
[-] my_base.h [open]
[-] opt_subselect.h [open]
[-] repl_failsafe.h [open]
[-] handler.h [open]
[-] wsrep_mysqld_c.h [open]
[-] records.h [open]
[-] backup.h [open]
[-] sql_bitmap.h [open]
[-] sql_binlog.h [open]
[-] log_event_data_type.h [open]
[-] wsrep_client_service.h [open]
[-] lex_symbol.h [open]
[-] sql_lex.h [open]
[-] ddl_log.h [open]
[-] create_options.h [open]
[-] group_by_handler.h [open]
[-] strfunc.h [open]
[-] my_service_manager.h [open]
[-] semisync_master.h [open]
[-] sql_db.h [open]
[-] sql_insert.h [open]
[-] my_stacktrace.h [open]
[-] lex.h [open]
[-] item_cmpfunc.h [open]
[-] sql_type_int.h [open]
[-] wsrep_var.h [open]
[-] maria.h [open]
[-] event_data_objects.h [open]
[-] sql_handler.h [open]
[-] source_revision.h [open]
[-] debug.h [open]
[-] rpl_gtid.h [open]
[-] key.h [open]
[-] sql_servers.h [open]
[-] lex_string.h [open]
[-] myisampack.h [open]
[-] rpl_tblmap.h [open]
[-] sql_type_fixedbin_storage.h [open]
[-] my_crypt.h [open]
[-] structs.h [open]
[-] sql_table.h [open]
[-] field.h [open]
[-] sql_plist.h [open]
[-] replication.h [open]
[-] select_handler.h [open]
[-] winservice.h [open]
[-] win_tzname_data.h [open]
[-] slave.h [open]
[-] init.h [open]
[-] sql_get_diagnostics.h [open]
[-] sp_head.h [open]
[-] custom_conf.h [open]
[-] sql_join_cache.h [open]
[-] sql_audit.h [open]
[-] sql_connect.h [open]
[-] wsrep_server_state.h [open]
[+] data
[-] sql_update.h [open]
[-] transaction.h [open]
[-] log_event_old.h [open]
[-] pfs_stage_provider.h [open]
[-] mariadb.h [open]
[-] item_func.h [open]
[-] my_tree.h [open]
[-] sql_tvc.h [open]
[-] rpl_reporting.h [open]
[-] derror.h [open]
[-] sql_schema.h [open]
[-] sql_parse.h [open]
[-] sql_type_real.h [open]
[-] pfs_thread_provider.h [open]
[-] my_check_opt.h [open]
[-] rowid_filter.h [open]
[-] sql_base.h [open]
[-] sql_test.h [open]
[-] sp.h [open]
[-] my_uctype.h [open]
[-] myisammrg.h [open]
[-] sp_pcontext.h [open]
[-] my_bit.h [open]
[-] wsrep_client_state.h [open]
[-] event_queue.h [open]
[-] sql_window.h [open]
[-] sql_limit.h [open]
[-] my_rdtsc.h [open]
[-] sql_list.h [open]
[-] pfs_file_provider.h [open]
[-] rpl_constants.h [open]
[-] sql_explain.h [open]
[-] sql_class.h [open]
[-] sql_i_s.h [open]
[-] sql_lifo_buffer.h [open]
[-] pfs_memory_provider.h [open]
[-] ssl_compat.h [open]
[-] wsrep_mysqld.h [open]
[-] dur_prop.h [open]
[-] sql_union.h [open]
[-] field_comp.h [open]
[-] contributors.h [open]
[-] pfs_table_provider.h [open]
[-] wsrep_condition_variable.h [open]
[-] wsrep_trans_observer.h [open]
[-] rpl_parallel.h [open]
[-] parse_file.h [open]
[-] my_atomic_wrapper.h [open]
[-] sql_alloc.h [open]
[-] threadpool_winsockets.h [open]
[-] sql_show.h [open]
[-] sql_mode.h [open]
[-] gcalc_tools.h [open]
[-] hash.h [open]
[-] sql_partition.h [open]
[-] mysqld_default_groups.h [open]
[-] sql_truncate.h [open]
[-] mem_root_array.h [open]
[-] sql_basic_types.h [open]
[-] socketpair.h [open]
[-] lex_token.h [open]
[-] thr_lock.h [open]
[+] providers
[-] authors.h [open]
[-] sql_error.h [open]
[-] threadpool.h [open]
[-] opt_range.h [open]
[-] log_slow.h [open]
[-] debug_sync.h [open]
[-] ha_partition.h [open]
[-] sql_derived.h [open]
[-] sql_bootstrap.h [open]
[-] gcalc_slicescan.h [open]
[-] queues.h [open]
[-] aria_backup.h [open]
[-] aligned.h [open]
[-] partition_element.h [open]
[-] spatial.h [open]
[-] semisync.h [open]
[-] my_default.h [open]
[-] sql_hset.h [open]
[-] sql_cte.h [open]
[-] opt_histogram_json.h [open]
[-] scope.h [open]
[-] event_parse_data.h [open]
[-] ilist.h [open]
[-] sql_view.h [open]
[-] wsrep_schema.h [open]
[-] lock.h [open]
[-] sql_admin.h [open]
[-] sql_partition_admin.h [open]
[-] vers_string.h [open]
[-] ha_sequence.h [open]
[-] sql_cursor.h [open]
[-] sql_string.h [open]
[-] sql_statistics.h [open]
[-] tztime.h [open]
[-] my_alarm.h [open]
[-] my_decimal.h [open]
[-] sql_analyse.h [open]
[-] sql_digest.h [open]
[-] unireg.h [open]
[-] hostname.h [open]
[-] ft_global.h [open]
[-] grant.h [open]
[-] wsrep_priv.h [open]
[-] log.h [open]
[-] filesort_utils.h [open]
[-] sql_time.h [open]
[-] sql_select.h [open]
[-] wsrep_binlog.h [open]
[-] wsrep_high_priority_service.h [open]
[-] pfs_idle_provider.h [open]
[-] derived_handler.h [open]
[-] thread_cache.h [open]
[-] lf.h [open]
[-] des_key_file.h [open]
[-] span.h [open]
[-] rpl_utility.h [open]