magiclen commented on issue #6111: URL: https://github.com/apache/hop/issues/6111#issuecomment-3609861919
> I will try this tomorrow > > [ClickHouse/ClickHouse#52791](https://github.com/ClickHouse/ClickHouse/pull/52791) It affects string-to-float conversion, but INSERT statements seem to still behave as they originally did. In other words, these still store different values: ```sql INSERT INTO TAG_VALUE VALUES (fromUnixTimestamp64Nano(173566111000000), 5.54874E+7); INSERT INTO TAG_VALUE VALUES (fromUnixTimestamp64Nano(173566111000000), 55487400); ``` But the following expressions end up producing the same value: ```sql SELECT toFloat64('5.54874E+7') AS a, reinterpretAsUInt64(a) AS bits_a, toFloat64('55487400') AS b, reinterpretAsUInt64(b) AS bits_b toFloat64('55487400.0') AS c, reinterpretAsUInt64(c) AS bits_c; ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
