QueryOptimizer/testQuerry at master · mkonstant/QueryOptimizer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
proj[account_number]
(	join[account_number=account_number and branch_city=branch_city]
		(savingaccounts)
		(join[id=customer_id](customer)(chekingaccounts))
)


proj[account_number]
(union
	(proj[account_number,branch_name,branch_city](savingaccounts))
	(proj[account_number,branch_name,branch_city](chekingaccounts))
)


proj[account_number,branch_city](
	join
		[savingaccounts.account_number=account_number]
		(savingaccounts)
		(proj[account_number]
			(union
				(proj[account_number,branch_name,branch_city](savingaccounts))
				(proj[account_number,branch_name,branch_city](chekingaccounts))
			)
		)
	)


sel
	[chekingaccounts.account_number>3 and branch_name=2 and branch_city=4 and customer_id=5]
	(chekingaccounts)


join
	[savingaccounts.account_number=account_number and branch_city=branch_city]
	(savingaccounts)
	(proj[chekingaccounts.account_number,branch_city](chekingaccounts))


union
	(chekingaccounts)
	(proj[account_number,branch_name,branch_city,customer_id](savingaccounts))


groupby[branch_city] max(account_number) having[max(account_number)="vdfb"] (proj[account_number,branch_city](proj[account_number,branch_city,branch_name](chekingaccounts)))