pglite icon indicating copy to clipboard operation
pglite copied to clipboard

FTS support?

Open AlexErrant opened this issue 6 months ago • 1 comments

How's support for FTS?

On https://pglite.dev/repl/ running SELECT 'a fat cat sat on a mat and ate a fat rat'::tsvector @@ 'cat & rat'::tsquery; works, which is cool.

However, running SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); fails with y is not a function. Then trying to run the first query yields null, which is weird.

Queries come from https://www.postgresql.org/docs/current/textsearch-intro.html

Stacktrace:

Uncaught (in promise) RuntimeError: memory access out of bounds
    at postgres.DSvoAWnW.wasm:0x1eea49
    at postgres.DSvoAWnW.wasm:0x326c39
    at postgres.DSvoAWnW.wasm:0x332072
    at invoke_vi (index.Cg2RIL2X.js:3289:142550)
    at postgres.DSvoAWnW.wasm:0x32fc89
    at FM.execProtocolRaw (index.Cg2RIL2X.js:3289:204501)
    at FM.execProtocol (index.Cg2RIL2X.js:3289:204698)
    at FM.$ (index.Cg2RIL2X.js:3289:210185)
    at index.Cg2RIL2X.js:3289:209134

AlexErrant avatar Aug 12 '24 16:08 AlexErrant