Escaping Data for Data Types BOOLEAN / SUPER / GEOMETRY in Hash-Function

[MatheHostel]

Description

Taking correct data_type for ghost records and escaping hash-values for hashing function for data type boolean, geometry and super. These data types cannot be used in TRIM() function (in hashing-function)

Fixes #(issue)

Type of change

Please delete options that are not relevant.

• [x] Bug fix (non-breaking change which fixes an issue)
• [ ] New feature (non-breaking change which adds functionality)
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] This change requires a documentation update

How Has This Been Tested?

Configurate Hash-Columns with "is_hashdiff" with BOOLEAN / GEOMETRY / SUPER data types and create the stage. The error: function pg_catalog.btrim(boolean, "unknown") does not exist will occur.

• [ ] Tests you ran

Test Configuration:

• datavault4dbt-Version:
• dbt-Version: cloud/core, version number
• dbt-adapter-Version:

Checklist:

• [x] I have performed a self-review of my code
• [x] I have commented my code, particularly in hard-to-understand areas
• [ ] I have made corresponding changes to the documentation or included information that needs updates (e.g. in the Wiki)

[tkirschke]

Hi @MatheHostel ,

Thanks for your contribution! Can you please move your new macro "get_field_hash_by_datatype" into a new file within "macros/supporting/field_hash_by_datatype"?

Best regards Tim

[MatheHostel]

Hi @MatheHostel ,

Thanks for your contribution! Can you please move your new macro "get_field_hash_by_datatype" into a new file within "macros/supporting/field_hash_by_datatype"?

Best regards Tim

Done.

[remoteworkflow[bot]]

Link to workflow summary: https://github.com/ScalefreeCOM/datavault4dbt-ci-cd/actions/runs/10668880822

---

RESULTS for Synapse: :x: dbt-tests
:x: dbt-macro-tests

---

RESULTS for Postgres: :x: dbt-tests :x: dbt-macro-tests

---

RESULTS for BigQuery: :x: dbt-tests :x: dbt-macro-tests

---

RESULTS for Redshift: :x: dbt-tests :x: dbt-macro-tests

---

RESULTS for Snowflake: :x: dbt-tests :x: dbt-macro-tests

---

RESULTS for Exasol: :x: dbt-tests :x: dbt-macro-tests

[remoteworkflow[bot]]

Link to workflow summary: https://github.com/ScalefreeCOM/datavault4dbt-ci-cd/actions/runs/10678132620

---

RESULTS for Synapse: :white_check_mark: dbt-tests
:white_check_mark: dbt-macro-tests

---

RESULTS for Postgres: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

---

RESULTS for BigQuery: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

---

RESULTS for Redshift: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

---

RESULTS for Snowflake: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

---

RESULTS for Exasol: :x: dbt-tests :white_check_mark: dbt-macro-tests