Reported By: Nick Costanzo Reported On: 3/18/2013 For: Version 4.35 Build 1
# 3750MIN/MAX Aggregate Functions Not Optimized when Used in Expressions One thing that puzzles me about the following query is how slow it is. If you try it with dbSys the progress bar goes all the way through the file.
INSERT INTO Script (RxNo) SELECT MAX(RxNo) + 1 FROM Script
ResolutionFixed Problem on 3/18/2013 in version 4.35 build 2
Products AffectedDBISAM Additional Software and Utilities DBISAM CLX Client-Server DBISAM CLX Client-Server with Source DBISAM CLX Standard DBISAM CLX Standard with Source DBISAM ODBC Client-Server DBISAM ODBC Client-Server with Source DBISAM ODBC Standard DBISAM ODBC Standard with Source DBISAM ODBC Trial DBISAM VCL Client-Server DBISAM VCL Client-Server with Source DBISAM VCL Standard DBISAM VCL Standard with Source DBISAM VCL Trial