> When I try to string in the year field it gives me the following error
The JDBC driver is reporting a jdbc type of Date - which Teiid then expects to be a full date. Our literal handling is very strict to ensure as much source compatibility as possible.
> So I tried to insert an object of java.sql.date with the date 2018-05-05. This time I got the following error
Teiid is passing the value down to MySQL, but MySQL probably does not like that it contains non-default day/month values. Can you try using 2018-01-01?
If that still doesn't work that means that we need to look at a different mapping/handling of the mysql year type.
I tried using 2018-01-01. But the issue still exists.
It appears that mariadb will truncate automatically with just a warning, but you are seeing a hard error with mysql.
Can you log an issue for this?