Problem Note 9378: Implicit SQL Pass Through query returns incorrect results from the Teradata DBMS
If you submit an implicit PROC SQL Pass Through query to a Teradata
database that references TIME or TIMESTAMP fields in the WHERE clause,
an incorrect record set might be returned.
For example, the following query will return only one row, for TIMEKEY='01JAN2000:00:00:00'. Any other
values are ignored.
proc sql;
create table work.test as
select distinct TIMEKEY
from teralib.timetable as x
where x.TIMEKEY >= '01JAN2000:00:00:00'dt and
x.TIMEKEY <= '01JAN2001:00:00:00'dt);
quit;
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Teradata | Solaris | 8.2 TS2M0 | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 9.2 TS2M0 |
| ABI+ for Intel Architecture | 8.2 TS2M0 | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 9.2 TS2M0 |
| HP-UX | 8.2 TS2M0 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 9.2 TS2M0 |
| AIX | 8.2 TS2M0 | 9.2 TS2M0 |
*
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: | alert |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Teradata
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2003-06-02 08:53:24 |
| Date Created: | 2003-02-10 14:20:29 |
