You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
I noticed that in some particular cases the insertOnDuplicateKey method creates a wrong record in the table. This is an example of input with the table schema, at the very bottom.
Simply inserting the data, starting from an empty table,
AwnRecord::insertOnDuplicateKey($records);
results in the insertion of only 50 records (out of 92 as input) one of which is totally wrong and even invalid, i.e. the is_valid_solarRad field, defined as boolean, is equal to 127 and tstamp, a datetime field, equals 0000-00-00 00:00:00 (which I believe it's not a valid datetime value)
What's wrong with the code/data?
How can the database even allow for creating an invalid type field?
If of any relevance, I noticed the not inserted records are mostly empty, although null is a valid value for those columns (and relevant data in my case).
The text was updated successfully, but these errors were encountered:
Hi,
I noticed that in some particular cases the
insertOnDuplicateKey
method creates a wrong record in the table. This is an example of input with the table schema, at the very bottom.Simply inserting the data, starting from an empty table,
results in the insertion of only 50 records (out of 92 as input) one of which is totally wrong and even invalid, i.e. the
is_valid_solarRad
field, defined asboolean
, is equal to 127 andtstamp
, adatetime
field, equals0000-00-00 00:00:00
(which I believe it's not a valid datetime value)What's wrong with the code/data?
How can the database even allow for creating an invalid type field?
If of any relevance, I noticed the not inserted records are mostly empty, although
null
is a valid value for those columns (and relevant data in my case).The text was updated successfully, but these errors were encountered: