You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Though all (non-side-effecting) functions are safe to execute in a single-shard SELECT query, the same is not true for multi-shard SELECTs. In particular, a function such as random() or now() would return a different value for each shard and so the query results would not represent a consistent view of the world.
This may overlap somewhat with #47, but that issue is more concerned with single-shard ramifications. We've noticed this bug affects multi-shard queries as well, so they'll need similar treatment.
The text was updated successfully, but these errors were encountered:
Though all (non-side-effecting) functions are safe to execute in a single-shard
SELECT
query, the same is not true for multi-shard SELECTs. In particular, a function such asrandom()
ornow()
would return a different value for each shard and so the query results would not represent a consistent view of the world.This may overlap somewhat with #47, but that issue is more concerned with single-shard ramifications. We've noticed this bug affects multi-shard queries as well, so they'll need similar treatment.
The text was updated successfully, but these errors were encountered: