awslabs / awslabs/amazon-redshift-utils

v_generate_tbl_ddl : Invalid operation: value too long for type character varying(798)

Open
#647 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.