• Sergey Vojtovich's avatar
    MDEV-4911 - add KILL query id, and add query id information to processlist · 1a2a9d74
    Sergey Vojtovich authored
    It is now possible to kill query by query id. KILL syntax was extended to:
    KILL [HARD | SOFT] [CONNECTION | QUERY [ID query_id]] [thread_id | USER user_name]
    
    Added QUERY_ID column to INFORMATION_SCHEMA.PROCESSLIST.
    
    Fixed tests affected by this change:
    - added PROCESSLIST.QUERY_ID column
    - ID is now keyword and is quoted in SHOW CREATE TABLE output
    - PFS statement digest is calculated basing on token id
      (not token text). Token id has shifted for keywords residing
      after ID in keywords array.
    1a2a9d74
kill.test 17.2 KB