Copying a row truncates data

[iammattmartin]

What happened?

Copied a row in the database. It appeared to copy directly.

On review, the copied row is missing half of the data from a LONGTEXT field.

The original row did have this data.

Using other tools to do this do not have the problem.

Steps to reproduce

Select row
Duplicate
Save
Check data, missing in LONGTEXT

other types maybe affected.

Expected behavior

No response

Database type

None

TablePro version

No response

macOS version & chip

No response

Screenshots / Logs

No response

[datlechin]

Hello @iammattmartin what is your TablePro version, this issue is already fixed in v0.43.2

[iammattmartin]

I'm on 0.45.0

[datlechin]

Hi @iammattmartin, sorry it's still happening for you on 0.45.0. A few details would help narrow this down:

1. How large is the LONGTEXT value (rough number of characters or bytes is fine)?
2. Did you check the truncated copy from another client (mysql CLI, TablePlus, DataGrip), or only in TablePro's own grid? The grid caps the displayed cell preview at 10,000 characters, so if you only saw it there, the data on disk may actually be intact.
3. If you run SELECT LENGTH(<column>) FROM <table> WHERE <pk> from mysql CLI on the original and the duplicate, do the two LENGTHs differ, and by how much?
4. Is the server MySQL or MariaDB, and which version?
5. What does SHOW VARIABLES LIKE 'max_allowed_packet' return on the server?

A small repro (a CREATE TABLE + INSERT for a row that reliably reproduces, or even just the size and column type) would speed this up a lot.