From: Justin Hunter Date: Tue, 5 May 2009 07:27:13 +0000 (+0000) Subject: add a line to Changes and add a CAVEAT X-Git-Tag: v0.08103~118^2 X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FDBIx-Class.git;a=commitdiff_plain;h=d4483998dff1af8eff35b3c5398f564a9a1fb9d8;hp=8c4b8df30ab42884e1da4fc1f08a07665bae6dec add a line to Changes and add a CAVEAT --- diff --git a/Changes b/Changes index 13bb6d8..58c5737 100644 --- a/Changes +++ b/Changes @@ -1,5 +1,9 @@ Revision history for DBIx::Class + - Refactor DBIx::Class::Storage::DBI::Sybase to automatically + load a subclass, namely Microsoft_SQL_Server.pm + (similar to DBIx::Class::Storage::DBI::ODBC) + 0.08102 2009-04-30 08:29:00 (UTC) - Fixed two subtle bugs when using columns or select/as paired with a join (limited prefetch) diff --git a/lib/DBIx/Class/Storage/DBI/Sybase.pm b/lib/DBIx/Class/Storage/DBI/Sybase.pm index 2fe0b83..f1a8dc8 100644 --- a/lib/DBIx/Class/Storage/DBI/Sybase.pm +++ b/lib/DBIx/Class/Storage/DBI/Sybase.pm @@ -31,6 +31,15 @@ This subclass supports L for real Sybase databases. If you are using an MSSQL database via L, see L. +=head1 CAVEATS + +This storage driver uses L as a base. +This means that bind variables will be interpolated (properly quoted of course) +into the SQL query itself, without using bind placeholders. + +More importantly this means that caching of prepared statements is explicitly +disabled, as the interpolation renders it useless. + =head1 AUTHORS Brandon L Black diff --git a/lib/DBIx/Class/Storage/DBI/Sybase/Microsoft_SQL_Server.pm b/lib/DBIx/Class/Storage/DBI/Sybase/Microsoft_SQL_Server.pm index 8a63ef9..d4485a3 100644 --- a/lib/DBIx/Class/Storage/DBI/Sybase/Microsoft_SQL_Server.pm +++ b/lib/DBIx/Class/Storage/DBI/Sybase/Microsoft_SQL_Server.pm @@ -19,10 +19,14 @@ This subclass supports MSSQL connected via L. $schema->storage_type('::DBI::Sybase::Microsoft_SQL_Server'); $schema->connect_info('dbi:Sybase:....', ...); -=head1 BUGS +=head1 CAVEATS -Currently, this doesn't work right unless you call C -after connecting. +This storage driver uses L as a base. +This means that bind variables will be interpolated (properly quoted of course) +into the SQL query itself, without using bind placeholders. + +More importantly this means that caching of prepared statements is explicitly +disabled, as the interpolation renders it useless. =head1 AUTHORS