Warning: "schema is different from the query

[Anonymous]

Hi.
I build a job with a mysql input component. The SQL:

SELECT CAST(COALESCE(MAX(ID), 0)+1 as SIGNED) as MAX_ID FROM TABLE_XY

The schema:

I got the warning near the the component:

What is the solution?
Thanks in advance.
Marcus

[Anonymous]

Hi,
This warning refer to the setting of your "DB type" not the query. Because the query should be fine if it can check the data source.
Set a correct DB type in schema will avoid this issue. Certainly, this warning doesn't affect your job.
Related https://community.talend.com/t5/Design-and-Development/Schema-s-db-type-not-correct-for-this-compone...
Best regards
Sabrina