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.

Sign up for GitHub

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

Jump to bottom

[Bug]: Dimension Lookup/Update transform is not quoting fields per the connection setting. #2182

Closed
usbrandon opened this issue Jan 23, 2023 · 0 comments
Closed

[Bug]: Dimension Lookup/Update transform is not quoting fields per the connection setting. #2182

usbrandon opened this issue Jan 23, 2023 · 0 comments
Assignees
@nadment
Labels
bug P2 Default Priority Transforms
Milestone
2.3

Comments

@usbrandon
Copy link
Contributor

Apache Hop version?

2.3

Java version?

11

Operating system

Linux

What happened?

We use Postgres and have "Quote all identifiers in database" checked. The "Key Tab" on the Dimension lookup\update transform is failing to put quotes around the "Dimension field". Postgres automatically lowercases any field names that are not surrounded by double quotes.

image

Issue Priority

Priority: 2

Issue Component

Component: Transforms
@github-actions github-actions bot added P2 Default Priority Transforms labels Jan 23, 2023
@nadment nadment self-assigned this Jan 23, 2023
nadment added a commit to nadment/hop that referenced this issue Jan 23, 2023
@nadment
Dimension Lookup transform is not quoting fields per the connection
21242de 
setting apache#2182
hansva added a commit that referenced this issue Jan 23, 2023
@hansva
Merge pull request #2183 from nadment/2182
95d7dd3 
Fix Dimension Lookup transform #2182 #2184
@hansva hansva closed this as completed Jan 23, 2023
@hansva hansva added this to the 2.3 milestone Jan 23, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@nadment nadment

Labels
bug P2 Default Priority Transforms
Projects
None yet
Milestone
2.3
Development

No branches or pull requests
3 participants
@hansva @usbrandon @nadment