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

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)