hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hubertzh...@apache.org
Subject [6/6] incubator-hawq git commit: HAWQ-1359. Add policy test for HAWQ with Ranger enabled.
Date Thu, 02 Mar 2017 01:55:10 GMT
HAWQ-1359. Add policy test for HAWQ with Ranger enabled.

Signed-off-by: Chuling Wang <wangchunling14@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 <hubertzhang@apache.org>
Authored: Thu Mar 2 09:53:39 2017 +0800
Committer: Chuling Wang <wangchunling14@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



Mime
View raw message