create table statement with large varchar column results in a parser error

Bug #1370081 reported by Suresh Subbiah on 2014-09-16
This bug affects 1 person
Affects Status Importance Assigned to Milestone
In Progress
Suresh Subbiah

Bug Description

create table temp2(a varchar(20) not null, b varchar(512) not null, primary key(b)) salt using 16 partitions;

*** ERROR[15001] A syntax error occurred at or before:
CAST ( _ISO88591';
                 ^ (19 characters from start of SQL statement)

This issue has been fixed in a side thread and needs to be ported. Internal clauses generated and sent to the parser and there is logic that attempts to save memory and resize if memory needed is more than 512 bytes. An error in that resize logic is causing this problem.

tags: added: sql-cmu
Paul Low (paul-low-x) on 2014-12-16
Changed in trafodion:
milestone: r1.0 → none
Paul Low (paul-low-x) on 2014-12-22
Changed in trafodion:
milestone: none → r1.1
Paul Low (paul-low-x) on 2015-04-15
Changed in trafodion:
milestone: r1.1 → r1.2
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers