X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2Fmysql.pm;h=9fa6d31ca5bd428bc7dc85a2e632c2fa42773b68;hb=02d9b41a4842cf599a547299986b46ad83adfc1d;hp=516dde1c1c57aaa788ffb23f06da05faf858cf55;hpb=3ce9dd081d5e76a1d41714da8b77f699342bff7d;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/mysql.pm b/lib/DBIx/Class/Storage/DBI/mysql.pm index 516dde1..9fa6d31 100644 --- a/lib/DBIx/Class/Storage/DBI/mysql.pm +++ b/lib/DBIx/Class/Storage/DBI/mysql.pm @@ -33,6 +33,21 @@ sub _dbh_last_insert_id { $dbh->{mysql_insertid}; } +# we need to figure out what mysql version we're running +sub sql_maker { + my $self = shift; + + unless ($self->_sql_maker) { + my $maker = $self->next::method (@_); + + # mysql 3 does not understand a bare JOIN + my $mysql_ver = $self->_get_dbh->get_info(18); + $maker->{_default_jointype} = 'INNER' if $mysql_ver =~ /^3/; + } + + return $self->_sql_maker; +} + sub sqlt_type { return 'MySQL'; } @@ -40,28 +55,28 @@ sub sqlt_type { sub _svp_begin { my ($self, $name) = @_; - $self->dbh->do("SAVEPOINT $name"); + $self->_get_dbh->do("SAVEPOINT $name"); } sub _svp_release { my ($self, $name) = @_; - $self->dbh->do("RELEASE SAVEPOINT $name"); + $self->_get_dbh->do("RELEASE SAVEPOINT $name"); } sub _svp_rollback { my ($self, $name) = @_; - $self->dbh->do("ROLLBACK TO SAVEPOINT $name") + $self->_get_dbh->do("ROLLBACK TO SAVEPOINT $name") } sub is_replicating { - my $status = shift->dbh->selectrow_hashref('show slave status'); + my $status = shift->_get_dbh->selectrow_hashref('show slave status'); return ($status->{Slave_IO_Running} eq 'Yes') && ($status->{Slave_SQL_Running} eq 'Yes'); } sub lag_behind_master { - return shift->dbh->selectrow_hashref('show slave status')->{Seconds_Behind_Master}; + return shift->_get_dbh->selectrow_hashref('show slave status')->{Seconds_Behind_Master}; } # MySql can not do subquery update/deletes, only way is slow per-row operations.