GreptimeTeam / greptimedb

An open-source, cloud-native, unified time series database for metrics, logs and events with SQL/PromQL supported. Available on GreptimeCloud.
https://greptime.com/
Apache License 2.0
4.35k stars 315 forks source link

sqlness vector test results difference in local env #5004

Closed lyang24 closed 3 days ago

lyang24 commented 5 days ago

What type of bug is this?

Other

What subsystems are affected?

Other

Minimal reproduce step

cargo sqlness on lastest main branch

What did you expect to see?

no diff on test result files

What did you see instead?

looks like some precision diff?

--- a/tests/cases/standalone/common/types/vector/vector.result +++ b/tests/cases/standalone/common/types/vector/vector.result @@ -56,9 +56,9 @@ SELECT round(cos_distance('[7.0, 8.0, 9.0]', v), 4) FROM t; +-----------------------------------------------------------+ | round(cos_distance(Utf8("[7.0, 8.0, 9.0]"),t.v),Int64(4)) | +-----------------------------------------------------------+ -| 0.0406 | -| 0.0018 | -| 0.0 | +| 0.0432 | +| 0.0037 | +| 0.0005 | +-----------------------------------------------------------+

SELECT , round(cos_distance('[7.0, 8.0, 9.0]', v), 4) as d FROM t ORDER BY d; @@ -66,9 +66,9 @@ SELECT , round(cos_distance('[7.0, 8.0, 9.0]', v), 4) as d FROM t ORDER BY d; +-------------------------+--------------------------+--------+ | ts | v | d | +-------------------------+--------------------------+--------+ -| 1970-01-01T00:00:00.003 | 0000e0400000004100001041 | 0.0 | -| 1970-01-01T00:00:00.002 | 000080400000a0400000c040 | 0.0018 | -| 1970-01-01T00:00:00.001 | 0000803f0000004000004040 | 0.0406 | +| 1970-01-01T00:00:00.003 | 0000e0400000004100001041 | 0.0005 | +| 1970-01-01T00:00:00.002 | 000080400000a0400000c040 | 0.0037 | +| 1970-01-01T00:00:00.001 | 0000803f0000004000004040 | 0.0432 |

What operating system did you use?

mac

What version of GreptimeDB did you use?

lastest main

Relevant log output and stack trace

No response

killme2008 commented 5 days ago

@zhongzc Please take a look

zhongzc commented 4 days ago

Under investigation