Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Fulltext index bug - not updating after changing text column via a MERGE statement on a partitioned table with a nonclustered prim

My team has discovered a bug with fulltext indexes not automatically updating after a text change, yet are configured to do so. The bug seems limited to situations where a text column involved in a fulltext index is updated via a MERGE statement on a partitioned table with a nonclustered primary key. Change any of those 3 elements and the update will occur as expected. The problem was reproduced on 2012 Enterprise [11.0.5613.0], 2014 Enterprise: Core-based Licensing [12.0.4100.1] and 2016 Developer [13.0.1604.5].

0 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base