I have upgraded CrateDB from version 5.9 to 5.10. Prior to the upgrade, I was able to retrieve records without any issues. However, after the upgrade, newly inserted records are showing null values when queried, although applying a WHERE clause still filters the records correctly based on the condition.
Interestingly, if I create a new table with the same definition and insert new records, the data is displayed correctly.
Has anyone faced a similar issue? Any help would be appreciated.
Hi, this looks similar to a bug that was fixed in 5.10.6 , see the last entry in Version 5.10.6 - CrateDB: Reference , are you running 5.10.7 ? if the problem persists with the latest version maybe could you share the table definition, the query you are using and if there is some history with the table originating from an earlier version or columns having been renamed?
- We are on 5.10.1
Then definitely worth upgrading to 5.10.7 as the issue you describe is very likely to be the one I was referring to in the release notes which is already fixed.