1951723 - SELECT INTO query fails with error 15422, "cannot be executed because there is no default encryption key", even though encryption has not been enabled - SAP ASE

• SELECT INTO query fails with ASE error 15422:

Msg 15422, Level 16, State 3:
Server 'SYBASE', Line 4:
The 'SELECT INTO' command cannot be executed because there is no default encryption key in database tempdb. Use a named key or contact a user with System Security Officer (SSO) role for help.

• This occurs even though encryption is not enabled:

sp_configure 'enable encrypted'
Parameter Name                 Default              Memory Used
           Config Value         Run Value            Unit               
           Type                
------------------------------ -------------------- -----------
           -------------------- -------------------- --------------------
           --------------------
enable encrypted columns                 0                    2
                      0                    0         switch             
           dynamic

• The query involved is of the form:

declare @var1 varchar(4)
declare @var2 varchar(5)
select @var1 = b, @var2 = c
into #temp
from test.dbo.ldd
where a = 1

SAP Adaptive Server Enterprise (ASE) 15.7

encryption, error 15422 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed