Repository navigation
SQLite queries return stale table metadata after alter operation #529
Description
Please agree to the following
- I have searched existing issues for duplicates
- I agree to follow this project's Code of Conduct
Summary
In rare cases queries to a recently changed table will return stale table metadata (e.g. column names). This might cause difficult to diagnose bugs during database migration. So far this issue hasn't been reported in production, but was encountered during development on #506.
System Setup
...Cloud Type
No response
Steps to Reproduce
...
Expected Behavior
...
Actual Behavior
...
Reproducibility
Always
Relevant Log Output
No response
Anything else?
Related bug on the google issue tracker: 153521693
Activity
[-]SQLite queries return stale table metadata after update[/-][+]SQLite queries return stale table metadata after alter operation[/+]Added tests for migration to v13
Added tests/snippets to explain/reproduce bug #529 [1]
Applied code style to BugTest.kt and SmallBugTest.kt
Finalized work on BugTest.kt and SmallBugTest.kt
Specified journal mode
Added first implementation of "CacheControlledSupportSQLiteDatabase"
Refactored "CacheControlledSupportSQLiteDatabase"
Narrowed visibility for members of "AOP_SQLiteDatabase" class
Renamed parts of cache-control
Renamed class "CacheControlledSupportSQLiteDatabase" and its members
Reorganized cache-control to improve abstraction
Renamed "RandomUUIDSQLMappingFunction" to "RandomUUIDMapping"
Refactored "SQLMappingFunction"
25 remaining items
Performed cleanup
Moved "pseudo equality" methods to dedicated class
Moved helper methods for "Iterables" to dedicated class
Added type-checks to tests for "MappingSupportSQLiteQuery"
Consolidated common test-logic to "DatabaseTests.kt"
Improved caching to properly handle unconventional keys
Added test for "SupportSQLiteDatabase.compileStatement"
Added tests for "MappingSupportSQLiteStatement.newBoundStatement"
Added large tests for "MappingSupportSQLiteStatement.newBoundStatement"
Refactored "testInsert" and tests in "MappingSupportSQLiteStatementTest"
Refactored "testInsertConflictAlgorithms" to also use "testSingleInsert"
Reformatted "MappingSupportSQLiteDatabaseTest.kt"
github-actions commentedon Apr 11, 2025
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.