• unknown's avatar
    Fix bug#11298 insert into select from VIEW produces incorrect result · 401fa3cb
    unknown authored
      when using ORDER BY
    
    Insert were inserting data from last record fetched instead of inserting from 
    temporary table.
    
    Make Item_ref to save data from result_field if it's available rather then
    from *ref on save_in_field() call.
    
    
    
    sql/item.h:
       Fix bug#11298 insert into select from VIEW produces incorrect result when using ORDER BY
    sql/item.cc:
      Fix bug#11298 insert into select from VIEW produces incorrect result when using ORDER BY
    mysql-test/r/view.result:
      Test case for bug#11298 insert into select from VIEW produces incorrect result when using ORDER BY
    mysql-test/t/view.test:
      Test case for bug#11298 insert into select from VIEW produces incorrect result when using ORDER BY
    401fa3cb
item.cc 140 KB