Gerald Nowitzky wrote:
> Again I stumbled over a bug:
>
> Here are the steps to reproduce:
> First I create a table:
>
> CREATE TABLE "DBA"."ZIP"
> (
> "ZIP" Integer,
> "COUNTRY_ID" Varchar (50) ASCII
> )
>
> and insert some values:
>
> insert into zip values (81549,'D')
> --
> insert into zip values (76133,'D')
> --
> insert into zip values (4540,'A')
> --
> insert into zip values (8867,'A')
>
> now I try to get the max(zip) for each country:
>
> select country_id,max(zip) as maxzip from zip group by country_id
> The correct result is:
>
> country_id maxzip
> A 8867
> D 81549
>
> now I create an Index:
> CREATE INDEX "IDX_ZIP_CTRY" ON "DBA"."ZIP"("ZIP" ASC,
> "COUNTRY_ID" ASC)
> and try again:
>
> select country_id,max(zip) as maxzip from zip group by country_id
> Now I get:
>
> country_id maxzip
> D 81549
>
> I tried with a table with zips for different countries. In
> case I build the
> Index, I only get the absolute max of all zips for all
> countries, not the
> grouped max
>
> I could not find something in the PTS, so I decided to report
> it. Hope it is
> a "new" one :-)
I couldn't reproduce the problem neither in 7.4 nor in 7.3.
What kind of version do you use and how looks the explain output?
Best regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
