Feature: Default Primary Key Causes Misleading Error Message

[mxwli]

API

Python

Description

Given the following csv file 'data'

iD
1

and the following cypher queries

create node table tab(id int32, primary key(id));
copy tab from 'data.csv' (header=true);

The error message given is

Error: Copy exception: Found NULL, which violates the non-null constraint of the primary key column.

But the actual problem is that the headers don't match. This is an issue partly because of case sensitive column matching: table names are case insensitive, and struct fields are case insensitive, so users might expect column names to be case insensitive.