INTERNAL Error:
Failed to bind column reference "" [76.0] (bindings: {#[0.0], #[0.1], #[141.0], #[144.0], #[138.0], #[135.0], #[132.0], #[129.0], #[30.0], #[30.1], #[30.2]})

INTERNAL Error:
Failed to bind column reference "" [76.0] (bindings: {#[0.0], #[0.1], #[141.0], #[144.0], #[138.0], #[135.0], #[132.0], #[129.0], #[30.0], #[30.1], #[30.2]})

Stack Trace:

./duckdb() [0x91b5c3]
./duckdb() [0x91b5f6]
./duckdb() [0x91dc01]
./duckdb() [0xaf0f24]
./duckdb() [0x491d60]
./duckdb() [0xe4d521]
./duckdb() [0xadad01]
./duckdb() [0xadad75]
./duckdb() [0xe5a7a2]
./duckdb() [0xadac2b]
./duckdb() [0xe5a7a2]
./duckdb() [0xadac2b]
./duckdb() [0xe5a7a2]
./duckdb() [0xadac2b]
./duckdb() [0xe5a7a2]
./duckdb() [0xadac2b]
./duckdb() [0xadb72c]
./duckdb() [0xb72937]
./duckdb() [0xb72f4d]
./duckdb() [0xb7f7b6]
./duckdb() [0xb86857]
./duckdb() [0xb8792b]
./duckdb() [0xb86aa6]
./duckdb() [0xb8ba3e]
./duckdb() [0xb8bb3e]
./duckdb() [0xb8bde2]
./duckdb() [0x74a6fc]
./duckdb() [0x72c4e7]
./duckdb() [0x72d14c]
./duckdb() [0x72d7c7]
./duckdb() [0x71f8e3]
/lib/x86_64-linux-gnu/libc.so.6(+0x29d90) [0x7d53bfe29d90]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x80) [0x7d53bfe29e40]
./duckdb() [0x723237]

This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.
For more information, see https://duckdb.org/docs/dev/internal_errors

CREATE TABLE sample_docs AS
    SELECT o_orderkey::VARCHAR AS name, o_comment AS content
    FROM 'https://shell.duckdb.org/data/tpch/0_01/parquet/orders.parquet';

PRAGMA create_fts_index(sample_docs, name, content);

USE fts_main_sample_docs;
CREATE TABLE postings AS
    SELECT docid, termid, COUNT(*) AS tf
    FROM fts_main_sample_docs.terms
    GROUP BY ALL;

WITH termids AS (
    WITH tokens AS (
        SELECT unnest(tokenize('this is a sample test query')) AS t
    ),
    stemmed AS (
        SELECT stem(t, 'porter') AS t
        FROM tokens
        WHERE tokens.t NOT IN (FROM stopwords)
    ),
    qtfs AS (
        SELECT t, COUNT(*) AS qtf
        FROM stemmed
        GROUP BY t
    )
    SELECT termid, df, qtf
    FROM qtfs
    JOIN dict ON dict.term = qtfs.t
)
SELECT
    docid,
    first(name) AS name,
    CASE LOWER('bm25')
        WHEN 'bm25' THEN
            SUM(
                qtf * 
                log(
                    ((SELECT num_docs FROM stats) - df + 0.5) / (df + 0.5)
                ) * (tf * (0.9 + 1)) / (
                    tf + 0.9 * (1 - 0.4 + 0.4 * len / (SELECT avgdl FROM stats))
                )
            )
        WHEN 'lm' THEN
            log(FIRST(len)) + SUM(
                qtf *
                log(
                    1 + (0.7 * tf * (SELECT SUM(df) FROM dict)) / ((1-0.7) * df * len)
                )
            )
        WHEN 'inquery' THEN
            SUM(
                qtf * 
                (
                    0.4 + (1 - 0.4) * (tf / (tf + 50 + 150 * len / (SELECT avgdl FROM stats))) * log(((SELECT num_docs FROM stats) + 0.5) / df) / log((SELECT num_docs FROM stats) + 1.0)
                )
            )
    END AS score
FROM postings
JOIN docs USING (docid)
JOIN termids USING (termid)
WHERE termid IN (SELECT termid FROM termids)
GROUP BY docid;