2093416 - Temporary tables return NULL value in subsequent SELECT - SAP ASE

• Temporary tables return the NULL value in a subsequent SELECT, for example: 

create table #t1 (ticket char(8))
insert into #t1 values ('testvalue')
select * from #t1

returns:
 
   ticket 
   -------- 
   testvalue

declare @ticket CHAR(8)
select @ticket = ticket from #t1
select @ticket

returns:
 
    -------- 
    testvalue

drop table #t1
create table #t1 (ticket char(8))
insert into #t1 values ('testvalue')
declare @ticket CHAR(8)
select @ticket = ticket from #t1
select @ticket 

returns:
 
   --------
   NULL

• This occurs only when the value from the column is assigned to a SQL variable.

• SAP Adaptive Server Enterprise (ASE) 15.0.3
• SAP Adaptive Server Enterprise (ASE) 15.5
• SAP Adaptive Server Enterprise (ASE) 15.7

686209, CR686209, statement cache , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed