You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Sandhya Sundaresan (JIRA)" <ji...@apache.org> on 2018/09/05 21:24:00 UTC
[jira] [Closed] (TRAFODION-1599) LOB: select LOB columns with
sample returns illegible output
[ https://issues.apache.org/jira/browse/TRAFODION-1599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sandhya Sundaresan closed TRAFODION-1599.
-----------------------------------------
> LOB: select LOB columns with sample returns illegible output
> ------------------------------------------------------------
>
> Key: TRAFODION-1599
> URL: https://issues.apache.org/jira/browse/TRAFODION-1599
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 1.2-incubating
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Priority: Major
>
> As shown in the following execution output, several select statements with various sample options caused the output of LOB columns to become illegible. Since the length of column has also expanded, presumably the character set returned by these select statements has deviated from the original character set.
> >>control query default TRAF_BLOB_AS_VARCHAR 'OFF';
> --- SQL operation complete.
> >>control query default TRAF_CLOB_AS_VARCHAR 'OFF';
> --- SQL operation complete.
> >>
> >>create schema mytest10;
> --- SQL operation complete.
> >>set schema mytest10;
> --- SQL operation complete.
> >>
> >>create table t (c1 blob, c2 clob);
> --- SQL operation complete.
> >>insert into table t values (stringtolob('row 1 column 1'), stringtolob('row 1 column 2'));
> --- 1 row(s) inserted.
> >>insert into table t values (stringtolob('row 2 column 1'), stringtolob('row 2 column 2'));
> --- 1 row(s) inserted.
> >>select * from t;
> C1 C2
> ---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
> LOBH00000200010565209708741798677119604728795474301620418212311687530649329022"TRAFODION"."MYTEST10" LOBH00000200020565209708741798677119604728795474537648518212311687533192794022"TRAFODION"."MYTEST10"
> LOBH00000200010565209708741798677119604728795474799161218212311687535804902022"TRAFODION"."MYTEST10" LOBH00000200020565209708741798677119604728795475040874518212311687538191506022"TRAFODION"."MYTEST10"
> --- 2 row(s) selected.
> >>select * from t sample first 1 rows;
> C1 C2
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Ӯ▒▒ZHpN
> ▒▒▒ZH▒S▒▒▒ZH▒"TRAFODION"."MYTEST10" Ӯ▒▒ZHpN▒▒ZH▒SZf▒ZH▒"TRAFODION"."MYTEST10"▒▒▒▒
> --- 1 row(s) selected.
> >>select * from t sample periodic 1 rows every 2 rows;
> C1 C2
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Ӯ▒▒ZHpN
> ▒▒▒ZH▒S▒▒▒ZH▒"TRAFODION"."MYTEST10" Ӯ▒▒ZHpN▒▒ZH▒SZf▒ZH▒"TRAFODION"."MYTEST10"▒▒▒▒
> --- 1 row(s) selected.
> >>select * from t sample random 50 percent;
> C1 C2
> ---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
> LOBH00000200010565209708741798677119604728795474799161218212311687535804902022"TRAFODION"."MYTEST10" LOBH00000200020565209708741798677119604728795475040874518212311687538191506022"TRAFODION"."MYTEST10"
> --- 1 row(s) selected.
> >>drop table t cascade;
> --- SQL operation complete.
> >>
> >>drop schema mytest10 cascade;
> --- SQL operation complete.
> >>
> >>
> >>exit;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)