• Gleb Shchepa's avatar
    Bug #39002: The server crashes on the query: · 0e9cba18
    Gleb Shchepa authored
      INSERT .. SELECT .. ON DUPLICATE KEY UPDATE col=DEFAULT
    
    In order to get correct values from update fields that
    belongs to the SELECT part in the INSERT .. SELECT .. ON
    DUPLICATE KEY UPDATE statement, the server adds referenced
    fields to the select list. Part of the code that does this
    transformation is shared between implementations of
    the DEFAULT(col) function and the DEFAULT keyword (in
    the col=DEFAULT expression), and an implementation of
    the DEFAULT keyword is incomplete.
    
    
    mysql-test/r/default.result:
      Added test case for bug #39002.
    mysql-test/t/default.test:
      Added test case for bug #39002.
    sql/item.cc:
      The Item_default_value::transform() function has been
      modified to take into account the fact that the DEFAULT
      keyword has no arguments unlike the DEFAULT(col) function
      that always has an argument.
    0e9cba18
default.test 5.76 KB