diff options
| author | mark <mark> | 2010-11-04 05:57:00 +0000 |
|---|---|---|
| committer | mark <mark> | 2010-11-04 05:57:00 +0000 |
| commit | bd35baff8b7b5dcdd44d14a1139ef4d48009274c (patch) | |
| tree | a727a7ef414a242fad7ddb3cd1eda6533f97f14b /rt/lib/RT | |
| parent | 2ecef68b926eae756524a564bd0986da7b56109f (diff) | |
clean up postgres-isms, RT#10324
Diffstat (limited to 'rt/lib/RT')
| -rw-r--r-- | rt/lib/RT/Tickets_Overlay.pm | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/rt/lib/RT/Tickets_Overlay.pm b/rt/lib/RT/Tickets_Overlay.pm index f2949ed..be5a0d5 100644 --- a/rt/lib/RT/Tickets_Overlay.pm +++ b/rt/lib/RT/Tickets_Overlay.pm @@ -1855,7 +1855,13 @@ sub OrderByCols { ); #if there was a Links.RemoteTarget int, this bs wouldn't be necessary - my $custnum_sql = "CAST(SUBSTR($linkalias.Target,31) AS INTEGER)"; + my $custnum_sql = "CAST(SUBSTR($linkalias.Target,31) AS "; + if ( RT->Config->Get('DatabaseType') eq 'mysql' ) { + $custnum_sql .= 'SIGNED INTEGER)'; + } + else { + $custnum_sql .= 'INTEGER)'; + } if ( $subkey eq 'Number' ) { |