[
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)
