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

Oracle validation fails due to reserved word COLUMN #1393

Open
nj1973 opened this issue Jan 13, 2025 · 0 comments
Open

Oracle validation fails due to reserved word COLUMN #1393

nj1973 opened this issue Jan 13, 2025 · 0 comments
Labels
type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.

Comments

@nj1973
Copy link
Contributor

nj1973 commented Jan 13, 2025

Test table:

CREATE TABLE dvt_test.dvt_reserved_words
( id number(5) primary key
, "DATE" date
, "COLUMN" NUMBER(1)
, "SELECT" NUMBER(1)
);

Test command:

$ data-validation validate column -sc ora -tc ora  --tables-list=dvt_test.dvt_reserved_words --count="*"
...
    cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-01747: invalid user.table.column, table.column, or column specification
[SQL: SELECT count(*) AS count, count(t0.id) AS count__id, count(t0."DATE") AS count__date, count(t0.column) AS count__column, count(t0."SELECT") AS count__select
FROM dvt_test.dvt_reserved_words t0]

Notice above that SELECT and DATE have been quoted but COLUMN has not.

@helensilva14 helensilva14 added the type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns. label Jan 17, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.
Projects
None yet
Development

No branches or pull requests

2 participants