What happens?

random() gives repeated results even when run only 100k times and single-threaded.

In comparison, numpy gives unique results even when asked for 100M random numbers.

To Reproduce

SET THREADS to 1;
SELECT count() FROM (SELECT DISTINCT random() AS a FROM range(100_000));

┌──────────────┐
│ count_star() │
│    int64     │
├──────────────┤
│        99998 │
└──────────────┘

OS:

Ubuntu22.04

DuckDB Version:

1.1.0

DuckDB Client:

Python3.9

Hardware:

i5, x64

Full Name:

Soeren Wolfers

Affiliation:

G-Research

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

Did you include all relevant data sets for reproducing the issue?

Not applicable - the reproduction does not require a data set

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have