Skip to content

SQL statement runs infinitely #66

Open
@degtyaryov

Description

@degtyaryov

Hello!

Experimented with RUM.

Purely by chance, I created a table:

CREATE TABLE test
(
    tsvector1 tsvector,
    tsvector2 tsvector
);

Insert data into it:

INSERT INTO test(tsvector1, tsvector2)
SELECT to_tsvector('russian'::regconfig, 'тест '||s), to_tsvector('english'::regconfig, 'test '||s)
FROM generate_series(1, 1000000) s;

Created an index:

CREATE INDEX idx_test_rum
ON test
USING rum (tsvector1, tsvector2);

Run the SQL statement:

SELECT  *,
        tsvector1 <=> plainto_tsquery('russian'::regconfig, 'тест') as rank1,
        tsvector2 <=> plainto_tsquery('english'::regconfig, 'test') as rank2
FROM test
WHERE  tsvector1 @@ plainto_tsquery('russian'::regconfig, 'тест')
ORDER BY rank1, rank2
LIMIT 1000;

SQL statement runs infinitely!

Query is not canceled by pg_cancel_backend and disconnect client.
Unable to stop server PostgreSQL.

Only kill -SIGKILL.

I check this on PostgreSQL 10 and PostgreSQL 12.
RUM latest release 1.3.6 and latest commit e34375a.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions