Advantage Database Server 12 Service Pack 2 now available for download
Please note that Advantage Database Server (ADS) 12 Service Pack 2 (SP2) is now available for download from the SAP Market Place under “Support Packages & Patches”. Please change the platform to # OS INDEPENDENT.
Windows and Linux binaries are included in a single 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
Hello Wolfgang,
it also works if you use "Date" instead of "TimeStamp".
Michael,
could you please also publish the release notes of this service pack?
If you click on the Related Info pull-down and select Content Info, it will take you to Knowledge Base Article 2571905 with the release notes. This is the same as the Readme.txt file included in the download.
One detail that was missed is that Windows 10 and Windows Server 2016 are now supported platforms.
Regards,
Mike Loop
Senior Support Engineer
SAP Product Support
that works only if you have a valid user account to download the SP. Without user account you're not able to access that information.
You do need a valid user account to download the SP.
If you have the SP, you can read the Readme.txt file included in the download.
Mike Loop
Senior Support Engineer
SAP Product Support