Advantage Database Server 12 Service Pack 2 now available for download

Hello,

maybe to find out, what this Service Pack is worth, we should post existing bugs here:

I reported a bug on Jan 12th 2016, almost two years ago.

ADS12: Year(SomedateColumn) = xx with Index on SomedateColumn produces no results

This bug still exists in Version 12.0.0.02 and I report it again so that all users are warned:

(there is an open support incident with SAP, open since over a year, NO Feedback at all)

A simple SQL Statement executed in ARC32 like "select * from sometable where year(somedatecolumn) = 2016" fails if the Table has an index on somedatecolumn.
SQL to test:

Create Table BUGTEST(
ID AutoInc,
Somedate TimeStamp);

EXECUTE PROCEDURE sp_CreateIndex90( 'BUGTEST', 'BUGTEST.adi', 'PRIMARY', 'Somedate', '', 2, 1024, NULL );
insert into BUGTEST (Somedate) VALUES (now());

select * from BUGTEST where Year(SomeDate) = Year(now())

This SQL should select one column but it does not! If you change "Year(SomeDate) = Year(now())" to "Year(SomeDate) >= Year(now())" or drop the Index on Somedate it works.

In all previous versions this worked correct.

Kind regards,

Wolfgang Hanke