bccomp() type error on certain MySQL column types

[Endermanbugzjfc]

Describe the bug

Fatal error: Uncaught TypeError: bccomp() expects parameter 1 to be string, int given in phar:///home/container/virions/libasynql.phar/src/poggit/libasynql/mysqli/MysqliThread.php:186
Stack trace:
#0 phar:///home/container/virions/libasynql.phar/src/poggit/libasynql/mysqli/MysqliThread.php(186): bccomp(1, '922337203685477...')
#1 phar:///home/container/virions/libasynql.phar/src/poggit/libasynql/mysqli/MysqliThread.php(224): poggit\libasynql\mysqli\MysqliThread->poggit\libasynql\mysqli\{closure}(1)
#2 phar:///home/container/virions/libasynql.phar/src/poggit/libasynql/mysqli/MysqliThread.php(155): poggit\libasynql\mysqli\MysqliThread->toSelectResult(Object(mysqli_result))
#3 phar:///home/container/virions/libasynql.phar/src/poggit/libasynql/base/SqlSlaveThread.php(85): poggit\libasynql\mysqli\MysqliThread->executeQuery(Object(mysqli), 3, 'SELECT record_i...', Array)
#4 [internal function]: poggit\libasynql\base\SqlSlaveThread->run()
#5 {main}
thrown in phar:///home/container/virions/libasynql.phar/src/poggit/libasynql/mysqli/MysqliThread.php on line 186

Sample code

-- #            { pre_registered
-- #              :username string
SELECT record_id
FROM pre_registered
WHERE username = :username
LIMIT 1;
-- #            }

Expected behavior

record_id is a unsigned bigint, the error didn't occur when no result is selected

Environment

OS: linux and idk other stuffs (Same result on Windows10) PocketMine version: 3.14.2 Libasynql version: 3.3.1

[Endermanbugzjfc]

Somehow fixed by setting record_id to unsigned int

[SOF3]

This seems a bug indeed.

[matcracker]

Hi, I had the same problem today. ~Why is it necessary to manage precision? We shouldn't worry as we are using PHP 64-bit.~

Otherwise we need to use CONVERT function or use GMP extension but I don't think it's included in PocketMine binaries files.

[matcracker]

However, there would be a problem, int casting is not possible. We must therefore transform the value into a float.

[SOF3]

unsigned longs?