# Issue post upgrade from 5.9.+ to 5.10.+

**URL:** <https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035>\
**Category:** CrateDB\
**Created:** [June 4, 2025, 2:08pm UTC](https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035 "2025-06-04T14:08:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![atish11pune](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@atish11pune](https://community.cratedb.com/u/atish11pune)\
**Post date:** [June 4, 2025, 2:08pm UTC](https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035/1 "2025-06-04T14:08:26Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![hernanc](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/hernanc/32/676_2.png) [@hernanc](https://community.cratedb.com/u/hernanc)\
**Post date:** [June 4, 2025, 2:13pm UTC](https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035/2 "2025-06-04T14:13:47Z")

</div>

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](https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/5.10.6.html) , 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?

---

<div class="post-metadata">

**Author:** ![atish11pune](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@atish11pune](https://community.cratedb.com/u/atish11pune)\
**Post date:** [June 5, 2025, 5:10am UTC](https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035/3 "2025-06-05T05:10:56Z")

</div>

- We are on 5.10.1
- There are no renamed columns and no table definition changes

---

<div class="post-metadata">

**Author:** ![hernanc](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/hernanc/32/676_2.png) [@hernanc](https://community.cratedb.com/u/hernanc)\
**Post date:** [June 5, 2025, 6:49am UTC](https://community.cratedb.com/t/issue-post-upgrade-from-5-9-to-5-10/2035/4 "2025-06-05T06:49:39Z")

</div>

> - 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.