gluent / goe

GOE: a simple and flexible way to copy data from an Oracle Database to Google BigQuery.
Apache License 2.0
8 stars 2 forks source link

Numeric synthetic partition expression issue due to parameterized types #74

Open nj1973 opened 8 months ago

nj1973 commented 8 months ago

There is an issue in GOEs NUMERIC synthetic partition expressions due to the implementation of parameterized types.

Two tests are failing and have been disabled:

pytest tests/integration/offload/test_backend_table.py -k test_synthetic_part_number_decimal_18_expressions
pytest tests/integration/offload/test_backend_table.py -k test_synthetic_part_number_decimal_18_9_expressions

We need to fix the issue and then enable the tests.

Example output from one of the tests:

E   AssertionError: False is not true : Exception casting input number: (<class 'float'>) 12391.6
E   Cast: CAST(FLOOR(CAST(CAST(12391.6 AS NUMERIC(18,9)) AS BIGNUMERIC) / 1000) * 1000 AS INT64)
E   Exception: 400 Parameterized types are not allowed in CAST expressions.