Comments (5)
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/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());
from phpclickhouse.
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.
from phpclickhouse.
@simPod Clouse issue - "as an unsolvable" ?
from phpclickhouse.
from phpclickhouse.
Good work! Thx!
from phpclickhouse.
Related Issues (20)
- ALTER TABLE? How? HOT 2
- FR: progressFunction on write
- help
- Unexpected readonly mode with specific string in query HOT 3
- Error use
- connect on domain
- Operation timed out after 60000 milliseconds with 0 bytes received
- How to check insertBatchFiles is finished HOT 1
- Using insertBatchFiles with CSVWithNamesAndTypes is not possible HOT 3
- Critical errror with insert. HOT 3
- Converting boolean when inserting into int
- Php syntax error in php ^7.3 HOT 1
- Error when inserting boolean values HOT 2
- readonly flag doesn't work with insert() HOT 2
- Undefined constant "ClickHouseDB\Transport\CURLOPT_SSL_VERIFYHOST HOT 1
- error on update query
- Long running no data query Timeout "Operation timed out" HOT 1
- Specific value inside a raw marks response as failed
- Async insert without CSV? HOT 1
- Inserting a Map results in an error about expecting Map but got Array
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from phpclickhouse.