A
A
Anton Chernogolov2020-03-04 18:10:40
firebird
Anton Chernogolov, 2020-03-04 18:10:40

Why does a request to the same Firebird database from php and OO Base work differently?

I'm trying to get data from a Firebird 3 database using php (Laravel - jacquestvanzuydam / laravel-firebird)
There are 664 records in the table. And php sees it.
Here is a request through php that works fine:

select first 10 skip 10 * from "CONTROL_TBL" order by "SNAME" asc

I do it like this:
select first 100 skip 10 * from "CONTROL_TBL" order by "SNAME" asc

I get only 10 records and not 100.
I do this:
select first 10 skip 200 * from "CONTROL_TBL" order by "SNAME" asc

I get: SQLSTATE[HY000]: General error: -802 arithmetic exception, numeric overflow, or string truncation (SQL: select first 10 skip 200 * from "CONTROL_TBL" order by "SNAME" asc)

All the same queries through Open Office Base work wonderful.
The base is 100% the same. Tried through RAW - the same.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dimonchik, 2020-03-04
@dimonchik2013

bye, well, the cant in PDO / ORM, you
need to remember about the shortcomings

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question