Started a new transaction tid = 5
Added scan of table emp
Added scan of table dept
Added scan of table hobbies
Added scan of table hobby
Added join between emp.c1 and dept.c0
Added join between hobbies.c0 and emp.c2
Added join between hobbies.c1 and hobby.c0
Added select list field null.*
The query plan is:
                                                 π(emp.c0,emp.c1,emp.c2,emp.c3,emp.c4,emp.c5,dept.c0,dept.c1,dept.c2,hobbies.c0,hobbies.c1,hobby.c0,hobby.c1,hobby.c2,hobby.c3,hobby.c4,hobby.c5),card:200000
                                                 |
                                                 ⨝(hobbies.c1=hobby.c0),card:200000
                               __________________|__________________
                               |                                   |
                               ⨝(emp.c2=hobbies.c0),card:200000    |
                _______________|________________                   |
                |                              |                   |
                ⨝(emp.c1=dept.c0),card:1515    |                   |
  ______________|______________                |                   |
  |                           |                |                   |
  σ(emp.c3<1000),card:1515    |                |                   |
  |                           |              scan(hobbies)         |
scan(emp)                   scan(dept)                           scan(hobby)

emp.c0	emp.c1	emp.c2	emp.c3	emp.c4	emp.c5	dept.c0	dept.c1	dept.c2	hobbies.c0	hobbies.c1	hobby.c0	hobby.c1	hobby.c2	hobby.c3	hobby.c4	hobby.c5	
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
14886	43334	25034	280	16861	13109	43334	32032	56577	25034	19709	19709	40829	59152	46562	16985	57422

14886	43334	25034	280	16861	13109	43334	32032	56577	25034	38158	38158	9948	57639	4440	11109	19862

34917	39222	31124	581	38547	34833	39222	43620	49571	31124	62585	62585	8114	3830	47679	51416	58388


 3 rows.
Transaction 5 committed.