15 years agoAdded AmbiguousGlob.pm for silly servers like mssql and mysql. See docs for more...
Arthur Axel "fREW" Schmidt [Tue, 9 Jun 2009 21:49:10 +0000]
Added AmbiguousGlob.pm for silly servers like mssql and mysql.  See docs for more info

15 years agomore tests for SQL Server!
Arthur Axel "fREW" Schmidt [Tue, 9 Jun 2009 21:18:46 +0000]
more tests for SQL Server!

15 years agoMerge 'trunk' into 'mssql_top_fixes'
Peter Rabbitson [Tue, 9 Jun 2009 04:56:41 +0000]
Merge 'trunk' into 'mssql_top_fixes'

r6553@Thesaurus (orig r6552):  ribasushi | 2009-06-08 23:56:41 +0200
duh

15 years agoduh
Peter Rabbitson [Mon, 8 Jun 2009 21:56:41 +0000]
duh

15 years agoSimply order_by/_virtual_order_by handling
Peter Rabbitson [Mon, 8 Jun 2009 09:36:56 +0000]
Simply order_by/_virtual_order_by handling

15 years agoFix find_or_new/create to stop returning random rows when default value insert is...
Peter Rabbitson [Sun, 7 Jun 2009 23:24:06 +0000]
Fix find_or_new/create to stop returning random rows when default value insert is requested

15 years agoMake podcoverage happy
Peter Rabbitson [Sun, 7 Jun 2009 23:03:04 +0000]
Make podcoverage happy

15 years agoAdd mysql empty insert SQL override
Peter Rabbitson [Sun, 7 Jun 2009 22:59:21 +0000]
Add mysql empty insert SQL override
Make SQLAHacks parts loadable at runtime via ensure_class_loaded

15 years agoMake empty/default inserts use standard SQL
Peter Rabbitson [Sun, 7 Jun 2009 21:36:43 +0000]
Make empty/default inserts use standard SQL

15 years agoFix for mysql subquery problem
Peter Rabbitson [Sun, 7 Jun 2009 21:07:55 +0000]
Fix for mysql subquery problem

15 years agoPort another forgotten MC fix
Peter Rabbitson [Sat, 6 Jun 2009 08:50:56 +0000]
Port another forgotten MC fix

15 years agoTODOified reentrancy counter - this shall be used to optimize MC some day
Peter Rabbitson [Sat, 6 Jun 2009 08:47:47 +0000]
TODOified reentrancy counter - this shall be used to optimize MC some day

15 years agorename MC test dir
Peter Rabbitson [Sat, 6 Jun 2009 08:45:10 +0000]
rename MC test dir

15 years agoFactor out the grouped count subquery SELECTor so specific storage classes can overri...
Peter Rabbitson [Fri, 5 Jun 2009 17:25:56 +0000]
Factor out the grouped count subquery SELECTor so specific storage classes can override it
Trim attribute deletion lists - we work with _resolved_attrs - +X are already folded into X and the like

15 years agoThis was dumb - of course I want a copy
Peter Rabbitson [Fri, 5 Jun 2009 14:28:58 +0000]
This was dumb - of course I want a copy
Otherwise the next serach_related will work with a contaminated seen_joins

15 years agoIt seems that this localisation can lead to problems
Peter Rabbitson [Thu, 4 Jun 2009 21:51:13 +0000]
It seems that this localisation can lead to problems
Unfortunately no test case as the trigger was buried deep within Reaction, I coulnd't figure out an isolation

15 years agohaving without group_by is useless - thus do not supply a group_by on count, let...
Peter Rabbitson [Thu, 4 Jun 2009 20:54:28 +0000]
having without group_by is useless - thus do not supply a group_by on count, let things die

15 years agoReally delegate counting to the storage class - now we have either a grouped count...
Peter Rabbitson [Thu, 4 Jun 2009 13:38:21 +0000]
Really delegate counting to the storage class - now we have either a grouped count or a regular one

15 years agoDelegate actual counting to the storage class
Peter Rabbitson [Thu, 4 Jun 2009 09:52:18 +0000]
Delegate actual counting to the storage class

15 years agoMove relationship tests around
Peter Rabbitson [Thu, 4 Jun 2009 07:35:25 +0000]
Move relationship tests around

15 years agoRequire a recent version of Date::Simple during CDBI tests
Peter Rabbitson [Wed, 3 Jun 2009 08:14:51 +0000]
Require a recent version of Date::Simple during CDBI tests

15 years agoFix fallout from another botched merge (I suck, part 2)
Peter Rabbitson [Mon, 1 Jun 2009 14:49:09 +0000]
Fix fallout from another botched merge (I suck, part 2)

15 years agoMerge 'order_by_refactor' into 'trunk'
Peter Rabbitson [Mon, 1 Jun 2009 14:41:49 +0000]
Merge 'order_by_refactor' into 'trunk'

15 years agodeploy-related pod fixes
Peter Rabbitson [Mon, 1 Jun 2009 10:24:41 +0000]
deploy-related pod fixes

15 years agoLast set of Makefile.PL optimizations
Peter Rabbitson [Sun, 31 May 2009 14:07:18 +0000]
Last set of Makefile.PL optimizations

15 years agoThere is a saner way to write out resources
Peter Rabbitson [Sun, 31 May 2009 09:24:15 +0000]
There is a saner way to write out resources

15 years agoThrow away the makefile SQLite test - it served its purpose
Peter Rabbitson [Sun, 31 May 2009 07:42:35 +0000]
Throw away the makefile SQLite test - it served its purpose

15 years agoM::I 0.89 finally resolves all provlems with auto_install
Peter Rabbitson [Sun, 31 May 2009 07:37:37 +0000]
M::I 0.89 finally resolves all provlems with auto_install

15 years agopopulate() fix and Changes
Peter Rabbitson [Sat, 30 May 2009 17:46:09 +0000]
populate() fix and Changes

15 years agoAdd changes
Peter Rabbitson [Sat, 30 May 2009 17:17:02 +0000]
Add changes

15 years agoEvil hack to make Carp::Clan work throughout SQLA as well
Peter Rabbitson [Sat, 30 May 2009 17:13:23 +0000]
Evil hack to make Carp::Clan work throughout SQLA as well

15 years agoGreatly simplify _order_by override to fallback on new SQLA
Peter Rabbitson [Sat, 30 May 2009 15:15:57 +0000]
Greatly simplify _order_by override to fallback on new SQLA

15 years agoRestructure bind tests
Peter Rabbitson [Sat, 30 May 2009 14:55:37 +0000]
Restructure bind tests

15 years agoTODOify some of the order with bind tests
Peter Rabbitson [Sat, 30 May 2009 14:54:37 +0000]
TODOify some of the order with bind tests

15 years agoorder_by tests
Moritz Onken [Sat, 30 May 2009 09:06:54 +0000]
order_by tests

15 years agoAdd better error reporting on bulk_insert (ash++)
Peter Rabbitson [Sat, 30 May 2009 07:34:20 +0000]
Add better error reporting on bulk_insert (ash++)

15 years agoPatch + test for more informative exceptions on load_namespace a non-rs class
Peter Rabbitson [Sat, 30 May 2009 05:40:24 +0000]
Patch + test for more informative exceptions on load_namespace a non-rs class

15 years agoFix multiprefetch warning - we can now count properly
Peter Rabbitson [Thu, 28 May 2009 11:02:22 +0000]
Fix multiprefetch warning - we can now count properly

15 years agoCommit rather useless but already written mysql test extension
Peter Rabbitson [Thu, 28 May 2009 08:20:57 +0000]
Commit rather useless but already written mysql test extension

15 years agoRelease 0.08103 v0.08103
Peter Rabbitson [Tue, 26 May 2009 20:02:29 +0000]
Release 0.08103

15 years agoAttempt to reproduce reported mysql error (failed) - fixed another bug in ResultSetCo...
Peter Rabbitson [Tue, 26 May 2009 19:28:49 +0000]
Attempt to reproduce reported mysql error (failed) - fixed another bug in ResultSetColumn along the way

15 years agofix comments
Peter Rabbitson [Tue, 26 May 2009 18:49:49 +0000]
fix comments

15 years agoMinor fixes of the return value of rs->update/delete
Peter Rabbitson [Tue, 26 May 2009 15:20:57 +0000]
Minor fixes of the return value of rs->update/delete

15 years agoFix test skip message
Peter Rabbitson [Tue, 26 May 2009 14:36:55 +0000]
Fix test skip message

15 years agoMerge 'top_limit_altfix' into 'trunk'
Peter Rabbitson [Tue, 26 May 2009 14:29:55 +0000]
Merge 'top_limit_altfix' into 'trunk'

15 years agoFix 'timestamp with time zone' columns for IC::DT inflation
Ash Berlin [Tue, 26 May 2009 14:17:44 +0000]
Fix 'timestamp with time zone' columns for IC::DT inflation

15 years agoTODOified test for RT#40701
Peter Rabbitson [Tue, 26 May 2009 06:15:34 +0000]
TODOified test for RT#40701

15 years agoThis method does not exist anymore
Peter Rabbitson [Mon, 25 May 2009 17:42:02 +0000]
This method does not exist anymore

15 years agoSmall documentation improvement: link to a documented method.
Tom Hukins [Mon, 25 May 2009 16:33:46 +0000]
Small documentation improvement:  link to a documented method.

15 years agoToo much logic for no benefit - always populate _virtual_order_by
Peter Rabbitson [Mon, 25 May 2009 15:45:33 +0000]
Too much logic for no benefit - always populate _virtual_order_by

15 years agoActually don't need this anymore
Peter Rabbitson [Mon, 25 May 2009 14:53:13 +0000]
Actually don't need this anymore

15 years agoMerge 'top_limit_tweaks' into 'top_limit_altfix'
Peter Rabbitson [Mon, 25 May 2009 14:08:40 +0000]
Merge 'top_limit_tweaks' into 'top_limit_altfix'

Shoot another Top problem, move test from top_limit_tweaks branch and delete

15 years agoThe Top limit emulation bundled with SQLA::Limit assumes that the limited resultset...
Peter Rabbitson [Mon, 25 May 2009 09:24:32 +0000]
The Top limit emulation bundled with SQLA::Limit assumes that the limited resultset will be _always_ sorted. In order to fix this, I reimplemented _Top in SQLAHacks with a slight modification. Now the original order_by is passed to the outside of the nested select block, while order_up/down are calculated either based on the original order_by, or if one is not present an order by all PKs is attempted.
Since I do not have access to $rsrc in SQLA, I pass the list of PKs as an extra group_by hash entry. This appears to be rather safe, and besides we already pollute order_by with group_by and having (which seems to work rather well).
The only thing I am unsure about is the need for _gen_virtual_order(). Initially I was going to generate the pk list, only if we use the Top limit. Then it turned out there is no limit dialect before we connect, so I commented it out. Now all it does is check for a limit condition and returns the PK list. Is this necessary at all?

15 years agoDefine how Top limit emulation should behave
Peter Rabbitson [Mon, 25 May 2009 09:11:01 +0000]
Define how Top limit emulation should behave

15 years agoForgotten podcoverage override
Peter Rabbitson [Mon, 25 May 2009 07:47:01 +0000]
Forgotten podcoverage override

15 years agoMove the DB2 Limit syntax setting into the storage class
Peter Rabbitson [Mon, 25 May 2009 07:42:45 +0000]
Move the DB2 Limit syntax setting into the storage class

15 years agoFactor out the order_by sqlahacks resolver
Peter Rabbitson [Mon, 25 May 2009 06:48:38 +0000]
Factor out the order_by sqlahacks resolver

15 years agoadded test to make sure only one connection to ODBC/MSSQL is made
Rafael Kitover [Sun, 24 May 2009 23:53:12 +0000]
added test to make sure only one connection to ODBC/MSSQL is made

15 years agofix double connect for ODBC/MSSQL
Rafael Kitover [Sun, 24 May 2009 23:49:17 +0000]
fix double connect for ODBC/MSSQL

15 years agoSwitch around inheritance of MSSQL drivers, remove some duplicate code
Peter Rabbitson [Sun, 24 May 2009 20:53:15 +0000]
Switch around inheritance of MSSQL drivers, remove some duplicate code

15 years agoFailing test about warnings triggered in SQLA::Limit when using a subquery
Peter Rabbitson [Sun, 24 May 2009 13:35:07 +0000]
Failing test about warnings triggered in SQLA::Limit when using a subquery

15 years agoeol adjustments
Peter Rabbitson [Sun, 24 May 2009 13:00:50 +0000]
eol adjustments

15 years agoDeprecate ::DBI::Sybase::MSSQL
Peter Rabbitson [Sun, 24 May 2009 12:12:39 +0000]
Deprecate ::DBI::Sybase::MSSQL

15 years agoSUPER is so last century
Peter Rabbitson [Sun, 24 May 2009 09:43:32 +0000]
SUPER is so last century

15 years agoMake sure we do not clobber search attributes when using subqueries
Peter Rabbitson [Sun, 24 May 2009 09:42:01 +0000]
Make sure we do not clobber search attributes when using subqueries

15 years agoMSSQL through ODBC does not like unfinished statements - make sure we finish the...
Peter Rabbitson [Sun, 24 May 2009 08:47:03 +0000]
MSSQL through ODBC does not like unfinished statements - make sure we finish the scope identity retrieval
(This worked before because of the automatic retry on exception, essentially running any select after insert twice)

15 years agoExtend distinct deprecation tests and clarify warnings
Peter Rabbitson [Sat, 23 May 2009 22:50:08 +0000]
Extend distinct deprecation tests and clarify warnings

15 years agoupdate changes
Peter Rabbitson [Sat, 23 May 2009 22:47:40 +0000]
update changes

15 years agoMake sure MultiColumnIn quotes column names while munging literal sql
Peter Rabbitson [Sat, 23 May 2009 21:37:19 +0000]
Make sure MultiColumnIn quotes column names while munging literal sql
Tested by running t/resultset/update_delete against pg with quote char " and name sep .

15 years agominor clean up
Rafael Kitover [Sat, 23 May 2009 21:04:01 +0000]
minor clean up

15 years agoExtra test and count fixes for prefetch + distinct
Peter Rabbitson [Sat, 23 May 2009 20:59:17 +0000]
Extra test and count fixes for prefetch + distinct

15 years agorevert last Sybase changes
Rafael Kitover [Sat, 23 May 2009 20:28:42 +0000]
revert last Sybase changes

15 years agohide internal Sybase classes from PAUSE
Rafael Kitover [Sat, 23 May 2009 19:57:08 +0000]
hide internal Sybase classes from PAUSE

15 years agoSybase bindvar and IC::DT support
Rafael Kitover [Sat, 23 May 2009 19:46:11 +0000]
Sybase bindvar and IC::DT support

15 years agoAdd storage component of multipk resultset update/delete for multicolumn IN capable...
Peter Rabbitson [Sat, 23 May 2009 19:35:59 +0000]
Add storage component of multipk resultset update/delete for multicolumn IN capable rdbms
Switch Pg to that (tested via DBICTEST_DSN)

15 years agoTests and test schema adjustments for resultset update/delete
Peter Rabbitson [Sat, 23 May 2009 19:33:28 +0000]
Tests and test schema adjustments for resultset update/delete

15 years agoSybase autopk, and a test, no limit support yet
Rafael Kitover [Sat, 23 May 2009 14:44:59 +0000]
Sybase autopk, and a test, no limit support yet

15 years agoRefactor rs_update_delete (too many methods for no reason)
Peter Rabbitson [Sat, 23 May 2009 08:09:46 +0000]
Refactor rs_update_delete (too many methods for no reason)
Make mysql use _per_row_update_delete by default as this is the only thing it understands: http://dev.mysql.com/doc/refman/5.0/en/subquery-errors.html

15 years agoMake distinct calculate columns *after* prefetch has been resolved. Tests to come
Ash Berlin [Fri, 22 May 2009 16:54:00 +0000]
Make distinct calculate columns *after* prefetch has been resolved. Tests to come

15 years ago::Replicated -- check for master rebless and reapply role if necessary
Rafael Kitover [Fri, 22 May 2009 13:50:45 +0000]
::Replicated -- check for master rebless and reapply role if necessary

15 years agoduh
Peter Rabbitson [Fri, 22 May 2009 08:35:36 +0000]
duh

15 years agoSome attributes require a grouped count subquery, some - just a subquery. Differentia...
Peter Rabbitson [Fri, 22 May 2009 08:31:25 +0000]
Some attributes require a grouped count subquery, some - just a subquery. Differentiate properly

15 years agoExtend DB2 test
Peter Rabbitson [Fri, 22 May 2009 08:28:58 +0000]
Extend DB2 test

15 years agofix limit for DB2
Rafael Kitover [Fri, 22 May 2009 06:09:05 +0000]
fix limit for DB2

15 years agocomment addition
Rafael Kitover [Fri, 22 May 2009 04:52:47 +0000]
comment addition

15 years agoadd some support for trying to determine storage driver without being connected
Rafael Kitover [Fri, 22 May 2009 02:54:12 +0000]
add some support for trying to determine storage driver without being connected

15 years agoDuh, no point of having ordered subqueries while counting, Debolaz++
Peter Rabbitson [Thu, 21 May 2009 07:59:50 +0000]
Duh, no point of having ordered subqueries while counting, Debolaz++

15 years agoClarify usage of _resolved_attrs by adding the explicit _resolved_attrs_copy
Peter Rabbitson [Thu, 21 May 2009 07:45:52 +0000]
Clarify usage of _resolved_attrs by adding the explicit _resolved_attrs_copy
Clarify code in ResultSetColumn

15 years agoon_connect_do now accepts a single string like it does an arrayref (patch by prema)
Peter Rabbitson [Wed, 20 May 2009 21:47:05 +0000]
on_connect_do now accepts a single string like it does an arrayref (patch by prema)

15 years agoSwitch as_query testing to direct specification in is_same_sql_bind
Peter Rabbitson [Wed, 20 May 2009 21:00:13 +0000]
Switch as_query testing to direct specification in is_same_sql_bind

15 years agoPOD fixes
Peter Rabbitson [Wed, 20 May 2009 20:59:10 +0000]
POD fixes

15 years agofix test for people with spaces in path
Arthur Axel "fREW" Schmidt [Wed, 20 May 2009 16:03:55 +0000]
fix test for people with spaces in path

15 years agofix for sql functions in group_by
Justin Hunter [Wed, 20 May 2009 15:06:50 +0000]
fix for sql functions in group_by

15 years agoupdate to Changes
Justin Hunter [Wed, 20 May 2009 15:04:17 +0000]
update to Changes

15 years agoMore explicit attribute deletion/detection - a lof of this is probably redundant...
Peter Rabbitson [Wed, 20 May 2009 13:42:48 +0000]
More explicit attribute deletion/detection - a lof of this is probably redundant, as _resoved_attrs() should flatten them away (i.e. prefetch to collapse and distinct to group_by). Nevertheless keep them there for explcetness ( delete() is cheap )

15 years agoMake sure we always work with resolved rs attributes while counting (and test)
Peter Rabbitson [Wed, 20 May 2009 13:32:27 +0000]
Make sure we always work with resolved rs attributes while counting (and test)

15 years agoAdd explicit grouping for rs update/delete operations if the parameters warrant it...
Peter Rabbitson [Wed, 20 May 2009 12:30:40 +0000]
Add explicit grouping for rs update/delete operations if the parameters warrant it (tests coming tonight)

15 years agoBring back the old code from resolve_prefetch so ash's code can work
Peter Rabbitson [Wed, 20 May 2009 10:51:05 +0000]
Bring back the old code from resolve_prefetch so ash's code can work
Add tests to make sure we throw it away in 09

15 years agodetect/purge having bind for compeleteness
Peter Rabbitson [Wed, 20 May 2009 10:44:54 +0000]
detect/purge having bind for compeleteness

15 years agoMake joined rs counts backwards compatible - we do not collapse a result exploded...
Peter Rabbitson [Wed, 20 May 2009 07:03:08 +0000]
Make joined rs counts backwards compatible - we do not collapse a result exploded by a has_many join unless it is explicitly requested by distinct => 1, OR unless we have collapse set which implies prefetch