update ADOdb v5.20.0

MyOOS hat einen Fehler, oder tut nicht das, was Ihr erwartet? Derartige "Unanehmlichkeiten" bitte hier.
Antworten
r23
Beiträge: 2625
Registriert: 18.09.2008, 05:56
Wohnort: Hagen
Kontaktdaten:

update ADOdb v5.20.0

Beitrag von r23 »

Hallo,

heute wurde ADOdb 5.20.0 veröffentlicht.

hier die Changelog

5.20.0 - 28-Nov-2015

adodb: Fix regression introduced in v5.19, causing queries to return empty rows. See Github #20, #93, #95
adodb: Fix regression introduced in v5.19 in GetAssoc() with ADODB_FETCH_ASSOC mode and '0' as data. See Github #102
adodb: AutoExecute correctly handles empty result set in case of updates. See Github #13
adodb: Fix regex in Version(). See Github #16
adodb: Align method signatures to definition in parent class ADODB_DataDict. See Github #31
adodb: Improve compatibility of ADORecordSet_empty, thanks to Sjan Evardsson. See Github #43
adodb: fix ADODB_Session::open() failing after successful ADONewConnection() call, thanks to Sjan Evardsson. See Github #44
adodb: Only include memcache library once for PHPUnit 4.x, thanks to Alan Farquharson. See Github #74
adodb: Move() returns false when given row is < 0, thanks to Mike Benoit.
adodb: Add support for pagination with complex queries, thanks to Mike Benoit. See Github #88
adodb: Parse port out of hostname if specified in connection parameters, thanks to Andy Theuninck. See Github #63
adodb: Fix inability to set values from 0 to null (and vice versa) with Active Record, thanks to Louis Johnson. See Github #71
adodb: Fix PHP strict warning in ADODB_Active_Record::Reload(), thanks to Boštjan Žokš. See Github #75
adodb: Add mssql's DATETIME2 type to ADOConnection::MetaType(), thanks to MarcelTO. See Github #80
adodb: When flushing cache, initialize it if it is not set, thanks to Paul Haggart. See Github #57
adodb: Define DB_AUTOQUERY_* constants in main include file. See Github #49
adodb: Improve documentation of fetch mode and assoc case
adodb: Improve logic to build the assoc case bind array
adodb: Strict-standards compliance for function names. See Github #18, #142
adodb: Remove old PHP 4.x constructors for compatibility with PHP 7. See Github #139
adodb: Initialize charset in ADOConnection::SetCharSet. See Github #39
adodb: Fix incorrect handling of input array in Execute(). See Github #146
adodb: Release Recordset when raising exception. See Github #143
adodb: Added new setConnectionParameter() method, currently implemented in mssqlnative driver only. See Github #158.
adodb-lib: Optimize query pagination, thanks to Mike Benoit. See Github #110
memcache: use include_once() to avoid issues with PHPUnit. See http://phplens.com/lens/lensforum/msgs.php?id=19489
mssql_n: Allow use of prepared statements with driver. See Github #22
mssqlnative: Use ADOConnection::outp instead of error_log. See Github #12
mssqlnative: fix failure on Insert_ID() if the insert statement contains a semicolon in a value string, thanks to sketule. See Github #96
mssqlnative: Fix "invalid parameter was passed to sqlsrv_configure" error, thanks to Ray Morris. See Github #103
mssqlnative: Fix insert_ID() failing if server returns more than 1 row, thanks to gitjti. See Github #41
mysql: prevent race conditions when creating/dropping sequences, thanks to MikeB. See Github #28
mysql: Fix adodb_strip_order_by() bug causing SQL error for subqueries with order/limit clause, thanks to MikeB.
mysql: workaround for HHVM behavior, thanks to Mike Benoit.
mysqli: Fix qstr() when called without an active connection. See Github #11
oci8: Fix broken quoting of table name in AddColumnSQL and AlterColumnSQL, thanks to Andreas Fernandez. see Github #67
oci8: Allow oci8 driver to use lowercase field names in assoc mode. See Github #21
oci8po: Prevent replacement of '?' within strings, thanks to Mark Newnham. See Github #132
pdo: Added missing property (fixes PHP notices). see Github #56
pdo: Align method signatures with parent class, thanks to Andy Theuninck. see Github #62
pdo: new sqlsrv driver, thanks to MarcelTO. See Github #81
pdo/mysql: New methods to make the driver behave more like mysql/mysqli, thanks to Andy Theuninck. see Github #40
postgres: Stop using legacy function aliases
postgres: Fix AlterColumnSQL when updating multiple columns, thanks to Jouni Ahto. See Github #72
postgres: Fix support for HHVM 3.6, thanks to Mike Benoit. See Github #87
postgres: Noblob optimization, thanks to Mike Benoit. See Github #112
postgres7: fix system warning in MetaColumns() with schema. See http://phplens.com/lens/lensforum/msgs.php?id=19481
sqlite3: ServerInfo() now returns driver's version
sqlite3: Fix wrong connection parameter in _connect(), thanks to diogotoscano. See Github #51
sqlite3: Fix FetchField, thanks to diogotoscano. See Github #53
sqlite3: Fix result-less SQL statements executed twice. See Github #99
sqlite3: use -1 for _numOfRows. See Github #151
xmlschema: Fix ExtractSchema() when given $prefix and $stripprefix parameters, thanks to peterdd. See Github #92
Convert languages files to UTF-8, thanks to Marc-Etienne Vargenau. See Github #32.


Der adodb: Fix regression introduced in v5.19 in GetAssoc() with ADODB_FETCH_ASSOC mode and '0' as data. See Github #102 kann zu Problemen führen.

Hilfe kann hier die Änderung an der ADODB_ASSOC_CASE in der ~/includes/configure.php sein.

Ändert den Wert einfach auf 2

[php]
define('ADODB_ASSOC_CASE', 2);
[/php]

// ADODB_ASSOC_CASE LOWER = 0 - $rs->fields['orderid']
// ADODB_ASSOC_CASE UPPER = 1 - $rs->fields['ORDERID']
// ADODB_ASSOC_CASE NATIVE = 2 - $rs->fields['OrderID'] (or whatever the RDBMS will return)

Wir verwenden zwar - und empfehlen zwar die Kleinschreibung = 0 aber Abfragen wie

SELECT datenfeld AS mit_Großbuchstaben FROM ... WHERE

führten zu unerwarteten Ergebnissen.

Handbuch von ADOdb 5.20.0 erzeuge ich wegen zeitmangel erst in einem der nächsten Monate.

Die Dokumentation von ADOdb 5.19 habe ich euch hier veröffentlicht:
http://www.oos-shop.de/doc/adodb/html/

Beste Grüße und für morgen wünsche ich euch einen frohen 1. Advent


Ralf
Antworten