Crashing when horizontal scrolling in DuckDB with geometry type fields #569
Description
Before Proceeding, please acknowledge:
- I have consulted the Troubleshooting guide.
- I have searched Issues and Discussions in this repo.
- Feature requests should be initiated as Discussions. This is a bug report.
Describe the bug
I make a query on a table with a geometry inside of it and when I scroll horizontally, Harlequin crashes.
MarkupError: closing tag
'[/\xf8D@\xd9\xd4Em8\xefU\xc0\xa1\xa3j\x95/\xf8D@\x1ao\x1a\x171\xefU\xc0E\x88Q\xbd/\xf8D@\xeb\xd7\x16\x8f+\xefU\xc0\xdf\xf7\xf4\xe3/\xf8D@\xb8\x12b\x1b%\xefU
\xc0]' at position 10150 doesn't match any open tagTo Reproduce
My query looks something like this:
LOAD spatial;
SELECT community, ST_GeomFromWKB(geometry) from geometry.community_areas_shape cas
ORDER BY community Expected behavior
I should be able to scroll and hover over the geometry values.
Actual behavior
Contributing
Are you interested in contributing a fix?
- Yes
- Maybe
- No
Additional context
Please provide as much as you can, but don't waste your time if it's definitely not relevant or you don't know.
I attached a file of the full error text.
error.txt
What is the output of harlequin --version?
❯ harlequin --version
harlequin, version 1.20.0
Installed Adapters:
- duckdb, version 1.20.0
- sqlite, version 1.20.0
What database adapter are you using with Harlequin? (Default is duckdb)
duckdb
What other options are you using when invoking Harlequin? (If you are using a profile, please add relevant items from your profile here).
-e spatial -e autocomplete
Can you tell us more about your system?
- Shell: zsh
- Terminal: iterm2
- OS of the shell: macos
- OS of the terminal (if different from the shell):
- Default locale / language for your OS/Terminal/Shell: en_US/UTF-8
How did you install Harlequin?
- pipx
- conda/mamba
- pip (global install)
- pip + venv/virtualenv or pipenv
- Poetry
- uv/Rye
- other: _____________