perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From RobertCZ <rob...@robert.cz>
Subject Re: ANNOUNCE: DBIx::Recordset 0.26
Date Sat, 20 Nov 2004 10:37:50 GMT
Gerald Richter wrote:

>>Search with subexpr...                 ERROR in Search with subexpr
>>Got too many rows (got 12, expected 6)
>>    
>>
>I am not aware of this bug, so if you have time to take a look it would be
>great
>  
>

So this looks like a problem in PG after all, it sorts '15' after 'Tenth 
Name'... (See the last SELECT)

Comments?

- Robert

----------------------------------------------


$set1 -> Search ({'$expr' => { id => 2, '*id' => '>' }, name => 'S', 
'*name' => '>'})  or die "not ok ($DBI::errstr)" ;
Check ([3, 6, 7, 10, 12, 13], $TestFields[0], \@set1) or print "ok\n" ;

db after subexpr test

test=# select * from dbixrs1;
 id |         name         | value1 |        addon        
----+----------------------+--------+----------------------
  1 | First Name           |   9991 | Is                 
  2 | Second Name          |   9992 | it                 
  3 | Third Name           |   9993 | it ok?             
  4 | Fourth Name          |   9994 | Or not??           
  5 | Fivth Name           |   9995 | Is                 
  6 | Sixth Name           |   9996 | it                 
  7 | Seventh Name         |   9997 | it ok?             
  8 | Eighth Name          |   9998 | Or not??           
  9 | Ninth Name           |   9999 | Is                 
 10 | Tenth Name           |  99910 | it                 
 11 | Eleventh Name        |  99911 | it ok?             
 12 | Twelvth Name         |  99912 |                    
 13 | Thirdteenth Name     |        |
 14 | Fourteenth Name      |      0 |
 15 | 15                   |     15 |
 16 | 15                   |     15 |
 17 | 1                    |      2 |
 18 | 3                    |     42 | 42                 
 19 | 2                    |     42 | 42                 
 20 | 2                    |      3 | 42                 
(20 rows)
 
test=# select * from dbixrs1 where name > 'S' and id > 2;
 id |         name         | value1 |        addon        
----+----------------------+--------+----------------------
  3 | Third Name           |   9993 | it ok?             
  6 | Sixth Name           |   9996 | it                 
  7 | Seventh Name         |   9997 | it ok?             
 10 | Tenth Name           |  99910 | it                 
 12 | Twelvth Name         |  99912 |                    
 13 | Thirdteenth Name     |        |
 15 | 15                   |     15 |
 16 | 15                   |     15 |
 17 | 1                    |      2 |
 18 | 3                    |     42 | 42                 
 19 | 2                    |     42 | 42                 
 20 | 2                    |      3 | 42                 
(12 rows)
 
test=# select * from dbixrs1 order by name;
 id |         name         | value1 |        addon        
----+----------------------+--------+----------------------
  8 | Eighth Name          |   9998 | Or not??           
 11 | Eleventh Name        |  99911 | it ok?             
  1 | First Name           |   9991 | Is                 
  5 | Fivth Name           |   9995 | Is                 
 14 | Fourteenth Name      |      0 |
  4 | Fourth Name          |   9994 | Or not??           
  9 | Ninth Name           |   9999 | Is                 
  2 | Second Name          |   9992 | it                 
  7 | Seventh Name         |   9997 | it ok?             
  6 | Sixth Name           |   9996 | it                 
 10 | Tenth Name           |  99910 | it                 
  3 | Third Name           |   9993 | it ok?             
 13 | Thirdteenth Name     |        |
 12 | Twelvth Name         |  99912 |                    
 17 | 1                    |      2 |
 15 | 15                   |     15 |
 16 | 15                   |     15 |
 19 | 2                    |     42 | 42                 
 20 | 2                    |      3 | 42                 
 18 | 3                    |     42 | 42                 
(20 rows)


Mime
View raw message