Peter Rabbitson > DBIx-Class > DBIx::Class::Storage::DBI::AmbiguousGlob

Download:
DBIx-Class-0.08112.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  4
Stalled  4
View Bugs
Report a bug
Source   Latest Release: DBIx-Class-0.08114

NAME ^

DBIx::Class::Storage::DBI::AmbiguousGlob - Storage component for RDBMS supporting multicolumn in clauses

DESCRIPTION ^

Some servers choke on things like:

  COUNT(*) FROM (SELECT tab1.col, tab2.col FROM tab1 JOIN tab2 ... )

claiming that col is a duplicate column (it loses the table specifiers by the time it gets to the *). Thus for any subquery count we select only the primary keys of the main table in the inner query. This hopefully still hits the indexes and keeps the server happy.

At this point the only overriden method is _subq_count_select()

AUTHORS ^

See "CONTRIBUTORS" in DBIx::Class

LICENSE ^

You may distribute this code under the same terms as Perl itself.