Permalink
Browse files

Cast to CHAR, not VARCHAR

Because MySQL does not work for casting (wut).
  • Loading branch information...
theory committed Apr 20, 2018
1 parent df756d8 commit 5425bff9226c76fc9502ffdcee2e122adaebd247
Showing with 4 additions and 4 deletions.
  1. +3 −3 Changes
  2. +1 −1 lib/App/Sqitch/Engine/mysql.pm
View
@@ -3,9 +3,9 @@ Revision history for Perl extension App::Sqitch
0.9998
- Fixed an issue where Sqitch would sometimes truncate the registry
version number fetched from MySQL, most likely because the Perl runtime
- was using 32-bit integers. Fixed by casting the version to VARCHAR in
- the query, before Perl ever see it. Thanks to Allen Godfrey David for
- the report.
+ was using 32-bit integers. Fixed by casting the version to CHAR in the
+ query, before Perl ever see it. Thanks to Allen Godfrey David for the
+ report.
0.9997 2018-03-15T21:13:52Z
- Fixed the Firebird engine to properly detect multiple instances of a
@@ -232,7 +232,7 @@ sub _quote_idents {
map { $_ eq 'change' ? '"change"' : $_ } @_;
}
-sub _version_query { 'SELECT CAST(ROUND(MAX(version), 1) AS VARCHAR(10)) FROM releases' }
+sub _version_query { 'SELECT CAST(ROUND(MAX(version), 1) AS CHAR) FROM releases' }
sub initialized {
my $self = shift;

0 comments on commit 5425bff

Please sign in to comment.