GitHub user gmitter-ef edited a comment on the discussion: Automatic case
change for column names
We already had these issues and investigated a little (status of 2.12, I do not
know if it's still the same):
- using SELECT ID as "myid" (instead of SELECT ID as myid) does the trick! So
use double quotes around the alias, then there is no need for a "Select values"
transform
- The "Force all identifiers to lower case" in the "Advanced" tab has no
effect, neither in native nor in JDBC Oracle connections (why? docu does not
say anything about this checkbox)
- native and JDBC connections behave the same in all tested respects
- all Script transforms ("JavaScript", "Script" with Python, "User Defined Java
Expression") are case sensitive ==> you must provide the correct case of the
field when reading the field
- other transforms ("Write to log", "Select values", "Concat") are case
insensitive, you can chose the "wrong" case, still everything works
- first tab of "Select values" transform is case insensitive
- metadata tab of "Select values" transform is case sensitive in the respect
that it makes a difference for subsequent Script transforms
GitHub link:
https://github.com/apache/hop/discussions/5429#discussioncomment-13527078
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
