Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 23 Feb 2015 @ 16:58:42 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Casting to integer with ** operator resulting incorrect
 
From:   Barner, Eric

I ran Dieter's test on my clients , and interestingly enough I am getting some mixed results.

Initially I ran this on SQL Assistant via. .Net Data Provider (with the option "Display Float Values using scientific notation" Unchecked") The Type returns as number but is showing like a Float.

The export File shows the below output from SQL Assistant. Basically I get the wrong result in all cases.

     Database Version:  Teradata 14.00.06.02 Provider Version: Teradata.Net 15.0.0.0 SQL
     Assistant Version: Teradata.Net 14.0.0.0

     ----------------------------------------------------------------------------
     SELECT 2**63    , Type (  POWER(2,32) * POWER (2,31)), (  POWER(2,32) *
     POWER (2,31))   , POWER(2,63)  ;

     1 Rows returned. DBS time = 00:00:00

     (2**63)   Type((POWER(2,32)*POWER(2,31)))   (POWER(2,32)*POWER(2,31))   POWER(2,63)
     9.22337203685478E+18   NUMBER   9.22337203685478E+18   9.22337203685478E+18

     ----------------------------------------------------------------------------

The answer set shows the following in the display window which is different

     (2**63)   Type((POWER(2,32)*POWER(2,31)))   (POWER(2,32)*POWER(2,31))
     POWER(2,63)
     9223372036854780000.0000   NUMBER   9223372036854780000.0000
     9223372036854780000.0000

     ----------------------------------------------------------------------------

IN BTEQ I get the same results as Dieter, and also this works with TD15 SQL assistant via TD .NET connector (all the same options).

The results are below. Is this a known issue with my version of SQL Assistant?

It seems pretty strange behavior for not only the DB to get a wrong answer, but then for a client to produce inconsistent results.

I would have further tested this behavior with Teradata Studio, however it seems to have committed Seppuku after the most recent Java update, and I don't have time to reconfigure/reinstall that junky application.

     BTEQ 14.00.00.16 Mon Feb 23 10:29:33 2015

     +---------+---------+---------+---------+---------+---------+---------+-


      *** Logon successfully completed.
      *** Teradata Database Release is 14.00.06.01
      *** Teradata Database Version is 14.00.06.02
      *** Transaction Semantics are BTET.
      *** Session Character Set Name is 'ASCII'.

      *** Set QUERY_BAND accepted.
      *** Total elapsed time was 7 seconds.


      *** Total elapsed time was 7 seconds.

     +---------+---------+---------+---------+---------+---------+---------+-
     .set width 255;
     +---------+---------+---------+---------+---------+---------+---------+-
     SELECT 2**63    , (  POWER(2,32) * POWER (2,31))   , POWER(2,63)  ;

      *** Query completed. One row found. 3 columns returned.
      *** Total elapsed time was 1 second.

                    (2**63)                 (POWER(2,32)*POWER(2,31))
     POWER(2,63)
     ----------------------  ----------------------------------------
      9.22337203685478E 018                       9223372036854775808
     9223372036854776000

     +---------+---------+---------+---------+---------+---------+---------+-

     .logoff
      *** You are now logged off from the DBC.
     +---------+---------+---------+---------+---------+---------+---------+-
     .quit
      *** Exiting BTEQ...

     ----------------------------------------------------------------------------

     Database Version:  Teradata 14.00.06.02 Provider Version: Teradata.Net 15.0.0.0 SQL
     Assistant Version: 15.00.0.3


     SELECT 2**63    , Type (  POWER(2,32) * POWER (2,31)), (  POWER(2,32) *
     POWER (2,31))   , POWER(2,63);

     1 Rows returned. DBS time =   00:00:00.062

     (2**63)   Type((POWER(2,32)*POWER(2,31)))   (POWER(2,32)*POWER(2,31))
     POWER(2,63)
     9.22337203685478E+18   NUMBER    9223372036854775808   9223372036854776000


     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019