| Subject: | better SQL expr |
Hi,
I hope that you can add this simple patch to your next release.
With it I can use successfully on PostgreSQL too.
Show quoted text
> diff -u lib/DBIx/Replicate/Strategy/PK.pm_orig
lib/DBIx/Replicate/Strategy/PK.pm
--- lib/DBIx/Replicate/Strategy/PK.pm_orig 2010-11-19 15:15:57 +0100
+++ lib/DBIx/Replicate/Strategy/PK.pm 2010-11-19 11:54:15 +0100
@@ -39,7 +39,7 @@
my $order_by = $args->{order_by} || join(',', @$pkey);
# copy by 'limit $block'
- my ($start_srcconn, $start_destconn) = qw/1 1/;
+ my ($start_srcconn, $start_destconn) = qw/1=1 1=1/;
while (1) {
my $start = time;
$sql = "select $columns_str from $src_table where
$start_srcconn $extra_cond $limit_cond order by $order_by limit $block";