Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Custom query validation throwing error with sql files ending with semicolon(;) #565

Closed
Raniksingh opened this issue Aug 23, 2022 · 0 comments
Assignees

Comments

@Raniksingh
Copy link
Contributor

Raniksingh commented Aug 23, 2022

If the source and target files that is being passed for custom query validation has ; in it, the validation fails.

Example : source.sql file --- select * from db.table1; fails
Whereas source.sql file --- select * from db.table1 runs fine.

File "/Users/ranisingh/Documents/DVT/professional-services-data-validator/env/lib/python3.7/site-packages/teradatasql/init.py", line 933, in executemany
raise OperationalError (sErr)
teradatasql.OperationalError: [Version 17.20.0.1] [Session 1318] [Teradata Database] [Error 3707] Syntax error, expected something like an 'EXCEPT' keyword or an 'UNION' keyword or a 'MINUS' keyword between the word 'DEPARTMENT' and ';'.
at gosqldriver/teradatasql.formatError ErrorUtil.go:88

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants