• V Narayanan's avatar
    Bug#39616: Missing quotes from .CSV crashes server · af2e74f8
    V Narayanan authored
          
    When a CSV file contained comma separated elements 
    that were not enclosed in quotes, it was causing the
    mysql server to crash.
          
    The old algorithm that parsed the content of a row in
    mysql 5.0 was assuming that the values of the fields
    in a .CSV file will be enclosed in quotes and will be
    separated by commas.
    
    This was causing the old algorithm to fail when the 
    content of the file resembled the following
    3,"sans quotes"
    The CSV engine that is part of mysql 5.0 was expecting
    the above to be
    "3","sans quotes"
          
    The above is just one example of where the engine was
    failing for what would be recognized as a valid .CSV 
    file content otherwise.
          
    The proposed fix changes the old algorithm being used
    to parse rows from the .CSV file to handle two separate
    cases
    
    1) When the current field of the row is enclosed in quotes
    2) When the current field of the row is not enclosed in 
       quotes
    af2e74f8
ha_tina.cc 27.4 KB