MySQL/MariaDB BigInt Primary Key ID not working in Where

Wappler Version : 3.6.1
Operating System : W10
Server Model: PHP
Database Type: MariaDB
Hosting Type: Self

Expected behavior

image808×290 8.29 KB

Running a query on this table returns value correctly on the SQL Server

select id from tbl_x where id = 4659555762231;

Actual behavior

Running the same query via Wappler returns empty result set.

How to reproduce

Create a fresh new table in MariaDB

CREATE TABLE slashash_nh.tbl_test (
	id BIGINT NOT NULL,
	CONSTRAINT tbl_test_PK PRIMARY KEY (id)
)
ENGINE=InnoDB
DEFAULT CHARSET=latin1
COLLATE=latin1_swedish_ci;

Insert a row with id as 4659555762231.
Setup query builder like so:

image931×216 9.33 KB

It should return a blank data set. Even though it returns 1 row when same query is run directly on sql server.

Running the query without the condition returns this:

ID being in double quotes is a bit weird since its supposed to be a number.