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
two print tools, p_red() and p_green(), are created for highligh
debugging print.
Modified result_set_ in ResultCollector.
add DMLTest TestSuit and two Test Cases, hoping that fzh is able to
continue to make the sql test cases more comprehensive.
fix the bug triggered by inserting into empty table.
ResutSet::print() emits query results in a very professional way.
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.
Add partition_schema, which covers hash, range, and boardcast
partitioning.