Greetings All!

23 years ago today, NexusDB v1 was officially released, and here we are, still kickin'. We're celebrating this great milestone with some live updates from the dungeon:

A major effort has gone into SQL engine updates recently. All issues in the tracker has been evaluated and a great many closed with fixes. See the very very long list at the end for details.

Due to the many changes, we would like to invite those of you using the remote NexusDB Server to run the latest updates through your regression tests and to use it for your daily development. As an incentive to join the testing, we'll give the first reporter of a new bug a 10% discount code. Test and cash in! :D

Here are links to the beta servers. Keep in mind that these are *Beta* and *Trial* versions, as such, they require restarting every couple of hours. They are not intended for distributing to your clients.

Standard Server:

https://www.nexusdb.com/downloads/NXDBTrial/nxServer_Standard_TRIAL_BETA.7z

Professional Server:

https://www.nexusdb.com/downloads/NXDBTrial/nxServer_Professional_TRIAL_BETA.7z


We would also like to make you aware of a change in download availability on the Customer pages. Due to the ever increasing amount of files and associated costs, it is no longer feasible to keep every old version available for instant download. Therefore, files that are more than ~5 years old are now available on request only. We will be happy to provide old files to holders of active subscriptions. We recommend that you always save our downloads in a safe place for peace of mind.


Our Nexus Quality Suite product is also marching towards a v2 release later this year, work is progressing well and we expect to have a beta available soon too.

Please note that it is likely that the new license cost of NQS will increase at the time of the major update, in step with added features. However, if you have an active subscription, major version updates are included. If you are considering getting an NQS license (or getting more licenses for your team), now is a good time!


Regards,
The NexusDB Team

no AI was harmed during the writing of this email.


Attached:

The current change log for the next NexusDB update:

NexusDB - v4.75.xx Release (not yet released)
====================================================================
- 0002792: [DB Engine \ fix] Restructuring table with a fulltext index on blob memo dropped fulltext keys (Eivind) - closed.
- 0002141: [SQL Engine \ fix] error location not detected (Eivind) - closed.
- 0001559: [SQL Engine \ fix] Binary string literal should support documented multiline split (Thorsten) - closed.
- 0000342: [SQL Engine \ fix] SELECT ... WHERE False could be faster with joins (Thorsten) - closed.
- 0001316: [SQL Engine \ fix] Performance for IN poor (compared to OR) (Thorsten) - closed.
- 0001379: [SQL Engine \ fix] Memory Table Index Creation Problem (hdanzl) - closed.
- 0001406: [SQL Engine \ fix] Integer constant Low(int64) triggered integer overflow (Eivind) - closed.
- 0001330: [SQL Engine \ fix] Escape quotes are not always folded together in string constants (Thorsten) - closed.
- 0001412: [SQL Engine \ fix] TOP don?t work with 2 tables in select (Thorsten) - closed.
- 0001574: [SQL Engine \ fix] SQL exception contains base64 garbage (on Windows Russian locale) (Thorsten) - closed.
- 0001417: [SQL Engine \ fix] SQL - wrong results - missing column data in result (Thorsten) - closed.
- 0002224: [SQL Engine \ fix] Memory leaks in function TnxSqlTableProxy.ExtractFieldDef (unit nxsqlProxies) (Thorsten) - closed.
- 0002235: [SQL Engine \ fix] select fieldname from tablename where confield in ('123456', '655435', ...) (Thorsten) - closed.
- 0002480: [SQL Engine \ fix] Run SQL SELECT or UPDATE without results for very long time (Eivind) - closed.
- 0002242: [SQL Engine \ fix] Use of paranthesis in where clause has a huge performance impact (Thorsten) - closed.
- 0002272: [SQL Engine \ fix] the INTERVAL operator does not handle wrapping in parenthesis (Thorsten) - closed.
- 0002790: [SQL Engine \ fix] Optimise IN () statement (Eivind) - closed.
- 0001435: [SQL Engine \ feature] Set Autoincrement from SQL (Thorsten) - closed.
- 0001677: [SQL Engine \ feature] SQL engine needs CREATE INDEX extension to generate indexes with Duplicates = idNone (Eivind) - closed.
- 0001064: [SQL Engine \ feature] Alter procedure/function (Thorsten) - closed.
- 0002519: [Server \ feature] Pause auto refresh statistics page & resize menu (Thorsten) - closed.
- 0002718: [SQL Engine \ fix] Combining OVERLAY(field) with COUNT() without GROUP BY should fail (Thorsten) - closed.
- 0002661: [SQL Engine \ fix] EnxInternalSQLException in the log but query runs without error (Eivind) - closed.
- 0002321: [DB Engine \ fix] Field error while executing a script a second time (Thorsten) - closed.
- 0002390: [Server \ fix] Desktop - black icons (Thorsten) - closed.
- 0002789: [Server \ feature] Browse button in Alias web config page to fill the path edit (Eivind) - closed.
- 0000300: [SQL Engine \ feature] ALTER TABLE should be able to change (nearly?) all table settings (Thorsten) - closed.
- 0002710: [SQL Engine \ fix] Transition variable and IN predicate issue (Again) (Thorsten) - closed.
- 0002165: [SQL Engine \ fix] Transition variable and IN predicate issue (Eivind) - closed.
- 0002550: [Server \ feature] Introduce a way to trim the #SESSION_STATS data (Thorsten) - closed.
- 0002778: [SQL Engine \ fix] Derived column list does not work with TABLE() (Thorsten) - closed.
- 0002788: [Enterprise Manager \ fix] Enterprise Manager cannot connect to HTTP transport servers on ports other than 443 (Eivind) - closed.
- 0001315: [SQL Engine \ fix] Fitting index not found (Thorsten) - closed.
- 0002114: [Enterprise Manager \ feature] Load SQL Reserved KeyWords/Colors from external file (Eivind) - closed.
- 0001106: [SQL Engine \ fix] Turning on CloseInactiveTables option causes AVs (Thorsten) - closed.
- 0001453: [SQL Engine \ feature] Update multiple fields with values from multiple tables (Thorsten) - closed.
- 0002787: [SQL Engine \ feature] Implement update and delete with support for joins (Thorsten) - closed.
- 0001427: [SQL Engine \ feature] Implement RENAME TABLE in ALTER TABLE (Thorsten) - closed.
- 0002122: [SQL Engine \ feature] The INTERVAL operator does not allow expressions (Thorsten) - closed.
- 0000921: [SQL Engine \ feature] Forcing a query to return an empty dataset (Thorsten) - closed.
- 0002159: [SQL Engine \ feature] Add a system variable to get the number of rows returned in the last SELECT (Thorsten) - closed.
- 0001507: [SQL Engine \ feature] ALTER TABLE for adding Multiple Column (Thorsten) - closed.
- 0000498: [SQL Engine \ feature] Extend ALTER TABLE syntax to allow DROP multiple Columns at once. (Thorsten) - closed.
- 0001528: [SQL Engine \ fix] Slow query with SELECT MAX(xxx) (Thorsten) - closed.
- 0002008: [Enterprise Manager \ feature] Find and Editform (Eivind) - closed.
- 0001266: [Enterprise Manager \ feature] Add function to source code generated by EM that lets you update indices if required by NLS changes (Eivind) - closed.
- 0001259: [Enterprise Manager \ feature] Command line parameter support for opening specific database/table on startup (Eivind) - closed.
- 0001249: [SQL Engine \ feature] Interval expressin should support the [... * numeric] syntax (Eivind) - closed.
- 0000125: [Enterprise Manager \ fix] Typing too fast into dict editor fieldname column erases first letter typed (Eivind) - closed.
- 0000494: [Enterprise Manager \ fix] Del key does not work when editing tablename in treeview (Eivind) - closed.
- 0000334: [Enterprise Manager \ fix] Unrecognized message exception when expanding treeview (Eivind) - closed.
- 0000639: [Enterprise Manager \ fix] Add description for keyfielddescriptor in dict editor (Eivind) - closed.
- 0000688: [Enterprise Manager \ fix] Restructure errors should only be shown once (Eivind) - closed.
- 0001455: [Enterprise Manager \ feature] Close browsers database popup menu item (Eivind) - closed.
- 0002001: [Enterprise Manager \ feature] Live backup/restore style table selections for table management (Eivind) - closed.
- 0002641: [Enterprise Manager \ feature] Add hints on Table Browser tabs with database alias/path (Eivind) - closed.
- 0001981: [Enterprise Manager \ fix] Export to CSV -> Import from CSV not working with blob fields and line breaks (Eivind) - closed.
- 0001156: [Enterprise Manager \ feature] Change all tables dialog needs "set encryptionengine" option (Eivind) - closed.
- 0000819: [Enterprise Manager \ feature] From database treenode, have "Open in Explorer" menu item (Eivind) - closed.
- 0000490: [Enterprise Manager \ fix] Live Backup dialog clips database folder name if it is very long (Eivind) - closed.
- 0000841: [Enterprise Manager \ fix] When first inserting field, take default type from active field (Eivind) - closed.
- 0000915: [Enterprise Manager \ feature] Add possibility to copy single data value (Eivind) - closed.
- 0001077: [Enterprise Manager \ feature] Change size of the EE application icons (Eivind) - closed.
- 0001177: [Enterprise Manager \ feature] Fetch synedit highlight keywords from sql engine instead of hardcoded list (Eivind) - closed.
- 0002786: [Enterprise Manager \ feature] Search edit for fieldname in field editor (Eivind) - closed.
- 0002518: [Enterprise Manager \ fix] Request for feature to Format SQL (Eivind) - closed.
- 0002679: [SQL Engine \ feature] ASSERT statement should support alias.tablename syntax (Eivind) - closed.
- 0002189: [SQL Engine \ feature] Create #meta tables for reserved identifiers/keywords etc (Eivind) - closed.
- 0001718: [SQL Engine \ feature] Missing a CURRENT_ALIAS system function and #SESSION metatable (Thorsten) - closed.
- 0001421: [SQL Engine \ feature] Suggestion: CREATE TABLE IF NOT EXISTS. . . (Thorsten) - closed.
- 0000361: [SQL Engine \ feature] Support CASE as flow control (Thorsten) - closed.
- 0002781: [SQL Engine \ fix] Possible bug: TOP <count>,<offset> does not work correctly inside an IN subquery (Thorsten) - closed.
- 0001492: [SQL Engine \ fix] Design of QueryLog Table is not optimized (Thorsten) - closed.
- 0001562: [SQL Engine \ fix] Column selection schema.database.* not supported (Thorsten) - closed.
- 0002785: [SQL Engine \ fix] Double '' inside DESCRIPTION statements were not escaped (Thorsten) - closed.
- 0001237: [SQL Engine \ fix] CREATE INDEX is missing DESCRIPTION part (Thorsten) - closed.
- 0001209: [SQL Engine \ fix] Investigate INTO #table optimization (Thorsten) - closed.
- 0000823: [SQL Engine \ fix] CREATE TABLE AS...WITH DATA is two order of magnitude slower than SELECT query alone (Thorsten) - closed.
- 0002033: [SQL Engine \ fix] the max function within a cast is not taking into account an index (Thorsten) - closed.
- 0000520: [SQL Engine \ fix] Engine should optimize 2nd index field with IN(...) similar to OR (Thorsten) - closed.
- 0001210: [SQL Engine \ fix] NexusDB SQL runs 10 times SLOWER than MySQL (Thorsten) - closed.
- 0001483: [SQL Engine \ fix] Missing error position info on sql alias error (Eivind) - closed.
- 0002011: [SQL Engine \ fix] Optimize something like ((H.Source = 'H') or (1=1)) (Thorsten) - closed.
- 0001227: [SQL Engine \ fix] Poor and/or inconsistent index selection for LIKE queries. (Thorsten) - closed.
- 0001397: [SQL Engine \ fix] LIKE ... IGNORE CASE is not correctly optimized (Thorsten) - closed.
- 0002080: [SQL Engine \ fix] Executing again query cancelled raise exception. (Thorsten) - closed.
- 0002608: [SQL Engine \ fix] SELECT with UNION does not return the same data when used to create a table (Thorsten) - closed.
- 0001322: [SQL Engine \ fix] Order by problem with LIST() (Thorsten) - closed.
- 0001337: [SQL Engine \ fix] Very BAD NEW Error in ALTER TABLE script (Thorsten) - closed.
- 0001193: [SQL Engine \ fix] too general: NexusDB: Unexpected exception object raised: [EConvertError] No argument for format '%s' (Thorsten) - closed.
- 0001454: [SQL Engine \ fix] Problem with "Like" + apostrophe (Thorsten) - closed.
- 0002339: [SQL Engine \ fix] Memory leak after call the Prepare method (Thorsten) - closed.
- 0002058: [SQL Engine \ fix] Error "Unable to resolve the identifier"in SELECT with parameters (Thorsten) - closed.
- 0002340: [SQL Engine \ fix] Bad index (Thorsten) - closed.
- 0002348: [DB Engine \ fix] Problems with blob memo field in db trigger (Thorsten) - closed.
- 0001414: [SQL Engine \ fix] Error when grouping on bytearray field (Eivind) - closed.
- 0002438: [DB Engine \ fix] SYSTEM_ROW# not work if using GROUP BY (Thorsten) - closed.
- 0001360: [SQL Engine \ fix] wrong Result set when using group by and left Join with no aggregate fields (hdanzl) - closed.
- 0001362: [SQL Engine \ fix] AV using a UDF in a SELECT + JOIN (hdanzl) - closed.
- 0002257: [SQL Engine \ fix] Typo in trigger kills server (Thorsten) - closed.
- 0002353: [SQL Engine \ fix] Select statement returng wrong value (Thorsten) - closed.
- 0002760: [SQL Engine \ feature] #P statement switch to set transaction priority from SQL statements (Thorsten) - closed.
- 0002294: [SQL Engine \ fix] EXECUTE IMMEDIATE throws EVariantCast error with NULL parameter (Thorsten) - closed.
- 0002783: [Enterprise Manager \ fix] SQL Error window loses it's buttons (Eivind) - closed.
- 0002303: [SQL Engine \ fix] Exception when running seemingly good SQL query in Enterprise Manager (Thorsten) - closed.
- 0002399: [SQL Engine \ fix] Query Generates Exception (Thorsten) - closed.
- 0002502: [SQL Engine \ fix] Unwanted exception in log file (Thorsten) - closed.
- 0002570: [SQL Engine \ fix] Query execution failed (Thorsten) - closed.
- 0002611: [SQL Engine \ fix] Unable to resolve the identifier (Thorsten) - closed.
- 0002782: [SQL Engine \ feature] Support outer aggregates inside subqueries (Thorsten) - closed.
- 0001415: [SQL Engine \ feature] Support cast to and from bytearray/[var]char (Eivind) - closed.
- 0001363: [SQL Engine \ fix] Max with a byte array key doesn't work (hdanzl) - closed.
- 0002060: [SQL Engine \ fix] Omitting column quotes returns wrong data (wrong parsing) (Thorsten) - closed.
- 0000939: [SQL Engine \ fix] Problems using Formatted BCD fields (Thorsten) - closed.
- 0001939: [SQL Engine \ fix] Transaction corruped when query is cancelled (Thorsten) - closed.
- 0002777: [Enterprise Manager \ fix] Referential Integrity Dialog crashes when closed if child tables exist (Eivind) - closed.
- 0002776: [Enterprise Manager \ fix] Referential Integrity Dialog does not handle space in table names (Eivind) - closed.
- 0002775: [Transports \ fix] Winsock Transport IPv6 address notation regression (Thorsten) - closed.
- 0002774: [Transports \ fix] Blowfish Transport could do a memory overwrite (Thorsten) - closed.
- 0002772: [Enterprise Manager \ fix] Use UTF-8 with BOM for the dictionary generation output (Eivind) - closed.
- 0002767: [SQL Engine \ fix] JOIN does not work correctly with CHAR fields. (Thorsten) - closed.
- 0002612: [SQL Engine \ fix] Float variables are sometimes considered to be integers. (Thorsten) - closed.
- 0002762: [Enterprise Manager \ feature] Enable Field Chooser etc in devex grid column header popup (Eivind) - closed.
- 0002765: [Documentation \ feature] Add NexusDB Help files to the recent IDE's Help | Third-Party Help menu (Eivind) - closed.
- 0002764: [Utilities \ feature] Add the ability to TnxEventLog to create UTF8 files, instead of the UTF16 it uses right now (Eivind) - closed.
- 0002747: [Enterprise Manager \ fix] Large font in EM's referential integrity frame (Eivind) - closed.
- 0002761: [DB Engine \ fix] Avoid illegal Multi-Byte character at the end of field (Thorsten) - closed.
- 0002759: [Enterprise Manager \ feature] EM support for Transaction Priorities (Eivind) - closed.