SASHELP.VCOLUMN returns the wrong columns if filtering on MEMTYPE

CurtisMackWSIPP — Tue, 15 Dec 2020 18:20:49 GMT

If you make a query to SASHELP.VCOLUMN using a where clause including the MEMTYPE field, it returns the wrong columns associated
with the correct table. It appears to be returning the columns from the last table created.
This is a new bug in M7, as the code that failed because of this ran fine last year at this time, and a colleague ran it in M6 without problems
I have boiled it down to the very simple example included in the diagnostic step section. The first query return the wrong
information, the second works correctly. The third is a work around using like instead of equality.

SAS support has been notified and "notif(ied) R&D of this issue."

data temp.table1;
  Var_A = "Hello";
  Var_B = "There";
run;

data temp.table2;
  Var_C = "Hello";
  Var_D = "Again";
run;

proc sql;
  select libname,memname,memtype,name from sashelp.vcolumn where libname = "TEMP" and memname = "TABLE1" and memtype = 'DATA';
  select libname,memname,memtype,name from sashelp.vcolumn where libname = "TEMP" and memname = "TABLE1";
  select libname,memname,memtype,name from sashelp.vcolumn where libname = "TEMP" and memname = "TABLE1" and memtype like 'DATA%';
quit;

However, I just ran all of the latest hotfixes to fix a different bug, and it solved the problem! So the fix is in one of these hotfixes. Sorry I don't know which one, but just install them all.

I9R002	11/06/20	Issue(s) Addressed	Documentation	Download
I9R003	11/03/20	Issue(s) Addressed	Documentation	Download
I9R004	10/27/20	Issue(s) Addressed	Documentation	Download
I9R006	11/17/20	Issue(s) Addressed [ 1 ]	Documentation	Download
I9R009	11/30/20	Issue(s) Addressed	Documentation	Download
I9S001 [ C ]	11/12/20	Issue(s) Addressed	Documentation [ D ]	Download

SAS Enterprise Guide 8.3 for Windows for x64
Hot Fix	Released
I8T001	11/09/20	Issue(s) Addressed	Documentation	Download

SAS/ETS 15.2 for Windows for x64
Hot Fix	Released
J4K001	11/30/20	Issue(s) Addressed [ S ]	Documentation	Download See: 58607

SAS Add-In for Microsoft Office 8.3 for Windows for x64
Hot Fix	Released
I8U001	11/09/20	Issue(s) Addressed	Documentation	Download

SAS Middle Tier 9.4_M7 for Windows for x64
Hot Fix	Released
J2L001 [ C ]	11/11/20	Issue(s) Addressed [ S ]	Documentation [ D ]	Download See: 58607

SAS/STAT 15.2 for Windows for x64
Hot Fix	Released
I5L002 [ C ]	11/17/20	Issue(s) Addressed [ A ] [ 1 ]	Documentation	Download

Base SAS 9.4_M7 for Windows for x64
Hot Fix	Released
I8G001 [ C ]	11/16/20	Issue(s) Addressed	Documentation [ D ]	Download

SAS Threaded Kernel User Functions 9.4_M7 for Windows for x64
Hot Fix	Released
I7U001	10/22/20	Issue(s) Addressed	Documentation	Download

SAS Threaded Kernel Grid 9.4_M8 for Windows for x64
Hot Fix	Released
I8C001	10/09/20	Issue(s) Addressed	Documentation	Download

SAS Threaded Kernel Extensions for High-Performance Data Mining 15.2 for Windows for x64
Hot Fix	Released
I7I001	10/05/20	Issue(s) Addressed	Documentation	Download

SAS Threaded Kernel Extensions for Interactive Matrix Language 15.2 for Windows for x64
Hot Fix	Released
J3B001	11/30/20	Issue(s) Addressed [ A ]	Documentation	Download

Threaded Kernel Metadata Component 9.4_M7 for Windows for x64
Hot Fix	Released
J5A001	12/08/20	Issue(s) Addressed	Documentation	Download

Threaded Kernel Extensions for Operations Research and GRAPH Analytics 15.2 for Windows for x64
Hot Fix	Released
J4N001	11/25/20	Issue(s) Addressed	Documentation	Download

SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M7 for Windows for x64
Hot Fix	Released
J1F001	12/04/20	Issue(s) Addressed	Documentation	Download

SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M5 for Windows for x64
Hot Fix	Released
I9H002	11/10/20	Issue(s) Addressed	Documentation	Download

SAS Threaded Kernel 9.4_M7 for Windows for x64
Hot Fix	Released
I5V002	12/08/20	Issue(s) Addressed	Documentation	Download

SAS ODBC Drivers for the Web Infrastructure Platform Data Server 9.46 for Windows for x64
Hot Fix	Released
J1Q001

Re: SASHELP.VCOLUMN returns the wrong columns if filtering on MEMTYPE

CurtisMackWSIPP — Tue, 15 Dec 2020 18:22:41 GMT

I posted this so others would find it in search results. The solution in in the original post.

topic Re: SASHELP.VCOLUMN returns the wrong columns if filtering on MEMTYPE in SAS Programming

SASHELP.VCOLUMN returns the wrong columns if filtering on MEMTYPE

Re: SASHELP.VCOLUMN returns the wrong columns if filtering on MEMTYPE