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