/[SQLSession]/trunk/lib/SQLSession/Utils.pm
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/lib/SQLSession/Utils.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 108 by dpavlin, Fri Feb 16 22:20:41 2007 UTC revision 109 by dpavlin, Mon Apr 9 21:53:50 2007 UTC
# Line 30  sub reformat_sql { Line 30  sub reformat_sql {
30                  return "\n" . uc($sql) . $suff;                  return "\n" . uc($sql) . $suff;
31          }          }
32    
33          $sql =~ s/(\s*)(select|from|inner\s+join|order\s+by|where|group\s+by|having|limit|offset)(\s+)/sql_uc($1,$2,$3)/egis;          $sql =~ s/(\s*)(select|from|inner\s+join|order\s+by|where|group\s+by|having|limit|offset|union)(\s+)/sql_uc($1,$2,$3)/egis;
34    
35          warn ">>>> canonicalize SQL:\n$sql";          warn ">>>> canonicalize SQL:\n$sql";
36    
Legend:
Removed from v.108  
changed lines
  Added in v.109
  ViewVC Help
Powered by ViewVC 1.1.26