FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 or 2016

Symptoms

Assume that you use the CONTEXT_INFO system function in SQL Server 2014 or 2016. When you assign a hexadecimal value that ends with trailing zeros to context_info, every combination of two trailing zeros ('00') is truncated. Therefore, when you retrieve the context_info value by using the CONTEXT_INFO function, wrong values are returned.

Resolution

The issue was fixed in the following cumulative updates of SQL Server: 
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properti

ID Artikel: 3168710 - Tinjauan Terakhir: 22 Sep 2016 - Revisi: 1

Tanggapan