Environment
- Version: seekdb (OceanBase seekdb)
- Revision: 1-4a092697e4a0f07ff7fb77e62b453489811acf9e
- Build Branch: master
- Build Time: Apr 13 2026 23:38:32
- Build Flags: RelWithDebInfo|Sanity
- Build Info: obbu...
Description
After executing an ALTER TABLE ... ADD operation to add a second VECTOR column and creating an asynchronous index on it, queries using the APPROXIMATE operator return empty results.
Steps to Reproduce
- Have an existing table.
- Execute
ALTER TABLE to add a second column with the VECTOR data type.
- Create an asynchronous index on this new VECTOR column.
- Execute a query using the
APPROXIMATE operator on the newly indexed column.
- Observed Result: The query returns an empty result set.
- Expected Result: The query should return relevant approximate nearest neighbor results based on the indexed data.
Impact
Data retrieval using the new asynchronous vector index is non-functional, blocking any application logic that depends on approximate similarity search for the newly added column.
Environment
Description
After executing an
ALTER TABLE ... ADDoperation to add a second VECTOR column and creating an asynchronous index on it, queries using theAPPROXIMATEoperator return empty results.Steps to Reproduce
ALTER TABLEto add a second column with the VECTOR data type.APPROXIMATEoperator on the newly indexed column.Impact
Data retrieval using the new asynchronous vector index is non-functional, blocking any application logic that depends on approximate similarity search for the newly added column.