diff options
| author | Damien Regad <dregad@mantisbt.org> | 2025-07-19 18:46:15 +0200 |
|---|---|---|
| committer | Damien Regad <dregad@mantisbt.org> | 2025-08-03 18:05:05 +0200 |
| commit | 90a11eb03178e1e9ebd233d497c477fd6a581648 (patch) | |
| tree | 490e4e993efc665caaf29011c597f7842adfd0fe | |
| parent | a78e02e1813da604971bae7632b5b846084485ca (diff) | |
| download | adodb-90a11eb03178e1e9ebd233d497c477fd6a581648.tar.gz adodb-90a11eb03178e1e9ebd233d497c477fd6a581648.tar.bz2 adodb-90a11eb03178e1e9ebd233d497c477fd6a581648.zip | |
Remove unnecessary where clause
According to SQLite schema documentation, the only valid values for
*type* are 'table', 'index', 'view', or 'trigger' [1] so testing for
`type != 'meta'` is useless.
[1]: https://sqlite.org/schematab.html#interpretation_of_the_schema_table
| -rw-r--r-- | drivers/adodb-sqlite3.inc.php | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/drivers/adodb-sqlite3.inc.php b/drivers/adodb-sqlite3.inc.php index 4e2815d6..6fdf2ab8 100644 --- a/drivers/adodb-sqlite3.inc.php +++ b/drivers/adodb-sqlite3.inc.php @@ -219,8 +219,7 @@ class ADODB_sqlite3 extends ADOConnection { */ $sql = "SELECT sql FROM sqlite_master - WHERE type != 'meta' - AND sql NOTNULL + WHERE sql NOTNULL AND LOWER(name) = ?"; $tableSql = $this->getOne($sql, [strtolower($table)]); |