SUPPORT / SAMPLES & SAS NOTES
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 | ||||