Data Import Error on Data Type Change for Non-URL Values in Columns #3512
Labels
needs: unblocking
Blocked by other work
type: bug
Something isn't working
work: backend
Related to Python, Django, and simple SQL
work: frontend
Related to frontend code in the mathesar_ui directory
Milestone
Description
In data import, if a column contains non-url values, such as the following:
![image](https://private-user-images.githubusercontent.com/845767/316499746-be4bf345-0f1e-4d5b-9b6d-aec40c1b2f5e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjAxNjU2MTcsIm5iZiI6MTcyMDE2NTMxNywicGF0aCI6Ii84NDU3NjcvMzE2NDk5NzQ2LWJlNGJmMzQ1LTBmMWUtNGQ1Yi05YjZkLWFlYzQwYzFiMmY1ZS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzA1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcwNVQwNzQxNTdaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0yODVmYTUyZDVhMTI5MDI5ZmNmZDJmNzM1YTU5ZDdiMTIwMWU5ZDJkMTA4MDM5YmNiZjYwNTIwMDhlOTkwOWZjJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.jCDCCArTsmpiyUZrlA0x2BB4CIwb49rKO11PMb3WlsQ)
Attempting to update the data type under these circumstances results in a crash, accompanied by the following error message:
![image](https://private-user-images.githubusercontent.com/845767/316499631-14e343b4-2ea2-4588-aebc-42f27b7448fd.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjAxNjU2MTcsIm5iZiI6MTcyMDE2NTMxNywicGF0aCI6Ii84NDU3NjcvMzE2NDk5NjMxLTE0ZTM0M2I0LTJlYTItNDU4OC1hZWJjLTQyZjI3Yjc0NDhmZC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzA1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcwNVQwNzQxNTdaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0yMzcxZDdlMjhjM2ZjNzBmZmY0MjA5M2QwMGM1YzE3ZDY0NDA0OTFmMTNiZTdkNDdjZDA3YWUxMzQ3M2VmNmQ1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.vzA9UDiLIJGlGlQM0qt_R0k0HgG7-s7sQXJSKVJQRw0)
Expected behavior
When attempting a data type change for such a column, the operation should either complete successfully, or a clear notification should be provided, indicating that the data type change cannot be executed.
Status
As noted by @Anish9901, further work on this issues is blocked until we re-implement the previews logic with our RPC API.
The text was updated successfully, but these errors were encountered: