PostgreSQL LIMIT with OFFSET fails

[jerrac]

Describe the bug When trying to limit a select query, and using an offset, the limit is just left off the query entirely.

Information

• Version of Medoo: 1.6
• Type of Database (MySQL, MSSQL, SQLite...): PostgreSQL 10
• System (Liunx\Windows\Mac): Linux (Ubuntu 18.04 is executing the php code. The db server is on CentOS 7 with the official PostgreSQL yum repo enabled.)

Detail Code $this->db is from new Medoo(...);.

$offset = 0;
$size = 100;
 $get = $this->db->select('actions_data',
                  ['id', 'action', 'udcid', 'field', 'value', 'created'],
                  ['LIMIT' => [$offset, $size]]
                );

Using xdebug, I can tell the sql statement is:

SELECT "id","action","udcid","field","value","created" FROM "actions_data"

Expected output I expect a result with 100, or fewer, results.

The query should have looked like:

SELECT "id","action","udcid","field","value","created" FROM "actions_data" LIMIT 100 OFFSET 0;

The $offset value changes based on the results of a loop that processes each returned row.

What I get is all 1.8 million rows in my database table.

[jerrac]

Never mind. If found some code before my select call if(empty($offset)) can evaluate to true when $offset = 0... Inside that if statement, I was selecting all rows.