Bug #81534 [NEW]: Math Functions are not working on SQLITE connection.

From: Date: Mon, 18 Oct 2021 06:10:49 +0000
Subject: Bug #81534 [NEW]: Math Functions are not working on SQLITE connection.
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-237247@lists.php.net to get a copy of this message 
From:             iyashpal dot dev at gmail dot com
Operating system: Windows 11
PHP version:      8.0.11
Package:          PDO SQLite
Bug Type:         Bug
Bug description:Math Functions are not working on SQLITE connection.

Description:
------------
PHP Version: 8.0.11
OS Edition: Windows 11 Pro
OS Version: 21H2
OS Build: 22000.258

PHP Framework Used: Laravel 8.63
 

Test script:
---------------
Route::get('/', function () {

    $sqlite = new SQLite3(base_path('sqlite3.dbi'),
SQLITE3_OPEN_READWRITE);


    dd($sqlite->query('SELECT SQRT(4)'));
    dd(DB::select("SELECT SQRT(4)"));
    return view('welcome');
});

Expected result:
----------------
Should show 2

Actual result:
--------------
ErrorException
SQLite3::query(): Unable to prepare statement: 1, no such function: SQRT

-- 
Edit bug report at https://bugs.php.net/bug.php?id=81534&edit=1
-- 
Fix committed:                    https://bugs.php.net/fix.php?id=81534&r=fixed
Fixed in release:                 https://bugs.php.net/fix.php?id=81534&r=alreadyfixed
Need backtrace:                   https://bugs.php.net/fix.php?id=81534&r=needtrace
Need Reproduce Script:            https://bugs.php.net/fix.php?id=81534&r=needscript
Try newer version:                https://bugs.php.net/fix.php?id=81534&r=oldversion
Not developer issue:              https://bugs.php.net/fix.php?id=81534&r=support
Expected behavior:                https://bugs.php.net/fix.php?id=81534&r=notwrong
Not enough info:                  https://bugs.php.net/fix.php?id=81534&r=notenoughinfo
Submitted twice:                  https://bugs.php.net/fix.php?id=81534&r=submittedtwice
register_globals:                 https://bugs.php.net/fix.php?id=81534&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=81534&r=phptooold
Daylight Savings:                 https://bugs.php.net/fix.php?id=81534&r=dst
IIS Stability:                    https://bugs.php.net/fix.php?id=81534&r=isapi
Install GNU Sed:                  https://bugs.php.net/fix.php?id=81534&r=gnused
Floating point limitations:       https://bugs.php.net/fix.php?id=81534&r=float
No Zend Extensions:               https://bugs.php.net/fix.php?id=81534&r=nozend
MySQL Configuration Error:        https://bugs.php.net/fix.php?id=81534&r=mysqlcfg

Thread (12 messages)

« previous php.bugs (#237247) next »