protected function limit(&$query)
    {
        switch ($this->mode) {

            case "mysql":
            case "postgres":
            case "redshift":
            case "sqlite":
                $query = preg_replace("/\bFETCH\s+FIRST\s+([0-9]+)\s+ROW(S?)\s+ONLY\b/i", "\nLIMIT $1\n", $query);
                break;

            case "odbc":
                $query = preg_replace("/\bLIMIT\s+([0-9]+)\b/i", "\nFETCH FIRST $1 ROWS ONLY\n", $query);
                break;
        }
    }
protected function limit(&$query)
    {
        switch ($this->mode) {

            case "mysql":
            case "postgres":
            case "redshift":
            case "sqlite":
                $query = preg_replace("/\bFETCH\s+FIRST\s+([0-9]+)\s+ROW(S?)\s+ONLY\b/i", "\nLIMIT $1\n", $query);
                break;

            case "odbc":
                $query = preg_replace("/\bLIMIT\s+([0-9]+)\b/i", "\nFETCH FIRST $1 ROWS ONLY\n", $query);
                break;
        }
    }
protected function limit ( & $ query ) { switch ( $ this -> mode ) { case "mysql" : case "postgres" : case "redshift" : case "sqlite" : $ query = preg_replace ( "/\bFETCH\s+FIRST\s+([0-9]+)\s+ROW(S?)\s+ONLY\b/i" , "\nLIMIT $1\n" , $ query ) ; break ; case "odbc" : $ query = preg_replace ( "/\bLIMIT\s+([0-9]+)\b/i" , "\nFETCH FIRST $1 ROWS ONLY\n" , $ query ) ; break ; } }
Convert any limit usage
Doesn't work with the mssql variety
Convert any limit usage Doesn t work with the mssql variety