message: There can be fewer types provided than columns in the file
diff: @@ -922,10 +922,12 @@ vector<LogicalType> BufferedCSVReader::SniffCSV(const vector<LogicalType> &reque
  continue;
  }
  }
  - if (!options.union_by_name && found < names.size()) {
  + if (!options.union_by_name && found < options.sql_types_per_column.size()) {
  string exception = ColumnTypesError(options.sql_types_per_column, names);
  + if (!exception.empty()) {
  throw BinderException(exception);
  }
  + }
  } else {
  // types supplied as list
  if (names.size() < options.sql_type_list.size()) {
  