Results of 1 - 1 of about 1 for determinism (0.000 sec.)
- Non-Deterministic Behavior 9414
- Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-
...operating systems and hardware architectures, can also cause changes in ordering. This page documents the cases where non-determinism is an expected behavior . If you would like to make your queries deterministic, see the “Working Around Non-Determinism” s...ection . Set Semantics One of the most common sources of non-determinism is the set semantics used by SQL. E.g., if you run the following query repeatedly, you may get two different results: SELE...ple threads, the query may return small numbers ( 0 <= z < 10e-16 ) due to floating-point inaccuracies. Working Around Non-Determinism For the majority of use cases, non-determinism is not causing any issues. However, there are some cases where deterministi... - https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work