Error Code: 1292. Incorrect datetime value: 'null'

[Phil Siyam]

Hi,
I am getting error message : Error Code: 1292. Incorrect datetime value: 'null' when trying to insert data into table using select

Neither table has timestamp field , view_temp has timestamp values but stored in varchar field and are not part of query out put.



CREATE TABLE mdm_fms.`test_tar` ( `col_a` int DEFAULT NULL )

-- Running Query seperately

select line_no from view_temp where product_id in ('3100022', 2000000360)
Out put
10
11

Insert into mdm_fms.`test_src` (col_a)
select line_no from view_temp where product_id in ('3100022', 2000000360)

Error Code: 1292. Incorrect datetime value: 'null'

--- Works fine
Insert into mdm_fms.`test_src` (col_a)
values (10),(11)
2 row(s) affected Records: 2 Duplicates: 0 Warnings: 0