diff options
| author | Frédéric Buclin <LpSolit@gmail.com> | 2011-08-17 00:32:25 +0200 |
|---|---|---|
| committer | Frédéric Buclin <LpSolit@gmail.com> | 2011-08-17 00:32:25 +0200 |
| commit | 7a8598938d6976acb5f6bde6c86be8b65d1df8da (patch) | |
| tree | 44764f356546b7ccdf75588d8ab07bdeae57e2e9 /Bugzilla/DB | |
| parent | 69cb46eaca778c78d775406ff3e92ed32fa87124 (diff) | |
| download | bugs-7a8598938d6976acb5f6bde6c86be8b65d1df8da.tar bugs-7a8598938d6976acb5f6bde6c86be8b65d1df8da.tar.gz bugs-7a8598938d6976acb5f6bde6c86be8b65d1df8da.tar.bz2 bugs-7a8598938d6976acb5f6bde6c86be8b65d1df8da.tar.xz bugs-7a8598938d6976acb5f6bde6c86be8b65d1df8da.zip | |
Bug 675603: Remove obsolete code from Bugzilla/DB/Oracle.pm
r=mkanat a=LpSolit
Diffstat (limited to 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Oracle.pm | 12 |
1 files changed, 1 insertions, 11 deletions
diff --git a/Bugzilla/DB/Oracle.pm b/Bugzilla/DB/Oracle.pm index d91eb428e..73ed2068c 100644 --- a/Bugzilla/DB/Oracle.pm +++ b/Bugzilla/DB/Oracle.pm @@ -312,9 +312,6 @@ sub adjust_statement { my $is_select = ($part =~ m/^\s*SELECT\b/io); my $has_from = ($part =~ m/\bFROM\b/io) if $is_select; - # Oracle recognizes CURRENT_DATE, but not CURRENT_DATE() - $part =~ s/\bCURRENT_DATE\b\(\)/CURRENT_DATE/io; - # Oracle use SUBSTR instead of SUBSTRING $part =~ s/\bSUBSTRING\b/SUBSTR/io; @@ -343,18 +340,11 @@ sub adjust_statement { $has_from = ($nonstring =~ m/\bFROM\b/io) if ($is_select and !$has_from); - # Oracle recognizes CURRENT_DATE, but not CURRENT_DATE() - $nonstring =~ s/\bCURRENT_DATE\b\(\)/CURRENT_DATE/io; - # Oracle use SUBSTR instead of SUBSTRING $nonstring =~ s/\bSUBSTRING\b/SUBSTR/io; - + # Oracle need no 'AS' $nonstring =~ s/\bAS\b//ig; - - # Take the first 4000 chars for comparison - $nonstring =~ s/\(\s*(longdescs_\d+\.thetext|attachdata_\d+\.thedata)/ - \(DBMS_LOB.SUBSTR\($1, 4000, 1\)/ig; # Look for a LIMIT clause ($limit) = ($nonstring =~ m(/\* LIMIT (\d*) \*/)o); |