Jet He comments

Results 7 comments of


                                            Jet He

[Feature] Add NGRAM bloom filter index to speed up like queries.

> @compasses have you researched tokenbf_v1 in clickhouse? It's also useful for simple fulltext search. I'd like to collaborate with you and take tokenbf_v1. Yes, for tokenbf it's work for...

which PG version can I used ?

oh thanks， i use PG 9.3 seems not work, i have change to PG 12.

which PG version can I used ?

Hi, after do some investigation. I have a few questions 1. The vops table not pg native heap table, all data saved in tiles format, right? 2. The vectorized execution...

fix memory leak when exception happend during count distinct for null key

> Thank you for the PR! Please, use the template PR description and choose the changelog entry. Also, a test is needed. Done, thanks. But I have no idea add...

fix memory leak when exception happend during count distinct for null key

> > But I have no idea add test to this, since it fix the memory leak, the test maybe no effect. > > We run tests under address sanitizer,...

fix memory leak when exception happend during count distinct for null key

The test results are strange: > 2024-07-31 01:30:50 The query succeeded but the server error '241' was expected (query: SELECT count(distinct b) FROM testnull GROUP BY a SETTINGS max_memory_usage =...

fix memory leak when exception happend during count distinct for null key

> > On my local test, it should always fail as expected. Do I need to do anything? > > From the logs: `2024.07.31 01:30:50.371770 [ 9867 ] {b21e3a8f-67e3-48f6-83c5-ca6f88a3e91a} MemoryTracker:...