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