c93365bdc94273b8de49d278eeb03ea747993c56
[Packages/TYPO3.CMS.git] / typo3 / sysext / dbal / ChangeLog
1 2007-05-30 Karsten Dambekalns <karsten@typo3.org>
2
3 * Added default values and some usability improvements to cached info display in debug module (closes bug #3750)
4 * EXPLAIN PLAN support for Oracle (closes bug #3850)
5 * Fixed a warning when using admin_get_fields() on a non-existent table
6 * Fixed a bug causing inserts with more than one affected CLOB field to fail
7 * quoteWhereClause() now die()s when the input cannot be parsed by parseWhereClause()
8 * PHP backtraces can be logged with the queries now (closes bug #3856)
9
10 2007-05-29 Karsten Dambekalns <karsten@typo3.org>
11
12 * Closes bug #4462: creates tables without OIDs on PostgreSQL now
13 * Closes bugs #4494, #3759: & is translated to BITAND() on Oracle now
14 * Large text fields are CLOB fields now; for Oracle LIKE comparisons against such fields are translated to dbms_lob.instr() calls. This should fix e.g. bug #5535 as well as issues with TV data that cannot be unserialized (see comments on bug #4638)
15 * Updates to the manual
16 * A fix for bug #5481, field mapping not working on the right side of a comparison in WHERE clauses
17 * Fixed bugs #2438 and #4496 about quoting of DISTINCT in SELECT clauses
18
19 2006-07-19 Karsten Dambekalns <karsten@typo3.org>
20
21 * Fixes SQL issues when searching in list view or with the global search box on the bottom of the BE page
22
23 2006-06-30 Karsten Dambekalns <karsten@typo3.org>
24
25 * this update closes bugs #3638, #2106, #2866, #3754 (for Firefox, broken in MSIE) and maybe a few more
26 * Implemented support for sysLog() on connection failure
27 * DBAL now honours the no_pconnect setting
28 * For handlers in native mode the setDBinit queries are executed upon connection
29 * The initial value for generated sequences can be configured per handler, to avoid duplicate key errors after having imported data
30 * BLOB fields are handled correctly now during INSERT and UPDATE
31 * Setting $store_lastBuiltQuery acts like in t3lib_db now (fill $debug_lastBuiltQuery)
32 * For the native handler quoting methods directly return the input for speedup, as no quoting is needed in that case
33 * Added support for native and userdefined handler to MetaType()
34 * Changed mapping of types to always use the largest possible integer, map tinytext to varchar instead of text
35 * admin_get_tables() skips tables whose names match /BIN\$/ (coming from the recycle bin on Oracle)
36 * Importing dumps using the install tool now works, see manual for tips
37 * Changed the way NOT NULL and DEFAULT are handled when setting up tables, see manual for the rules that now apply
38 * Code cleanup (indentation, documentation)
39 * Updated the manual and added new content
40
41 2006-01-19 Karsten Dambekalns <karsten@typo3.org>
42
43 * Changes to connection handling, detecting failed connections.
44 * Added support for $no_quote_fields in UPDATE and INSERT methods.
45
46 2006-01-04 Karsten Dambekalns <karsten@typo3.org>
47
48 * Changed the way a connection is established with ADOdb. The new
49 way allows ODBC connections (rather, connections to drivers having
50 an underscore in their name).
51 * Changes to ext_tables.sql to make it more portable.
52 * When printing errors, output the offending SQL as well.
53 * Some small fixes, enhancements to code documentation.
54 * Some additions to the manual.
55
56 2005-12-27 Karsten Dambekalns <karsten@typo3.org>
57
58 * Converted locallang to XML, small adaptions to syext location.
59 * One slight fix to the SQL check in the BE module (wrong output if
60 an error occurred).
61
62 2005-12-26 Karsten Dambekalns <karsten@typo3.org>
63
64 * Code cleanup and improvements to the mapping. Merged 3rd
65 party changes done by DIACC GmbH.
66
67 2005-12-23 Karsten Dambekalns <karsten@typo3.org>
68
69 * Fixed a few issues that were left undiscovered yet.
70 * Added a new module to test query building and parsing
71 from the DBAL debug module.
72 * Finalized fix for bug #1649.
73
74 2005-12-22 Karsten Dambekalns <karsten@typo3.org>
75
76 * Fixed bug #2077 (NOT handling breaking, consequently
77 discarding WHERE clauses).
78
79 2005-12-21 Karsten Dambekalns <karsten@typo3.org>
80
81 * Fixed bug #1781 to allow easier install.
82 * Closed bug #1204 as not reproducable. Probably rather a
83 PHP/Apache bug than a DBAL bug.
84 * Closed bug #1317 which has been fixed earlier. It was due
85 to a msissing check for the incoming SQL (string/array) in the
86 native part of exec_UPDATEquery().
87 * Fixed parseFieldDef() t3lib_sqlparser to allow datatypes
88 with just a trailing comma (like in "tyinytext," as opposed
89 to "varchar(19)". This prevented installation of some
90 extensions.
91 * Fixed bug #2072.
92 * Fixed bug #1206.
93 * Fixed a bug with error logging and array queries (BLOB).
94 * Prepared a fix for bug #1649, pending core list approval.
95 * Fixed a bug in t3lib_page, getMultipleGroupsWhereClause()
96 where double quotes were used to quote a literal for use in
97 SQL. THIS IS MYSQL-ONLY! NEVER DO THIS! ALWAYS USE SINGLE
98 QUOTES!
99
100 2005-06-07 Karsten Dambekalns <karsten@typo3.org>
101
102 Documentation update.
103
104 2005-05-19 Karsten Dambekalns <karsten@typo3.org>
105
106 Committed changes to go along with the library removal done
107 earlier. Completed debug logging.
108
109 2005-02-07 Karsten Dambekalns <karsten@typo3.org>
110
111 Bringing the DBAL extension AS OF JANUARY 2005 into CVS. Works
112 pretty well, but still needs more work. A few optimizations are
113 planned and some bugs in native mode need to be fixed. Checking
114 this in is (similar to yesterday's commit) more for
115 historic/archival reasons. This version will NOT work with 3.7.x.
116 You have been warned.
117
118 2005-02-06 Karsten Dambekalns <karsten@typo3.org>
119
120 Bringing the DBAL extension AS OF JULY 2004 into CVS. This is
121 rather for historic purposes, more changes will follow in the near
122 future. This version was already a huge step forward, but it will
123 not work as expected with 3.7.x or 3.8.x. You have been warned.
124
125 2004-03-28 Kasper Skaarhoej <kasperYYYY@typo3.com>
126
127 Initial revision