[ https://issues.apache.org/jira/browse/TRAFODION-2749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall updated TRAFODION-2749: -------------------------------------------- Fix Version/s: 2.3-incubating > UPDATE STATS mc histogram failure when column has reserved word name > -------------------------------------------------------------------- > > Key: TRAFODION-2749 > URL: https://issues.apache.org/jira/browse/TRAFODION-2749 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 2.3-incubating > Environment: All > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > Fix For: 2.3-incubating > > > When UPDATE STATISTICS tries to create a multi-column histogram, and one or > more of the columns has a name which happens to be a SQL reserved word, the > command fails with a syntax error on an internal statement. > The following script reproduces the problem (here, the failure occurs when > UPDATE STATS tries to create a multi-column histogram on the two key columns): > ?section setup > create table ExampleTable > ( a smallint not null, > "YEAR" smallint not null, > primary key (a, "YEAR") ); > insert into ExampleTable values (1,1996),(2,1997),(3,1998); > ?section doit > update statistics for table ExampleTable on every column; > Below is the execution output: > >>obey repro.sql; > >>?section setup > >> > >>create table ExampleTable > +>( a smallint not null, > +> "YEAR" smallint not null, > +> primary key (a, "YEAR") ); > --- SQL operation complete. > >> > >>insert into ExampleTable values (1,1996),(2,1997),(3,1998); > --- 3 row(s) inserted. > >> > >>?section doit > >> > >>update statistics for table ExampleTable on every column; > *** ERROR[9200] UPDATE STATISTICS for table TRAFODION.SCH.EXAMPLETABLE > encountered an error (15001) from statement FETCH_BOUNDARY_ROWSET. > *** ERROR[15001] A syntax error occurred at or before: > SELECT FMTVAL, SUMVAL FROM (SELECT "A","YEAR", _ucs2'unused', COUNT(*) FROM > TRA > FODION.SCH.EXAMPLETABLE <<+ cardinality 3.000000e+00 >> GROUP BY A, YEAR FOR > R > EAD UNCOMMITTED ACCESS) T(A, YEAR, FMTVAL, SUMVAL); > ^ (162 characters from start of SQL statement) > *** ERROR[8822] The statement was not prepared. > --- SQL operation failed with errors. > >> > >> -- This message was sent by Atlassian JIRA (v6.4.14#64029)