Bug #119797 Contribution: Feat: Native Vector Search with HNSW Indexing

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

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.

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.

any progress?