Does not support types normally

[roquie]

How to reproduce?
0. Use postgresql

1. Create table

CREATE TABLE test (
    id SERIAL PRIMARY KEY,
    boolfield Boolean not null,
);

2. Execute queries

$con = Connection::fromPDO($this->PDO);
$db = new Database($con);
$db->insert(['boolfield' => true])->into('tree2'); // ok
$db->insert(['boolfield' => false])->into('tree2'); // type err, because PDO::PARAM_STRING used in the $stmt->execute() pdo method by default.

3. Get the following errors

Database error.SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \"\" [ INSERT INTO \"test\" (\"boolfield\") VALUES ('') ] 

The same bug as in Fluentpdo.

How fix it?
Work correctly with PHP types through PDO methods bindValue or bindParam like this:

$stmt->bindValues(1, $value, PDO::PARAM_BOOL);

[roquie]

#39

[msarca]

Fixed in v.4.0.1, thanks