• Hugo Wen's avatar
    MDEV-33408 Initial support for vector DELETE and UPDATE · 19b0c089
    Hugo Wen authored
    When the source row is deleted, mark the corresponding node in HNSW
    index by setting `tref` to null. An index is added for the `tref` in
    secondary table for faster searching of the to-be-marked nodes.
    
    The nodes marked as deleted will still be used for search, but will not
    be included in the final query results.
    
    As skipping deleted nodes and not adding deleted nodes for new-inserted
    nodes' neighbor list could impact the performance, we now only skip
    these nodes in search results.
    
    - for some reason the bitmap is not set for hlindex during the delete so
      I had to temporarily comment out one line
    
    All new code of the whole pull request, including one or several files
    that are either new files or modified ones, are contributed under the
    BSD-new license. I am contributing on behalf of my employer Amazon Web
    Services, Inc.
    19b0c089
sql_base.cc 324 KB