David Wayne Birdsall created TRAFODION-2255:
-----------------------------------------------
Summary: Regression test compGeneral/TEST023 failure
Key: TRAFODION-2255
URL: https://issues.apache.org/jira/browse/TRAFODION-2255
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.1-incubating
Environment: All
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
Regression test compGeneral/TEST023 has started failing with the following
differences:
313c313,321
< --- SQL operation complete.
---
> *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (3047) from
> statement .
>
> *** ERROR[3047] The timestamp '2016-010-01 08:21:54' is not valid.
>
> *** ERROR[8822] The statement was not prepared.
>
> *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STEST encountered an error from
> statement updIUSUpdateInfo.
>
> --- SQL operation failed with errors.
320c328
< STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn I c1
>= 100000
---
> STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn I
364c372,380
< --- SQL operation complete.
---
> *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STESTC encountered an error (3047) from
> statement .
>
> *** ERROR[3047] The timestamp '2016-010-01 08:22:04' is not valid.
>
> *** ERROR[8822] The statement was not prepared.
>
> *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STESTC encountered an error from
> statement updIUSUpdateInfo.
>
> --- SQL operation failed with errors.
387c403
< STESTC TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn I c1
>= 'naaaa'
---
> STESTC TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn
> I
476c492
< *** ERROR[9200] UPDATE STATISTICS for table
TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (15001) from
statement HSCursor::prepareRowsetInternal().
---
> *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (3047) from
> statement .
478,481c494
< *** ERROR[15001] A syntax error occurred at or before:
< SELECT "C1", "C2", "C3", "_SALT_" FROM
TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPL
< E_nn_nnnnnnnnnn_nnnnnn WHERE 1 FOR READ UNCOMMITTED ACCESS; < ^ (zzz
characters from start of SQL statement)
---
> *** ERROR[3047] The timestamp '2016-010-01 08:22:19' is not valid.
485,492c498
< *** ERROR[9200] UPDATE STATISTICS for table
TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (15001) from
statement POPULATE_FROM_QUERY.
<
< *** ERROR[15001] A syntax error occurred at or before:
< SELECT "C1", "C2", "C3", "_SALT_" FROM
TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPL
< E_nn_nnnnnnnnnn_nnnnnn WHERE 1 FOR READ UNCOMMITTED ACCESS; < ^ (zzz
characters from start of SQL statement) < < *** ERROR[8822] The statement
was not prepared.
---
> *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STEST encountered an error from
> statement updIUSUpdateInfo.
First suspicion is that it is a bug in formatting a timestamp literal. Note
that we just transitioned into October, a two-digit month.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
