I found that self-join (including partitioned table) didn't run against my expectation using auto broad cast join.
For example, I created three tables as follows:
There is same data in all table as follows:
Following queries have to print same result as follows:
But above queries print result data differently.
First and second query print result as follows:
But last query print result as follows: