Problem Note 65911: Comparison of two VARCHAR variables with the FEDSQL procedure or the FEDSQL action might generate unexpected results
 |  |  |  |  |
Using the FEDSQL procedure or the FEDSQL action with the CAS procedure might generate unexpected results when the following is true:
- An = (equal) or a ^= (not equal) comparison is done on two VARCHAR variables.
- One or both of the variables are null.
When one variable is null and one variable has a value, then an equal (v1=v2) and a not equal (v1 ^= v2) comparison evaluates to false. When both variables are null, then an equal (v1=v2) and a not equal (v1 ^= v2) comparison evaluates to true.
| V1 | V2 | V1 ^= V2 Comparison | V1 = V2 Comparison |
| a | a | not equal is false | equal is true |
| a | b | not equal is true | equal is false |
| <null> | b | not equal is false | equal is false |
| a | <null> | not equal is false | equal is false |
| <null> | <null> | not equal is true | equal is true |
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Microsoft® Windows® for x64 | 3.4 | Viya | ||
| Linux for x64 | 3.4 | Viya | ||||
Viya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-05-04 08:41:43 |
| Date Created: | 2020-04-30 11:43:13 |