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 ->