Problem Note 8219: Incorrect SQL is generated when using 'with many' and 'with one' sets on
tables that are joined by compound keys
If you run a selection rule in the SAS Campaign Management component
that uses the 'with many' or 'with one' set operator, and if any of the
tables are joined using a compound key, the SQL that is produced may be
incorrect. The selection rule executes without error, but incorrect
counts are returned.
An example of the type of selection rule that may be affected is:
Select Customers where age > 10
and any Cards where type = chq
with many Transactions where bal > 0
In this example, the compound join key exists for the Cards and the
Transactions tables. Instead of returning the number of records that
meet all three criteria, the SQL for this rule returns the record
counts for the first two criteria then simply checks to see that the
number of transactions is greater than 1. It does not actually select
the transactions with a balance greater than 0. Therefore, it does not
drop any customers after the second line of the rule.
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.00 | 7.5 | | |
| Microsoft Windows 2000 Server | 7.00 | 7.5 | | |
| Microsoft Windows 95/98 | 7.00 | 7.5 | | |
| Microsoft Windows 2000 Advanced Server | 7.00 | 7.5 | | |
| Microsoft Windows 2000 Datacenter Server | 7.00 | 7.5 | | |
| Microsoft Windows 2000 Professional | 7.00 | 7.5 | | |
| Microsoft Windows XP Professional | 7.2 | 7.5 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2003-01-02 13:46:47 |
| Date Created: | 2002-08-09 11:45:44 |
