search

CurtTilmes / perl6-dbmysql

DB::MySQL
2 stars 3 forks source link

NULL bugs (already fixed in execute() ) are still present in query() #5

Closed bbkr closed 5 years ago

bbkr commented 5 years ago

To reproduce:

CREATE TABLE foo ( bar timestamp NULL default NULL ) engine=InnoDB;
INSERT INTO foo (bar) VALUES (NULL);
$mysql.query("SELECT bar FROM foo").arrays;

Result:

Invalid DateTime string ''; use an ISO 8601 timestamp (yyyy-mm-ddThh:mm:ssZ or yyyy-mm-ddThh:mm:ss+01:00) instead

Issue where execute was fixed: https://github.com/CurtTilmes/perl6-dbmysql/issues/2

CurtTilmes commented 5 years ago

Got it -- can't check just the data pointer itself, have to check the extra 'is_null' pointer too.