vitess.io/vitess@v0.16.2/go/vt/vtgate/planbuilder/operators/operator_test_data.txt

(select id from unsharded union all select id from unsharded_auto order by id) union select id from user
Horizon {
	Query: "(select id from unsharded union all select id from unsharded_auto order by id asc) union select id from `user`"
	Inner:	Concatenate(distinct) {
		Horizon {
			Query: "select id from unsharded"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:unsharded
			}
		},
		Horizon {
			Query: "select id from unsharded_auto"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:unsharded_auto
			}
		},
		Horizon {
			Query: "select id from `user`"
			Inner:	QueryGraph: {
			Tables:
				TableSet{2}:`user`
			}
		}
	}
}

select id from unsharded union select id from unsharded_auto
Horizon {
	Query: "select id from unsharded union select id from unsharded_auto"
	Inner:	Concatenate(distinct) {
		Horizon {
			Query: "select id from unsharded"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:unsharded
			}
		},
		Horizon {
			Query: "select id from unsharded_auto"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:unsharded_auto
			}
		}
	}
}

select id from unsharded union all select id from unsharded_auto
Horizon {
	Query: "select id from unsharded union all select id from unsharded_auto"
	Inner:	Concatenate {
		Horizon {
			Query: "select id from unsharded"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:unsharded
			}
		},
		Horizon {
			Query: "select id from unsharded_auto"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:unsharded_auto
			}
		}
	}
}

(select id from unsharded union all select id from unsharded_auto limit 10) union select id from x order by id
Horizon {
	Query: "(select id from unsharded union all select id from unsharded_auto limit 10) union select id from x order by id asc"
	Inner:	Concatenate(distinct) {
		Horizon {
			Query: "select id from unsharded"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:unsharded
			}
		},
		Horizon {
			Query: "select id from unsharded_auto"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:unsharded_auto
			}
		},
		Horizon {
			Query: "select id from x"
			Inner:	QueryGraph: {
			Tables:
				TableSet{2}:x
			}
		},
		order by id asc
	}
}

(select id from unsharded union all select id from unsharded_auto) union all select id from x
Horizon {
	Query: "select id from unsharded union all select id from unsharded_auto union all select id from x"
	Inner:	Concatenate {
		Horizon {
			Query: "select id from unsharded"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:unsharded
			}
		},
		Horizon {
			Query: "select id from unsharded_auto"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:unsharded_auto
			}
		},
		Horizon {
			Query: "select id from x"
			Inner:	QueryGraph: {
			Tables:
				TableSet{2}:x
			}
		}
	}
}

(select id from unsharded union select id from unsharded_auto) union select id from x
Horizon {
	Query: "select id from unsharded union select id from unsharded_auto union select id from x"
	Inner:	Concatenate(distinct) {
		Horizon {
			Query: "select id from unsharded"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:unsharded
			}
		},
		Horizon {
			Query: "select id from unsharded_auto"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:unsharded_auto
			}
		},
		Horizon {
			Query: "select id from x"
			Inner:	QueryGraph: {
			Tables:
				TableSet{2}:x
			}
		}
	}
}

(select id from unsharded union select id from unsharded_auto) union all select id from x
Horizon {
	Query: "select id from unsharded union select id from unsharded_auto union all select id from x"
	Inner:	Concatenate {
		Concatenate(distinct) {
			Horizon {
				Query: "select id from unsharded"
				Inner:	QueryGraph: {
				Tables:
					TableSet{0}:unsharded
				}
			},
			Horizon {
				Query: "select id from unsharded_auto"
				Inner:	QueryGraph: {
				Tables:
					TableSet{1}:unsharded_auto
				}
			}
		},
		Horizon {
			Query: "select id from x"
			Inner:	QueryGraph: {
			Tables:
				TableSet{2}:x
			}
		}
	}
}

select * from t
Horizon {
	Query: "select * from t"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:t
	}
}

select t.c from t,y,z where t.c = y.c and (t.a = z.a or t.a = y.a) and 1 < 2
Horizon {
	Query: "select t.c from t, y, z where t.c = y.c and (t.a = z.a or t.a = y.a) and 1 < 2"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:t
		TableSet{1}:y
		TableSet{2}:z
	JoinPredicates:
		TableSet{0,1,2} - t.a = z.a or t.a = y.a
		TableSet{0,1} - t.c = y.c
	ForAll: 1 < 2
	}
}

select t.c from t join y on t.id = y.t_id join z on t.id = z.t_id where t.name = 'foo' and y.col = 42 and z.baz = 101
Horizon {
	Query: "select t.c from t join y on t.id = y.t_id join z on t.id = z.t_id where t.`name` = 'foo' and y.col = 42 and z.baz = 101"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:t where t.`name` = 'foo'
		TableSet{1}:y where y.col = 42
		TableSet{2}:z where z.baz = 101
	JoinPredicates:
		TableSet{0,1} - t.id = y.t_id
		TableSet{0,2} - t.id = z.t_id
	}
}

select t.c from t,y,z where t.name = 'foo' and y.col = 42 and z.baz = 101 and t.id = y.t_id and t.id = z.t_id
Horizon {
	Query: "select t.c from t, y, z where t.`name` = 'foo' and y.col = 42 and z.baz = 101 and t.id = y.t_id and t.id = z.t_id"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:t where t.`name` = 'foo'
		TableSet{1}:y where y.col = 42
		TableSet{2}:z where z.baz = 101
	JoinPredicates:
		TableSet{0,1} - t.id = y.t_id
		TableSet{0,2} - t.id = z.t_id
	}
}

select 1 from t where '1' = 1 and 12 = '12'
Horizon {
	Query: "select 1 from t where '1' = 1 and 12 = '12'"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:t
	ForAll: '1' = 1 and 12 = '12'
	}
}

select 1 from t left join s on t.id = s.id
Horizon {
	Query: "select 1 from t left join s on t.id = s.id"
	Inner:	OuterJoin: {
		Inner: 	QueryGraph: {
		Tables:
			TableSet{0}:t
		}
		Outer: 	QueryGraph: {
		Tables:
			TableSet{1}:s
		}
		Predicate: t.id = s.id
	}
}

select 1 from t join s on t.id = s.id and t.name = s.name
Horizon {
	Query: "select 1 from t join s on t.id = s.id and t.`name` = s.`name`"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:t
		TableSet{1}:s
	JoinPredicates:
		TableSet{0,1} - t.id = s.id and t.`name` = s.`name`
	}
}

select 1 from t left join s on t.id = s.id where t.name = 'Mister'
Horizon {
	Query: "select 1 from t left join s on t.id = s.id where t.`name` = 'Mister'"
	Inner:	OuterJoin: {
		Inner: 	QueryGraph: {
		Tables:
			TableSet{0}:t where t.`name` = 'Mister'
		}
		Outer: 	QueryGraph: {
		Tables:
			TableSet{1}:s
		}
		Predicate: t.id = s.id
	}
}

select 1 from t right join s on t.id = s.id
Horizon {
	Query: "select 1 from t right join s on t.id = s.id"
	Inner:	OuterJoin: {
		Inner: 	QueryGraph: {
		Tables:
			TableSet{1}:s
		}
		Outer: 	QueryGraph: {
		Tables:
			TableSet{0}:t
		}
		Predicate: t.id = s.id
	}
}

select 1 from (a left join b on a.id = b.id) join (c left join d on c.id = d.id) on a.id = c.id
Horizon {
	Query: "select 1 from (a left join b on a.id = b.id) join (c left join d on c.id = d.id) on a.id = c.id"
	Inner:	Join: {
		LHS: 	OuterJoin: {
			Inner: 	QueryGraph: {
			Tables:
				TableSet{0}:a
			}
			Outer: 	QueryGraph: {
			Tables:
				TableSet{1}:b
			}
			Predicate: a.id = b.id
		}
		RHS: 	OuterJoin: {
			Inner: 	QueryGraph: {
			Tables:
				TableSet{2}:c
			}
			Outer: 	QueryGraph: {
			Tables:
				TableSet{3}:d
			}
			Predicate: c.id = d.id
		}
		Predicate: a.id = c.id
	}
}

select 1 from (select 42 as id from tbl) as t
Horizon {
	Query: "select 1 from (select 42 as id from tbl) as t"
	Inner:	Derived t: {
		Query: select 42 as id from tbl
		Inner:	QueryGraph: {
		Tables:
			TableSet{0}:tbl
		}
	}
}

select 1 from (select id from tbl limit 10) as t join (select foo, count(*) from usr group by foo) as s on t.id = s.foo
Horizon {
	Query: "select 1 from (select id from tbl limit 10) as t join (select foo, count(*) from usr group by foo) as s on t.id = s.foo"
	Inner:	Join: {
		LHS: 	Derived t: {
			Query: select id from tbl limit 10
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:tbl
			}
		}
		RHS: 	Derived s: {
			Query: select foo, count(*) from usr group by foo
			Inner:	QueryGraph: {
			Tables:
				TableSet{2}:usr
			}
		}
		Predicate: t.id = s.foo
	}
}

select (select 1) from t where exists (select 1) and id in (select 1)
Horizon {
	Query: "select (select 1 from dual) from t where exists (select 1 from dual) and id in (select 1 from dual)"
	Inner:	SubQuery: {
		SubQueries: [
		{
			Type: PulloutValue
			Query: 	QueryGraph: {
			Tables:
				TableSet{1}:dual
			}
		}
		{
			Type: PulloutExists
			Query: 	QueryGraph: {
			Tables:
				TableSet{2}:dual
			}
		}
		{
			Type: PulloutIn
			Query: 	QueryGraph: {
			Tables:
				TableSet{3}:dual
			}
		}]
		Outer: 	QueryGraph: {
		Tables:
			TableSet{0}:t where id in (select 1 from dual)
		ForAll: exists (select 1 from dual)
		}
	}
}

select u.id from user u where u.id = (select id from user_extra where id = u.id)
Horizon {
	Query: "select u.id from `user` as u where u.id = (select id from user_extra where id = u.id)"
	Inner:	SubQuery: {
		SubQueries: [
		{
			Type: PulloutValue
			Query: 	QueryGraph: {
			Tables:
				TableSet{1}:user_extra
			JoinPredicates:
				TableSet{0,1} - id = u.id
			}
		}]
		Outer: 	QueryGraph: {
		Tables:
			TableSet{0}:`user` AS u where u.id = (select id from user_extra where id = u.id)
		}
	}
}

select id from user_index where id = :id
Horizon {
	Query: "select id from user_index where id = :id"
	Inner:	Vindex: {
		Name: user_index
		Value: :id
	}
}

select ui.id from user_index as ui join user as u where ui.id = 1 and ui.id = u.id
Horizon {
	Query: "select ui.id from user_index as ui join `user` as u where ui.id = 1 and ui.id = u.id"
	Inner:	Join: {
		LHS: 	Vindex: {
			Name: user_index
			Value: 1
		}
		RHS: 	QueryGraph: {
		Tables:
			TableSet{1}:`user` AS u
		}
		Predicate: ui.id = u.id
	}
}

select u.id from (select id from user_index where id = 2) as u
Horizon {
	Query: "select u.id from (select id from user_index where id = 2) as u"
	Inner:	Derived u: {
		Query: select id from user_index where id = 2
		Inner:	Vindex: {
			Name: user_index
			Value: 2
		}
	}
}

select 1 from a union select 2 from b
Horizon {
	Query: "select 1 from a union select 2 from b"
	Inner:	Concatenate(distinct) {
		Horizon {
			Query: "select 1 from a"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:a
			}
		},
		Horizon {
			Query: "select 2 from b"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:b
			}
		}
	}
}

select 1 from a union select 2 from b union select 3 from c
Horizon {
	Query: "select 1 from a union select 2 from b union select 3 from c"
	Inner:	Concatenate(distinct) {
		Horizon {
			Query: "select 1 from a"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:a
			}
		},
		Horizon {
			Query: "select 2 from b"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:b
			}
		},
		Horizon {
			Query: "select 3 from c"
			Inner:	QueryGraph: {
			Tables:
				TableSet{2}:c
			}
		}
	}
}

select 1 from a union select 2 from b union select 3 from c union all select 4 from d
Horizon {
	Query: "select 1 from a union select 2 from b union select 3 from c union all select 4 from d"
	Inner:	Concatenate {
		Concatenate(distinct) {
			Horizon {
				Query: "select 1 from a"
				Inner:	QueryGraph: {
				Tables:
					TableSet{0}:a
				}
			},
			Horizon {
				Query: "select 2 from b"
				Inner:	QueryGraph: {
				Tables:
					TableSet{1}:b
				}
			},
			Horizon {
				Query: "select 3 from c"
				Inner:	QueryGraph: {
				Tables:
					TableSet{2}:c
				}
			}
		},
		Horizon {
			Query: "select 4 from d"
			Inner:	QueryGraph: {
			Tables:
				TableSet{3}:d
			}
		}
	}
}

select id from unsharded union select id from unsharded_auto order by id
Horizon {
	Query: "select id from unsharded union select id from unsharded_auto order by id asc"
	Inner:	Concatenate(distinct) {
		Horizon {
			Query: "select id from unsharded"
			Inner:	QueryGraph: {
			Tables:
				TableSet{0}:unsharded
			}
		},
		Horizon {
			Query: "select id from unsharded_auto"
			Inner:	QueryGraph: {
			Tables:
				TableSet{1}:unsharded_auto
			}
		},
		order by id asc
	}
}

select id from user where exists(select user_id from user_extra where user_id = 3 and user_id < user.id)
Horizon {
	Query: "select id from `user` where exists (select user_id from user_extra where user_id = 3 and user_id < `user`.id)"
	Inner:	SubQuery: {
		SubQueries: [
		{
			Type: PulloutExists
			Query: 	QueryGraph: {
			Tables:
				TableSet{1}:user_extra where user_id = 3
			JoinPredicates:
				TableSet{0,1} - user_id < `user`.id
			}
		}]
		Outer: 	QueryGraph: {
		Tables:
			TableSet{0}:`user` where exists (select user_id from user_extra where user_id = 3 and user_id < `user`.id)
		}
	}
}

select ks.tbl.col from ks.tbl where ks.tbl.id = 1
Horizon {
	Query: "select ks.tbl.col from ks.tbl where tbl.id = 1"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:ks.tbl where tbl.id = 1
	}
}

select 1 from ks.t join ks.y on ks.t.id = ks.y.t_id
Horizon {
	Query: "select 1 from ks.t join ks.y on t.id = y.t_id"
	Inner:	QueryGraph: {
	Tables:
		TableSet{0}:ks.t
		TableSet{1}:ks.y
	JoinPredicates:
		TableSet{0,1} - t.id = y.t_id
	}
}

select 1 from ks.t left join ks.y on ks.t.id = ks.y.t_id
Horizon {
	Query: "select 1 from ks.t left join ks.y on t.id = y.t_id"
	Inner:	OuterJoin: {
		Inner: 	QueryGraph: {
		Tables:
			TableSet{0}:ks.t
		}
		Outer: 	QueryGraph: {
		Tables:
			TableSet{1}:ks.y
		}
		Predicate: t.id = y.t_id
	}
}