[teiid-issues] [JBoss JIRA] (TEIID-5585) Insert of a disk backed temporary lob into a temp table is un-readable

[Steven Hawkins (Jira)]

Steven Hawkins created TEIID-5585:
-------------------------------------

             Summary: Insert of a disk backed temporary lob into a temp table is un-readable
                 Key: TEIID-5585
                 URL: https://issues.jboss.org/browse/TEIID-5585
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 12.0


This can be reproduced with a script like:

insert into #temp select 1 as x, cast(repeat('1', 4000) as clob) y;
insert into #temp select 2, concat((select y from #temp where x = 1), (select y from #temp where x = 1));
insert into #temp select 3, concat((select y from #temp where x = 2), (select y from #temp where x = 2));
insert into #temp select 4, concat((select y from #temp where x = 3), (select y from #temp where x = 3));
-- will fail
insert into #temp select 5, concat((select y from #temp where x = 4), (select y from #temp where x = 4));

The #4 clob is unreadable as the backing filestore is removed after insert.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)