| 
      
            Lines 65-72
          subtest 'prep_report' => sub {
      
      
        Link Here
      
     | 
  
        
          | 65 | 
              ($sql, undef) = $report->prep_report( ['Test|list','Another'],["1\n12\n\r243",'the other'] );  | 
          65 | 
              ($sql, undef) = $report->prep_report( ['Test|list','Another'],["1\n12\n\r243",'the other'] );  | 
        
        
          | 66 | 
              is( $sql, qq{SELECT * FROM items WHERE itemnumber IN ('1','12','243') AND 'the other' AND ('1','12','243') /* saved_sql.id: $id */},'Expected sql generated correctly with multiple params and names'); | 
          66 | 
              is( $sql, qq{SELECT * FROM items WHERE itemnumber IN ('1','12','243') AND 'the other' AND ('1','12','243') /* saved_sql.id: $id */},'Expected sql generated correctly with multiple params and names'); | 
        
        
          | 67 | 
           | 
          67 | 
           | 
        
          
            
              | 68 | 
                  ($sql, undef) = $report->prep_report( [],["1\n12\n\r243",'the other',"42\n32\n22\n12"] );  | 
              68 | 
                  ($sql, undef) = $report->prep_report( [],["1\n12\n\r243",'the other'] );  | 
            
            
              | 69 | 
                  is( $sql, qq{SELECT * FROM items WHERE itemnumber IN ('1','12','243') AND 'the other' AND ('42','32','22','12') /* saved_sql.id: $id */},'Expected sql generated correctly with multiple params and no names'); | 
              69 | 
                  is( $sql, qq{SELECT * FROM items WHERE itemnumber IN ('1','12','243') AND 'the other' AND ('1','12','243') /* saved_sql.id: $id */},'Expected sql generated correctly with multiple params and no names'); | 
            
        
          | 70 | 
           | 
          70 | 
           | 
        
        
          | 71 | 
              $report->savedsql(  | 
          71 | 
              $report->savedsql(  | 
        
        
          | 72 | 
                  q{SELECT  i.itemnumber, i.itemnumber as Exemplarnummber, [[i.itemnumber| itemnumber for batch]] FROM items}) | 
          72 | 
                  q{SELECT  i.itemnumber, i.itemnumber as Exemplarnummber, [[i.itemnumber| itemnumber for batch]] FROM items}) | 
        
            
              | 73 | 
              -   | 
               | 
               |