Skip to content
This repository has been archived by the owner on Sep 26, 2023. It is now read-only.

Truncate long VARCHAR fields before casting #126

Closed
chuwy opened this issue Oct 1, 2020 · 0 comments
Closed

Truncate long VARCHAR fields before casting #126

chuwy opened this issue Oct 1, 2020 · 0 comments
Labels
bug
Milestone
0.8.0

Comments

@chuwy
Copy link
Contributor

chuwy commented Oct 1, 2020

In #55 and #99 we made all VARCHARs trimmed like following:

substr(enriched_data:refr_urlpath::VARCHAR(6000),0,6000)

Which means that first expression executed is refr_urlpath::VARCHAR(6000), which would understandably fail if the string is longer. It seems that it needs to be changed to:

substr(enriched_data:refr_urlpath,0,6000)::VARCHAR(6000)
@chuwy chuwy added the bug label Oct 1, 2020
@chuwy chuwy added this to the 0.8.0 milestone Oct 1, 2020
chuwy added a commit that referenced this issue Oct 1, 2020
@chuwy
Truncate long VARCHAR fields before casting (close #126)
33eea4f
@chuwy chuwy closed this as completed in 4f39ed1 Oct 6, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
0.8.0
Development

No branches or pull requests
1 participant
@chuwy