3754 Precision error in FLOAT type constant or during implicit conversions

Problem:

select * from DBC.QryLogExplainV where queryid='307124780753391274';

*** Failure 3754 Precision error in FLOAT type constant or during implicit conversions.

  

Solution:

You can see the type by using the following query:

sel type(07124780753391274);

Type(7124780753391274.)

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

DECIMAL(16,0)

 

Use Cast to make it work:

 

select * from DBC.QryLogExplainV where queryid=cast('307124780753391274' as Decimal(38,20));

 

ProcID           CollectTimeStamp              QueryID       ExpRowNo Expla

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

 30712 2019-02-25 13:29:07.870000   307124780753391274              1   ->

 

Comments