On the embedded Loop Operation of mysql concatenated Table the execution order of on and where in nested loop join

for example, the statement
select * from table_a join table_b on table_a.id=table_b.a_id and table_a.name="smith" join table_c where table_a.priority=3 and table_b.seq=8 and table_c.sales=1998;

in the operation of embedded loops in concatenated tables, if table_a is the driver table

1) table_a does the first layer circular set according to the result set after table_a.name="smith" Filter in the on condition, and so on. Wait until the temporary table generated by an on bmemorie c join table and then do Filter according to the condition in the where statement
2) table_a according to the table_a.name="smith" in the on condition and the result set after the where condition in the first layer circular set, and so on

actually means to understand the execution order of on and where
which is right?

Mar.12,2021

the theoretical basis of mysql has not been found. My understanding is to implement the Filter condition of where first, and what Filter does is obviously useless.

As you can see in the execution plan in

oracle, the Filter condition is executed first (the last line in the following code).

explain plan for SELECT * FROM tmp_t2 t2 LEFT JOIN tmp_t1  t1 ON t2.id = t1.id AND t1.good_id = 'A'

-----------------------------------------------------------------------------
| Id  | Operation          | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |        |     3 |   147 |     6   (0)| 00:00:01 |
|*  1 |  HASH JOIN         |        |     3 |   147 |     6   (0)| 00:00:01 |
|   2 |   TABLE ACCESS FULL| TMP_T2 |     3 |    60 |     3   (0)| 00:00:01 |
|*  3 |   TABLE ACCESS FULL| TMP_T1 |     3 |    87 |     3   (0)| 00:00:01 |
-----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
   1 - access("T2"."ID"="T1"."ID")
   3 - filter("T1"."GOOD_ID"='A')
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1beb1fc-31298.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1beb1fc-31298.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?