Daylon Wilkins
Daylon Wilkins
From my understanding of reading the documentation, `setof type` is essentially how standard table operations work. When we create a table, the table creation implicitly creates a composite type that...
In addition to references above, I created a custom type and played around with it to get even more details on how the analyzer works, confirm the documentation, etc. I...
@zachmu is looking into this!
I was finally able to replicate the issue here, and I think I've found a way to fix it. First, we should convert the column to a `BLOB`, as the...
It's worth mentioning that we don't have to use `UNHEX` for the `UPDATE`, but it makes it much clearer the values that are being modified (especially since it's binary data...
I wonder if there's some other invalid state, since I made sure it would work on my repro beforehand. You're specifically referring to this `ALTER` correct? ```sql ALTER TABLE Products...
Having multiple columns may make a difference, since I was only testing with one column having invalid data. I'll try this out and see if it makes a difference.
I've been able to confirm that having multiple columns with bad data will prevent the solution that I've posted above. In simplified terms, when we modify a column, rather than...
Thank you for sharing your workaround! With the column conversion via `ALTER TABLE`, one would still need to know all of the wrong characters, so your workaround should be functionally...
Interesting, thank you for the information. I'll dig into this a bit more and see what I can find, although it may be a bit as we've had a few...