You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by hu...@apache.org on 2017/03/02 01:55:10 UTC
[6/6] incubator-hawq git commit: HAWQ-1359. Add policy test for HAWQ
with Ranger enabled.
HAWQ-1359. Add policy test for HAWQ with Ranger enabled.
Signed-off-by: Chuling Wang <wa...@126.com>
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/12089267
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/12089267
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/12089267
Branch: refs/heads/master
Commit: 1208926791cc3b30cc64e243e57edf86a9794af1
Parents: ee79ec2
Author: Hubert Zhang <hu...@apache.org>
Authored: Thu Mar 2 09:53:39 2017 +0800
Committer: Chuling Wang <wa...@126.com>
Committed: Thu Mar 2 09:53:39 2017 +0800
----------------------------------------------------------------------
.../feature/ExternalSource/test_errortbl.cpp | 8 +
src/test/feature/Ranger/ans/adminfirst1.ans | 4 +
src/test/feature/Ranger/ans/adminfirst10.ans | 4 +
src/test/feature/Ranger/ans/adminfirst11.ans | 4 +
src/test/feature/Ranger/ans/adminfirst12.ans | 4 +
src/test/feature/Ranger/ans/adminfirst13.ans | 4 +
src/test/feature/Ranger/ans/adminfirst14.ans | 4 +
src/test/feature/Ranger/ans/adminfirst15.ans | 4 +
src/test/feature/Ranger/ans/adminfirst16.ans | 4 +
src/test/feature/Ranger/ans/adminfirst17.ans | 4 +
src/test/feature/Ranger/ans/adminfirst18.ans | 4 +
src/test/feature/Ranger/ans/adminfirst19.ans | 4 +
src/test/feature/Ranger/ans/adminfirst2.ans | 4 +
src/test/feature/Ranger/ans/adminfirst20.ans | 4 +
src/test/feature/Ranger/ans/adminfirst21.ans | 4 +
src/test/feature/Ranger/ans/adminfirst22.ans | 4 +
src/test/feature/Ranger/ans/adminfirst23.ans | 4 +
src/test/feature/Ranger/ans/adminfirst24.ans | 4 +
src/test/feature/Ranger/ans/adminfirst25.ans | 5 +
src/test/feature/Ranger/ans/adminfirst26.ans | 4 +
src/test/feature/Ranger/ans/adminfirst27.ans | 29 ++++
src/test/feature/Ranger/ans/adminfirst28.ans | 4 +
src/test/feature/Ranger/ans/adminfirst29.ans | 4 +
src/test/feature/Ranger/ans/adminfirst3.ans | 4 +
src/test/feature/Ranger/ans/adminfirst30.ans | 4 +
src/test/feature/Ranger/ans/adminfirst31.ans | 4 +
src/test/feature/Ranger/ans/adminfirst32.ans | 4 +
src/test/feature/Ranger/ans/adminfirst33.ans | 4 +
src/test/feature/Ranger/ans/adminfirst34.ans | 4 +
src/test/feature/Ranger/ans/adminfirst35.ans | 4 +
src/test/feature/Ranger/ans/adminfirst36.ans | 4 +
src/test/feature/Ranger/ans/adminfirst37.ans | 4 +
src/test/feature/Ranger/ans/adminfirst38.ans | 4 +
src/test/feature/Ranger/ans/adminfirst39.ans | 4 +
src/test/feature/Ranger/ans/adminfirst4.ans | 4 +
src/test/feature/Ranger/ans/adminfirst40.ans | 4 +
src/test/feature/Ranger/ans/adminfirst41.ans | 8 +
src/test/feature/Ranger/ans/adminfirst42.ans | 6 +
src/test/feature/Ranger/ans/adminfirst43.ans | 8 +
src/test/feature/Ranger/ans/adminfirst44.ans | 4 +
src/test/feature/Ranger/ans/adminfirst45.ans | 4 +
src/test/feature/Ranger/ans/adminfirst46.ans | 6 +
src/test/feature/Ranger/ans/adminfirst47.ans | 5 +
src/test/feature/Ranger/ans/adminfirst48.ans | 4 +
src/test/feature/Ranger/ans/adminfirst49.ans | 4 +
src/test/feature/Ranger/ans/adminfirst5.ans | 4 +
src/test/feature/Ranger/ans/adminfirst50.ans | 4 +
src/test/feature/Ranger/ans/adminfirst51.ans | 4 +
src/test/feature/Ranger/ans/adminfirst52.ans | 4 +
src/test/feature/Ranger/ans/adminfirst53.ans | 4 +
src/test/feature/Ranger/ans/adminfirst54.ans | 4 +
src/test/feature/Ranger/ans/adminfirst55.ans | 9 ++
src/test/feature/Ranger/ans/adminfirst56.ans | 5 +
src/test/feature/Ranger/ans/adminfirst57.ans | 8 +
src/test/feature/Ranger/ans/adminfirst58.ans | 9 ++
src/test/feature/Ranger/ans/adminfirst59.ans | 8 +
src/test/feature/Ranger/ans/adminfirst6.ans | 4 +
src/test/feature/Ranger/ans/adminfirst60.ans | 4 +
src/test/feature/Ranger/ans/adminfirst61.ans | 4 +
src/test/feature/Ranger/ans/adminfirst62.ans | 4 +
src/test/feature/Ranger/ans/adminfirst63.ans | 4 +
src/test/feature/Ranger/ans/adminfirst64.ans | 4 +
src/test/feature/Ranger/ans/adminfirst65.ans | 4 +
src/test/feature/Ranger/ans/adminfirst66.ans | 4 +
src/test/feature/Ranger/ans/adminfirst67.ans | 4 +
src/test/feature/Ranger/ans/adminfirst68.ans | 4 +
src/test/feature/Ranger/ans/adminfirst69.ans | 4 +
src/test/feature/Ranger/ans/adminfirst7.ans | 4 +
src/test/feature/Ranger/ans/adminfirst70.ans | 4 +
src/test/feature/Ranger/ans/adminfirst71.ans | 5 +
src/test/feature/Ranger/ans/adminfirst8.ans | 4 +
src/test/feature/Ranger/ans/adminfirst9.ans | 4 +
src/test/feature/Ranger/ans/adminsecond1.ans | 4 +
src/test/feature/Ranger/ans/adminsecond10.ans | 4 +
src/test/feature/Ranger/ans/adminsecond11.ans | 4 +
src/test/feature/Ranger/ans/adminsecond12.ans | 4 +
src/test/feature/Ranger/ans/adminsecond13.ans | 4 +
src/test/feature/Ranger/ans/adminsecond14.ans | 4 +
src/test/feature/Ranger/ans/adminsecond15.ans | 4 +
src/test/feature/Ranger/ans/adminsecond16.ans | 4 +
src/test/feature/Ranger/ans/adminsecond17.ans | 4 +
src/test/feature/Ranger/ans/adminsecond18.ans | 4 +
src/test/feature/Ranger/ans/adminsecond19.ans | 4 +
src/test/feature/Ranger/ans/adminsecond2.ans | 4 +
src/test/feature/Ranger/ans/adminsecond20.ans | 4 +
src/test/feature/Ranger/ans/adminsecond21.ans | 4 +
src/test/feature/Ranger/ans/adminsecond22.ans | 4 +
src/test/feature/Ranger/ans/adminsecond23.ans | 4 +
src/test/feature/Ranger/ans/adminsecond24.ans | 4 +
src/test/feature/Ranger/ans/adminsecond25.ans | 13 ++
src/test/feature/Ranger/ans/adminsecond26.ans | 4 +
src/test/feature/Ranger/ans/adminsecond27.ans | 29 ++++
src/test/feature/Ranger/ans/adminsecond28.ans | 4 +
src/test/feature/Ranger/ans/adminsecond29.ans | 4 +
src/test/feature/Ranger/ans/adminsecond3.ans | 4 +
src/test/feature/Ranger/ans/adminsecond30.ans | 4 +
src/test/feature/Ranger/ans/adminsecond31.ans | 4 +
src/test/feature/Ranger/ans/adminsecond32.ans | 4 +
src/test/feature/Ranger/ans/adminsecond33.ans | 4 +
src/test/feature/Ranger/ans/adminsecond34.ans | 4 +
src/test/feature/Ranger/ans/adminsecond35.ans | 4 +
src/test/feature/Ranger/ans/adminsecond36.ans | 4 +
src/test/feature/Ranger/ans/adminsecond37.ans | 4 +
src/test/feature/Ranger/ans/adminsecond38.ans | 4 +
src/test/feature/Ranger/ans/adminsecond39.ans | 4 +
src/test/feature/Ranger/ans/adminsecond4.ans | 4 +
src/test/feature/Ranger/ans/adminsecond40.ans | 4 +
src/test/feature/Ranger/ans/adminsecond41.ans | 16 ++
src/test/feature/Ranger/ans/adminsecond42.ans | 6 +
src/test/feature/Ranger/ans/adminsecond43.ans | 16 ++
src/test/feature/Ranger/ans/adminsecond44.ans | 4 +
src/test/feature/Ranger/ans/adminsecond45.ans | 4 +
src/test/feature/Ranger/ans/adminsecond46.ans | 6 +
src/test/feature/Ranger/ans/adminsecond47.ans | 5 +
src/test/feature/Ranger/ans/adminsecond48.ans | 4 +
src/test/feature/Ranger/ans/adminsecond49.ans | 4 +
src/test/feature/Ranger/ans/adminsecond5.ans | 4 +
src/test/feature/Ranger/ans/adminsecond50.ans | 4 +
src/test/feature/Ranger/ans/adminsecond51.ans | 4 +
src/test/feature/Ranger/ans/adminsecond52.ans | 4 +
src/test/feature/Ranger/ans/adminsecond53.ans | 4 +
src/test/feature/Ranger/ans/adminsecond54.ans | 4 +
src/test/feature/Ranger/ans/adminsecond55.ans | 17 ++
src/test/feature/Ranger/ans/adminsecond56.ans | 5 +
src/test/feature/Ranger/ans/adminsecond57.ans | 8 +
src/test/feature/Ranger/ans/adminsecond58.ans | 9 ++
src/test/feature/Ranger/ans/adminsecond59.ans | 8 +
src/test/feature/Ranger/ans/adminsecond6.ans | 4 +
src/test/feature/Ranger/ans/adminsecond60.ans | 4 +
src/test/feature/Ranger/ans/adminsecond61.ans | 4 +
src/test/feature/Ranger/ans/adminsecond62.ans | 4 +
src/test/feature/Ranger/ans/adminsecond63.ans | 4 +
src/test/feature/Ranger/ans/adminsecond64.ans | 4 +
src/test/feature/Ranger/ans/adminsecond65.ans | 4 +
src/test/feature/Ranger/ans/adminsecond66.ans | 4 +
src/test/feature/Ranger/ans/adminsecond67.ans | 4 +
src/test/feature/Ranger/ans/adminsecond68.ans | 4 +
src/test/feature/Ranger/ans/adminsecond69.ans | 4 +
src/test/feature/Ranger/ans/adminsecond7.ans | 4 +
src/test/feature/Ranger/ans/adminsecond70.ans | 4 +
src/test/feature/Ranger/ans/adminsecond71.ans | 5 +
src/test/feature/Ranger/ans/adminsecond8.ans | 4 +
src/test/feature/Ranger/ans/adminsecond9.ans | 4 +
src/test/feature/Ranger/ans/normal10_fail.ans | 7 +
.../feature/Ranger/ans/normal10_success.ans | 6 +
.../feature/Ranger/ans/normal11_success.ans | 6 +
.../feature/Ranger/ans/normal12_success.ans | 7 +
src/test/feature/Ranger/ans/normal13_fail.ans | 7 +
.../feature/Ranger/ans/normal13_success.ans | 6 +
src/test/feature/Ranger/ans/normal14_fail.ans | 7 +
.../feature/Ranger/ans/normal14_success.ans | 6 +
src/test/feature/Ranger/ans/normal15_fail.ans | 7 +
.../feature/Ranger/ans/normal15_success.ans | 6 +
src/test/feature/Ranger/ans/normal16_fail.ans | 7 +
.../feature/Ranger/ans/normal16_success.ans | 6 +
.../feature/Ranger/ans/normal17_success.ans | 6 +
.../feature/Ranger/ans/normal18_success.ans | 6 +
.../feature/Ranger/ans/normal19_success.ans | 7 +
src/test/feature/Ranger/ans/normal1_fail.ans | 7 +
src/test/feature/Ranger/ans/normal1_success.ans | 6 +
src/test/feature/Ranger/ans/normal20_fail.ans | 7 +
.../feature/Ranger/ans/normal20_success.ans | 6 +
src/test/feature/Ranger/ans/normal21_fail.ans | 7 +
.../feature/Ranger/ans/normal21_success.ans | 6 +
src/test/feature/Ranger/ans/normal22_fail.ans | 7 +
.../feature/Ranger/ans/normal22_success.ans | 6 +
.../feature/Ranger/ans/normal23_success.ans | 6 +
.../feature/Ranger/ans/normal24_success.ans | 7 +
src/test/feature/Ranger/ans/normal25_fail.ans | 7 +
.../feature/Ranger/ans/normal25_success.ans | 7 +
src/test/feature/Ranger/ans/normal26_fail.ans | 7 +
.../feature/Ranger/ans/normal26_success.ans | 6 +
src/test/feature/Ranger/ans/normal27_fail.ans | 11 ++
.../feature/Ranger/ans/normal27_success.ans | 31 ++++
src/test/feature/Ranger/ans/normal28_fail.ans | 7 +
.../feature/Ranger/ans/normal28_success.ans | 6 +
src/test/feature/Ranger/ans/normal29_fail.ans | 7 +
.../feature/Ranger/ans/normal29_success.ans | 6 +
src/test/feature/Ranger/ans/normal2_success.ans | 6 +
src/test/feature/Ranger/ans/normal30_fail.ans | 7 +
.../feature/Ranger/ans/normal30_success.ans | 6 +
src/test/feature/Ranger/ans/normal31_fail.ans | 7 +
.../feature/Ranger/ans/normal31_success.ans | 6 +
src/test/feature/Ranger/ans/normal32_fail.ans | 6 +
.../feature/Ranger/ans/normal32_success.ans | 6 +
src/test/feature/Ranger/ans/normal33_fail.ans | 6 +
.../feature/Ranger/ans/normal33_success.ans | 6 +
src/test/feature/Ranger/ans/normal34_fail.ans | 11 ++
.../feature/Ranger/ans/normal34_success.ans | 6 +
src/test/feature/Ranger/ans/normal35_fail.ans | 11 ++
.../feature/Ranger/ans/normal35_success.ans | 8 +
src/test/feature/Ranger/ans/normal36_fail.ans | 6 +
.../feature/Ranger/ans/normal36_success.ans | 6 +
src/test/feature/Ranger/ans/normal37_fail.ans | 7 +
.../feature/Ranger/ans/normal37_success.ans | 6 +
src/test/feature/Ranger/ans/normal38_fail.ans | 7 +
.../feature/Ranger/ans/normal38_success.ans | 6 +
src/test/feature/Ranger/ans/normal39_fail.ans | 7 +
.../feature/Ranger/ans/normal39_success.ans | 6 +
src/test/feature/Ranger/ans/normal3_success.ans | 6 +
src/test/feature/Ranger/ans/normal40_fail.ans | 7 +
.../feature/Ranger/ans/normal40_success.ans | 6 +
src/test/feature/Ranger/ans/normal41_fail.ans | 11 ++
.../feature/Ranger/ans/normal41_success.ans | 10 ++
src/test/feature/Ranger/ans/normal42_fail.ans | 11 ++
.../feature/Ranger/ans/normal42_success.ans | 8 +
src/test/feature/Ranger/ans/normal43_fail.ans | 11 ++
.../feature/Ranger/ans/normal43_success.ans | 10 ++
src/test/feature/Ranger/ans/normal44_fail.ans | 11 ++
.../feature/Ranger/ans/normal44_success.ans | 6 +
src/test/feature/Ranger/ans/normal45_fail.ans | 11 ++
.../feature/Ranger/ans/normal45_success.ans | 6 +
src/test/feature/Ranger/ans/normal46_fail.ans | 9 ++
.../feature/Ranger/ans/normal46_success.ans | 8 +
src/test/feature/Ranger/ans/normal47_fail.ans | 11 ++
.../feature/Ranger/ans/normal47_success.ans | 7 +
src/test/feature/Ranger/ans/normal48_fail.ans | 7 +
.../feature/Ranger/ans/normal48_success.ans | 6 +
src/test/feature/Ranger/ans/normal49_fail.ans | 7 +
.../feature/Ranger/ans/normal49_success.ans | 6 +
src/test/feature/Ranger/ans/normal4_fail.ans | 12 ++
src/test/feature/Ranger/ans/normal4_success.ans | 6 +
src/test/feature/Ranger/ans/normal50_fail.ans | 7 +
.../feature/Ranger/ans/normal50_success.ans | 6 +
src/test/feature/Ranger/ans/normal51_fail.ans | 7 +
.../feature/Ranger/ans/normal51_success.ans | 6 +
src/test/feature/Ranger/ans/normal52_fail.ans | 7 +
.../feature/Ranger/ans/normal52_success.ans | 6 +
src/test/feature/Ranger/ans/normal53_fail.ans | 7 +
.../feature/Ranger/ans/normal53_success.ans | 6 +
src/test/feature/Ranger/ans/normal54_fail.ans | 7 +
.../feature/Ranger/ans/normal54_success.ans | 6 +
src/test/feature/Ranger/ans/normal55_fail.ans | 12 ++
.../feature/Ranger/ans/normal55_success.ans | 11 ++
src/test/feature/Ranger/ans/normal56_fail.ans | 7 +
.../feature/Ranger/ans/normal56_success.ans | 6 +
src/test/feature/Ranger/ans/normal57_fail.ans | 14 ++
.../feature/Ranger/ans/normal57_success.ans | 10 ++
src/test/feature/Ranger/ans/normal58_fail.ans | 12 ++
.../feature/Ranger/ans/normal58_success.ans | 11 ++
src/test/feature/Ranger/ans/normal59_fail.ans | 12 ++
.../feature/Ranger/ans/normal59_success.ans | 13 ++
src/test/feature/Ranger/ans/normal5_success.ans | 7 +
src/test/feature/Ranger/ans/normal60_fail.ans | 7 +
.../feature/Ranger/ans/normal60_success.ans | 7 +
src/test/feature/Ranger/ans/normal61_fail.ans | 6 +
.../feature/Ranger/ans/normal61_success.ans | 6 +
src/test/feature/Ranger/ans/normal62_fail.ans | 7 +
.../feature/Ranger/ans/normal62_success.ans | 7 +
.../feature/Ranger/ans/normal63_success.ans | 92 +++++++++++
src/test/feature/Ranger/ans/normal64_fail.ans | 7 +
.../feature/Ranger/ans/normal64_success.ans | 6 +
src/test/feature/Ranger/ans/normal65_fail.ans | 7 +
.../feature/Ranger/ans/normal65_success.ans | 6 +
src/test/feature/Ranger/ans/normal66_fail.ans | 7 +
.../feature/Ranger/ans/normal66_success.ans | 6 +
src/test/feature/Ranger/ans/normal67_fail.ans | 7 +
.../feature/Ranger/ans/normal67_success.ans | 6 +
src/test/feature/Ranger/ans/normal68_fail.ans | 7 +
.../feature/Ranger/ans/normal68_success.ans | 6 +
src/test/feature/Ranger/ans/normal69_fail.ans | 7 +
.../feature/Ranger/ans/normal69_success.ans | 6 +
src/test/feature/Ranger/ans/normal6_success.ans | 6 +
src/test/feature/Ranger/ans/normal70_fail.ans | 7 +
.../feature/Ranger/ans/normal70_success.ans | 6 +
src/test/feature/Ranger/ans/normal71_fail.ans | 6 +
.../feature/Ranger/ans/normal71_success.ans | 6 +
src/test/feature/Ranger/ans/normal7_fail.ans | 7 +
src/test/feature/Ranger/ans/normal7_success.ans | 6 +
src/test/feature/Ranger/ans/normal8_fail.ans | 7 +
src/test/feature/Ranger/ans/normal8_success.ans | 6 +
src/test/feature/Ranger/ans/normal9_fail.ans | 7 +
src/test/feature/Ranger/ans/normal9_success.ans | 6 +
src/test/feature/Ranger/ans/super11_fail.ans | 6 +
src/test/feature/Ranger/ans/super11_success.ans | 6 +
src/test/feature/Ranger/ans/super12_success.ans | 6 +
src/test/feature/Ranger/ans/super17_success.ans | 6 +
src/test/feature/Ranger/ans/super18_success.ans | 6 +
src/test/feature/Ranger/ans/super19_success.ans | 6 +
src/test/feature/Ranger/ans/super23_success.ans | 6 +
src/test/feature/Ranger/ans/super24_fail.ans | 6 +
src/test/feature/Ranger/ans/super24_success.ans | 6 +
src/test/feature/Ranger/ans/super2_fail.ans | 6 +
src/test/feature/Ranger/ans/super2_success.ans | 6 +
src/test/feature/Ranger/ans/super3_fail.ans | 6 +
src/test/feature/Ranger/ans/super3_success.ans | 6 +
src/test/feature/Ranger/ans/super5_success.ans | 6 +
src/test/feature/Ranger/ans/super63_fail.ans | 10 ++
src/test/feature/Ranger/ans/super63_success.ans | 6 +
src/test/feature/Ranger/ans/super6_success.ans | 6 +
src/test/feature/Ranger/data/copydata.txt | 2 +
src/test/feature/Ranger/policy/1/1.json | 1 +
src/test/feature/Ranger/policy/10/1.json | 1 +
src/test/feature/Ranger/policy/10/2.json | 1 +
src/test/feature/Ranger/policy/10/3.json | 1 +
src/test/feature/Ranger/policy/11/1.json | 1 +
src/test/feature/Ranger/policy/13/1.json | 1 +
src/test/feature/Ranger/policy/14/1.json | 1 +
src/test/feature/Ranger/policy/15/1.json | 1 +
src/test/feature/Ranger/policy/16/1.json | 1 +
src/test/feature/Ranger/policy/2/1.json | 1 +
src/test/feature/Ranger/policy/20/1.json | 1 +
src/test/feature/Ranger/policy/20/2.json | 1 +
src/test/feature/Ranger/policy/21/1.json | 1 +
src/test/feature/Ranger/policy/21/2.json | 1 +
src/test/feature/Ranger/policy/22/1.json | 1 +
src/test/feature/Ranger/policy/24/1.json | 1 +
src/test/feature/Ranger/policy/25/1.json | 1 +
src/test/feature/Ranger/policy/25/2.json | 1 +
src/test/feature/Ranger/policy/26/1.json | 1 +
src/test/feature/Ranger/policy/27/1.json | 1 +
src/test/feature/Ranger/policy/27/2.json | 1 +
src/test/feature/Ranger/policy/28/1.json | 1 +
src/test/feature/Ranger/policy/28/2.json | 1 +
src/test/feature/Ranger/policy/29/1.json | 1 +
src/test/feature/Ranger/policy/29/2.json | 1 +
src/test/feature/Ranger/policy/3/1.json | 1 +
src/test/feature/Ranger/policy/30/1.json | 1 +
src/test/feature/Ranger/policy/31/1.json | 1 +
src/test/feature/Ranger/policy/32/1.json | 1 +
src/test/feature/Ranger/policy/33/1.json | 1 +
src/test/feature/Ranger/policy/33/2.json | 1 +
src/test/feature/Ranger/policy/34/1.json | 1 +
src/test/feature/Ranger/policy/35/1.json | 1 +
src/test/feature/Ranger/policy/35/2.json | 1 +
src/test/feature/Ranger/policy/36/1.json | 1 +
src/test/feature/Ranger/policy/37/1.json | 1 +
src/test/feature/Ranger/policy/38/1.json | 1 +
src/test/feature/Ranger/policy/38/2.json | 1 +
src/test/feature/Ranger/policy/39/1.json | 1 +
src/test/feature/Ranger/policy/39/2.json | 1 +
src/test/feature/Ranger/policy/4/1.json | 1 +
src/test/feature/Ranger/policy/4/2.json | 1 +
src/test/feature/Ranger/policy/4/3.json | 1 +
src/test/feature/Ranger/policy/40/1.json | 1 +
src/test/feature/Ranger/policy/40/2.json | 1 +
src/test/feature/Ranger/policy/40/3.json | 1 +
src/test/feature/Ranger/policy/41/1.json | 1 +
src/test/feature/Ranger/policy/41/2.json | 1 +
src/test/feature/Ranger/policy/42/1.json | 1 +
src/test/feature/Ranger/policy/43/1.json | 1 +
src/test/feature/Ranger/policy/43/2.json | 1 +
src/test/feature/Ranger/policy/43/3.json | 1 +
src/test/feature/Ranger/policy/44/1.json | 1 +
src/test/feature/Ranger/policy/44/2.json | 1 +
src/test/feature/Ranger/policy/45/1.json | 1 +
src/test/feature/Ranger/policy/45/2.json | 1 +
src/test/feature/Ranger/policy/45/3.json | 1 +
src/test/feature/Ranger/policy/46/1.json | 1 +
src/test/feature/Ranger/policy/46/2.json | 1 +
src/test/feature/Ranger/policy/47/1.json | 1 +
src/test/feature/Ranger/policy/47/2.json | 1 +
src/test/feature/Ranger/policy/48/1.json | 1 +
src/test/feature/Ranger/policy/48/2.json | 1 +
src/test/feature/Ranger/policy/48/3.json | 1 +
src/test/feature/Ranger/policy/49/1.json | 1 +
src/test/feature/Ranger/policy/49/2.json | 1 +
src/test/feature/Ranger/policy/50/1.json | 1 +
src/test/feature/Ranger/policy/51/1.json | 1 +
src/test/feature/Ranger/policy/52/1.json | 1 +
src/test/feature/Ranger/policy/53/1.json | 1 +
src/test/feature/Ranger/policy/54/1.json | 1 +
src/test/feature/Ranger/policy/54/2.json | 1 +
src/test/feature/Ranger/policy/54/3.json | 1 +
src/test/feature/Ranger/policy/55/1.json | 1 +
src/test/feature/Ranger/policy/55/2.json | 1 +
src/test/feature/Ranger/policy/55/3.json | 1 +
src/test/feature/Ranger/policy/56/1.json | 1 +
src/test/feature/Ranger/policy/57/1.json | 1 +
src/test/feature/Ranger/policy/57/2.json | 1 +
src/test/feature/Ranger/policy/57/3.json | 1 +
src/test/feature/Ranger/policy/58/1.json | 1 +
src/test/feature/Ranger/policy/58/2.json | 1 +
src/test/feature/Ranger/policy/59/1.json | 1 +
src/test/feature/Ranger/policy/60/1.json | 1 +
src/test/feature/Ranger/policy/60/2.json | 1 +
src/test/feature/Ranger/policy/61/1.json | 1 +
src/test/feature/Ranger/policy/61/2.json | 1 +
src/test/feature/Ranger/policy/61/3.json | 1 +
src/test/feature/Ranger/policy/62/1.json | 1 +
src/test/feature/Ranger/policy/63/1.json | 1 +
src/test/feature/Ranger/policy/63/2.json | 1 +
src/test/feature/Ranger/policy/63/3.json | 1 +
src/test/feature/Ranger/policy/63/4.json | 1 +
src/test/feature/Ranger/policy/64/1.json | 1 +
src/test/feature/Ranger/policy/65/1.json | 1 +
src/test/feature/Ranger/policy/66/1.json | 1 +
src/test/feature/Ranger/policy/67/1.json | 1 +
src/test/feature/Ranger/policy/68/1.json | 1 +
src/test/feature/Ranger/policy/69/1.json | 1 +
src/test/feature/Ranger/policy/7/1.json | 1 +
src/test/feature/Ranger/policy/7/2.json | 1 +
src/test/feature/Ranger/policy/7/3.json | 1 +
src/test/feature/Ranger/policy/70/1.json | 1 +
src/test/feature/Ranger/policy/71/1.json | 1 +
src/test/feature/Ranger/policy/8/1.json | 1 +
src/test/feature/Ranger/policy/8/2.json | 1 +
src/test/feature/Ranger/policy/8/3.json | 1 +
src/test/feature/Ranger/policy/9/1.json | 1 +
src/test/feature/Ranger/rangerpolicy.py | 100 ++++++++++++
src/test/feature/Ranger/rangerrest.py | 86 ++++++++++
src/test/feature/Ranger/rangeruser.py | 117 ++++++++++++++
src/test/feature/Ranger/sql/admin/1.sql | 2 +
src/test/feature/Ranger/sql/admin/10.sql | 2 +
src/test/feature/Ranger/sql/admin/11.sql | 2 +
src/test/feature/Ranger/sql/admin/12.sql | 2 +
src/test/feature/Ranger/sql/admin/13.sql | 2 +
src/test/feature/Ranger/sql/admin/14.sql | 2 +
src/test/feature/Ranger/sql/admin/15.sql | 2 +
src/test/feature/Ranger/sql/admin/16.sql | 2 +
src/test/feature/Ranger/sql/admin/17.sql | 2 +
src/test/feature/Ranger/sql/admin/18.sql | 2 +
src/test/feature/Ranger/sql/admin/19.sql | 2 +
src/test/feature/Ranger/sql/admin/2.sql | 2 +
src/test/feature/Ranger/sql/admin/20.sql | 2 +
src/test/feature/Ranger/sql/admin/21.sql | 2 +
src/test/feature/Ranger/sql/admin/22.sql | 2 +
src/test/feature/Ranger/sql/admin/23.sql | 2 +
src/test/feature/Ranger/sql/admin/24.sql | 2 +
src/test/feature/Ranger/sql/admin/25.sql | 2 +
src/test/feature/Ranger/sql/admin/26.sql | 2 +
src/test/feature/Ranger/sql/admin/27.sql | 2 +
src/test/feature/Ranger/sql/admin/28.sql | 2 +
src/test/feature/Ranger/sql/admin/29.sql | 2 +
src/test/feature/Ranger/sql/admin/3.sql | 2 +
src/test/feature/Ranger/sql/admin/30.sql | 2 +
src/test/feature/Ranger/sql/admin/31.sql | 2 +
src/test/feature/Ranger/sql/admin/32.sql | 2 +
src/test/feature/Ranger/sql/admin/33.sql | 2 +
src/test/feature/Ranger/sql/admin/34.sql | 2 +
src/test/feature/Ranger/sql/admin/35.sql | 2 +
src/test/feature/Ranger/sql/admin/36.sql | 2 +
src/test/feature/Ranger/sql/admin/37.sql | 2 +
src/test/feature/Ranger/sql/admin/38.sql | 2 +
src/test/feature/Ranger/sql/admin/39.sql | 2 +
src/test/feature/Ranger/sql/admin/4.sql | 2 +
src/test/feature/Ranger/sql/admin/40.sql | 2 +
src/test/feature/Ranger/sql/admin/41.sql | 2 +
src/test/feature/Ranger/sql/admin/42.sql | 2 +
src/test/feature/Ranger/sql/admin/43.sql | 2 +
src/test/feature/Ranger/sql/admin/44.sql | 2 +
src/test/feature/Ranger/sql/admin/45.sql | 2 +
src/test/feature/Ranger/sql/admin/46.sql | 2 +
src/test/feature/Ranger/sql/admin/47.sql | 2 +
src/test/feature/Ranger/sql/admin/48.sql | 2 +
src/test/feature/Ranger/sql/admin/49.sql | 2 +
src/test/feature/Ranger/sql/admin/5.sql | 2 +
src/test/feature/Ranger/sql/admin/50.sql | 2 +
src/test/feature/Ranger/sql/admin/51.sql | 2 +
src/test/feature/Ranger/sql/admin/52.sql | 2 +
src/test/feature/Ranger/sql/admin/53.sql | 2 +
src/test/feature/Ranger/sql/admin/54.sql | 2 +
src/test/feature/Ranger/sql/admin/55.sql | 2 +
src/test/feature/Ranger/sql/admin/56.sql | 2 +
src/test/feature/Ranger/sql/admin/57.sql | 2 +
src/test/feature/Ranger/sql/admin/58.sql | 2 +
src/test/feature/Ranger/sql/admin/59.sql | 2 +
src/test/feature/Ranger/sql/admin/6.sql | 2 +
src/test/feature/Ranger/sql/admin/60.sql | 2 +
src/test/feature/Ranger/sql/admin/61.sql | 2 +
src/test/feature/Ranger/sql/admin/62.sql | 2 +
src/test/feature/Ranger/sql/admin/63.sql | 2 +
src/test/feature/Ranger/sql/admin/64.sql | 2 +
src/test/feature/Ranger/sql/admin/65.sql | 2 +
src/test/feature/Ranger/sql/admin/66.sql | 2 +
src/test/feature/Ranger/sql/admin/67.sql | 2 +
src/test/feature/Ranger/sql/admin/68.sql | 2 +
src/test/feature/Ranger/sql/admin/69.sql | 2 +
src/test/feature/Ranger/sql/admin/7.sql | 2 +
src/test/feature/Ranger/sql/admin/70.sql | 2 +
src/test/feature/Ranger/sql/admin/71.sql | 2 +
src/test/feature/Ranger/sql/admin/8.sql | 2 +
src/test/feature/Ranger/sql/admin/9.sql | 2 +
src/test/feature/Ranger/sql/init_file | 7 +
src/test/feature/Ranger/sql/normal/1.sql | 3 +
src/test/feature/Ranger/sql/normal/10.sql | 3 +
src/test/feature/Ranger/sql/normal/11.sql | 3 +
src/test/feature/Ranger/sql/normal/12.sql | 3 +
src/test/feature/Ranger/sql/normal/13.sql | 3 +
src/test/feature/Ranger/sql/normal/14.sql | 3 +
src/test/feature/Ranger/sql/normal/15.sql | 3 +
src/test/feature/Ranger/sql/normal/16.sql | 3 +
src/test/feature/Ranger/sql/normal/17.sql | 3 +
src/test/feature/Ranger/sql/normal/18.sql | 3 +
src/test/feature/Ranger/sql/normal/19.sql | 3 +
src/test/feature/Ranger/sql/normal/2.sql | 3 +
src/test/feature/Ranger/sql/normal/20.sql | 3 +
src/test/feature/Ranger/sql/normal/21.sql | 3 +
src/test/feature/Ranger/sql/normal/22.sql | 3 +
src/test/feature/Ranger/sql/normal/23.sql | 3 +
src/test/feature/Ranger/sql/normal/24.sql | 3 +
src/test/feature/Ranger/sql/normal/25.sql | 3 +
src/test/feature/Ranger/sql/normal/26.sql | 3 +
src/test/feature/Ranger/sql/normal/27.sql | 3 +
src/test/feature/Ranger/sql/normal/28.sql | 3 +
src/test/feature/Ranger/sql/normal/29.sql | 3 +
src/test/feature/Ranger/sql/normal/3.sql | 3 +
src/test/feature/Ranger/sql/normal/30.sql | 3 +
src/test/feature/Ranger/sql/normal/31.sql | 3 +
src/test/feature/Ranger/sql/normal/32.sql | 3 +
src/test/feature/Ranger/sql/normal/33.sql | 3 +
src/test/feature/Ranger/sql/normal/34.sql | 3 +
src/test/feature/Ranger/sql/normal/35.sql | 3 +
src/test/feature/Ranger/sql/normal/36.sql | 3 +
src/test/feature/Ranger/sql/normal/37.sql | 3 +
src/test/feature/Ranger/sql/normal/38.sql | 3 +
src/test/feature/Ranger/sql/normal/39.sql | 3 +
src/test/feature/Ranger/sql/normal/4.sql | 3 +
src/test/feature/Ranger/sql/normal/40.sql | 3 +
src/test/feature/Ranger/sql/normal/41.sql | 3 +
src/test/feature/Ranger/sql/normal/42.sql | 3 +
src/test/feature/Ranger/sql/normal/43.sql | 3 +
src/test/feature/Ranger/sql/normal/44.sql | 3 +
src/test/feature/Ranger/sql/normal/45.sql | 3 +
src/test/feature/Ranger/sql/normal/46.sql | 3 +
src/test/feature/Ranger/sql/normal/47.sql | 3 +
src/test/feature/Ranger/sql/normal/48.sql | 3 +
src/test/feature/Ranger/sql/normal/49.sql | 3 +
src/test/feature/Ranger/sql/normal/5.sql | 3 +
src/test/feature/Ranger/sql/normal/50.sql | 3 +
src/test/feature/Ranger/sql/normal/51.sql | 3 +
src/test/feature/Ranger/sql/normal/52.sql | 3 +
src/test/feature/Ranger/sql/normal/53.sql | 3 +
src/test/feature/Ranger/sql/normal/54.sql | 3 +
src/test/feature/Ranger/sql/normal/55.sql | 3 +
src/test/feature/Ranger/sql/normal/56.sql | 3 +
src/test/feature/Ranger/sql/normal/57.sql | 3 +
src/test/feature/Ranger/sql/normal/58.sql | 3 +
src/test/feature/Ranger/sql/normal/59.sql | 3 +
src/test/feature/Ranger/sql/normal/6.sql | 3 +
src/test/feature/Ranger/sql/normal/60.sql | 3 +
src/test/feature/Ranger/sql/normal/61.sql | 3 +
src/test/feature/Ranger/sql/normal/62.sql | 3 +
src/test/feature/Ranger/sql/normal/63.sql | 3 +
src/test/feature/Ranger/sql/normal/64.sql | 3 +
src/test/feature/Ranger/sql/normal/65.sql | 3 +
src/test/feature/Ranger/sql/normal/66.sql | 3 +
src/test/feature/Ranger/sql/normal/67.sql | 3 +
src/test/feature/Ranger/sql/normal/68.sql | 3 +
src/test/feature/Ranger/sql/normal/69.sql | 3 +
src/test/feature/Ranger/sql/normal/7.sql | 3 +
src/test/feature/Ranger/sql/normal/70.sql | 3 +
src/test/feature/Ranger/sql/normal/71.sql | 3 +
src/test/feature/Ranger/sql/normal/8.sql | 3 +
src/test/feature/Ranger/sql/normal/9.sql | 3 +
src/test/feature/Ranger/sql/sqlsplit.cpp | 92 +++++++++++
src/test/feature/Ranger/sql/sqlsplitinput | 142 +++++++++++++++++
src/test/feature/Ranger/sql/super/11.sql | 3 +
src/test/feature/Ranger/sql/super/12.sql | 3 +
src/test/feature/Ranger/sql/super/17.sql | 3 +
src/test/feature/Ranger/sql/super/18.sql | 3 +
src/test/feature/Ranger/sql/super/19.sql | 3 +
src/test/feature/Ranger/sql/super/2.sql | 3 +
src/test/feature/Ranger/sql/super/23.sql | 3 +
src/test/feature/Ranger/sql/super/24.sql | 3 +
src/test/feature/Ranger/sql/super/3.sql | 3 +
src/test/feature/Ranger/sql/super/5.sql | 3 +
src/test/feature/Ranger/sql/super/6.sql | 3 +
src/test/feature/Ranger/sql/super/63.sql | 3 +
src/test/feature/Ranger/test_ranger.cpp | 159 +++++++++++++++++++
src/test/feature/Ranger/test_ranger.h | 33 ++++
src/test/feature/lib/gpfdist.cpp | 7 -
src/test/feature/lib/psql.cpp | 13 +-
src/test/feature/lib/psql.h | 4 +-
src/test/feature/lib/sql_util.cpp | 17 +-
src/test/feature/lib/sql_util.h | 7 +-
src/test/feature/sanity_tests.txt | 2 +-
567 files changed, 3149 insertions(+), 23 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/ExternalSource/test_errortbl.cpp
----------------------------------------------------------------------
diff --git a/src/test/feature/ExternalSource/test_errortbl.cpp b/src/test/feature/ExternalSource/test_errortbl.cpp
index a11a8df..7409f81 100644
--- a/src/test/feature/ExternalSource/test_errortbl.cpp
+++ b/src/test/feature/ExternalSource/test_errortbl.cpp
@@ -102,5 +102,13 @@ TEST_F(TestErrorTable, TestErrorTableAll) {
"LOG ERRORS INTO EXT_NATION_ERROR_WRITABLE SEGMENT REJECT LIMIT 5;",
false);
+ util.execute("drop external table EXT_NATION_WITH_EXIST_ERROR_TABLE;");
+ util.execute("drop external table EXT_NATION1;");
+ util.execute("drop table EXT_NATION_ERROR1 CASCADE;");
+ util.execute("drop external table EXT_NATION2;");
+ util.execute("drop table EXT_NATION_ERROR2 CASCADE;");
+ util.execute("drop external table EXT_NATION3;");
+ util.execute("drop table EXT_NATION_ERROR3 CASCADE;");
+
gpdfist.finalize_gpfdist();
}
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst1.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst1.ans b/src/test/feature/Ranger/ans/adminfirst1.ans
new file mode 100644
index 0000000..b9fca34
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst1.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create table a(i int);
+CREATE TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst10.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst10.ans b/src/test/feature/Ranger/ans/adminfirst10.ans
new file mode 100644
index 0000000..ca24909
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst10.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OR REPLACE FUNCTION si_same(text, text) RETURNS int AS $$ BEGIN IF normalize_si($1) < normalize_si($2) THEN RETURN -1; END IF; END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst11.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst11.ans b/src/test/feature/Ranger/ans/adminfirst11.ans
new file mode 100644
index 0000000..1a5787c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst11.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OPERATOR CLASS sva_special_ops FOR TYPE text USING btree AS OPERATOR 1 <#, FUNCTION 1 si_same(text, text);
+CREATE OPERATOR CLASS
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst12.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst12.ans b/src/test/feature/Ranger/ans/adminfirst12.ans
new file mode 100644
index 0000000..2ec6c82
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst12.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop OPERATOR CLASS sva_special_ops USING btree;
+DROP OPERATOR CLASS
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst13.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst13.ans b/src/test/feature/Ranger/ans/adminfirst13.ans
new file mode 100644
index 0000000..e5b435e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst13.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop OPERATOR <# (text,text) CASCADE;
+DROP OPERATOR
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst14.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst14.ans b/src/test/feature/Ranger/ans/adminfirst14.ans
new file mode 100644
index 0000000..150db1e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst14.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop FUNCTION si_same(text, text);
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst15.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst15.ans b/src/test/feature/Ranger/ans/adminfirst15.ans
new file mode 100644
index 0000000..56708c6
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst15.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop FUNCTION si_lt(text, text);
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst16.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst16.ans b/src/test/feature/Ranger/ans/adminfirst16.ans
new file mode 100644
index 0000000..2f4e41c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst16.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop FUNCTION normalize_si(text);
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst17.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst17.ans b/src/test/feature/Ranger/ans/adminfirst17.ans
new file mode 100644
index 0000000..78b7091
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst17.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE RESOURCE QUEUE myqueue WITH (PARENT='pg_root', ACTIVE_STATEMENTS=20, MEMORY_LIMIT_CLUSTER=50%, CORE_LIMIT_CLUSTER=50%);
+CREATE QUEUE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst18.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst18.ans b/src/test/feature/Ranger/ans/adminfirst18.ans
new file mode 100644
index 0000000..c0721f9
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst18.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+DROP RESOURCE QUEUE myqueue;
+DROP QUEUE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst19.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst19.ans b/src/test/feature/Ranger/ans/adminfirst19.ans
new file mode 100644
index 0000000..e32ffa2
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst19.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE TABLESPACE mytblspace FILESPACE dfs_system;
+CREATE TABLESPACE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst2.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst2.ans b/src/test/feature/Ranger/ans/adminfirst2.ans
new file mode 100644
index 0000000..3c74a36
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst2.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create language plpythonu;
+CREATE LANGUAGE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst20.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst20.ans b/src/test/feature/Ranger/ans/adminfirst20.ans
new file mode 100644
index 0000000..0136985
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst20.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE TABLE foo(i int) TABLESPACE mytblspace;
+CREATE TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst21.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst21.ans b/src/test/feature/Ranger/ans/adminfirst21.ans
new file mode 100644
index 0000000..ee188ab
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst21.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+insert into foo(i) values(1234);
+INSERT 0 1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst22.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst22.ans b/src/test/feature/Ranger/ans/adminfirst22.ans
new file mode 100644
index 0000000..b6a0d25
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst22.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop table foo;
+DROP TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst23.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst23.ans b/src/test/feature/Ranger/ans/adminfirst23.ans
new file mode 100644
index 0000000..30a0e21
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst23.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop tablespace mytblspace;
+DROP TABLESPACE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst24.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst24.ans b/src/test/feature/Ranger/ans/adminfirst24.ans
new file mode 100644
index 0000000..2fc5625
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst24.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+COPY a FROM '/tmp/a.txt';
+COPY 2
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst25.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst25.ans b/src/test/feature/Ranger/ans/adminfirst25.ans
new file mode 100644
index 0000000..dc309a6
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst25.ans
@@ -0,0 +1,5 @@
+-- start_ignore
+-- end_ignore
+COPY a TO STDOUT WITH DELIMITER '|';
+1
+1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst26.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst26.ans b/src/test/feature/Ranger/ans/adminfirst26.ans
new file mode 100644
index 0000000..fffdc0e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst26.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE EXTERNAL TABLE ext_t ( N_NATIONKEY INTEGER ,N_NAME CHAR(25), N_REGIONKEY INTEGER ,N_COMMENT VARCHAR(152))location ('gpfdist://localhost:7070/nation_error50.tbl')FORMAT 'text' (delimiter '|')SEGMENT REJECT LIMIT 51;
+CREATE EXTERNAL TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst27.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst27.ans b/src/test/feature/Ranger/ans/adminfirst27.ans
new file mode 100644
index 0000000..842a8b6
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst27.ans
@@ -0,0 +1,29 @@
+-- start_ignore
+-- end_ignore
+select * from ext_t order by N_NATIONKEY;
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: NOTICE: Found 50 data formatting errors (50 or more input rows). Rejected related input data.
+0|ALGERIA |0| haggle. carefully final deposits detect slyly agai
+1|ARGENTINA |1|al foxes promise slyly according to the regular accounts. bold requests alon
+2|BRAZIL |1|y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special
+3|CANADA |1|eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
+4|EGYPT |4|y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
+5|ETHIOPIA |0|ven packages wake quickly. regu
+6|FRANCE |3|refully final requests. regular, ironi
+7|GERMANY |3|l platelets. regular accounts x-ray: unusual, regular acco
+8|INDIA |2|ss excuses cajole slyly across the packages. deposits print aroun
+9|INDONESIA |2| slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
+10|IRAN |4|efully alongside of the slyly final dependencies.
+11|IRAQ |4|nic deposits boost atop the quickly final requests? quickly regula
+12|JAPAN |2|ously. final, express gifts cajole a
+13|JORDAN |4|ic deposits are blithely about the carefully regular pa
+14|KENYA |0| pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
+15|MOROCCO |0|rns. blithely bold courts among the closely regular packages use furiously bold platelets?
+16|MOZAMBIQUE |0|s. ironic, unusual asymptotes wake blithely r
+17|PERU |1|platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
+18|CHINA |2|c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
+19|ROMANIA |3|ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
+20|SAUDI ARABIA |4|ts. silent requests haggle. closely express packages sleep across the blithely
+21|VIETNAM |2|hely enticingly express accounts. even, final
+22|RUSSIA |3| requests against the platelets use never according to the quickly regular pint
+23|UNITED KINGDOM |3|eans boost carefully special requests. accounts are. carefull
+24|UNITED STATES |1|y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst28.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst28.ans b/src/test/feature/Ranger/ans/adminfirst28.ans
new file mode 100644
index 0000000..b14ade2
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst28.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE WRITABLE EXTERNAL TABLE ext_t2 (i int) LOCATION ('gpfdist://localhost:7070/ranger2.out') FORMAT 'TEXT' ( DELIMITER '|' NULL ' ');
+CREATE EXTERNAL TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst29.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst29.ans b/src/test/feature/Ranger/ans/adminfirst29.ans
new file mode 100644
index 0000000..3d0587f
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst29.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+insert into ext_t2(i) values(234);
+INSERT 0 1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst3.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst3.ans b/src/test/feature/Ranger/ans/adminfirst3.ans
new file mode 100644
index 0000000..d0b2353
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst3.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst30.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst30.ans b/src/test/feature/Ranger/ans/adminfirst30.ans
new file mode 100644
index 0000000..278ff6c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst30.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop EXTERNAL TABLE ext_t;
+DROP EXTERNAL TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst31.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst31.ans b/src/test/feature/Ranger/ans/adminfirst31.ans
new file mode 100644
index 0000000..dfeb2dc
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst31.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop EXTERNAL TABLE ext_t2;
+DROP EXTERNAL TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst32.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst32.ans b/src/test/feature/Ranger/ans/adminfirst32.ans
new file mode 100644
index 0000000..9be07d2
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst32.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create schema sa;
+CREATE SCHEMA
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst33.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst33.ans b/src/test/feature/Ranger/ans/adminfirst33.ans
new file mode 100644
index 0000000..d286367
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst33.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create temp table ta(i int);
+CREATE TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst34.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst34.ans b/src/test/feature/Ranger/ans/adminfirst34.ans
new file mode 100644
index 0000000..eb4429f
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst34.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create view av as select * from a order by i;
+CREATE VIEW
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst35.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst35.ans b/src/test/feature/Ranger/ans/adminfirst35.ans
new file mode 100644
index 0000000..6f7bf29
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst35.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create table aa as select * from a order by i;
+SELECT 2
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst36.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst36.ans b/src/test/feature/Ranger/ans/adminfirst36.ans
new file mode 100644
index 0000000..429211d
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst36.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create table sa.t(a int, b int);
+CREATE TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst37.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst37.ans b/src/test/feature/Ranger/ans/adminfirst37.ans
new file mode 100644
index 0000000..a84343d
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst37.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE SEQUENCE myseq START 1;
+CREATE SEQUENCE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst38.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst38.ans b/src/test/feature/Ranger/ans/adminfirst38.ans
new file mode 100644
index 0000000..eb0b157
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst38.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+insert into a values(1);
+INSERT 0 1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst39.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst39.ans b/src/test/feature/Ranger/ans/adminfirst39.ans
new file mode 100644
index 0000000..eb0b157
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst39.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+insert into a values(1);
+INSERT 0 1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst4.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst4.ans b/src/test/feature/Ranger/ans/adminfirst4.ans
new file mode 100644
index 0000000..5a06518
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst4.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+select * from f4();
+
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst40.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst40.ans b/src/test/feature/Ranger/ans/adminfirst40.ans
new file mode 100644
index 0000000..7a178c6
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst40.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+insert into a VALUES (nextval('myseq'));
+INSERT 0 1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst41.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst41.ans b/src/test/feature/Ranger/ans/adminfirst41.ans
new file mode 100644
index 0000000..d28e95d
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst41.ans
@@ -0,0 +1,8 @@
+-- start_ignore
+-- end_ignore
+select * from a order by i;
+1
+1
+1
+1
+1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst42.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst42.ans b/src/test/feature/Ranger/ans/adminfirst42.ans
new file mode 100644
index 0000000..09dd411
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst42.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+select generate_series(1,3);
+1
+2
+3
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst43.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst43.ans b/src/test/feature/Ranger/ans/adminfirst43.ans
new file mode 100644
index 0000000..d877593
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst43.ans
@@ -0,0 +1,8 @@
+-- start_ignore
+-- end_ignore
+select * from av;
+1
+1
+1
+1
+1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst44.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst44.ans b/src/test/feature/Ranger/ans/adminfirst44.ans
new file mode 100644
index 0000000..ce8e756
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst44.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+SELECT setval('myseq', 1);
+1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst45.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst45.ans b/src/test/feature/Ranger/ans/adminfirst45.ans
new file mode 100644
index 0000000..8c146c7
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst45.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+SELECT * INTO aaa FROM a WHERE i > 0 order by i;
+SELECT 5
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst46.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst46.ans b/src/test/feature/Ranger/ans/adminfirst46.ans
new file mode 100644
index 0000000..a8582d8
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst46.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+PREPARE fooplan (int) AS INSERT INTO a VALUES($1);EXECUTE fooplan(1);DEALLOCATE fooplan;
+PREPARE
+INSERT 0 1
+DEALLOCATE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst47.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst47.ans b/src/test/feature/Ranger/ans/adminfirst47.ans
new file mode 100644
index 0000000..c3aa5ee
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst47.ans
@@ -0,0 +1,5 @@
+-- start_ignore
+-- end_ignore
+explain select * from a;
+Gather Motion 1:1 (slice1; segments: 1) (cost=0.00..1.02 rows=2 width=4)
+ -> Append-only Scan on a (cost=0.00..1.02 rows=2 width=4)
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst48.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst48.ans b/src/test/feature/Ranger/ans/adminfirst48.ans
new file mode 100644
index 0000000..fdaa03b
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst48.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE FUNCTION scube_accum(numeric, numeric) RETURNS numeric AS 'select $1 + $2 * $2 * $2' LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPUT;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst49.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst49.ans b/src/test/feature/Ranger/ans/adminfirst49.ans
new file mode 100644
index 0000000..fc2f8b2
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst49.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE AGGREGATE scube(numeric) ( SFUNC = scube_accum, STYPE = numeric, INITCOND = 0 );
+CREATE AGGREGATE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst5.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst5.ans b/src/test/feature/Ranger/ans/adminfirst5.ans
new file mode 100644
index 0000000..9a6a74f
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst5.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop function f4();
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst50.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst50.ans b/src/test/feature/Ranger/ans/adminfirst50.ans
new file mode 100644
index 0000000..c0e6523
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst50.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+ALTER AGGREGATE scube(numeric) RENAME TO scube2;
+ALTER AGGREGATE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst51.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst51.ans b/src/test/feature/Ranger/ans/adminfirst51.ans
new file mode 100644
index 0000000..aa4f869
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst51.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+DROP AGGREGATE scube2(numeric);
+DROP AGGREGATE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst52.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst52.ans b/src/test/feature/Ranger/ans/adminfirst52.ans
new file mode 100644
index 0000000..af03391
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst52.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+DROP FUNCTION scube_accum(numeric, numeric);
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst53.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst53.ans b/src/test/feature/Ranger/ans/adminfirst53.ans
new file mode 100644
index 0000000..4eaf4cc
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst53.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE TYPE mytype AS (f1 int, f2 int);
+CREATE TYPE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst54.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst54.ans b/src/test/feature/Ranger/ans/adminfirst54.ans
new file mode 100644
index 0000000..c8bb63f
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst54.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE FUNCTION getfoo() RETURNS SETOF mytype AS $$ SELECT i, i FROM a order by i $$ LANGUAGE SQL;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst55.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst55.ans b/src/test/feature/Ranger/ans/adminfirst55.ans
new file mode 100644
index 0000000..ae52d70
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst55.ans
@@ -0,0 +1,9 @@
+-- start_ignore
+-- end_ignore
+select getfoo();
+(1,1)
+(1,1)
+(1,1)
+(1,1)
+(1,1)
+(1,1)
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst56.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst56.ans b/src/test/feature/Ranger/ans/adminfirst56.ans
new file mode 100644
index 0000000..7577294
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst56.ans
@@ -0,0 +1,5 @@
+-- start_ignore
+-- end_ignore
+drop type mytype cascade;
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: NOTICE: drop cascades to function getfoo()
+DROP TYPE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst57.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst57.ans b/src/test/feature/Ranger/ans/adminfirst57.ans
new file mode 100644
index 0000000..1dd130e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst57.ans
@@ -0,0 +1,8 @@
+-- start_ignore
+-- end_ignore
+begin; DECLARE mycursor CURSOR FOR SELECT * FROM a order by i; FETCH FORWARD 2 FROM mycursor; commit;
+BEGIN
+DECLARE CURSOR
+1
+1
+COMMIT
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst58.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst58.ans b/src/test/feature/Ranger/ans/adminfirst58.ans
new file mode 100644
index 0000000..3b7fd19
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst58.ans
@@ -0,0 +1,9 @@
+-- start_ignore
+-- end_ignore
+BEGIN; INSERT INTO a VALUES (1); SAVEPOINT my_savepoint; INSERT INTO a VALUES (1); RELEASE SAVEPOINT my_savepoint; COMMIT;
+BEGIN
+INSERT 0 1
+SAVEPOINT
+INSERT 0 1
+RELEASE
+COMMIT
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst59.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst59.ans b/src/test/feature/Ranger/ans/adminfirst59.ans
new file mode 100644
index 0000000..c4eb2ef
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst59.ans
@@ -0,0 +1,8 @@
+-- start_ignore
+-- end_ignore
+\d
+public|a|table|huanzhang|append only
+public|aa|table|huanzhang|append only
+public|aaa|table|huanzhang|append only
+public|av|view|huanzhang|none
+public|myseq|sequence|huanzhang|heap
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst6.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst6.ans b/src/test/feature/Ranger/ans/adminfirst6.ans
new file mode 100644
index 0000000..8691498
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst6.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop language plpythonu;
+DROP LANGUAGE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst60.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst60.ans b/src/test/feature/Ranger/ans/adminfirst60.ans
new file mode 100644
index 0000000..f235f1e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst60.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+analyze a;
+ANALYZE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst61.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst61.ans b/src/test/feature/Ranger/ans/adminfirst61.ans
new file mode 100644
index 0000000..36b8749
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst61.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+analyze;
+ANALYZE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst62.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst62.ans b/src/test/feature/Ranger/ans/adminfirst62.ans
new file mode 100644
index 0000000..3281aef
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst62.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+vacuum aa;
+VACUUM
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst63.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst63.ans b/src/test/feature/Ranger/ans/adminfirst63.ans
new file mode 100644
index 0000000..15dac5d
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst63.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+vacuum analyze;
+VACUUM
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst64.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst64.ans b/src/test/feature/Ranger/ans/adminfirst64.ans
new file mode 100644
index 0000000..7565e97
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst64.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+truncate aa;
+TRUNCATE TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst65.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst65.ans b/src/test/feature/Ranger/ans/adminfirst65.ans
new file mode 100644
index 0000000..1f19c46
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst65.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+alter table a rename column i to j;
+ALTER TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst66.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst66.ans b/src/test/feature/Ranger/ans/adminfirst66.ans
new file mode 100644
index 0000000..6779298
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst66.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop SEQUENCE myseq;
+DROP SEQUENCE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst67.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst67.ans b/src/test/feature/Ranger/ans/adminfirst67.ans
new file mode 100644
index 0000000..7b67364
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst67.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop view av;
+DROP VIEW
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst68.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst68.ans b/src/test/feature/Ranger/ans/adminfirst68.ans
new file mode 100644
index 0000000..071be2a
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst68.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop table aaa;
+DROP TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst69.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst69.ans b/src/test/feature/Ranger/ans/adminfirst69.ans
new file mode 100644
index 0000000..e203c88
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst69.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop table aa;
+DROP TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst7.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst7.ans b/src/test/feature/Ranger/ans/adminfirst7.ans
new file mode 100644
index 0000000..5026d33
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst7.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OR REPLACE FUNCTION normalize_si(text) RETURNS text AS $$ BEGIN RETURN substring($1, 9, 2) || substring($1, 7, 2) || substring($1, 5, 2) || substring($1, 1, 4); END; $$LANGUAGE 'plpgsql' IMMUTABLE;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst70.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst70.ans b/src/test/feature/Ranger/ans/adminfirst70.ans
new file mode 100644
index 0000000..e7fbc71
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst70.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop table a;
+DROP TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst71.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst71.ans b/src/test/feature/Ranger/ans/adminfirst71.ans
new file mode 100644
index 0000000..a9779cf
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst71.ans
@@ -0,0 +1,5 @@
+-- start_ignore
+-- end_ignore
+drop schema sa CASCADE;
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: NOTICE: drop cascades to append only table sa.t
+DROP SCHEMA
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst8.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst8.ans b/src/test/feature/Ranger/ans/adminfirst8.ans
new file mode 100644
index 0000000..03712a3
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst8.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OR REPLACE FUNCTION si_lt(text, text) RETURNS boolean AS $$ BEGIN RETURN normalize_si($1) < normalize_si($2); END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminfirst9.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminfirst9.ans b/src/test/feature/Ranger/ans/adminfirst9.ans
new file mode 100644
index 0000000..b2aaca8
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminfirst9.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OPERATOR <# ( PROCEDURE=si_lt,LEFTARG=text, RIGHTARG=text);
+CREATE OPERATOR
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond1.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond1.ans b/src/test/feature/Ranger/ans/adminsecond1.ans
new file mode 100644
index 0000000..64c6082
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond1.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create table a(i int);
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: ERROR: relation "a" already exists
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond10.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond10.ans b/src/test/feature/Ranger/ans/adminsecond10.ans
new file mode 100644
index 0000000..ca24909
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond10.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OR REPLACE FUNCTION si_same(text, text) RETURNS int AS $$ BEGIN IF normalize_si($1) < normalize_si($2) THEN RETURN -1; END IF; END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond11.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond11.ans b/src/test/feature/Ranger/ans/adminsecond11.ans
new file mode 100644
index 0000000..1a5787c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond11.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OPERATOR CLASS sva_special_ops FOR TYPE text USING btree AS OPERATOR 1 <#, FUNCTION 1 si_same(text, text);
+CREATE OPERATOR CLASS
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond12.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond12.ans b/src/test/feature/Ranger/ans/adminsecond12.ans
new file mode 100644
index 0000000..2ec6c82
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond12.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop OPERATOR CLASS sva_special_ops USING btree;
+DROP OPERATOR CLASS
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond13.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond13.ans b/src/test/feature/Ranger/ans/adminsecond13.ans
new file mode 100644
index 0000000..e5b435e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond13.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop OPERATOR <# (text,text) CASCADE;
+DROP OPERATOR
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond14.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond14.ans b/src/test/feature/Ranger/ans/adminsecond14.ans
new file mode 100644
index 0000000..150db1e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond14.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop FUNCTION si_same(text, text);
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond15.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond15.ans b/src/test/feature/Ranger/ans/adminsecond15.ans
new file mode 100644
index 0000000..56708c6
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond15.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop FUNCTION si_lt(text, text);
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond16.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond16.ans b/src/test/feature/Ranger/ans/adminsecond16.ans
new file mode 100644
index 0000000..2f4e41c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond16.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop FUNCTION normalize_si(text);
+DROP FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond17.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond17.ans b/src/test/feature/Ranger/ans/adminsecond17.ans
new file mode 100644
index 0000000..78b7091
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond17.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE RESOURCE QUEUE myqueue WITH (PARENT='pg_root', ACTIVE_STATEMENTS=20, MEMORY_LIMIT_CLUSTER=50%, CORE_LIMIT_CLUSTER=50%);
+CREATE QUEUE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond18.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond18.ans b/src/test/feature/Ranger/ans/adminsecond18.ans
new file mode 100644
index 0000000..c0721f9
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond18.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+DROP RESOURCE QUEUE myqueue;
+DROP QUEUE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond19.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond19.ans b/src/test/feature/Ranger/ans/adminsecond19.ans
new file mode 100644
index 0000000..91ced40
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond19.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE TABLESPACE mytblspace FILESPACE dfs_system;
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: ERROR: tablespace "mytblspace" already exists
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond2.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond2.ans b/src/test/feature/Ranger/ans/adminsecond2.ans
new file mode 100644
index 0000000..3c74a36
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond2.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+create language plpythonu;
+CREATE LANGUAGE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond20.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond20.ans b/src/test/feature/Ranger/ans/adminsecond20.ans
new file mode 100644
index 0000000..4c27ee0
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond20.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE TABLE foo(i int) TABLESPACE mytblspace;
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: ERROR: relation "foo" already exists
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond21.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond21.ans b/src/test/feature/Ranger/ans/adminsecond21.ans
new file mode 100644
index 0000000..ee188ab
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond21.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+insert into foo(i) values(1234);
+INSERT 0 1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond22.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond22.ans b/src/test/feature/Ranger/ans/adminsecond22.ans
new file mode 100644
index 0000000..b6a0d25
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond22.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop table foo;
+DROP TABLE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond23.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond23.ans b/src/test/feature/Ranger/ans/adminsecond23.ans
new file mode 100644
index 0000000..30a0e21
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond23.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop tablespace mytblspace;
+DROP TABLESPACE
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond24.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond24.ans b/src/test/feature/Ranger/ans/adminsecond24.ans
new file mode 100644
index 0000000..2fc5625
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond24.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+COPY a FROM '/tmp/a.txt';
+COPY 2
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond25.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond25.ans b/src/test/feature/Ranger/ans/adminsecond25.ans
new file mode 100644
index 0000000..08e29ae
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond25.ans
@@ -0,0 +1,13 @@
+-- start_ignore
+-- end_ignore
+COPY a TO STDOUT WITH DELIMITER '|';
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond26.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond26.ans b/src/test/feature/Ranger/ans/adminsecond26.ans
new file mode 100644
index 0000000..ca1d242
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond26.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE EXTERNAL TABLE ext_t ( N_NATIONKEY INTEGER ,N_NAME CHAR(25), N_REGIONKEY INTEGER ,N_COMMENT VARCHAR(152))location ('gpfdist://localhost:7070/nation_error50.tbl')FORMAT 'text' (delimiter '|')SEGMENT REJECT LIMIT 51;
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: ERROR: relation "ext_t" already exists
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond27.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond27.ans b/src/test/feature/Ranger/ans/adminsecond27.ans
new file mode 100644
index 0000000..842a8b6
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond27.ans
@@ -0,0 +1,29 @@
+-- start_ignore
+-- end_ignore
+select * from ext_t order by N_NATIONKEY;
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: NOTICE: Found 50 data formatting errors (50 or more input rows). Rejected related input data.
+0|ALGERIA |0| haggle. carefully final deposits detect slyly agai
+1|ARGENTINA |1|al foxes promise slyly according to the regular accounts. bold requests alon
+2|BRAZIL |1|y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special
+3|CANADA |1|eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
+4|EGYPT |4|y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
+5|ETHIOPIA |0|ven packages wake quickly. regu
+6|FRANCE |3|refully final requests. regular, ironi
+7|GERMANY |3|l platelets. regular accounts x-ray: unusual, regular acco
+8|INDIA |2|ss excuses cajole slyly across the packages. deposits print aroun
+9|INDONESIA |2| slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
+10|IRAN |4|efully alongside of the slyly final dependencies.
+11|IRAQ |4|nic deposits boost atop the quickly final requests? quickly regula
+12|JAPAN |2|ously. final, express gifts cajole a
+13|JORDAN |4|ic deposits are blithely about the carefully regular pa
+14|KENYA |0| pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
+15|MOROCCO |0|rns. blithely bold courts among the closely regular packages use furiously bold platelets?
+16|MOZAMBIQUE |0|s. ironic, unusual asymptotes wake blithely r
+17|PERU |1|platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
+18|CHINA |2|c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
+19|ROMANIA |3|ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
+20|SAUDI ARABIA |4|ts. silent requests haggle. closely express packages sleep across the blithely
+21|VIETNAM |2|hely enticingly express accounts. even, final
+22|RUSSIA |3| requests against the platelets use never according to the quickly regular pint
+23|UNITED KINGDOM |3|eans boost carefully special requests. accounts are. carefull
+24|UNITED STATES |1|y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond28.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond28.ans b/src/test/feature/Ranger/ans/adminsecond28.ans
new file mode 100644
index 0000000..6ccf0e7
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond28.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE WRITABLE EXTERNAL TABLE ext_t2 (i int) LOCATION ('gpfdist://localhost:7070/ranger2.out') FORMAT 'TEXT' ( DELIMITER '|' NULL ' ');
+psql:/tmp/TestHawqRanger_BasicTest.sql:3: ERROR: relation "ext_t2" already exists
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond29.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond29.ans b/src/test/feature/Ranger/ans/adminsecond29.ans
new file mode 100644
index 0000000..3d0587f
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond29.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+insert into ext_t2(i) values(234);
+INSERT 0 1
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond3.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond3.ans b/src/test/feature/Ranger/ans/adminsecond3.ans
new file mode 100644
index 0000000..d0b2353
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond3.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+CREATE FUNCTION
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/adminsecond30.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/adminsecond30.ans b/src/test/feature/Ranger/ans/adminsecond30.ans
new file mode 100644
index 0000000..278ff6c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/adminsecond30.ans
@@ -0,0 +1,4 @@
+-- start_ignore
+-- end_ignore
+drop EXTERNAL TABLE ext_t;
+DROP EXTERNAL TABLE