/dports/databases/mariadb103-server/mariadb-10.3.34/sql/ |
H A D | opt_subselect.cc | 3781 join->join_tab[first].n_sj_tables= join->best_positions[first].n_sj_tables; in fix_semijoin_strategies_for_picked_join_order() 4719 pos += pos->n_sj_tables; in setup_semijoin_loosescan() 4743 i+= pos->n_sj_tables; in setup_semijoin_loosescan() 4744 pos+= pos->n_sj_tables; in setup_semijoin_loosescan() 4872 pos += pos->n_sj_tables; in setup_semijoin_dups_elimination() 4877 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4878 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4923 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4924 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4976 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/sql/ |
H A D | opt_subselect.cc | 3781 join->join_tab[first].n_sj_tables= join->best_positions[first].n_sj_tables; in fix_semijoin_strategies_for_picked_join_order() 4719 pos += pos->n_sj_tables; in setup_semijoin_loosescan() 4743 i+= pos->n_sj_tables; in setup_semijoin_loosescan() 4744 pos+= pos->n_sj_tables; in setup_semijoin_loosescan() 4872 pos += pos->n_sj_tables; in setup_semijoin_dups_elimination() 4877 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4878 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4923 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4924 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 4976 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/sql/ |
H A D | opt_subselect.cc | 3990 join->join_tab[first].n_sj_tables= join->best_positions[first].n_sj_tables; in fix_semijoin_strategies_for_picked_join_order() 4951 pos += pos->n_sj_tables; in setup_semijoin_loosescan() 4975 i+= pos->n_sj_tables; in setup_semijoin_loosescan() 4976 pos+= pos->n_sj_tables; in setup_semijoin_loosescan() 5104 pos += pos->n_sj_tables; in setup_semijoin_dups_elimination() 5109 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5110 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5155 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5156 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5208 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/sql/ |
H A D | opt_subselect.cc | 3976 join->join_tab[first].n_sj_tables= join->best_positions[first].n_sj_tables; in fix_semijoin_strategies_for_picked_join_order() 4909 pos += pos->n_sj_tables; in setup_semijoin_loosescan() 4933 i+= pos->n_sj_tables; in setup_semijoin_loosescan() 4934 pos+= pos->n_sj_tables; in setup_semijoin_loosescan() 5062 pos += pos->n_sj_tables; in setup_semijoin_dups_elimination() 5067 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5068 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5113 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5114 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5166 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/sql/ |
H A D | opt_subselect.cc | 3976 join->join_tab[first].n_sj_tables= join->best_positions[first].n_sj_tables; in fix_semijoin_strategies_for_picked_join_order() 4909 pos += pos->n_sj_tables; in setup_semijoin_loosescan() 4933 i+= pos->n_sj_tables; in setup_semijoin_loosescan() 4934 pos+= pos->n_sj_tables; in setup_semijoin_loosescan() 5062 pos += pos->n_sj_tables; in setup_semijoin_dups_elimination() 5067 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5068 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5113 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5114 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5166 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/sql/ |
H A D | opt_subselect.cc | 3990 join->join_tab[first].n_sj_tables= join->best_positions[first].n_sj_tables; in fix_semijoin_strategies_for_picked_join_order() 4951 pos += pos->n_sj_tables; in setup_semijoin_loosescan() 4975 i+= pos->n_sj_tables; in setup_semijoin_loosescan() 4976 pos+= pos->n_sj_tables; in setup_semijoin_loosescan() 5104 pos += pos->n_sj_tables; in setup_semijoin_dups_elimination() 5109 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5110 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5155 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5156 pos+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 5208 i+= pos->n_sj_tables; in setup_semijoin_dups_elimination() [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/sql/ |
H A D | sql_select.cc | 413 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 419 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 450 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 455 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 516 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 644 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 685 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1387 tableno+= best_positions[tableno].n_sj_tables; in get_best_combination() 1409 remaining_sjm_inner= pos_table->n_sj_tables; in get_best_combination() 1570 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in set_semijoin_info() [all …]
|
H A D | sql_planner.cc | 2507 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2527 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2543 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies() 2569 first_pos->n_sj_tables= in fix_semijoin_strategies() 2580 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies()
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/sql/ |
H A D | sql_select.cc | 413 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 419 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 450 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 455 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 516 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 644 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 685 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1387 tableno+= best_positions[tableno].n_sj_tables; in get_best_combination() 1409 remaining_sjm_inner= pos_table->n_sj_tables; in get_best_combination() 1570 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in set_semijoin_info() [all …]
|
H A D | sql_planner.cc | 2507 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2527 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2543 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies() 2569 first_pos->n_sj_tables= in fix_semijoin_strategies() 2580 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies()
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/sql/ |
H A D | sql_select.cc | 413 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 419 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 450 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 455 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 516 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 644 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 685 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1387 tableno+= best_positions[tableno].n_sj_tables; in get_best_combination() 1409 remaining_sjm_inner= pos_table->n_sj_tables; in get_best_combination() 1569 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in set_semijoin_info() [all …]
|
H A D | sql_planner.cc | 2497 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2517 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2533 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies() 2559 first_pos->n_sj_tables= in fix_semijoin_strategies() 2570 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies()
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/sql/ |
H A D | sql_select.cc | 413 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 419 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 450 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 455 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 516 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 644 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 685 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1387 tableno+= best_positions[tableno].n_sj_tables; in get_best_combination() 1409 remaining_sjm_inner= pos_table->n_sj_tables; in get_best_combination() 1570 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in set_semijoin_info() [all …]
|
H A D | sql_planner.cc | 2507 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2527 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2543 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies() 2569 first_pos->n_sj_tables= in fix_semijoin_strategies() 2580 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies()
|
/dports/databases/mysql56-client/mysql-5.6.51/sql/ |
H A D | sql_select.cc | 413 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 419 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 450 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 455 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 516 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 644 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 685 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1387 tableno+= best_positions[tableno].n_sj_tables; in get_best_combination() 1409 remaining_sjm_inner= pos_table->n_sj_tables; in get_best_combination() 1569 JOIN_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in set_semijoin_info() [all …]
|
H A D | sql_planner.cc | 2497 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2517 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 2533 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies() 2559 first_pos->n_sj_tables= in fix_semijoin_strategies() 2570 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies()
|
/dports/databases/percona57-server/percona-server-5.7.36-39/sql/ |
H A D | sql_select.cc | 480 QEP_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 486 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 519 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 524 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 585 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 692 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 734 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1152 plan_idx last_sj_tab= tableno + pos->n_sj_tables - 1; in set_semijoin_info() 1164 tableno+= pos->n_sj_tables; in set_semijoin_info()
|
H A D | sql_planner.cc | 3299 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 3319 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 3335 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies() 3361 first_pos->n_sj_tables= in fix_semijoin_strategies() 3372 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies()
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/sql/ |
H A D | sql_select.cc | 479 QEP_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 485 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 518 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 523 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 584 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 691 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 733 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1150 plan_idx last_sj_tab= tableno + pos->n_sj_tables - 1; in set_semijoin_info() 1162 tableno+= pos->n_sj_tables; in set_semijoin_info()
|
/dports/databases/percona57-client/percona-server-5.7.36-39/sql/ |
H A D | sql_select.cc | 480 QEP_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 486 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 519 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 524 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 585 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 692 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 734 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1152 plan_idx last_sj_tab= tableno + pos->n_sj_tables - 1; in set_semijoin_info() 1164 tableno+= pos->n_sj_tables; in set_semijoin_info()
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/sql/ |
H A D | sql_select.cc | 480 QEP_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 486 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 519 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 524 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 585 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 692 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 734 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1152 plan_idx last_sj_tab= tableno + pos->n_sj_tables - 1; in set_semijoin_info() 1164 tableno+= pos->n_sj_tables; in set_semijoin_info()
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/sql/ |
H A D | sql_select.cc | 479 QEP_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 485 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 518 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 523 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 584 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 691 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 733 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1150 plan_idx last_sj_tab= tableno + pos->n_sj_tables - 1; in set_semijoin_info() 1162 tableno+= pos->n_sj_tables; in set_semijoin_info()
|
H A D | sql_planner.cc | 3296 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 3316 join->best_positions[first].n_sj_tables= table_count; in fix_semijoin_strategies() 3332 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies() 3358 first_pos->n_sj_tables= in fix_semijoin_strategies() 3369 join->best_positions[first].n_sj_tables= tableno - first + 1; in fix_semijoin_strategies()
|
/dports/databases/mysql57-client/mysql-5.7.36/sql/ |
H A D | sql_select.cc | 479 QEP_TAB *last_sj_tab= tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 485 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 518 if (pos->n_sj_tables > 1) in setup_semijoin_dups_elimination() 523 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 584 sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 691 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 733 tableno+= pos->n_sj_tables; in setup_semijoin_dups_elimination() 1150 plan_idx last_sj_tab= tableno + pos->n_sj_tables - 1; in set_semijoin_info() 1162 tableno+= pos->n_sj_tables; in set_semijoin_info()
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/sql/ |
H A D | sql_select.cc | 1369 QEP_TAB *last_sj_tab = tab + pos->n_sj_tables - 1; in setup_semijoin_dups_elimination() 1375 tableno += pos->n_sj_tables; in setup_semijoin_dups_elimination() 1406 if (pos->n_sj_tables > 1) { in setup_semijoin_dups_elimination() 1410 tableno += pos->n_sj_tables; in setup_semijoin_dups_elimination() 1469 for (uint sj_tableno = tableno; sj_tableno < tableno + pos->n_sj_tables; in setup_semijoin_dups_elimination() 1530 tableno += pos->n_sj_tables; in setup_semijoin_dups_elimination() 1561 tableno += pos->n_sj_tables; in setup_semijoin_dups_elimination() 1924 plan_idx last_sj_tab = tableno + pos->n_sj_tables - 1; in set_semijoin_info() 1936 tableno += pos->n_sj_tables; in set_semijoin_info()
|