[jira] [Commented] (TRAFODION-2819) Drop table fails with error 4247 when certain CQDs are set

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16267613#comment-16267613 ] 

ASF GitHub Bot commented on TRAFODION-2819:
-------------------------------------------

GitHub user DaveBirdsall opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/1312

    [TRAFODION-2819] Fix 4247 error on drop table when certain CQDs are present

    When CQD TRAF_MAX_CHARACTER_COL_LENGTH is set to a value lower than '500', then DROP TABLE will fail when it tries to do a DELETE under the covers on the SB_HISTOGRAMS table. The latter fails with error 4247, raised in CmpSeabaseDDL::getColInfo (sqlcomp/CmpSeabaseDDLcommon.cpp).
    
    The fix is to change CmpSeabaseDDL::getColInfo to exempt metadata, histogram and repository tables from the maximum column length check.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion2819

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/1312.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1312
    
----
commit d96f3c7c136eab380acbd3f481ff1f738e16306d
Author: Dave Birdsall <db...@apache.org>
Date:   2017-11-27T21:35:35Z

    [TRAFODION-2819] Fix 4247 error on drop table when certain CQDs are present

----


> Drop table fails with error 4247 when certain CQDs are set
> ----------------------------------------------------------
>
>                 Key: TRAFODION-2819
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2819
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.3-incubating
>            Reporter: David Wayne Birdsall
>            Assignee: David Wayne Birdsall
>
> Drop table fails with error 4247 in the following scenario:
> >>cqd HIVE_MAX_STRING_LENGTH_IN_BYTES '200';
> --- SQL operation complete.
> >>cqd TRAF_MAX_CHARACTER_COL_LENGTH '200';
> --- SQL operation complete.
> >>
> >>create table my_traf_line (
> +>l_orderkey int not null not droppable,
> +>l_partkey int not null not droppable,
> +>l_suppkey int not null not droppable,
> +>l_linenumber int not null not droppable,
> +>l_quantity numeric(12,2) not null not droppable,
> +>l_extendedprice numeric(12,2) not null not droppable,
> +>l_discount numeric(12,2) not null not droppable,
> +>l_tax numeric(12,2) not null not droppable,
> +>l_returnflag char(1) not null not droppable,
> +>l_linestatus char(1) not null not droppable,
> +>l_shipdate date not null not droppable,
> +>l_commitdate date not null not droppable,
> +>l_receiptdate date not null not droppable,
> +>l_shipinstruct char(25) not null not droppable,
> +>l_shipmode char(10) not null not droppable,
> +>l_comment varchar(44) not null not droppable,
> +>primary key (l_shipdate asc, l_orderkey asc, l_linenumber asc) not droppable)
> +>salt using 8 partitions;
> --- SQL operation complete.
> >>
> >>drop table my_traf_line cascade;
> *** ERROR[4247] Specified size in bytes (500) exceeds the maximum size allowed (200) for column LOW_VALUE.
> *** ERROR[4082] Object TRAFODION.SCH.SB_HISTOGRAMS does not exist or is inaccessible.
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
> >>



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)