| /dports/databases/percona57-server/percona-server-5.7.36-39/sql/ |
| H A D | sql_resolver.cc | 1914 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
1936 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
1941 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
1943 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
1944 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
1968 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
1969 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
1972 wrap_nest->set_join_cond(outer_tbl->join_cond()->real_item()); in convert_subquery_to_semijoin()
1973 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
1979 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/sql/ |
| H A D | sql_resolver.cc | 1914 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
1936 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
1941 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
1943 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
1944 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
1968 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
1969 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
1972 wrap_nest->set_join_cond(outer_tbl->join_cond()->real_item()); in convert_subquery_to_semijoin()
1973 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
1979 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/sql/ |
| H A D | sql_resolver.cc | 1914 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
1936 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
1941 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
1943 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
1944 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
1968 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
1969 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
1972 wrap_nest->set_join_cond(outer_tbl->join_cond()->real_item()); in convert_subquery_to_semijoin()
1973 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
1979 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/sql/ |
| H A D | sql_resolver.cc | 1914 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
1936 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
1941 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
1943 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
1944 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
1968 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
1969 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
1972 wrap_nest->set_join_cond(outer_tbl->join_cond()->real_item()); in convert_subquery_to_semijoin()
1973 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
1979 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/sql/ |
| H A D | sql_resolver.cc | 1914 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
1936 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
1941 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
1943 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
1944 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
1968 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
1969 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
1972 wrap_nest->set_join_cond(outer_tbl->join_cond()->real_item()); in convert_subquery_to_semijoin()
1973 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
1979 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/sql/ |
| H A D | sql_resolver.cc | 1914 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
1936 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
1941 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
1943 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
1944 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
1968 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
1969 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
1972 wrap_nest->set_join_cond(outer_tbl->join_cond()->real_item()); in convert_subquery_to_semijoin()
1973 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
1979 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/sql/ |
| H A D | sql_resolver.cc | 2905 TABLE_LIST *outer_tbl = subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
2929 thd->mem_root, "(sj-wrap)", outer_tbl->embedding, in convert_subquery_to_semijoin()
2930 outer_tbl->join_list, this); in convert_subquery_to_semijoin()
2935 outer_tbl->embedding = wrap_nest; in convert_subquery_to_semijoin()
2960 wrap_nest->outer_join = outer_tbl->outer_join; in convert_subquery_to_semijoin()
2961 outer_tbl->outer_join = JOIN_TYPE_INNER; in convert_subquery_to_semijoin()
2965 outer_tbl->set_join_cond(nullptr); in convert_subquery_to_semijoin()
2970 if (tbl == outer_tbl) { in convert_subquery_to_semijoin()
2981 if (subquery->embedding_join_nest == outer_tbl) in convert_subquery_to_semijoin()
3048 for (TABLE_LIST *outer_tbl : *emb_join_list) { in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/sql/ |
| H A D | opt_subselect.cc | 1573 TABLE_LIST *outer_tbl= subq_pred->emb_on_expr_nest; in convert_subq_to_sj() local
1599 wrap_nest->embedding= outer_tbl->embedding; in convert_subq_to_sj()
1600 wrap_nest->join_list= outer_tbl->join_list; in convert_subq_to_sj()
1604 wrap_nest->nested_join->join_list.push_back(outer_tbl, thd->mem_root); in convert_subq_to_sj()
1606 outer_tbl->embedding= wrap_nest; in convert_subq_to_sj()
1607 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subq_to_sj()
1613 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subq_to_sj()
1614 outer_tbl->outer_join= 0; in convert_subq_to_sj()
1616 wrap_nest->on_expr= outer_tbl->on_expr; in convert_subq_to_sj()
1617 outer_tbl->on_expr= NULL; in convert_subq_to_sj()
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/sql/ |
| H A D | opt_subselect.cc | 1573 TABLE_LIST *outer_tbl= subq_pred->emb_on_expr_nest; in convert_subq_to_sj() local
1599 wrap_nest->embedding= outer_tbl->embedding; in convert_subq_to_sj()
1600 wrap_nest->join_list= outer_tbl->join_list; in convert_subq_to_sj()
1604 wrap_nest->nested_join->join_list.push_back(outer_tbl, thd->mem_root); in convert_subq_to_sj()
1606 outer_tbl->embedding= wrap_nest; in convert_subq_to_sj()
1607 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subq_to_sj()
1613 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subq_to_sj()
1614 outer_tbl->outer_join= 0; in convert_subq_to_sj()
1616 wrap_nest->on_expr= outer_tbl->on_expr; in convert_subq_to_sj()
1617 outer_tbl->on_expr= NULL; in convert_subq_to_sj()
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/sql/ |
| H A D | opt_subselect.cc | 1653 TABLE_LIST *outer_tbl= subq_pred->emb_on_expr_nest; in convert_subq_to_sj() local
1679 wrap_nest->embedding= outer_tbl->embedding; in convert_subq_to_sj()
1680 wrap_nest->join_list= outer_tbl->join_list; in convert_subq_to_sj()
1684 wrap_nest->nested_join->join_list.push_back(outer_tbl, thd->mem_root); in convert_subq_to_sj()
1686 outer_tbl->embedding= wrap_nest; in convert_subq_to_sj()
1687 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subq_to_sj()
1693 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subq_to_sj()
1694 outer_tbl->outer_join= 0; in convert_subq_to_sj()
1696 wrap_nest->on_expr= outer_tbl->on_expr; in convert_subq_to_sj()
1697 outer_tbl->on_expr= NULL; in convert_subq_to_sj()
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/sql/ |
| H A D | opt_subselect.cc | 1642 TABLE_LIST *outer_tbl= subq_pred->emb_on_expr_nest; in convert_subq_to_sj() local
1668 wrap_nest->embedding= outer_tbl->embedding; in convert_subq_to_sj()
1669 wrap_nest->join_list= outer_tbl->join_list; in convert_subq_to_sj()
1673 wrap_nest->nested_join->join_list.push_back(outer_tbl, thd->mem_root); in convert_subq_to_sj()
1675 outer_tbl->embedding= wrap_nest; in convert_subq_to_sj()
1676 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subq_to_sj()
1682 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subq_to_sj()
1683 outer_tbl->outer_join= 0; in convert_subq_to_sj()
1685 wrap_nest->on_expr= outer_tbl->on_expr; in convert_subq_to_sj()
1686 outer_tbl->on_expr= NULL; in convert_subq_to_sj()
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/sql/ |
| H A D | opt_subselect.cc | 1642 TABLE_LIST *outer_tbl= subq_pred->emb_on_expr_nest; in convert_subq_to_sj() local
1668 wrap_nest->embedding= outer_tbl->embedding; in convert_subq_to_sj()
1669 wrap_nest->join_list= outer_tbl->join_list; in convert_subq_to_sj()
1673 wrap_nest->nested_join->join_list.push_back(outer_tbl, thd->mem_root); in convert_subq_to_sj()
1675 outer_tbl->embedding= wrap_nest; in convert_subq_to_sj()
1676 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subq_to_sj()
1682 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subq_to_sj()
1683 outer_tbl->outer_join= 0; in convert_subq_to_sj()
1685 wrap_nest->on_expr= outer_tbl->on_expr; in convert_subq_to_sj()
1686 outer_tbl->on_expr= NULL; in convert_subq_to_sj()
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/sql/ |
| H A D | opt_subselect.cc | 1653 TABLE_LIST *outer_tbl= subq_pred->emb_on_expr_nest; in convert_subq_to_sj() local
1679 wrap_nest->embedding= outer_tbl->embedding; in convert_subq_to_sj()
1680 wrap_nest->join_list= outer_tbl->join_list; in convert_subq_to_sj()
1684 wrap_nest->nested_join->join_list.push_back(outer_tbl, thd->mem_root); in convert_subq_to_sj()
1686 outer_tbl->embedding= wrap_nest; in convert_subq_to_sj()
1687 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subq_to_sj()
1693 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subq_to_sj()
1694 outer_tbl->outer_join= 0; in convert_subq_to_sj()
1696 wrap_nest->on_expr= outer_tbl->on_expr; in convert_subq_to_sj()
1697 outer_tbl->on_expr= NULL; in convert_subq_to_sj()
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/sql/ |
| H A D | sql_optimizer.cc | 6670 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
6692 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
6697 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
6699 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
6700 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
6706 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
6707 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
6709 wrap_nest->set_join_cond(outer_tbl->join_cond()); in convert_subquery_to_semijoin()
6710 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
6716 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/sql/ |
| H A D | sql_optimizer.cc | 6670 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
6692 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
6697 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
6699 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
6700 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
6706 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
6707 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
6709 wrap_nest->set_join_cond(outer_tbl->join_cond()); in convert_subquery_to_semijoin()
6710 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
6716 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/sql/ |
| H A D | sql_optimizer.cc | 6650 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
6672 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
6677 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
6679 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
6680 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
6686 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
6687 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
6689 wrap_nest->set_join_cond(outer_tbl->join_cond()); in convert_subquery_to_semijoin()
6690 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
6696 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/sql/ |
| H A D | sql_optimizer.cc | 6670 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
6692 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
6697 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
6699 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
6700 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
6706 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
6707 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
6709 wrap_nest->set_join_cond(outer_tbl->join_cond()); in convert_subquery_to_semijoin()
6710 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
6716 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/sql/ |
| H A D | sql_optimizer.cc | 6650 TABLE_LIST *outer_tbl= subq_pred->embedding_join_nest; in convert_subquery_to_semijoin() local
6672 outer_tbl->embedding, outer_tbl->join_list, in convert_subquery_to_semijoin()
6677 wrap_nest->nested_join->join_list.push_back(outer_tbl); in convert_subquery_to_semijoin()
6679 outer_tbl->embedding= wrap_nest; in convert_subquery_to_semijoin()
6680 outer_tbl->join_list= &wrap_nest->nested_join->join_list; in convert_subquery_to_semijoin()
6686 wrap_nest->outer_join= outer_tbl->outer_join; in convert_subquery_to_semijoin()
6687 outer_tbl->outer_join= 0; in convert_subquery_to_semijoin()
6689 wrap_nest->set_join_cond(outer_tbl->join_cond()); in convert_subquery_to_semijoin()
6690 outer_tbl->set_join_cond(NULL); in convert_subquery_to_semijoin()
6696 if (tbl == outer_tbl) in convert_subquery_to_semijoin()
[all …]
|