Bug #119797 Contribution: Feat: Native Vector Search with HNSW Indexing
Submitted: 27 Jan 20:09
Reporter: OCA Admin (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[27 Jan 20:09] OCA Admin 
Description:
This bug tracks a contribution by mauricio perera (Github user: MauricioPerera), as described in http://github.com/mysql/mysql-server/pull/642

How to repeat:
See description

Suggested fix:
See contribution code attached
[27 Jan 20:09] OCA Admin 
Contribution submitted via Github - Feat: Native Vector Search with HNSW Indexing 
(*) Contribution by mauricio perera (Github MauricioPerera, mysql-server/pull/642#issuecomment-3794817772): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_3192246728.txt (text/plain), 236.70 KiB.
[10 Feb 6:48] Mauricio Perera 
Hi,
This contribution implements native vector search with HNSW indexing in MySQL 9.6 and is fully working end-to-end.

Current status:
Builds and runs successfully on Linux (tested on Alpine Linux, local + VPS)
Native CREATE INDEX … USING HNSW via InnoDB
Integrated with SQL, optimizer (ORDER BY VECTOR_DISTANCE() LIMIT k), and InnoDB lifecycle
Includes 50+ unit tests (HNSW engine, registry, vector ops)

I understand the change set is large and I’m happy to split the contribution (e.g. vector functions, HNSW engine, SQL/optimizer integration, InnoDB hooks) or provide additional MTR tests if preferred.

Please let me know how you would like to proceed with review or re-submission.