| Server IP : 66.29.137.217 / Your IP : 18.222.183.63 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/bofirm.gltechlimited.com/vendor/doctrine/dbal/src/Platforms/ |
Upload File : |
<?php
namespace Doctrine\DBAL\Platforms;
use Doctrine\DBAL\Exception;
use function sprintf;
/**
* Provides the behavior, features and SQL dialect of the IBM DB2 11.1 (11.1 GA) database platform.
*
* @deprecated This class will be merged with {@see DB2Platform} in 4.0 because support for IBM DB2
* releases prior to 11.1 will be dropped.
*
* @see https://www.ibm.com/docs/en/db2/11.1?topic=database-whats-new-db2-version-111-ga
*/
class DB2111Platform extends DB2Platform
{
/**
* {@inheritDoc}
*
* @see https://www.ibm.com/docs/en/db2/11.1?topic=subselect-fetch-clause
*/
protected function doModifyLimitQuery($query, $limit, $offset)
{
if ($offset > 0) {
$query .= sprintf(' OFFSET %u ROWS', $offset);
}
if ($limit !== null) {
if ($limit < 0) {
throw new Exception(sprintf('Limit must be a positive integer or zero, %d given', $limit));
}
$query .= sprintf(' FETCH %s %u ROWS ONLY', $offset === 0 ? 'FIRST' : 'NEXT', $limit);
}
return $query;
}
}