HAWQ-1359. Add policy test for HAWQ with Ranger enabled. Signed-off-by: Chuling Wang <[email protected]>
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 <[email protected]> Authored: Thu Mar 2 09:53:39 2017 +0800 Committer: Chuling Wang <[email protected]> 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
