select count(*) as a,max(row_id) as b from NATION group by N_REGIONKEY
having b+a<27 order by b;
support column alias,and the alias can be used in having,order by clause
I think that some semantic analysis should be done in constructing
logical plan.
1.the group by expr can be expression,but the expr in select_list which
doesn't contain agg_func must be in the group by as the same form.
eg:select row_id%2 from NATION group by row_id%2;
2.The select_expr of the subquery in from_list must has alias,and the
subquery can be regarded as the base_table.
eg:select a,row_id from (select row_id as a from NATION where
row_id<10)as na,NATION where a=row_id;
can support order by desc by zhanglei
support:
add_sub/add day,week,month,year,quarter
eg:
select row_id,DATE_SUB(L_SHIPDATE,INTERVAL 2 day)  from LINEITEM WHERE
DATE_SUB(L_SHIPDATE,INTERVAL 2 DAY)= '1998-11-27' order by row_id;
before merging with wangli
before merging with wangli
commit before merging with wangli
before
Merge branch 'master' of https://github.com/fzhedu/Claims.git
Merge remote-tracking branch 'liwang/master'

Conflicts:
	Parsetree/ExecuteLogicalQueryPlan.cpp
	Parsetree/ExecuteLogicalQueryPlan.h
	Parsetree/Test/execute_sql_test.cpp
	Parsetree/parsetree2logicalplan.cpp
	Parsetree/preprocess.cpp
	Parsetree/runparsetree.cpp
	Scheduler/Dataflow.cpp
	Test/TestMain.cpp
support time type
Merge remote-tracking branch 'liwang0921/master'

Conflicts:
	Parsetree/ExecuteLogicalQueryPlan.cpp
	common/Expression/initquery.cpp
test nest loop join
partial results
Solved the problem caused by carefulless merge.