Home
last modified time | relevance | path

Searched refs:n_sj_tables (Results 1 – 25 of 61) sorted by relevance

123

/dports/databases/mariadb103-server/mariadb-10.3.34/sql/
H A Dopt_subselect.cc3781 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 Dopt_subselect.cc3781 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 Dopt_subselect.cc3990 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 Dopt_subselect.cc3976 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 Dopt_subselect.cc3976 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 Dopt_subselect.cc3990 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 Dsql_select.cc413 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 Dsql_planner.cc2507 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 Dsql_select.cc413 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 Dsql_planner.cc2507 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 Dsql_select.cc413 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 Dsql_planner.cc2497 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 Dsql_select.cc413 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 Dsql_planner.cc2507 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 Dsql_select.cc413 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 Dsql_planner.cc2497 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 Dsql_select.cc480 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 Dsql_planner.cc3299 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 Dsql_select.cc479 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 Dsql_select.cc480 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 Dsql_select.cc480 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 Dsql_select.cc479 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 Dsql_planner.cc3296 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 Dsql_select.cc479 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 Dsql_select.cc1369 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()

123