A CSV file from Kaggle that loads without any problems in version 25.4.1.0 and earlier now fails with this error in version 26.1.2.0 build: 26.1.2.132.1334 (only the last lines shown):
#INFO COLUMN 25: number_of_reviews => NUMBER_OF_REVIEWS
#ERROR Create table error.
#ERROR Index -1 out of bounds for length 25
SEVERE: Load terminated
If I create the table empty by using previous version the file loads without any errors, so it looks to be in the scanning phase. The file is from Kaggle: https://www.kaggle.com/datasets/ruthgn/beer-profile-and-ratings-data-set?resource=download. Both of these commands fails:
load beers beer_profile_and_ratings.csv new
load beers beer_profile_and_ratings.csv show_ddl
Once the table exists this command work fine in latest version too:
load beers beer_profile_and_ratings.csv