interesting question from a current Vertica customer: when i execute
vsql -f nonexistentfile.sql
the vsql proces returns a zero RC, indicating all is well, while trying to execute a non-existent SQL file can be perceived as an error. Is there a (relatively easy) way to have vsql flag this error to the calling script?
howto make vsql return a non-zero RC when error in SQL file name?
[skeswani@skeswani vertica] [@:/]$ function v() { if [ -e "${1}" ];then vsql -X -v ON_ERROR_STOP=1 -f "${1}" ;else return 1; fi }; v file.sql
[skeswani@skeswani vertica] [@:/]$ echo $?
1
I think this is a bug, it shouldn't return 0.
agreed, VER-40945
Agreed and thanks very much!
Sumeet, thank you for the workaround....
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
