[dbsrgits/DBIx-Class.git] / WHATSNEW.txt

NOTE: do not merge this file but DELETE IT on merge

New in this branch:

 * Converted test cases to use SQL::Abstract::Test if available.
	* created DBIC::SqlMakerTest and DBIC::DebugObj helper modules
 	* that way the number of extra parens does not matter
 	* test cases still pass with SQLA 1.24, but also with 1.50RC
		* those tests that make no sense with older SQLA are skipped
	* Added dependency for Test::Deep (used when emulating SQL::Abstract::Test::eq_bind when SQLA is older than 1.50)

 * Removed a wrong TODO test: 95sql_maker_quote.t/"order_by with quoting needs fixing (ash/castaway)"
 	* it never passed and never will (SQLA should not parse the strings in order_by)
 	* asked by mst

 * Made a TODO test non-TODO: 95sql_maker_quote.t/"select attr with star needs fixing (mst/nate)"
 	* this works with SQLA 1.50

 * Removed dead code from DBI::Class::Storage::DBI (sub _RowNumberOver).
 	* neither DBIC, nor SQLA, nor SQLA::Limit uses this (in any version supported by DBIC)

 * Added test cases for every supported order_by syntax.
 * Made DBIC::SQL::Abstract pass on order_by hashref ({-desc => 'colname'}) to SQL::Abstract.
 	* this is the blessed way of doing order by
	* new SQLA supports it
	* formerly DBIC considered this as an error
 * Documented using order_by hashref in DBIx::Class::ResultSet.

 * Added test cases to test if arrayref bind values in insert/update are passed through sql_maker intact.
 * Added test cases to test if arrayref bind values work with a PostgreSQL array type.
 * Added 'array_datatypes' parameter to the sql_maker constructor.
	* formerly SQLA considered these as literal SQL with bind values, now that is \['literal SQL', @bind]
		* the new syntax is consistent (works the same in insert/update and where conditions)
	* fortunately 'array_datatypes' was simply ignored by old SQLA (at least with current version..)
 	* DBD::Pg can use arrayref bind values for PostgreSQL array types
 * Documented using PostgreSQL arrays (in Cookbook).

 * Fixed/improved a few skip and diag messages.
Commit	Line	Data
89479564	1	NOTE: do not merge this file but DELETE IT on merge
3578f8c6	2
	3	New in this branch:
	4
0e0eb76d	5	* Converted test cases to use SQL::Abstract::Test if available.
	6	* created DBIC::SqlMakerTest and DBIC::DebugObj helper modules
	7	* that way the number of extra parens does not matter
	8	* test cases still pass with SQLA 1.24, but also with 1.50RC
	9	* those tests that make no sense with older SQLA are skipped
	10	* Added dependency for Test::Deep (used when emulating SQL::Abstract::Test::eq_bind when SQLA is older than 1.50)
3578f8c6	11
	12	* Removed a wrong TODO test: 95sql_maker_quote.t/"order_by with quoting needs fixing (ash/castaway)"
	13	* it never passed and never will (SQLA should not parse the strings in order_by)
	14	* asked by mst
	15
	16	* Made a TODO test non-TODO: 95sql_maker_quote.t/"select attr with star needs fixing (mst/nate)"
	17	* this works with SQLA 1.50
	18
	19	* Removed dead code from DBI::Class::Storage::DBI (sub _RowNumberOver).
0e0eb76d	20	* neither DBIC, nor SQLA, nor SQLA::Limit uses this (in any version supported by DBIC)
3578f8c6	21
	22	* Added test cases for every supported order_by syntax.
	23	* Made DBIC::SQL::Abstract pass on order_by hashref ({-desc => 'colname'}) to SQL::Abstract.
	24	* this is the blessed way of doing order by
	25	* new SQLA supports it
	26	* formerly DBIC considered this as an error
0e0eb76d	27	* Documented using order_by hashref in DBIx::Class::ResultSet.
3578f8c6	28
3578f8c6	29	* Added test cases to test if arrayref bind values in insert/update are passed through sql_maker intact.
89479564	30	* Added test cases to test if arrayref bind values work with a PostgreSQL array type.
3578f8c6	31	* Added 'array_datatypes' parameter to the sql_maker constructor.
	32	* formerly SQLA considered these as literal SQL with bind values, now that is \['literal SQL', @bind]
	33	* the new syntax is consistent (works the same in insert/update and where conditions)
0e0eb76d	34	* fortunately 'array_datatypes' was simply ignored by old SQLA (at least with current version..)
89479564	35	* DBD::Pg can use arrayref bind values for PostgreSQL array types
0e0eb76d	36	* Documented using PostgreSQL arrays (in Cookbook).
	37
	38	* Fixed/improved a few skip and diag messages.