• Sergey Glukhov's avatar
    Bug#33717 INSERT...(default) fails for enum. Crashes CSV tables, loads spaces for MyISAM · 4b260b66
    Sergey Glukhov authored
    Table corruption happens during table reading in ha_tina::find_current_row() func.
    Field::store() method returns error(true) if stored value is 0.
    The fix:
    added special case for enum type which correctly processes 0 value.
    Additional fix:
    INSERT...(default) and INSERT...() have the same behaviour now for enum type.
    
    
    mysql-test/r/csv.result:
      test result
    mysql-test/r/default.result:
      result fix
    mysql-test/t/csv.test:
      test case
    sql/item.cc:
      Changes:
      do not print warning for 'enum' type if there is no default value.
      set default value.
    storage/csv/ha_tina.cc:
      Table corruption happens during table reading in ha_tina::find_current_row() func.
      Field::store() method returns error(true) if stored value is 0.
      The fix:
      added special case for enum type which correctly processes 0 value.
    4b260b66
item.cc 211 KB