Added limit_dialect info (no magic because of DBD::Multi driver).

[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / Storage / DBI / Replication.pm

diff --git a/lib/DBIx/Class/Storage/DBI/Replication.pm b/lib/DBIx/Class/Storage/DBI/Replication.pm
index 42c3170..791559f 100644 (file)
--- a/lib/DBIx/Class/Storage/DBI/Replication.pm
+++ b/lib/DBIx/Class/Storage/DBI/Replication.pm
@@ -23,6 +23,10 @@ DBIx::Class::Storage::DBI::Replication - Replicated database support
                     [ "dbi:mysql:database=test;hostname=slave2", "username", "password", { priority => 10 } ],  # slave2
                     <...>
                    ] );
+  # If you use LIMIT in your queries (effectively, if you use SQL::Abstract::Limit),
+  # do not forget to set up limit_dialect (see: perldoc SQL::Abstract::Limit)
+  # DBIC can not set it up automatically, since DBD::Multi could not be supported directly
+    $schema->limit_dialect( 'LimitXY' ) # For MySQL
 
 =head1 DESCRIPTION