[jira] [Resolved] (TRAFODION-857) LP Bug: 1408148 - Select literal causes the next select empty string to return junk

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah resolved TRAFODION-857.
--------------------------------------
    Resolution: Fixed

> LP Bug: 1408148 - Select literal causes the next select empty string to return junk
> -----------------------------------------------------------------------------------
>
>                 Key: TRAFODION-857
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-857
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Weishiun Tsai
>            Assignee: Howard Qin
>            Priority: Blocker
>             Fix For: 1.0 (pre-incubation)
>
>
> As shown in the following example.  The 1st query selects a literal with 10 characters.  It causes the 2nd query, which selects '', to return rows with junk.   It only happens when the 2 queries are executed together.  The problem seems to go away if the 1st query is commented out.
> This is seen on the v0105_0830 build installed on a cluster.  As the nature of junk result often is, it can’t be reproduced 100%, but it does occur often enough.  It is likely to be a regression introduced sometime between the v1218_0830 daily build and the v0105_0830 daily build.
> ---------------------------
> Here is the entire script to reproduce it:
> create schema mytest;
> set schema mytest;
> create table t (a int);
> insert into t values (1),(2);
> select '0123456789' from t;
> select '' from t;
> drop schema mytest cascade;
> ---------------------------
> Here is the execution output:
> [trafodion@n009 bin]$ sqlci
> Trafodion Conversational Interface 0.9.1
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>obey mytest.sql;
> >>create schema mytest;
> --- SQL operation complete.
> >>set schema mytest;
> --- SQL operation complete.
> >>create table t (a int);
> --- SQL operation complete.
> >>insert into t values (1),(2);
> --- 2 row(s) inserted.
> >>select '0123456789' from t;
> (EXPR)
> ----------
> 0123456789
> 0123456789
> --- 2 row(s) selected.
> >>select '' from t;
> (EXPR)
> ----------
> 23456789
> 23456789
> --- 2 row(s) selected.
> >>drop schema mytest cascade;
> --- SQL operation complete.
> ---------------------------
> Here is the execution output showing that if the 1st query is commented out, the 2nd query returns correct empty strings.
> [trafodion@n009 bin]$ sqlci
> Trafodion Conversational Interface 0.9.1
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>obey mytest.sql;
> >>create schema mytest;
> --- SQL operation complete.
> >>set schema mytest;
> --- SQL operation complete.
> >>create table t (a int);
> --- SQL operation complete.
> >>insert into t values (1),(2);
> --- 2 row(s) inserted.
> >>-- select '0123456789' from t;
> >>select '' from t;
> (EXPR)
> ------
> --- 2 row(s) selected.
> >>drop schema mytest cascade;
> --- SQL operation complete.



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