NexusDB

Beginning with V2.00 beta 5 we are providing a detailed list of fixes and additions to this product.

V2.08.04 - released on April 7th 2010

• removed potential AVs in fieldmappers
• removed unnecessary Assert in named pipe transport
• ensure serverengine only opens files with the correct nx1 extension
• improve SQL engine on query close behaviour
• #476 (Left join with WORD16 field returns nothing for right join table columns)

V2.08.03 - released on May 6th 2009

Back ports the following critical fix from NexusDB V3:

• 0205 Crash in UI / IterateDependents with heavy of the ADO provider

V2.08.02 - released on May 4th 2009

Back ports the following fixes from NexusDB V3:

• 0177 TOSTRINGLEN on (wide) string field gives field size of 8192
• 0188 SQL script with multiple statement blocks leaks cursor
• 0189 Memory leaks in .NET transport
• 0196 Update our zlib with the latest changes
• 0197 RecNoSet, if interrupted (e.g by a timeout) can leave an invalid IndexPath behind
• 0203 Memory leaks with ODBC driver

V2.08.01 - released on April 7th 2009

Back ports the following fixes from NexusDB V3:

• 0049 Valid SELECT ... WHERE clause throws assertion when used as TnxTable.Filter SQL expression
• 0050 Engine mixes up non-aliased field in subquery and Order By; results in wrong sort order
• 0065 Left join causes AV
• 0068 Inserting records with SQL leads to duplicate entries on field with unique index defined
• 0075 Left Join on stringfield with locale descriptor does not return the correct number of records
• 0069 AV when calling stored proc from update trigger
• 0090 Difference using USING between 1.0x and 2.0706
• 0092 Problem with UPPER and locales
• 0098 Grouped USING join returns field from wrong table
• 0100 Using lower() or upper() changes VARCHAR(50) field into VARCHAR(255) field
• 0103 Key Violation issue

V2.08 - released on April 3rd 2009

• 2603 CAST(date/time/datetime as Varchar(x)) should raise exception instead of silent truncation
• 2609 Locate may hide timeout exceptions etc
• 2612 Problem joining empty string values with locale
• 2614 RecordGetBatch() on record with large blob fails (lack of network buffer space)
• 2607 Invalid pointer operation with insert using param in multi query script
• 1243 New Table in CSV import doesnt work
• 1765 AV accessing free'd object in TnxMainIndexTokenIndexCursorEngine.Destroy
• 2500 AV calling CloseInactiveTables after opening and closing query
• 2597 AV in server during heartbeat failure cleanup
• 2600 Widestring fieldmapper should check for Assigned(aMapperDesc)
• 1919 Unknown identifier EnxDatabaseException used in text
• 1729 Close table component after Restructure - Close
• 2438 Check/Add help file integration into D2005 to D2007
• 2149 Memoryleaks in engine
• 2495 Problem resolving column in multi-JOIN
• 2604 Invalid pointer operation happens spuriously
• 2606 Random AVs in sql engine
• additionally V2.08 includes numerous fixes/changes that have been rolled into V3 including optimizations to the SQL engine. Unfortunately due to some mistake we made when integrating the old issues into the new system, we don't have any further details on that :(

V2.07.06 - released on March 28th 2008

• 2493 Huge slowdown when using the TOSTRING function
• 2494 Use of various functions should force readonly resultsets on live request
• 2531 Deleting stored proc with illegal parameter throws AV
• 2532 View with illegal parameter should not be added
• 2573 Problem resolving column
• 2576 Query with IN does not appear to use index
• 2578 Memory leak when running SQL statement
• 2580 LIKE does not properly utilize index (slow)
• 2582 Add Option "ClientTechnology"="ODBC"
• 2583 Leak in TnxSqlTableExp.DoUnionExceptIntersect in case of timeout or exception
• 2584 Memory Leak running SQL statement
• 2585 Repeatedly running statement eventually ends in "unable to resolve identifier"
• 2586 Allow non-RESTRICT behaviour to delete stored procs referencing other procs
• 2587 Using RETURN without required return value throws AV when creating trigger
• 2588 Adding field to table causes previously existing field's default descriptor to change existing records
• 2590 Defining function input parameter with locale does not use locale with Upper/Lower
• 2591 Setting clientside Session.ClientLocaleAsDefault to True has no effect inside stored proc/functions
• 2592 String parameter passed into function should keep its locale info

V2.07.05 - released on January 24th 2008

• 2503 SQL Performance issue
• 2505 Query on fulltext indexed table throws stack overflow error
• 2525 MAX() should use index to only read 1 row
• 2553 Query does not use any indexes when it should
• 2556 LIKE ... ESCAPE character should be able to escape itself
• 2563 WHERE True throws AV
• 2564 Slowdown
• 2565 Multiple single quotes in string literal only result in one single quote in string
• 2566 Query throws AV
• 2567 Website issues
• 2568 Left join on SubQuery hangs if result is empty
• 2569 Another slow left join
• 2570 Join optimizer issues with relations using operator <> opEQ
• 2571 nxserver /start reports "server started" even if service not installed
• 2572 STD() aggregate returns wrong values
• 2574 select "SIN" from tablewithfieldsin throws error

V2.07.04 - released on December 23rd 2007

• 2557 Left outer joins with secondary filters return wrong result
• 2558 Certain combination of outer and inner join raises AV
• 2559 after Session.PasswordRemoveAll, server does not respond
• 2561 Null pointer free in nxptTCPRequestTransport
• 2562 Result of function no set in TnxRequestReader

V2.07.03 - released on December 18th 2007

• 2489 AV raised on invalid column reference
• 2501 Incorrectly using SELECT storedproc(param) ... throws AV in server
• 2504 Server ignores name and password if allowsystem parameter is True
• 2524 Problem comparing boolean fields
• 2527 Subquery with aggregate causes AV with Request Live = True
• 2528 Installing as a service does not show username/password dialog
• 2530 Updating blob memo from nxCachedDataSet adds spurious characters to server table
• 2533 SQL statement does not free used memory
• 2534 13 million character binary string triggers "token too long" error
• 2537 SQL causes leak of TNotification
• 2538 CAST('10000000000' AS LARGEINT) fails
• 2542 Linefeeds are not preserved in LIST()
• 2544 Running queries with RequestLive = TRUE makes server run out of memory
• 2546 Query on non-existent column causes AV
• 2547 Problems with CAST()
• 2548 Performance problem with JOIN on string fields and WHERE clause
• 2549 Problem with fieldname matching built-in functions
• 2550 Accessing table in different database alias before system tables are created throws error
• 2552 Wrong Millisecond separator is not flagged as error
• 2554 Extremely slow outer joins
• 2555 Outer join returns empty fields

V2.07.02 - released on August 24th 2007

• 800 If explorer.exe crashes, tray icons should be recreated
• 2470 FULL JOIN returns non-matching rows
• 2472 Query throws stringlist out of bounds error
• 2473 I just bought NexusDB for replacing some FlashFiler applications. Conversion went OK except some SQL queries that do not work...
• 2475 Event log Max Size not persistant
• 2476 Attempting to create index on non-existing field throws AV
• 2479 Chess Script throws AV when executing
• 2480 Query wrongly returns empty resultset
• 2481 Swapping WHERE clause parts around throws assertion
• 2483 AV is thrown when attempting to open table in latest code
• 2484 SetRange on Seq Index with invalid strings cancels range
• 2485 Problem with NONSTRICTASSIGNMENT option in comparison of parameters
• 2486 Memory leak in nxsqlCondExp
• 2488 Incorrect overflow check for BCD values

V2.07.01 - released on June 19th 2007

• 2443 Adding blob to table slows down query with 2 orders of magnitude
• 2449 Repeatedly running live query throws unexpected exception
• 2451 Query without obligatory aliased table expression returns 1 record instead of raising error
• 2452 Meta query throws roottable unknown... not found
• 2454 Incorrect Unable to resolve the identifier message
• 2455 Widechar field returns ever changing data
• 2456 SELECT distinct table_name FROM #indexes AV's
• 2457 Compilation error in nxptTCPRequestTransport (.NET Provider support file)
• 2458 Fix D2007 Help installation startup page issues
• 2460 Missing UPPER() parameter causes AV
• 2461 Importing csv into word-type fields fails on negative integers
• 2462 Query throws AV in engine after division by 0 error is thrown
• 2463 Check for grouped selection list items is faulty
• 2464 Sharedmem transport does not work with win9x
• 2465 Query throws unknown exception in state of "capability not supported"
• 2466 Server writes config file although AutoSave is off
• 2467 LIKE '...%' causes range check error when Request Live is True
• 2471 Root table not found with INSERT INTO and temp tables

V2.07 - released on May 31 2007

• 1953 Installer should use Borlands predefined localized path to store BPL files in non-Enghlish Delphi versions
• 1987 TnxQuery.RecordCount returns wrong value for filtered query
• 2046 Prepared stored proc always returns the same value
• 2048 Constraint name uniqueness should be enforced
• 2052 The service should not allow itself to start if the server is already running from the same directory
• 2110 Assert in SQL engine when cleaning up after client heartbeatfailure
• 2170 Function returning TABLE should require TABLE in FROM clause
• 2208 Add rename table, rename column and changecolumn type to sql
• 2216 Error message when attempting to access deleted blob could be improved (Exprected BlockOwnerID ...)
• 2229 Function returning TABLE cant be used as a
• 2312 Autosave on Exit setting can't be turned off
• 2318 Bug when comparing blank, non-localized strings
• 2319 Stored procedure throws assertion
• 2320 Stored proc returns no records
• 2321 Server cannot start as service when explicitly started from commmand line
• 2323 Temporary table is not removed when query execution stops on error
• 2324 Unable to resolve identifier in aliased table expression created with UNION
• 2325 Refreshing table inside transaction throws Block 0 has not the correct signature error
• 2326 SELECT ... IN (SELECT ...) does not return records
• 2327 Problem with IN and local variable
• 2328 Problem with IN workaround in stored procedure
• 2329 Problem with left join in stored proc only returning data for first record
• 2330 Problem resolving tablename in join
• 2331 Left Join returns null for some values when used inside stored procedure
• 2332 WHERE field LIKE 'Y023 %' does not find matching records where matching records exist
• 2333 Using multiple EXISTS in the WHERE clause fails with factor not found
• 2334 nxServer /HELP only shows /NOICON info
• 2335 Inconsistent line/pos error position values returned
• 2336 SELECT field, SUM()... without GROUP BY should throw error
• 2337 Engine does not delete blob contents from table (table size keeps growing when adding and clearing blob)
• 2338 Select field from v1 table with RequestLive = true throws AV
• 2339 Investigate massive slowdown with joins
• 2340 Shared memory transport throws "access denied" exception when used under Windows Vista
• 2343 Improve "alias does not exist" message with aliasname
• 2344 SELECT rightjoinalias.*, * From .. throws AV
• 2345 Problem with DWORD values
• 2346 Swapping WHERE clause parts around returns different resultsets
• 2347 Query returns no records where matching records exist
• 2348 TnxSqlRowBuilder.ApplyFilterRange seriously broken
• 2349 TnxSqlSELECT.NormalQueryResult frees unititialized variable FieldDefList
• 2350 ORDER BY orders on the wrong column
• 2351 Northwind example script fails to run
• 2352 Problem with IN and #temporary table
• 2353 Problem with IN and repeated list value causing multiple copies of rows to be returned
• 2354 CONTAINS(non-fulltext-index,...) should throw error
• 2355 Query throws integer overflow error
• 2356 Invalid column reference not caught
• 2357 Query in trigger throws scalar subquery expected error
• 2358 UPPER() does not take table locale into consideration
• 2360 UPDATE query throws "Expected BlockOwnerID ..." error on temp table
• 2362 Typing something other than a number in the MaxRam field throws AV
• 2363 Using RETURN in stored procedure should produce sensible error message
• 2364 Query with ORDER BY...DESC does not correctly order the resultset
• 2365 Meta table caching problem
• 2367 Problem resolving identifier in correlated subquery
• 2368 Query throws AV on freeing function reference
• 2369 Query on CHAR() variable in SELECT list gives "could not convert variant ..." eror
• 2372 Query returning more than one column should not be allowed in calculations
• 2373 Query throws "error in addindex list: unknown column..."
• 2374 Query is slow/never times out (timeout = 10 sec)
• 2375 Add option to session to direct server to use specific client locale for string constants in SQL
• 2376 ToString should allow for longer input than 256 characters
• 2377 Query triggers assertion in nxSqlProxies.pas
• 2379 Query throws assertion; result unable to resolve identifier
• 2380 Nonexisting column name should throw error
• 2382 mapping empty string to blob can cause corruption
• 2383 MIN/MAX on nonpadded nullstrings should not return padded strings
• 2384 Query takes a long time and eats up memory
• 2385 SELECT LIST(field) FROM TABLE does not throw error on non-charachter fields
• 2387 TnxTable.AddIndexEx updates datadictionary even if operation fails
• 2388 Server does not Apply new settings but reverts to old
• 2389 GROUP BY on date/time fields from memorytable return strange values
• 2393 Query throws AV in engine
• 2394 Extra asterisks in comment specifier results in syntax error
• 2395 Query throws range check error
• 2396 Add support for unicode special characters (NCHR function?)
• 2397 SELECT ... DISTINCT ... returns NULL date fields
• 2398 Incorrect Union Result
• 2399 Large object columns not allowed in grouping operations
• 2400 Query throws integer overflow
• 2402 Query never stops executing
• 2403 Client method to fetch list of users (sessions) logged in
• 2406 Query throws integer overflow
• 2408 Heap engine sometimes corrupts blobs or variable size records
• 2410 Table with SQL filter created pre-localization switch code can't be opened with new server
• 2411 Multiple EXTRACT() calls combined with AND returns too many records
• 2412 TIME/TIMESTAMP assignment issues
• 2413 Engine should not assume any indexes exist (AV occurs if no indexes exists)
• 2414 Query throws "field out of range" error
• 2415 Turning on transport compression would fail at design-time with lost connection
• 2416 Assert may trigger erroneously
• 2417 Ambiguous error displays blank table/alias name
• 2418 Column binding error
• 2420 New client-side selected locale does not work for parameters
• 2421 Remove #0 from Client IP log entry
• 2423 If started twice from the same folder, nxServer now shows error dialog twice
• 2424 Range error thrown with this query
• 2425 Server should not save files under Program Files directory under Windows Vista
• 2426 Server Mutex should be created with an "all access"DACL
• 2427 Query throws AVs internally (they are handled but should not occur in the first place)
• 2430 Query erroneously throws ambiguous column error
• 2431 Dropping table erroneously throws "referred to from another table" error
• 2432 Stored procedure throws AV
• 2433 Using live queries could lead to AVs in the engine
• 2434 Server does not correctly remember windowposition between restarts
• 2435 When FreeFieldBuffers fails (e.g. timeout) inside Post the dataset remains in dsInsert and the same record can be posted again, possibly leading to multiple records referencing the same blob.
• 2436 TnxBaseSessionPool.bspTimeout not initialized
• 2439 Blobfield.IsNull returns wrong value after Post
• 2440 Query timeouts cause AVs
• 2441 Query throws AV
• 2443 Adding blob to table slows down query with 2 orders of magnitude
• 2444 Other AV in SQL engine on Win98
• 2445 Opening table with child table throws assertion
• 2447 Parser doesn't recognize "national character large object" and "nchar large object" anymore
• 2448 INNER join USING is broken

V2.06 - released on Jan 12th 2007

• 1512 Consider how to rename duplicated fields from aliased tables
• 1556 Problem with passed in proc parameter using INOUT/OUT
• 2193 Problem with outer reference in HAVING clause
• 2195 Aggregate functions in the WHERE clause
• 2241 CONTAINS... used with ORDER BY does not correctly order
• 2259 Delimited identifiers resolved wrong in VIEWS
• 2261 Server not working in Win98
• 2268 Wrong query evaluation
• 2283 Script with large numbers of INSERT statements runs very slowly
• 2285 UPPER comparison with national characters fail
• 2301 Char() type variable and cast does not return correct length
• 2303 Engine should not try to optimize field comparisons using an index when there is no global- or field-level locale defined
• 2304 Query with DISTINCT causes AV
• 2305 Double CAST on datetime returns integer
• 2307 SELECT *, a.blob from ablob a with requestlive = true throws errors
• 2308 Converting v1 table to v2 and then restructuring throws invalid property value error
• 2309 Query throws invalid floating point operation error
• 2310 Query wrongly throws "unable to resolve" error on alias used only in valid table expression
• 2311 OPTION function wrongly returns char(6)
• 2313 IN (NULL, ...) fails
• 2314 IN (CAST(NULL as [var]char()))... fails
• 2315 TnxSqlRowBuilder.SetSortedState does not take ReadReversed into account
• 2317 Joins unnecessarily copy blobs under certain circumstances

V2.05.99 Rel.4 beta - released on December 31st 2006

• 2169 Problem with qualified * in while blocks
• 2179 Query returns "index does not exist" instead of correctly returning timeout error
• 2199 Unable to resolve identifier in multijoin
• 2207 Query returns spurious extra characters in stringfields with MBCS data
• 2211 Problem with preparing queries
• 2226 GROUP BY columns return NULL for query on large table
• 2233 Problem resolving qualifier in stored procedure
• 2252 Performance regression with sudoku query
• 2255 Unable to resolve identiedier with select t1.*, t2.* ...
• 2257 Table lookup is Case sensitive in certain circumstances
• 2258 unable to resolve the identifier with left joins
• 2262 Slow Query - Optimizer problem
• 2263 Invalid Cast in View
• 2265 Field after * stays empty with distinct
• 2266 Table_Type set wrong for local temporary tables
• 2267 Equivalent joins return different results
• 2269 Non-scalar subquery in the select list
• 2270 Subquery in the select list returns null in grouped query
• 2271 Dependency check bugs
• 2272 Engine throws No explicit transaction in progress error
• 2273 Method parameter name matching reserved word should throw error
• 2274 Delimited parameter name should not be interpreted as reserved word
• 2275 Trigger returns wrong result the 2nd time it is called
• 2276 Statement makes server process disappear
• 2277 Cross database insert query does not insert data
• 2278 Invalid syntax not caught in insert
• 2279 Problem resolving column
• 2282 Query uses excessive amounts of RAM
• 2284 #Fields.Field_DefaultValue returns nonstandard values
• 2286 SELECT should not attempt to return and resolve columns removed with USING
• 2287 Multiple "Select Distinct" throws AV
• 2288 DISTINCT returns NULL for field with value
• 2289 Error message should include tablename
• 2290 Query throws Invalid index descriptor error
• 2291 Group By returns wrong value
• 2293 Setting default value on char,widechar,formatted bcd throws error
• 2294 Trigger updating 2nd table causes AV
• 2295 Parsing should throw error on missing default columntype specifiers and wrong default value formats
• 2296 IN (subquery) should throw error on multi-column subquery regardless of prescence of index
• 2297 Trigger causes AV on 2nd delete from table
• 2298 Error should be thrown on subquery column not in group by
• 2302 Trying to open the MasterFields link dialog on a password-protected table throws error even though password is present in Password property

V2.05.99 Rel.3 beta - released on November 1st 2006

• Implemented more details for exception logging
• New settings for SQL Engine to log queries

V2.05.99 Rel.2 beta - released on October 29th 2006

• 1411 Engine should use correct TargetCursorDescriptor for RI links depending on type of link
• 1563 Engine needs to evaluate passed in parameter types
• 2227 Regression: Fix for 2201 causes AV at shutdown
• 2237 Where clause without parentheses in stored proc does not return all records
• 2243 CREATE TABLE ... LIKE fails with AV across different databases
• 2248 IN does not correctly check for datatype match
• 2249 Error should be thrown on use of column from second table inside table expression
• 2250 CROSS join returns NULL for 2nd table expression columns
• 2253 Regression in cross database queries
• 2256 Range check error in left join with double

V2.05.99 beta - released on October 18th 2006

• 2197 Problem resolving JOIN alias in stored procedure / AV
• 2206 Uncorrelated IN subquery returns wrong number of records
• 2213 Query on #functions does not return data for all rows
• 2214 DROPping table should fail if there are password-protected tables present and the passwords have not been added to the session's password list
• 2219 LEFT JOIN does not return data for joined table
• 2220 Missing ORDER BY column does not throw error
• 2222 Meta query does not return rows when aliased
• 2224 Query should fail on LIKE '..' OR '...' OR ...
• 2225 AV when calling function and passing in select result
• 2228 SELECT DISTINCT...WHERE field IS NULL returns non-NULL records
• 2231 TOP n with ORDER BY returns all records
• 2232 SELECT...INTO should be allowed in function routine body
• 2235 Old-style join with where clause returns no records
• 2236 Left outer join ... on upper(s) = upper(s) fails to return records
• 2238 CREATE TABLE wrongly throws "multiple unique constraints defined..." error
• 2240 Improve "index does not exist" error with indexname
• 2242 ORDER BY 2 with requestlive = true causes AV
• 2244 Wrong number of columns in INSERT INTO...() SELECT ... could throw better error message than "list index out of bounds"
• 2245 Shortstring to shortstring field transformation fails
• 2246 Remove SQL parameter name 20 char length limitation

V2.05.98 beta - released on September 18th 2006

• 1069 Add fulltext syntax to parser
• 1896 Simple fulltext demo should not require XML file or XML Partner
• 1926 Setting memo fields to '' (empty string) should be allowed and autoconvert value to NULL
• 1944 Engine should allow assigning empty string to blob memo (translate to NULL)
• 1963 Message on key violation could be improved with table and indexname
• 1982 Show query log even when error stops query processing
• 2007 Query triggers EVariantBadVarTypeError on Windows 2000
• 2050 Setting BlockReadSize back to 0 does not do a proper resync (IsEmpty returns True)
• 2176 Table with RecNo support on should not throw Record/Key deleted errors for records deleted by others when fetching RecNo
• 2190 Server does not free all cursors etc when connection is lost (record can still remain locked)
• 2205 Adding index that would require blocksize to be increased should return proper error message instead of "dictionary is readonly"
• 2209 Query throws range check error
• 2210 alter table Table1 drop constraint "" deletes first index
• 2212 Order by on out of range column number causes AV
• 2217 Query throws BCD overflow
• 2218 Query errs with "could not convert olestr to type double"
• 2221 Setup issue of BDS2006 DCU edition

V2.05.97 beta - released on September 4th 2006

• 2039 Parser error with bracketed joins
• 2168 Ambiguous column reference not raised
• 2173 Ambiguous column problems with natural join
• 2175 Stored procedure with ATOMIC which mixes DDL and DML should trigger appropriate error
• 2180 Query does not return data for grouped column
• 2188 Query throws list index out of bounds
• 2191 Problem with column from aliased outer table not in scope in subquery
• 2196 Select max(field) should take advantage of index on field
• 2200 Function should return NULL and not False
• 2201 Query across databases throws AV
• 2202 Can't resolve variables in subselects

V2.05.96 beta - released on August 27th 2006

• 2040 Trigger should not cache query result between executions
• 2135 Slow left join with where clause
• 2140 Wrong column naming in join
• 2150 Assertion in TnxModifiedBlock.DecreaseTransLevel during recoverrecords
• 2157 Wrong error position returned
• 2160 Wrong error position returned
• 2165 Natural join should not throw unknown column error on unqualified use of joined column
• 2171 View with wrong number of parameters should throw better error than "list index out of bounds"
• 2172 Wrong column type from COALESCE
• 2173 Ambiguous column problems with natural join
• 2178 Aggregate query throws operation aborted error message
• 2181 Unable to resolve qualified identifiers in mutliple joins
• 2182 Query should not attempt to resolve using() columns in "select table.* ..."
• 2183 Query with parentheses should trigger error on division by 0
• 2184 Hello Nexus-Support....
• 2185 Display variant keyfield column when viewing fulltext index in tablebrowser
• 2186 Column1 / (Column2) gives multiplied result instead of division
• 2189 Trigger causes access violation
• 2194 Multiway outer join is broken

V2.06.01 / V2.05.95 beta - released on August 15th 2006

• 1522 ORDER BY used in UNION query expression should be detected as an error
• 1565 UNION gives list index out of bounds without parentheses
• 1572 Problem comparing CHAR types, trailing spaces should not be used for comparison
• 1929 AV when creating mappingcursor
• 2153 Query raises abstract error
• 2155 GROUP BY without aggregate should throw error
• 2174 Query throws "no user transaction is currently in progress"
• 2160 Wrong error position returned
• 2177 Adding records to live resultset duplicates data from previous record

V2.06.00 (DCU only) - released on August 8th 2006

• 1582 Speed issues in views
• 1684 AV when attempting snapshot trans and read-write trans is active
• 1876 Query should throw "unknown column" error
• 1912 Query throws AV on missing tables
• 2026 Quantified Comparison Predicate problems
• 2080 RESTRICT drop behavior (dependency check) is not enforced when dropping a routine
• 2128 Posting records on table with trigger throws AV
• 2129 Updating table with triggers throws AV
• 2142 COUNT should return BIGINT, not DOUBLE PRECISION
• 2151 Hash join speed regression
• 2154 BCD overflow in BDS2006
• 2156 Error message could be improved on unknown order by identifier
• 2158 Check if errorposition can be returned for this type of query
• 2159 Query erroneously complains about qualified field in USING
• 2161 Nullstring string conversions failed for fields longer than 255 chars during restructure
• 2162 Query slowdown regression in 2.0594
• 2163 Single-column inner query should not throw "single-column query expected" error when order by is used
• 2164 Calling function with top/order by throws "order by in union not supported" error message
• 2166 order by and top in functions trigger av
• 2167 Query wrongly returns "Single-column query expected"

V2.05.94 - released on July 26th 2006

• 1912 Query throws AV on missing tables
• 1949 SELECT function(..)... gives AV
• 2008 Timeout not checked during LIKE processing
• 2014 Previous page is not hidden in restructure window
• 2140 Wrong column naming in join
• 2142 COUNT should return BIGINT, not DOUBLE PRECISION
• 2143 Left Outer Join slowness in 2.0593
• 2144 Query fails to return records
• 2145 Field NOT IN (Select...) returns wrong result
• 2146 Query with NOT EXISTS() throws AV
• 2147 Where used with Group by returns no records
• 2148 Query with ORDER BY 2 throws AV
• 2152 Cursor stays open after ExecSQL due to Unprepare not called autmatically.

V2.05.93 - released on July 23th 2006

• 1663 Old-style cartesian join returns fields in wrong order
• 1925 Column order incorrect in cross product query
• 2081 RESTRICT drop behavior (dependency check) is not enforced when dropping a table
• 2082 RESTRICT drop behavior (dependency check) is not enforced when dropping a view
• 2112 Result sets have incorrect column order
• 2130 Cannot drop table with same name as tablealias used in trigger
• 2132 Invalid-Pointer-Exception using MemoryManager V3.04 - see "Steps to reproduce"
• 2133 HAVING is not evaluated
• 2134 Referencing same column twice in group by gives "stringlist does not allow duplicates"
• 2136 Natural/Using join issues
• 2137 regression issue grouping/having
• 2138 Query generates AV.
• 2139 Index already exists [$272B/10027] [$272B/10027]
• 2140 Wrong column naming in join
• 2141 Unable to resolve qualified column in where clause

V2.05.92 - released on July 20th 2006

• 1875 UNION should not require parentheses around the
• 1902 UNION gives column number mismatch error
• 1904 Problem evaluating variable in loop
• 1907 Function should not throw type mismatch between RETURN and RETURNS
• 1927 Make column renaming consistent
• 1941 SQL filter on table throws AVs internally
• 1962 Ambiguous column error should not be raised
• 1968 Query slowdown regression
• 1971 Error should be raised on unknown table alias in inner table scope
• 2029 Grouping does not return all needed values
• 2083 RESTRICT drop behavior (dependency check) is not enforced when dropping a column
• 2114 Natural join does not return expected row
• 2115 Natural join returns wrong data types for common columns
• 2116 Natural join should throw error on qualified common column in where clause
• 2124 AV when accessing qualified database
• 2131 Group By broken!

V2.05.91 - released on July 17th 2006

• 1250 Predicates in SELECT should not require parenthesis around them
• 1263 Optimize joins
• 1766 Query should throw syntax error on wrong ON part
• 1800 Slow IN predicate
• 1803 Implement String types to String types / BlobMemo types data conversion
• 1877 ORDER BY should trigger exception on nonexisting column
• 1891 Parameters used in "Create Table as ..." leads to type mismatch error
• 1905 WHERE clause could optmize the join further
• 1927 Make column renaming consistent
• 1942 SELECT ... WHERE IN (SELECT ...) could be optimized for live queries
• 1955 Recursive function that returns table throws AV
• 1956 Review transaction fixes
• 1965 Check if old-style join can be optimized for this query
• 1969 Query gives list index out of bounds
• 1970 Query gives string list does not allow duplicates
• 1973 Join on #meta tables takes forever and all RAM
• 1974 Join on Procedure/Procedure_arguments meta tables returns joins of all records regardless of join match
• 1975 Performance could be better on simple selects
• 1976 Problem with GUID comparison in stored procedure
• 1977 Prepared query does not change if parameter value changes
• 1978 Problem compiling nxSqlCondExp with BCB6
• 1979 Error message correction
• 1980 TnxStoredProc with params causes AV in server
• 1984 Query throws list index out of bounds error
• 1986 Use recordcount estimates to decide on driving table for joins
• 1988 AllocatedBytes gives wrong result under BCB6/BDS 2006
• 1992 Calling First after setting BlockReadSize should not cancel an active range
• 1993 If $DEFINE SecureServer in nxDefine.inc is undefined, the server does not compile
• 1998 INSERT in SQL throws AV in Delphi 5
• 1999 Meta Query causes AV
• 2000 Running query twice causes AV
• 2006 Invalid field name character """ triggered
• 2009 Ability to cancel live backup/restore
• 2010 Stored procedure adding foreign keys fails to execute
• 2011 DISTINCT does not return distinct rows
• 2016 Select a.*... returns NULL for all fields
• 2018 NexusDB: Block number is out of range (EnxCachedHeapEngineException)
• 2022 IN subquery taking very long
• 2025 TRIM issues
• 2029 Grouping does not return all needed values
• 2030 Null values not returned if "no nulls" index exists
• 2032 Tablename should be readonly on restructure
• 2033 V2 slowdown of query
• 2037 Column name in ORDER BY not recognized
• 2038 SELECT TOP ... ORDER BY returns no records
• 2041 Client does not receive proper error message
• 2043 Join columns should require table qualifiers
• 2044 Table with variable record engine fails to recover the whole table
• 2045 Date/time functions should be evaluated once per statement, not per script
• 2046 Prepared stored proc always returns the same value
• 2047 Join should give proper error when expression is not boolean
• 2049 Query could give "you need to roll back this transaction" error when no explicit transaction was started
• 2051 Aggregate query with simple fields last in SELECT list should trigger error
• 2053 TOSTRING should return Ansi format strings for date/time fields
• 2055 Comparison with negative number on DWord column should not fail
• 2056 ELSEIF causes AV
• 2057 Query with ambiguous column names should raise error
• 2060 Meta query gives "could not convert variant..." error
• 2061 EXISTS is much slower in 2.05 than in 2.02
• 2062 DROPping a number of indexes in the same script throws AV
• 2063 Order By n... should show sensible error if n is larger than columncount
• 2065 TnxStoredProc triggering AV when the proc returns a row set
• 2066 Range check error with inner join and negative values
• 2067 Timeout handling could cause integer overflow error
• 2068 Int64 not handled properly
• 2069 IN Query takes forever to run
• 2070 Slow join execution
• 2071 IN clause in constraint not working correctly
• 2072 Implicit columns in REFERENCES not working to standard
• 2074 Tablebrowser should reset the flip order flag when opening
• 2075 Function returning Table throws AV
• 2077 Indexed and aliased column should find an index match during query processing
• 2079 IN (subselect) erroneously matches all records
• 2084 Update statement with SELECT...ORDER BY should throw error and update the correct record
• 2085 DELETE query does not check timeout
• 2086 Query throws "could not convert variant of type olestr into type double" when comparisons are on string fields
• 2087 Adding fulltext index with invalid ident characters fails
• 2088 Lower and Upper fulltext index checkbox states are not saved
• 2089 Query throws "error in AddIndex list. unknown column:..."
• 2090 DECLARE...DEFAULT does not set the default variable value
• 2091 Message when attempting to drop column used by unique constraint should say constraint, not index
• 2092 Expression/Func filters were not nulled when closing dataset
• 2093 Dropping procedure throws wrong dependency error message
• 2094 nxParamToSqlParamDesc function fails with a NULL ftWideString
• 2095 BlobMemo/BlobWideMemo fields in table/querybrowser should only save data back if they were modified
• 2096 Add check/uncheck all buttons to backup window
• 2098 Investigate Knowall queries slowdown regression
• 2099 Query cant resolve table.field identifier in where clause
• 2100 Installer should use win32 executable to unzip downloads (dos exe fails on win64)
• 2102 Deleting or renaming database throws "invalid class typecast"
• 2103 Changes to accomodate SQL filters result in all queries run from EM throwing AV
• 2104 ORDER BY throws unknown column exception on single aggregate column
• 2106 AV in SQL engine
• 2107 Support creation of conditional (filtered) indexes
• 2108 CASE statement in SELECT returns NULL instead of correct data
• 2109 AV in SQL query on empty table
• 2111 Engine should throw error on attempt to GROUP BY expression column
• 2113 Query throws invalid pointer operation
• 2117 Query returns inconsistently named columns
• 2118 Slow outer join
• 2119 Order by desc not properly applied in subquery
• 2120 Query throws "Error in AddIndex list Unknown column" error
• 2121 Problems inserting and comparing with chr() function
• 2122 Unckecking fields in fulltext index fieldlist throws name not unique error
• 2123 ORD does not return the expected values
• 2125 Error position in SQL statement is incorrectly calculated if running selected text
• 2126 Add index operation on server with low MaxRam setting terminates prematurely without error, losing records
• 2127 Update on Int64 column with Case throws type mismatch error

V2.05 - released on March 27th 2006

• 655 CSV import shows wrong percentage in progress dialog if sourcefile is larger than 4GB
• 840 Voluntary email address submit system for those who want to receive general announcements fron NexusDB
• 1244 Improve error message returned to client with info on table and link: rsDBIERR_FORIEGNKEYERR = 'Master record missing.'
• 1426 CMOVx ASM statements need to be IFDEF'ed away for old crappy CPUs
• 1764 UNKNOWN only applies to Boolean primarys
• 1793 Problem with OUT param in CALL
• 1805 Allow cut and paste in secured transport key edit fields
• 1811 Ambiguous column reference should trigger error
• 1824 Testcase for JOIN optimizations
• 1857 Problem closing EM if connection is lost
• 1890 Triple left join with where clause on third table is not optimized
• 1892 Casting constant to numeric with requestlive = true fails
• 1893 CommandTimeout has no effect
• 1895 Creating a RETURN statement without BEGIN..END results in AV when called
• 1897 Adding constraint to child table fails even though a suitable index exists
• 1900 Optimization error with LIKE and localized index
• 1901 System tables ($SQL$...) should not require admin rights to be created
• 1904 Problem evaluating variable in loop
• 1906 Query should throw ambiguous table reference error
• 1908 Not 100% sure whether this functionality is incorrect, but here is a description:...
• 1909 Not 100% sure whether this functionality is incorrect, but here is a description:...
• 1911 ShortString Parameter returns "Source string data is too wide for the target field" error
• 1914 Variant code optimizations
• 1915 Add possibility to connect to server without specifying a database
• 1916 AV with "recursive" query in 2.04
• 1917 AV and 100% CPU use after session terminates due to heartbeat failure
• 1918 Assigning variable to field in loop inserts wrong value
• 1921 Query throws assertion
• 1922 I can add an alias with enterprise manager....
• 1928 Upper(stringfield) = Upper(:param) should not throw error when :param is null
• 1931 Assertion thrown in buffermanager followed by AV
• 1932 Wrong sort order when sorting on field from 2nd join table
• 1933 Query throws "list index out of bounds" instead of sensible error message
• 1934 SQL function resolver hub list is not threadsafe
• 1935 AV in TnxTableLockContainer.tlcGetReason referencing OwningSession
• 1937 SMPTest throws "Could not read exact nummber of bytes"
• 1939 Add support for DBFactories
• 1940 Tabulator is a legal whitespace character
• 1943 SYSTEM_ROW# returns NULL with GROUP BY
• 1946 Queries dont return values/rows under windows 2000
• 1948 Group By returns values from the wrong table
• 1951 UPDATE query takes far too long (iterating gone wild)
• 1952 Opening and closing SQL browser turns sql log on and off
• 1954 Engine is too restrictive in checking for RI / FK field type match
• 1957 SQL filter statement throws AV's internally
• 1961 Queries with function gives AV
• 1964 TnxWideStringVclFieldMapper.MapVclDataToNexus... fails on Delphi 2006
• 1966 Select gives "block number out of range" on temporary table
• 1967 I get an error message when performing a SELECT statement:...

V2.04 - released on February 1st 2006

• 1444 Support snapshot transactions in SQL keywords
• 1816 Integer Overflow in aggregates
• 1858 Passing Blob in ftBlob paramenter causes type mismatch error
• 1862 Joins with LIKE are not optimized
• 1864 Simplification Issue
• 1865 Calling Database.TableBackup repeatedly gives "System has been illegally reentered"
• 1866 AV with join and parameter
• 1867 Query wrongly gives ambiguous column reference error
• 1868 Invalid Primary key constraint created
• 1869 Another "Index doesn't exists" problem with RI and SQL
• 1870 Multiplying by -1.0 results in "invalid floating point" error
• 1871 Database dropdown in Live Backup dialog doesnt change when server changes
• 1874 RecoverRecords throws reentrancy exception
• 1878 Problem deleting child.child table
• 1880 Using bytearray SQL parameter gives AV
• 1881 Functions should not accept non-numeric arguments
• 1882 Join with view and table gives ambiguous column error
• 1883 WHERE clause doesnt check both parts of ... AND ...
• 1884 Query throws AV
• 1886 GUIDS are uppercased and case sensitive
• 1887 Type mismatch error for procedures with BIGINT
• 1888 AV With joins in CREATE TABLE AS

V2.04 beta3 - released on January 23th 2006

• 686 SELECT DISTINCT is slow
• 1289 AND could use some optimization
• 1538 Inconsistent field exist test in CASE when table is empty
• 1754 Subselect in Update does not return any value
• 1775 INTERVAL does not detect bad following non-numeric string
• 1799 ORDER BY should throw exception
• 1808 HAVING issues
• 1813 Add constraint name for system created constraint indices.
• 1817 NULL values in index create BAD join performance
• 1818 GetLongPathName stops nxServer from running on NT4
• 1825 Problem finding record with ' ' (space)
• 1826 AV raised when viewing tcp/ipv4 page in server UI
• 1846 Problem freeing object/Assertion
• 1847 Regression with constraint names
• 1848 Range check error triggered under Win98
• 1849 GUID and BLOB are not assignment compatible
• 1852 VIEW can't have same name as TABLE name
• 1853 $SQL$xxx tables should not use widestring fields for identifiers
• 1856 Function returning TABLE should trigger error if used in SELECT list
• 1859 Massive slowdown in restructure operation since 2.03
• 1860 Key Violation when inserting trigger into system tables
• 1861 LIKE does not return all records in LEFT JOIN
• 1863 Assertion when using live backup

V2.04 beta2 - released on January 16th 2006

• 1742 TnxTable.Refresh does not work as expected with SQL type filter
• 1763 Alias in SELECT causes ORDER BY on original fieldname to fail with unknown column
• 1785 Live Query generates invalid filter expression
• 1786 Query wrongly returns no records
• 1801 Clicking the 'Pin' icon causes AV
• 1809 Extract( year from MIN(date)) gives type mismatch
• 1810 Trigger source is truncated
• 1814 Query simplification going out of whack
• 1815 funtion returning table lists boolean as result type
• 1819 Show password character in EM for password and key input
• 1820 Function that changes data triggers "cant be used in this context" error on use
• 1822 Erroneous join does not stop processing

V2.04 beta - released on January 12th 2006

• 1018 Live backup on Northwind database gives "index does not exist"
• 1124 Restoring a v1 live backup with v2 results in "index does not exist"
• 1279 Fast Report inegration problems - Session not connected
• 1291 Make Trigger source and more data about them available through metadata
• 1306 Change 'UPPER() LIKE' into '...LIKE IGNORE CASE' internally
• 1426 CMOVx ASM statements need to be IFDEF'ed away for old crappy CPUs
• 1433 AV with triggers
• 1440 Return Static instead of nx1xDefault as storage engine in #Tables
• 1470 BETWEEN slow with dates.
• 1472 Improve FK violation message
• 1499 Default values not mapped when restructuring.
• 1520 SQL engine should not alter the case of tablenames when changing table structure
• 1596 Confusing Null behaviour with SQL created indexes
• 1616 Aggregate error message mixup
• 1619 Problem with function returning Table and using alias on return value
• 1630 query optimizer fails on NULLS
• 1635 Error should be raised when IN operands have different degree
• 1653 Improve "Master record missing" message when posting RI detail records
• 1661 Locate erroneously returns True when using variable length record engine
• 1665 Creating Shortstring field should map to varchar, not char
• 1666 Field does not clear contents when posting changes
• 1667 Function does not handle passed in value correctly
• 1668 Queries raises abstract error
• 1670 Query returns no records where records should be returned
• 1671 Datetime castings
• 1672 Problem evaluating qualified table.field column in GROUP BY
• 1673 TnxBlobStream and friends should support writing at a startposition larger than the size of the existing blob
• 1674 Toolbar settings were not correctly restored on restart
• 1675 Functions doesnt work in GROUP BY
• 1677 AV when unpinning/pinning server window
• 1678 IN doesnt return hits if index exists on field
• 1679 Timeout gives wrong error message
• 1680 Performance is slow with EXISTS
• 1681 Widestring to NullString, Boolean to various fieldmappers failed
• 1682 Old-style join never finishes processing; raises integer overflow
• 1685 Sub-Queries time out and/or return wrong data when RequestLive is true
• 1686 Contents of compound statements inside IF blocks is ignored
• 1687 Column picks up wrong name; CAST instead of the alias given
• 1688 Delete operation raises assertion in index engine
• 1689 Delete operation performed twice causes AV in server engine
• 1692 Error inserting value in BCD field
• 1693 Problem with left join not pulling data from right table
• 1695 CASE expression in procedure fails
• 1696 #Procedure/#Function_arguments problems
• 1703 Adding NOT NULL constraints should check exisiting data
• 1704 Trigger failure
• 1705 SET PASSWORDS ADD ... not working
• 1706 WORD32 type not handling large numbers correctly
• 1707 RI Bug
• 1709 Problems with LIKE
• 1711 Performance issue in primary key
• 1713 Procedure should not RETURN a result
• 1714 AV when Close Inactive Tables is set on the server engine (Server UI)
• 1715 #functions.function_source issue
• 1716 Issue with query expression in UDF
• 1717 FOLD function - wrong results
• 1718 trigger params problem
• 1719 NOT IN not working properly
• 1720 IN subquery creates AV/no result
• 1722 SkipOnNull flag missing on referencing fields
• 1724 Empty table removes password
• 1725 Join failure
• 1727 Query fails 2nd time around with "unable to open table"
• 1728 MED() aggregate calculation is wrong
• 1730 Backupcontroller should calculate progress from recordcount instead of guessing at size in bytes
• 1731 Problems with keydescriptors etc
• 1732 Creating procedure/function should enforce uniqueness in paramenter names
• 1733 Utilize index for live queries of the form ... LIKE 'String%'
• 1734 Problem with CHECK constraint?
• 1735 Live resultset not returned using GUID field in WHERE clause
• 1737 Syntax error in attached SQL script
• 1741 Adding 2nd table with left join removes rows from left table
• 1743 Unique constraint is created even if data is not unique
• 1744 Collation options on fields are not applied to the locale descriptor
• 1748 Disable recordcount option for live queries
• 1749 Check that "toggle live dataset" toolbarbutton stays down
• 1750 If Index "0" is not SAI, cant use a range in tablebrowser
• 1751 Unexpected exception with "E-Mail as Mail" in select list
• 1752 Ending parenthiesis in stored proc is not stored
• 1753 TOP n does not work with GROUP BY
• 1756 Timeout value not checked during stored proc execution
• 1759 Add ALTER TABLE support for ENCRYPT WITH, etc
• 1761 Investigate wether filters reads the same block of data twice from the physical media
• 1762 Implement PSGetUpdateException to return proper errorcodes for datasnap
• 1771 We are experiencing an issue with memory growing to a point that eventually exceeds the available memory and causes a catastr...
• 1772 Hi,...
• 1773 live queries with string params containing ' fail
• 1776 Using a descending index does not return any records in live query
• 1787 Menu shortcuts shared in dynamically activated menus were not working
• 1788 Live result does not stop on erroneous subquery
• 1789 Insert ... (newguid) goes not insert GUID value
• 1792 Query selecting from function triggers assertion
• 1794 Problem with HAVING clause
• 1795 The following query works fine in Nexus V1 , but not in V2:...
• 1796 i Just Ordered Nexus V2 after i tried my project with Nexusdb Trial V1 , which worked fine.....
• 1798 HAVING does not throw error on unknown column
• 1802 Database alias not recognized in trigger
• 1804 NULL rows are returned when they should not be
• 1806 Self referencing (and possibly other) RI not removed correctly when using alter..drop
• 1812 Problem converting float variant into string
• 1813 Add constraint name for system created constraint indices.

V2.03 - released on September 28th 2005

• 844 Importing CSV into shortstring fields that are shorter than the source text stores the full source length in byte 0 of the field instead of the max fieldlength

• 1407 Problem evaluating check constraint
• 1434 Sub Query doesn't resolve full qualified field names correctly
• 1446 Show Autoinc seed and step in #tables
• 1454 Optminization of live queries
• 1517 Duplicate unique constraints should trigger an error
• 1561 Evaluate use of integer/DWord/Autoinc type compatibility
• 1579 AV in engine when adding and removing read-only databases
• 1593 Problem comparing datetime columns
• 1596 Confusing Null behaviour with SQL created indexes
• 1602 Join speed test on Northwind view
• 1607 UNION query is orders of magnitude slower than its separate parts
• 1609 "Block number is ..." problem in table created by query
• 1611 Engine should not refuse to remove Sequential Access Index
• 1613 Alias.Table.Field qualified name does not work
• 1614 Invalid table name in subquery not detected
• 1616 Aggregate error message mixup
• 1618 Simple live SQL query takes much longer time than equivalent filter on table
• 1619 Problem with function returning Table and using alias on return value
• 1620 Attempting live query throws exception
• 1621 AV when calling datamodifying function with internal transaction from Select
• 1622 Log window splitter in query browser cant be moved
• 1623 The server icon in the tree view turns green even if connection attempt fails
• 1624 Support Unicode in grid views
• 1625 Slow left outer join
• 1626 Some flaot-type fieldmappers failed when mapping values of small magnitude
• 1628 Improve message if server could not be found with sharemem transport
• 1629 Problem comparing GUID field with GUID param
• 1631 Usage of the "top ... [percent]" on a query is not shown
• 1632 When a select returns no record the AVG function raise an exception
• 1634 Live query with Numericfield LIKE ... should throw type mismatch
• 1635 Error should be raised when IN operands have different degree
• 1636 Select Query raises AV
• 1637 Improve error reporting during restructuring
• 1638 Query causes AV
• 1639 Having Count(*) does not work
• 1640 Type mismatch with CASE
• 1641 Consider optimization of queries that never return any records
• 1642 Problem with Group by on field caluculation
• 1646 General Blob error triggered when updating record
• 1647 TOP could be optimized
• 1648 Optminization of non-live queries
• 1650 Problem resolving column in stored procedure
• 1651 Set field to Null did not work
• 1652 Converting date to datetime triggered integer overflow
• 1662 Live query gives List index out of bounds

V2.02 - released on September 8th 2005

• 761 Service hangs if an incomplete journal file is found
• 1166 Option to display recno on statusbar
• 1422 Consider how to handle widestring API functions that dont exist on win9x
• 1434 Sub Query doesn't resolve full qualified field names correctly
• 1521 The Drop table check for table referenced in stored procedures is too rigid
• 1525 RequestLive does not return correct result set
• 1527 Error messages can not be copied into the clipboard from SQL error dialog
• 1528 TnxKeyFieldDescriptor.IsEqual doesnt compare all settings
• 1529 UNIQUE does not handle NULL correctly
• 1531 Correlated subquery with RequestLive = true fails
• 1532 Error message posistion info is wrong
• 1534 Implicit conversion and comparison problems in UPDATE
• 1536 Setting NEW.field value in before trigger does not change field
• 1539 Live query does not optimize on case-insensitive index
• 1540 Left join on unique column excludes rows with NULL
• 1550 #function_arguments returns BOOLEAN for a function that actually returns TABLE
• 1551 Stored procs/funcs does not accept delimited identifiers as parameters
• 1552 Output parameters were not returned in StatementExecDirect()
• 1553 TnxTable with SQL filter should raise error if filter statement is invalid
• 1554 Slow inner join with WHERE clause
• 1555 LIKE 'N' works like LIKE 'N%'
• 1557 Calling procedure with scalar subquery fails with AV
• 1559 Blob descriptor editor added for child tables
• 1560 Query with group by gives AV
• 1562 Key violation is not raised in stored procedure
• 1564 Nested WHILE loops does not work as expected
• 1567 Selecting from view in different database fails
• 1569 SQLParams dialog failed to set param datatype for NULL params
• 1571 Problem with IN (subquery) not returning records
• 1573 Call storedproc() executed directly causes crash in engine
• 1574 Return line and pos info on type mismatch errors
• 1575 Adding LIKE returns no records
• 1576 Query gives list index out of bounds
• 1577 Using BCD params gives BCD overflow errors
• 1580 Column not found in ORDER BY
• 1581 Backupcontroller should stip off RI info when backing up and add it back when restoring
• 1583 The engine should detect and throw errors when date/time literals do not match the expected type
• 1584 Corruption of logical blob information structure when writing large blobs
• 1586 Update query gives assertion
• 1587 Distinct with Order By .. DESC gives wrong order
• 1588 Query unable to parse mixed old and new style join
• 1589 Function stops executing prematurely
• 1590 Remove padding with space of imported string fields
• 1591 Live query filters out valid record in where clause
• 1592 Insert into Table1 (select Field1 from Table2 order by Field2) doesn't work
• 1595 Changing the Failsafe Mode checkboxes does not make the Apply button active
• 1597 Create table statement gives "string list does not allow duplicates"
• 1599 Save width of serverlist window between sessions
• 1600 Problems with exception handling in loop statements
• 1603 tiny "error" in function template
• 1604 Literal IN (Literal, Literal2) always returns false
• 1612 Query causes AV in TnxSqlRecordCopier.Add

V2.01 - released on July 27th 2005

• 1459 Parameters switched around in TnxDataset.dsInitOffsets
• 1468 Executing query in database with only one, encrypted table, gives AV
• 1475 Serverengine did not free transactioncontext
• 1476 Dictionary.IsEqual ignored nested tables
• 1499 Default values not mapped when restructuring.
• 1229 Add #function_arguments table
• 1456 Inconsistent char_length() results with padded fields
• 1458 Live query issue with USER
• 1462 String list does not allow duplicates with query
• 1469 Error message on dropping nonexistant table could be improved
• 1478 Cast(0.00 as money) throws exception
• 1480 Incorrect result types of concatenation
• 1491 Distinct should work on guids and bcds
• 1492 Query returns no records where records should be returned
• 1495 CREATE INDEX on already existing index drops the original index first, then reports that there's a duplicate
• 1460 Query causes AV
• 1479 Query gives list index out of bounds
• 1481 Using double quotes instead of single gives AV
• 1483 OUTER JOIN returns more records than there are in the the 'base' table
• 1488 Problem resolving column name
• 1489 Query gives assertion failure
• 1494 Mixed joins should be allowed?
• 1496 Adding an 'OR' to WHERE clause returns 0 records where records should be returned
• 1502 The LIKE predicate seems to be broken in V2
• 1507 Invalid variant type with query
• 1405 Check if regression in JOIN performance with specific query
• 1457 Implicit conversions should not be supported + error message improvement
• 1473 Add lenght/precision/scale to #procedure_arguments
• 1493 Units must be > 0 error with live query on current_user
• 1509 Incorrect and misleading error message
• 1513 Refresh on database node
• 1510 Filter expression in join ON clause does not reduce result set
• 1514 Changing record in parameter dialog causes "dataset not in edit mode"
• 583 Query window: ability to go back and forth through the history of queries; remove connection list
• 1420 Confirmation dialog when deleting views, procedures etc
• 1452 Empty all tables should also empty child tables
• 1506 Pack issued on version 1 table gives AV
• 1515 Old value in before trigger is incorrect
• 1518 Improve error message on duplicate constraint name
• 1490 Changing AllowSystem parameter in CheckService makes the main window show after starting
• 1430 Changes to the User checkboxes (Admin/Read/Write) can not be saved unless something is typed into the Password field
• 1533 Fulltext index descriptor editor basic functionality implemented

V2.00 - released on June 26th 2005

• 1395 Memo display does not update if cursor moves after Find in table browser
• 1396 Locale info combo should display same list as #collations
• 1399 Adding child table to table when a child table is open gives AV
• 1415 Problem descending from TnxQuery with BCB
• 1431 Insufficient rights message should not mention password
• 1303 Backup table with child table doesn't work
• 1309 BackupController Feature Wish
• 1317 RI problems
• 1321 SQL - Trigger updating whole table
• 1385 correct handling of assignment / compare of character strings, taking into account locale / codepage
• 1388 Assertion in other query
• 1404 Problems with float/money literals
• 1406 Calculating max prescicion of BCB values
• 1409 Dropping columns and tables that are used by other tables should not be allowed
• 1416 SUM() on BCD columns should use maximum scale and precision
• 1417 Query raises assertion on merging with UNION
• 1418 Query raises AV on blob merging in UNION
• 1423 Adding second record gives AV in stored procedure
• 1427 KeyAsVariant used in BlockRead mode triggers invalid bookmark error
• 1428 Problem with GROUP BY
• 1429 Engine needs improvement in timeout handling
• 1432 SQL Live results with child tables don't work
• 1435 Check constraint with EXISTS doesnt work
• 1436 Check constraint not enforced with multiple inserts
• 1439 #Fields.field_type_sql reports wrong type for char/varchar
• 1441 Check constraint not enforced when inserting via TnxTable
• 1443 String Comparison problems
• 1447 Parser does not accept negative number for integer column default value
• 1448 #tables reports for 'current_user' as default
• 1451 RecordCount on this query with RequestLive true triggers abstract error
• 1377 Stack overflow with Try ... Catch
• 1433 AV with triggers

V2 RC 6 - released on June 21st 2005

• 1410 AV when updating row the second time on table with trigger
• 1408 Support if exists for columns: ALTER TABLE DROP COLUMN IF EXISTS
• 1407 Problem evaluating check constraint
• 1403 Query gives EIntOverflow
• 1402 Views should not be created on temporary table
• 1401 Field with name "User" creates trouble
• 1398 AV in TnxServerDatabase.sdTableRestructure if imporper mapping object passed in
• 1397 Editing child table name and restructuring gives AV
• 1394 ALTER TABLE DROP CONSTRAINT IF EXISTS last ignored
• 1393 Query simplification not applied to views
• 1392 Check assignment to read-only variables in triggers
• 1391 Support IF EXISTS on DROP CONSTRAINT
• 1384 important The SQL engine must correctly pass through locale / codepage information from source columns into resultset columns
• 1374 Unknown column error
• 1373 AV on the concatenation of FM."Last Name" and FM."First Name"
• 1344 Errors when creating RI in restructure dialog

RC 4, RC 5 - binary releases to newsgroups

• 333 BlobCreateFile should evaluate the path relative to the table folder
• 335 variable recrd size
• 544 Tables opened from read-only media should show read-only colour in grid
• 552 Need to catch and return proper error if the max value of autoinc is exceeded
• 629 CSV export
• 779 Service does not start and gives no info or error message with the command line in description
• 875 Need method to check table/index consistency
• 940 TnxTable.Exists needs to check for server connection; may cause table to be emptied
• 1024 AV when selecting filter expression from grouping combobox
• 1088 ExpressGrid bug; opening quantumgrid datetimepicker and closing it gives "control has no parent window"
• 1100 [CHALLENGE] MM and/or nxReplaceMove fails on some machines
• 1120 Command-line option for servicename
• 1133 Server V2 does not start with Buffer overflow prevention of MCAfee 8
• 1138 Sorting (clicking on column header) doesn't work in EM
• 1141 Quantum Grid 5 filtering doesn't work
• 1160 Ambiguous column references confuses query optimizer
• 1167 Table created without locale info should use byte compare in ORDER BY
• 1200 System tables should not be attempted created if the database is read-only
• 1210 Integer fields created from aritmetic operations should scale up the datatype properly to ensure no overflow
• 1211 Joins are SLOOOOOOOOOOOOW
• 1216 Evaluate chars allowed in unquoted regular identifiers
• 1221 Remove support for non-conforming date formats without date/time keywords
• 1222 Columns are returned in the wrong order
• 1231 Live query with qualified database different from the current database gives AV
• 1234 Misleading group by error message
• 1239 #CHECK_CONSTRAINTS only has a 128 unit widechar field to store the constraint statement
• 1253 CLOB fields should not accept binary string in INSERT
• 1258 Column just added cannot be dropped again
• 1265 Deleting records from table with triggers defined raises AV
• 1266 SELECT on constant and aggregates should not require GROUP BY
• 1267 Order By issue with aliased column
• 1270 Check constraint node in treeview shows no items
• 1271 Having search dialog open in sql browser stops EM from shutting down
• 1272 Investigate slow task switching
• 1274 Concatenation of binary string data doesnt work
• 1276 Make sure that "Field Like 'ABC%'" queries use an available index
• 1277 Login dialog too small for large fonts
• 1278 Em crashes on CTR-K in SQL window
• 1280 SQL Window annoyance - Scrollbars position jumping
• 1281 Problem with views - produced column names not recognized
• 1284 AV on Group by
• 1285 AV with Start Transaction in compound statements
• 1288 NCLOB doesn't work
• 1290 EXISTS predicate always returns TRUE in certain circumstances
• 1292 Error in constraint defintion
• 1293 AV when using triggers and stored procedures
• 1294 Make captions of tabsheets shorter
• 1296 Invalid Column Refererence triggered
• 1297 Default value not inserted for queries
• 1298 UNknown column with groupby/orderby
• 1299 NorthWind with NVarchar crashes
• 1300 Constraints accepted altough no mathcing key exists
• 1301 CAST doesn't map from char to byte
• 1302 CHAR type is not padding as required by the SQL standard
• 1304 TOP quantifier not working in UDF
• 1305 not working
• 1307 Optimize LIKE to use index for phrases like 'P1%P2'
• 1308 TnxReferenceDescriptor.IsEqual does not check for changes in TargetIndex.
• 1310 RC3 EM AV after LiveBackup
• 1311 Simple CASE bug
• 1313 Problem casting character string literals to CLOB/NCLOB
• 1314 Result data types of CASE expressions
• 1315 Error "Invalid File Number : 1" if the result is live
• 1316 DROP TABLE and triggers
• 1318 Change copyright in about dialog
• 1319 nxserver page "Server Engine" fontsize
• 1320 Query Log not updated
• 1321 SQL - Trigger updating whole table
• 1322 OPening tables in grids takes too long
• 1323 Detailed information when no matching key is found for constraints
• 1325 [Viewing Data Dictionary: in ] still too long as tab
• 1326 Show constraint names instead of IndexName (if any)
• 1327 tab context menu error
• 1328 Displaying timestamp values
• 1329 CSV export, currency has "$"
• 1330 Fontsize in Memofields
• 1331 Column types in unioned tables
• 1332 Assertion in query
• 1333 Please, add a main menu, "Servers\Register Server".
• 1334 Remember the "Tabs on top" position after a restart of EM.
• 1335 when seleting a tab using the tab context menu, it does not jump to the desired tab.
• 1338 Full qualified columns create error in group by
• 1339 SQL Editor when you right click it shows a TEST popup menu
• 1341 Don't create double "Redefine Table" windows
• 1342 Can't remove field description
• 1354 Invalid column reference a.c1
• 1355 Count returns DOUBLE for this script
• 1356 EM creates unwanted registry key
• 1357 Joined Metadata query times out
• 1358 GetRecordByID is not supported on virtual meta-tables
• 1363 Change error Message to show the referring column names
• 1364 Allow localized date/time in SQL again
• 1365 RI Editor repainting issue
• 1366 Error simplifying Triggers
• 1367 Triggers ignore WHERE clause if broken to next line
• 1368 Optimization issue with JOIN
• 1369 CAST issues
• 1370 Inconsistency between implicit and explicit cast
• 1371 Cannot open file "" whn etrying to load memo data
• 1375 Referential Integrity page "Referenced Fields" should be "Referencing Fields" or "Source Fields"
• 1376 crash / very poor performance on query
• 1378 Abstract error with following query
• 1381 Empty grid before new query is run
• 1382 Don't show version 1 servers in server window
• 1386 Assertion in query
• 1387 Query doesn't return expected results
• 1389 Blobs with certain size create endless loops in ADO
• 1390 Engine should not change error type indiscriminately

V2 RC 3 - released on May 20th 2005

• 1049 Dictionary Editor needs CHECK constraints view/editor
• 1098 Option to show time with milliseconds
• 1123 EncryptionEngine editor problems
• 1151 Parsing, evaluating and processing the group by clause in general
• 1172 BCD calculation produces incorrect result
• 1197 RecoverRecords fails with large testtable
• 1198 TnxCachedDataset issues
• 1204 Opening 3 dictionarybrowsers in a row gives "control has no parent window"
• 1207 Stored procedure should require data access identifier
• 1208 Calling a stored proc from the TnxStoredProc component gives assertion in sql engine
• 1212 Query returns real columnname instead of alias
• 1213 Engine should not allow stored procedures and functions to share names
• 1214 Query causes AV
• 1218 AV in engine with simple query
• 1219 Alter Table with Check constraint problems
• 1220 Numberic literals in calculations
• 1223 Viewing dictionary results in non-enabled grids that cant be scrolled
• 1227 Explicit transaction in multi-statement script does not get rolled back on exception
• 1232 AV in engine
• 1233 Group by problem with aliases
• 1235 SetFilePointer usage problems
• 1236 Boolean evaluation of NOT problem
• 1237 Executing procedure with two calls to the same function throws error
• 1238 Change Password should check if an encryptionengine exists and add if needed
• 1240 Problem with parameters in user-defined functions
• 1241 Parameters inside TRY... not recognized
• 1242 Exact numerics should use integer division
• 1245 Answering no to "Discard changes" upon program close still closes down
• 1246 Grouping column not in SELECT should not be included in resultset
• 1247 Combining literal and aggregate in SELECT clause returns NULL for aggregate
• 1248 AV when opening tablebrowser after undocking and closing tablebrowser
• 1249 Evaluate use of FmtBcd for DECIMAL types
• 1252 RI descriptors not created correctly from SQL CREATE statement
• 1254 Encryptionengine is not threadsafe
• 1255 AV when using delimited reserved word
• 1256 Non-parentesed expression causes illegal group by query to succeed

V2 RC 2 - released on April 27th 2005

• 1202 Problem with NOT evaluation
• 1201 Live query gives "data dictionary is read only" error
• 1196 Self-referencing update in after update trigger causes AV
• 1195 Query gives AV in engine when executing
• 1194 The #TRIGGERS table should use widestring to store the TRIGGER_SOURCE blob data
• 1193 Expression column does not get any values with GROUP BY
• 1190 Last parentesis is not stored in CREATE VIEW
• 1189 The various meta tables that stores widestring data in blobs should use the new nxtBlobWideMemo fieldtype
• 1188 Field AS Alias clause causes live query to duplicate previous row instead of inserting new data
• 1185 INSERTing character data into BLOB field should throw an error
• 1183 Adding TinyInt and Smallint value gives wrong result type
• 1182 Concatenating CHAR/VARCHAR and BLOB should be invalid
• 1181 Concatenating CHAR/VARCHAR with CLOB should result in CLOB type
• 1179 Live query gives "could not convert olestr to boolean" error
• 1178 Numeric overflow does not trigger error
• 1177 Wrong fieldtype used when returning sum of INTEGER and DECIMAL
• 1176 Engine is unable to handle constants in the BIGINT range
• 1175 Coalesce gives type mismatch
• 1174 SUM(integer expression) should not return double precision
• 1172 BCD calculation produces incorrect result
• 1170 RI editor should support nested tables
• 1169 LOCALE id should be verified when creating table
• 1168 Registered Servers adds duplicates each time dialog is closed with OK
• 1165 GUID string literals should be possible without needing casts etc
• 1164 INSERT into table values (...) does not trigger syntax error on missing column part
• 1163 Sort options in ORDER BY should override existing index
• 1161 Query gives unknown column error
• 1159 create... LIKE table does not recreate autoinc column
• 1158 BCD issues (incorrect rounding, missing error)
• 1157 WHERE clause doesnt catch invalid column reference with live queries
• 1156 Incorrect default referential action
• 1155 Optimizer bug producing incorrect joins
• 1154 Live dateaset returns no records
• 1153 The Direct TCP/.Net transport throws an error when first started after server install
• 1150 Outer Join bug
• 1143 Remove non-standard "= NULL" / "<> NULL" support outside drivers
• 1140 'Integrety Connection Properties' misspelled in RI editor
• 1135 InitialSize/GrowSize issues with v1.08
• 1134 Queries slower than DBIsam
• 1132 [EStringListError] String list does not allow duplicates
• 1129 Check implicit cast of expression column
• 1126 Running SQL queries from read-only users return no data at all
• 1110 I get an EAssertionFailed error message in the Enterprise Manager v2, when changing field values using the following metadata...
• 1107 Could EOpOpMis; return line/pos info when it is triggered?
• 1093 Opening dict browser in readonly mode should disable the GUI
• 928 Failed column name in required field value missing message
• 602 Inserting a record and setting an autoinc field to numeric 0 results in the autoinc field being assigned the next autoinc num...
• 333 BlobCreateFile should evaluate the path relative to the table folder

V2 RC 1 - released on April 7th 2005

• 76 More Server information
• 125 Server should remember its screen position between restarts
• 286 Messages per second for transport statistics
• 287 Summary screen which shows a list of all available running statistics, to avoid switching between views
• 308 Show status info on command line after service is installed (started, yes/no?)
• 484 Server needs user adjustable setting for the server-side watchdog value
• 608 command-line serice option to remove security requirements
• 745 Server GUI AVs when protocol is disabled
• 748 Server GUI problems with large fonts
• 752 Check for string length is redundant for a SELECT statement string parameter
• 760 Check if exectutables are running before installing
• 764 Option in the .init file to suppress the .worksettings file and use the .init file settings instead
• 765 Option in .init file to disable the "save settings" functions
• 766 Server menu doesnt stay open when you want to move between toplevel menus
• 779 Service does not start and gives no info or error message with the command line in description
• 780 Service does not start after either answering "yes" to dialog, or using /START on the command line
• 866 Server's "Active/InActive" marker doesnt always show the correct state
• 1043 DROP on global temp table fails
• 1063 EM should load the internal SQL functions and use them for highlighting
• 1076 Recovering table with TnxNotNullValidationEngine in use fails
• 1086 IN with correlated subquery doesnt return records
• 1101 "Component currently active...." smashes the screen
• 1102 SQL statement causes assertion
• 1103 Select * from #Check_Constraints gives AV
• 1104 RESTRICT not fully implemented
• 1105 "Method not implemented" error raised
• 1106 Creating a trigger on an "open" table will fail with an "Unable to open table..." error message.
• 1108 Datetime arithmetic does not work in EXTRACT
• 1109 I get an "Method not implemented" error message when running the following script in EM....
• 1112 Error when using functions with arguments in live queries
• 1113 Crash in TnxSqlTableProxy.RefersTo if a table in database causes exception when opening
• 1114 Autoinc engine starts on wrong value when seed and increment are both 1
• 1116 nxServer as Service problems
• 1117 nxServer should start with all modules active if no previous config was found
• 1118 Ensure autoinc numbers can roll over without range check error to support SQL start/step values
• 1119 Problem returning live cursor from procedure
• 1121 TnxDataDictionary.IsEqual should check for changes in the EncryptionEngine property
• 1127 LOWER() does not return records where there are matching data
• 1128 SET DEFAULT referential action is missing
• 1129 Check implicit cast of expression column
• 1130 Deleting a table that is open in the restructure window and then clicking restructure gives AV
• 1131 Service should add .\ to the username if the user didnt input any domainname
• 1137 Landscape Print preview in EM (preview contents) not working
• 1139 Server window redocking faulty
• 1144 Expanding "+" marks for databases disappear if undocking server window before expanding server
• 1147 EmptyTable destroys fielddescriptors on table with tsTempDatabase scope
• 1148 Problem parsing coalesce/group by statement
• 1149 Blob literals no longer work
• 1152 Empty all tables causes "invalid class typecast"

V2 beta 7 - released on March 16th 2005

• 1097 EM doesn't save the choosen Font in Query Options / Properties =>Global Defaults. I usually use fixed width fonts for SQL, s...
• 1095 CAST(MYTIMESTAMP AS TIME) should work
• 1094 Various FiledescriptorEditor problems
• 1092 Deleting child table does not remove internal descriptor editors
• 1091 Crash when inserting 10.000 records with trigger active
• 1090 Comparing TIMESTAMP values fails
• 1085 IProvider support is broken
• 1084 Problem resolving name when calling procedure from trigger
• 1083 Ensure that system views show the full 128 characters in identifiers
• 1082 COM transport officially deprecated
• 1081 #INDICES view needs an ISDEFAULT column to mark primary keys
• 1080 Problem comparing blobs in triggers
• 1079 Problem with lifetime handling of #temporary table
• 1074 Evaluate the use of IDENTITY keyword as a function
• 1073 Readonly dataset returned when ORDER BY is used and RequestLive is True
• 1072 INSERT...DEFAULT VALUES makes IDENTITY not return the actual value inserted
• 1071 Change ExecSql/Sql property case back to ExecSQL/SQL to support BCB
• 1064 Problem with insert statement in user-defined function
• 1062 Setting RecNo to 1 does not go to first record
• 1061 Table cant be deleted from script; returns "Table is open" error
• 1060 SQL statements cause assertions
• 1059 CAST(1.5 as Integer) should truncate, not round
• 1058 Problem with correlation in UPDATE
• 1057 Adding alias makes database list become duplicated
• 1056 RequestLive not working correctly when comparing a field against null
• 1055 Deleting one row in the field descriptor list actually deletes two
• 1054 Assertion executing SQL
• 1053 Setting filename in Event Log page has no effect
• 1048 System tables should be opened as read only if the containing database is read only
• 1047 Evaluate default NULL ordering
• 1046 CHECK constraint is incorrectly checked when a column is set to null
• 1045 Delphi's ROUND() function uses 'bankers rounding' while SQL should not
• 1044 Server Treeview redraw problem
• 1040 RowsAffected does not work in a regular multi-statement qurey
• 1028 ReallocMem should not be used on NXMM allocated memory
• 1020 Problem with trigger containing multiple INSERT statements
• 1013 Query ealuation/column name scope
• 1004 Implement default RESTRICT drop behaviour
• 998 Add first indexed field to list when adding an index to dictionary
• 984 Deleting a subtable from server tree gives invalid table name error
• 881 SELECT ... Field <> 'AAA' fails to include record with Field = 'BBB'
• 861 Manual item that lists all known limits (table size, fields per table, etc etc)
• 856 Delphi 5 problems with variants (especially in SQL engine) should be documented
• 852 If a subfolder of a database folder has the extension .nx1, then it shows up as a table when iterating tables
• 850 Accessing temporary memory table gives "table does not exist"
• 816 Edit shortcuts doesnt work in "Rename Table" mode
• 810 Add readonly Path property to TnxServerFolder
• 809 Remove code that checks for presence of report engine dll
• 807 Doing Set Autoinc followed by Reindex results in "cant perform this operation on an open dataset"
• 799 Query browser timeout problem
• 795 TnxBackupController: option to store In-Memory tables to disk
• 783 SELECT T2.* from #T1 join #T2 using(T2_id); returns a field from T1
• 762 Check clipboard commands in table browser filter combobox
• 646 Manual correction
• 645 Method to Insert field at specific position in dictionary
• 644 Display recordsize in View dictionary
• 596 Fix Server Logging of events
• 590 Set Default parameter type in parameter dialog to ftString
• 539 Expose function to set the used length of the last stringfield in a SetRange() call.
• 362 Display field/index # in grid
• 350 Manual issues
• 253 Empty All Tables command on database in Server window

V2 beta 6 - released on March 7th 2005

• 1042 Check for SQL 2003 conformity for return types of SUM and AVG
• 1041 Using the Nexus TTable component to insert records into a table. If the insertion violates the unique key, then the compone...
• 1039 Dont try to reindex virtual indexes
• 1038 Assertion when closing filehandle of readonly table after attempting to post
• 1035 SQL function to return the number of rows affected by the last statement
• 1034 Show server status in tray icon
• 1033 Invalid Table Name - Leading Trailing spaces not allowed when opening field editor on TnxMemTable
• 1032 Coco-R problem generating widestring support code
• 1031 Empty Table from the popupmenu while table is open in browser gives "control has no parent" error
• 1029 Server returns "insufficient table rights" to already logged in client after minimizing in secure mode
• 1025 General blob error when posting record with changed blob through Live SQL dataset
• 1023 CREATE INDEX ... NULLS FIRST gives descriptor with NullBehaviour = nbBottom
• 1022 CREATE UNIQUE INDEX on field with duplicate values leaves the indexin the dictionary
• 1021 When I try to access NexusDB2 server...
• 1019 Source string data is too wide for the target field error when updating table with audit trigger
• 1017 Method not implemented error when using trigger
• 1016 Invalid check condition
• 1015 Field type selection with keyboard impossible
• 1014 File descriptor editor problems
• 1012 nxSqlEngine/nxdb protocol mismatch
• 1011 Undocking the server window makes servers show up multiple times in tree
• 1010 Problems anchoring windows
• 1009 Allow multiple NULL values for UNIQUE index
• 1008 "Master record is missing" when referencing column is NULL
• 1007 AV when closing after stopping remote server
• 1006 RETURN clause accepts invalid values
• 1005 Identifier names may start with any valid identifier char except numerics
• 1003 Allow USER/CURRENT_USER/SESSION_USER as field default value
• 1002 Record engine always shows 'Variable' in the Dictionary view
• 1001 Referential constraints should not be checked for rows having NULL in a FK column
• 1000 Problem with Set Null referential action
• 999 Doing "Change password" without opening table gives "cannot perform this operation on closed dataset"
• 997 SQL datetime arithmetic problems
• 996 Checking boxes in the summary statistics list using the spacebar doesnt work
• 995 Summary statistics update problems
• 994 Server GUI updating needs optimization
• 993 Views return TRUE for TnxQuery.CanModify when RequestLive is True
• 991 UNION with blob field causes block number out of range error
• 990 Posting international characters into nxtChar field via TnxSqlUpdateObject fails
• 981 Server compiled with Delphi 6 triggers variant exceptions on startup
• 975 Table could not be opened problem in SQL script when server's CloseInactiveTables option is checked
• 965 Named Pipe is red in treeview and Active checkbox unchecked; still says "component currently active" at bottom of panel
• 953 Server statistic issues/wishes
• 949 StartTransactionWith wrongly doc'ed as Procedure instead of Function
• 927 Server statistics: Unable to locate "processor" performace object
• 906 Need GetTableNames... method that can separate system tables from normal tables
• 903 Problems activating SQL Triggers
• 902 Problems when saving Settings in Server (the config file disappeared)
• 877 DeleteRecords does not check timeout value and does not allow server to shut down if long-running
• 876 Problem when quoting table alias
• 871 GROUP BY fails if field is different case from SELECT
• 860 Server/Service should save config changes as soon as they are made
• 794 Setting ServerName in the init file does not work; EM still shows "NexusDB"
• 754 GUI inconsistency with NamedPipe protocol
• 727 The non-service server should disregard the secure server checkbox for UI operations, if there are no admin users defined.
• 669 Param.AsBlob() fails on pre-XP systems due to winapi bug, need workaround
• 659 Components should not attempt to send messages to the server when they are Close()'d if the connection is lost
• 631 Support SELECT across multiple databases
• 609 Add config setting to use only particular IP interface
• 531 TnxBackupController uses wrong TDataActions
• 527 Check Restore from Read-Ony medium
• 450 RegisteredCOM transport now has statistics items in server UI, but they don't seem to change when the transport is used
• 408 produce espresso from the cd drive into a coffee mug
• 400 Canceling pack operation grayes out menu items
• 213 Error running high-lighted SQL statement in Multi-statement script; error positioning is done from top of script instead of s...
• 23 NIC Selection at the Transport level

V2 beta 5 - released on February 18th 2005

• 989 CharToBuffer fails with invalid field length
• 988 Dictionary browser needs warning when closing with changes in edit mode
• 986 MM does not work with JCL v1.22; starting server or EM gives Invalid pointer ops and AVs
• 985 Deleting a subtable from dictionarybrowser fails to remove table from tablemapper
• 983 AV in TnxSqlTableProxy.GetIndexProperties with RequestLive = True
• 980 Variant error converting OleStr to Date with SQL Params
• 978 AV in TnxServerRootTable.srtSetReason when running SMPTest
• 977 Opening table over Shared Memory transport gives range check error in server
• 976 RecoverRecords fails with "table is read only" and does not handle this properly after this (continues with AVs inside server)
• 972 DevEx component does not allow editing Time part of DateTime field as default
• 971 Evaluate inconsistency between UNIQUE on table and on index
• 970 Problem creating multiple triggers
• 967 Table referenced by RI should not be allowed to DROP
• 966 AV when running SQL script
• 964 Starting EM on Win98 results in "win32 error in TnxNamedPipeBroadcastListenerThread"
• 963 Assertion in nxseIndexEngineStaticKeyBstarTree line 1987 (browsing table after SQL Delete statement)
• 962 LIKE problems
• 961 Problems with CHECK constraints on column level
• 960 Index out of bounds when using Request Live Dataset in query window
• 958 TnxServerDatabase.TableRecover uses the Dictionary variable before it is initialized
• 957 Selecting query with toolbar combo did not work
• 956 AV when clicking next/prev database connection in query browser if no previous query opened
• 955 AV when trying to open exclusively locked table in 2nd EM instance
• 954 Higher dict version required when adding locale descriptor to v1 table and restructuring
• 952 Right-click menu disappears
• 950 Names of Views are case-sensitive when used in queries
• 948 Delphi 5 gives internal error compiling nxllDataMessageQueue
• 947 Tablebrowser does not update the browse pane title when using the "Next table" commaand
• 944 Assertion triggered when running SQL script with memtable
• 943 Parser has trouble with INTO
• 935 Unexpected error raised when opening remote SQL resultset
• 921 Popupmenu stays on top after switching to another app using the mouse
• 907 Live backup does not work

The MPL License of FastMM 4 makes it necessary to publish these files publically as they are included in NexusDB V2.04.