You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2015/12/02 22:51:10 UTC
[jira] [Resolved] (TRAFODION-1272) LP Bug: 1464364 - Update stats
on tables in schemas with delimited names fail with syntax error
[ https://issues.apache.org/jira/browse/TRAFODION-1272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall resolved TRAFODION-1272.
---------------------------------------------
Resolution: Fixed
Fix Version/s: (was: 2.0-incubating)
1.3-incubating
I submitted a fix for this just before the project went into Apache incubation. So the fix should be in Release 1.3. I have verified that the bug no longer occurs.
> LP Bug: 1464364 - Update stats on tables in schemas with delimited names fail with syntax error
> -----------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1272
> URL: https://issues.apache.org/jira/browse/TRAFODION-1272
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Aruna Sadashiva
> Assignee: David Wayne Birdsall
> Priority: Critical
> Fix For: 1.3-incubating
>
>
> Select queries on repository tables returned warnings about stats not updated, so I tried running update stats and it fails with the errors below.
> [trafodion@n007 ~]$ sqid
> MY_SQROOT=/opt/home/trafodion/trafodion-20150604
> who@host=trafodion@amber-hn1
> JAVA_HOME=/usr/java/jdk1.7.0_75
> linux=2.6.32-279.el6.x86_64
> redhat=6.3
> Release 1.2.0 (Build release [1.1.0rc1-142-ge1edc95_Bld478], branch e1edc95-master, date 20150604_083001)
> [trafodion@n007 ~]$ sqlci
> Trafodion Conversational Interface 1.2.0
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>set schema "_REPOS_";
> --- SQL operation complete.
> >>update statistics for table metric_query_table on every column;
> *** ERROR[9200] UPDATE STATISTICS for table TRAFODION._REPOS_.METRIC_QUERY_TABLE encountered an error (8605) from statement Process_Query.
> *** ERROR[8605] Committing a transaction which has not started.
> *** ERROR[9200] UPDATE STATISTICS for table TRAFODION._REPOS_.METRIC_QUERY_TABLE encountered an error (15001) from statement .
> *** ERROR[15001] A syntax error occurred at or before:
> TABLE ;
> ^ (7 characters from start of SQL statement)
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
> >>update statistics for table metric_query_aggr_table on every column;
> *** ERROR[9200] UPDATE STATISTICS for table TRAFODION._REPOS_.METRIC_QUERY_AGGR_TABLE encountered an error (8605) from statement Process_Query.
> *** ERROR[8605] Committing a transaction which has not started.
> *** ERROR[9200] UPDATE STATISTICS for table TRAFODION._REPOS_.METRIC_QUERY_AGGR_TABLE encountered an error (15001) from statement .
> *** ERROR[15001] A syntax error occurred at or before:
> TABLE ;
> ^ (7 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.3.4#6332)