| Age | Commit message (Collapse) | Author | Files | Lines |
|
|
|
- running SED script
- manual adjustments for files not processed by regex
|
|
|
|
Optimize query pagination when row counting is disabled. Rather than
issue 3+ separate queries, it simply uses just one in most cases,
resulting in huge performance increases especially on large tables.
Fixes #110
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
There are cases where ADODB is not be able to figure out the proper
count(*) queries for PageExecute() on its own.
To work around this problem, ADOdb now handles a new keyword
"_ADODB_COUNT" that can be wrapped around the parts of the SQL query
that should be replaced with "COUNT(*)"; the code will remove everything
between and including the _ADODB_COUNT keywords and replace it with
COUNT(*). The _ADODB_COUNT tags are of course removed when COUNT(*) is
not needed.
Example usage:
SELECT
_ADODB_COUNT
col1,
col2,
col3,
( select col4 from table2 where col1=col2 )
col4,
_ADODB_COUNT
FROM table1
LEFT JOIN ( select col5 from table3 where col3=col4 ) AS tmp;
Original 2012 bug report: http://phplens.com/lens/lensforum/msgs.php?id=19058
The fix has been in use since that time in hundreds of thousands of
production installations.
Fixes #88
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
The original regex was causing sub-query with ORDER BY and LIMIT
clauses to be stripped out, resulting in multiple rows being returned
and causing a SQL error.
Example queries that were failing:
* SELECT name, ( SELECT id FROM tmp_table LIMIT 1 ) FROM table;
* SELECT id FROM ( SELECT id FROM tmp_table LIMIT 1 ) AS table;
Signed-off-by: Damien Regad <dregad@mantisbt.org>
|
|
Fixes #32
|
|
|
|
|
|
http://php.net/manual/en/language.basic-syntax.phptags.php
|
|
|
|
See https://sourceforge.net/p/adodb/bugs/127/
|
|
Implementing the patch submitted by Mike in
http://phplens.com/lens/lensforum/msgs.php?id=17813
|
|
Bumped 'dev' version allows users who rely on source code downloaded
from the git repository rather than an official release tarball to
reliably determine that they are running a development version of the
library.
|
|
- Move all files in adodb5/ to root
- Remove adodb-for-php4/ directory
|