[Bug]: MySQL geometry column shown as NULL

[c6p]

Describe the bug

All geometry columns are shown as NULL even though they have data.

MySQL 5.7

To Reproduce

• Create a table with geometry column.
• Insert some data such as:

ST_GeomFromText('POINT(30 40)', 4326)

OS Version

Windows 10

Tabularis Version

v0.8.10

Relevant Log Output

[debba]

Hi @c6p ,
thanks for the feedback, I'll investigate.
If you want, feel free to contribute.

[debba]

Hi @c6p !
I did a lot of research about it, with assistance of Claude I defined the feature which is accessible in the related branch.
Can you do a check?
Feel free to contribute, probably you know the context better than me.

[c6p]

Hi @debba,

Thank you for quickly checking out. It seems sqlx does not support mysql geometry types. I'll look into it to figure out what can be done.

I've tried the related branch, on geometry columns I'm getting:

[DEBUG] ✗ geometry as Vec<u8> (geometry): error occurred while decoding column 13: mismatched types; Rust type `alloc::vec::Vec<u8>` (as SQL type `BLOB`) is not compatible with SQL type `GEOMETRY`
[WARNING] Column 'geometry' [13] type 'GEOMETRY' (TypeInfo: MySqlTypeInfo { type: Geometry, flags: ColumnFlags(NOT_NULL | MULTIPLE_KEY | BLOB | BINARY | NO_DEFAULT_VALUE), max_size: Some(4294967295) }) could not be extracted. Raw value available: true

I think in the meantime, at least returning blob for not null geometry values would be enough, and making them non-editable.

[debba]

Did you take a look on the following branch?

https://github.com/debba/tabularis/tree/31-bug-mysql-geometry-column-shown-as-null

[c6p]

Sorry, my bad. I thought I'm on that branch. It seems I've fetched, but did not checked out that branch.

Thank you very much for your work @debba, it is working.

• Though going into edit mode, without modification still cause a submit dialog.
• Also trying to put a well-formed geometry as WKT such as POINT(30 40) results in:

Update failed: error returned from database: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?ST_GeomFromText(?))' at line 1

I'll look into it and report back.

[debba]

Ok @c6p .
If you want to add a contribute, feel free to check.
I will check too in the afternoon.

[debba]

Hello @c6p ,
I added a support of geometry and sql functions for geometry in v0.8.13.

Feel free to try and give me a feedback!

Thanks