Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

hll_hash_any() causes crash #145

Open
robins opened this issue May 4, 2023 · 1 comment
Open

hll_hash_any() causes crash #145

robins opened this issue May 4, 2023 · 1 comment

Comments

@robins
Copy link

robins commented May 4, 2023

SQL crashes the database:

SELECT hll_hash_any(cash_out(0::money));

Crash Example

psql (15devel, server 15.2)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
postgres15@postgres=> SELECT hll_hash_any(cash_out(0::money));
SSL SYSCALL error: EOF detected
The connection to the server was lost. Attempting reset: Failed.
@!>? \q

HLL v2.16

postgres15@postgres=> \dx hll
                List of installed extensions
 Name | Version | Schema |            Description
------+---------+--------+-----------------------------------
 hll  | 2.16    | public | type for storing hyperloglog data
(1 row)

Thanks to SQLSmith / SQLReduce for helping with the find.

@robins
Copy link
Author

robins commented Oct 18, 2023

Another variety:

tempdel=*> SELECT public.hll_hash_any(pg_catalog.timetztypmodout(85));
SSL SYSCALL error: EOF detected
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?> \q

tempdel=*> \dx hll
                List of installed extensions
 Name | Version | Schema |            Description
------+---------+--------+-----------------------------------
 hll  | 2.18    | public | type for storing hyperloglog data
(1 row)

tempdel=*> select version();
                                                 version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 16.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit
(1 row)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants