Replies: 1 comment
-
You cannot update the id field. Instead, consider using the crc32 value when inserting documents. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hello, I want to replace row ID with crc32 hash (as used for identify also) to reduce disk usage:
UPDATE yo_document SET id = crc32url;
This query returns:
ERROR 1064 (42000): P01: syntax error, unexpected identifier near 'crc32url'
crc32url
value isyo_document
.crc32url
field of this table.In MySQL it works but here I can't update indexes to optimize DB size
p.s. tried REPLACE syntax also but nothing works, I have no idea how to replace ID without creating new table.
Beta Was this translation helpful? Give feedback.
All reactions