[jira] [Created] (TRAFODION-709) LP Bug: 1384360 - setting the attribute DEFAULT_CHARSET to UTF8 produces wrong results for metadata queries

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

Alice Chen created TRAFODION-709:
------------------------------------

             Summary: LP Bug: 1384360 - setting the attribute DEFAULT_CHARSET to UTF8 produces wrong results for metadata queries
                 Key: TRAFODION-709
                 URL: https://issues.apache.org/jira/browse/TRAFODION-709
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Suresh Subbiah
            Assignee: Anoop Sharma
            Priority: Critical


Steps to reproduce

>From sqlci

insert into "_MD_".defaults values('DEFAULT_CHARSET', 'UTF8', 'inserted by jerry') ;
exit ;

>From another sqlci session

set schema "_MD_" ;
get tables ;

The "get tables" command returns 0 rows, while it should return a dozen or so rows with all metadata tables. This problem is not sen if a cqd was used to specify the DEFAULT_CHARSET attribute, but that could be due to a query cache issue.

I am placing this bug to have a critical priority since we have PoCs interested in using this attribute.



Output seen in 0.9.0 build. The last line (with command "get tables") shows the wrong result.

[ssubbiah@g4t3017 scripts]$ sqlci
Trafodion Conversational Interface 0.9.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>insert into "_MD_".defaults values('DEFAULT_CHARSET', 'UTF8', 'inserted by jerry') ;

set schema "_MD_" ;

get tables ;
--- 1 row(s) inserted.
>>>>
--- SQL operation complete.
>>>>

Tables in Schema TRAFODION._MD_
===============================

AUTHS
COLUMNS
DEFAULTS
INDEXES
KEYS
LIBRARIES
LIBRARIES_USAGE
OBJECTS
REF_CONSTRAINTS
ROUTINES
SEQ_GEN
TABLES
TABLE_CONSTRAINTS
TEXT
UNIQUE_REF_CONSTR_USAGE
VERSIONS
VIEWS
VIEWS_USAGE

--- SQL operation complete.
>>cqd query_cache '0' ;

--- SQL operation complete.
>>get tables ;

Tables in Schema TRAFODION._MD_
===============================

AUTHS
COLUMNS
DEFAULTS
INDEXES
KEYS
LIBRARIES
LIBRARIES_USAGE
OBJECTS
REF_CONSTRAINTS
ROUTINES
SEQ_GEN
TABLES
TABLE_CONSTRAINTS
TEXT
UNIQUE_REF_CONSTR_USAGE
VERSIONS
VIEWS
VIEWS_USAGE

--- SQL operation complete.
>>exit ;

End of MXCI Session

[ssubbiah@g4t3017 scripts]$ sqlci
Trafodion Conversational Interface 0.9.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>set schema "_MD_" ;

--- SQL operation complete.
>>get tables ;

--- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)