Insert max UInt64

[simPod]

How do you insert 18446744073709551615 value to column of type UInt64? Thx

[isublimity]

I think it's not easy to decide ;(
There is a system limitation is PHP_INT_MAX = 9223372036854775807
If variable more than PHP auto convert to Float : Integer overflow on a 64-bit system
http://php.net/manual/en/language.types.integer.php

https://stackoverflow.com/questions/34033575/is-it-possible-to-use-a-large-unsigned-int64-without-losing-precision-in-php

https://stackoverflow.com/questions/864058/how-to-have-64-bit-integer-on-php

Try use direct write gmp_strval and $client->transport()->write('INSERT INTO ')

$client = new ClickHouseDB\Client($config);
$client->write('DROP TABLE IF EXISTS _phpCh_UINT64Test');
$client->write('CREATE TABLE _phpCh_UINT64Test (ui64 UInt64) Engine=Log');

//
$value="18446744073709551615"; // WARN! STRING !
//
$client->transport()->write('INSERT INTO _phpCh_UINT64Test VALUES ( '.gmp_strval($value).' )');
echo "insert done\n";
print_r($client->select('SELECT ui64 FROM _phpCh_UINT64Test')->rows());

[simPod]

I'm preparing a PR with friendlier approach. I just wanted to check whether you have stumbled upon this and have solution or not. Thanks!

I'd leave this open until that PR submission.

[isublimity]

@simPod Clouse issue - "as an unsolvable" ?

[simPod]

Will look at it tomorrow, create test case at least and then shall see, k?

…

On Mon, Sep 24, 2018, 21:09 Igor Strykhar ***@***.***> wrote: @simPod <https://github.com/simPod> Clouse issue - "as an unsolvable" ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#80 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAUAJS7bsqGsGDscEL8I5OzTIuEEtqibks5ueS3MgaJpZM4VraNO> .

[isublimity]

Good work! Thx!