diff options
| author | Damien Regad <dregad@mantisbt.org> | 2025-07-19 18:44:59 +0200 |
|---|---|---|
| committer | Damien Regad <dregad@mantisbt.org> | 2025-08-03 18:05:05 +0200 |
| commit | a78e02e1813da604971bae7632b5b846084485ca (patch) | |
| tree | e01ab057adc95c82745e9f0841e09d38974c4b50 | |
| parent | 5b8bd52cdcffefb4ecded1b399c98cfa516afe03 (diff) | |
| download | adodb-a78e02e1813da604971bae7632b5b846084485ca.tar.gz adodb-a78e02e1813da604971bae7632b5b846084485ca.tar.bz2 adodb-a78e02e1813da604971bae7632b5b846084485ca.zip | |
Remove unnecessary subquery in metaForeignKeys()
| -rw-r--r-- | drivers/adodb-sqlite3.inc.php | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/drivers/adodb-sqlite3.inc.php b/drivers/adodb-sqlite3.inc.php index 564eec95..4e2815d6 100644 --- a/drivers/adodb-sqlite3.inc.php +++ b/drivers/adodb-sqlite3.inc.php @@ -218,10 +218,7 @@ class ADODB_sqlite3 extends ADOConnection { * Read sqlite master to find foreign keys */ $sql = "SELECT sql - FROM ( - SELECT sql sql, type type, tbl_name tbl_name, name name - FROM sqlite_master - ) + FROM sqlite_master WHERE type != 'meta' AND sql NOTNULL AND LOWER(name) = ?"; |