awslabs / awslabs/amazon-redshift-utils
v_generate_tbl_ddl : Invalid operation: value too long for type character varying(798)
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
I am getting similar error. Error screenshot: https://i.imgur.com/CglvPh1.png
SQL Statement:
select ddl
from admin.v_generate_tbl_ddl
where schemaname = 'schema_name_goes_here';
Contributor guide
Research direction
Locate the definition of admin.v_generate_tbl_ddl and reproduce the reported query against a schema whose generated DDL exceeds the stated limit. Inspect how the ddl value is constructed and identify the intended behavior for longer results; done means the query returns complete DDL without the varchar-length error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100