• Print |
• E-mail  |
• Bookmark

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 may be returned.

For example, the following query:

   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;

will return only one row, for TIMEKEY='01JAN2000:00:00:00'.  Any other
values are ignored.


A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009378

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: