[jira] [Created] (TRAFODION-1272) LP Bug: 1464364 - Update stats on tables in schemas with delimited names fail with syntax error

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1272:
-------------------------------------

             Summary: 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: 2.0-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)