You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by RobertCZ <ro...@robert.cz> on 2004/11/20 11:37:50 UTC
Re: ANNOUNCE: DBIx::Recordset 0.26
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)