Development Snapshots
| # | Summary | Fixed in |
| 2614 | RecordGetBatch() on record with large blob fails (lack of network buffer space) | V3.x |
| 2612 | Problem joining empty string values with locale | V3.x |
| 2609 | Locate may hide timeout exceptions etc | V3.x |
| 2607 | Invalid pointer operation with insert using param in multi query script | V3.x |
| 2603 | CAST(date/time/datetime as Varchar(x)) should raise exception instead of silent truncation | V2.x |
| 2592 | String parameter passed into function should keep its locale info | V2.x |
| 2591 | Setting clientside Session.ClientLocaleAsDefault to True has no effect inside stored proc/functions | V2.x |
| 2590 | Defining function input parameter with locale does not use locale with Upper/Lower | V2.x |
| 2588 | Adding field to table causes previously existing field's default descriptor to change existing records | V2.x |
| 2587 | Using RETURN without required return value throws AV when creating trigger | V2.x |
| 2586 | Allow non-RESTRICT behaviour to delete stored procs referencing other procs | V2.x |
| 2585 | Repeatedly running statement eventually ends in "unable to resolve identifier" | V2.x |
| 2584 | Memory Leak running SQL statement | V2.x |
| 2583 | Leak in TnxSqlTableExp.DoUnionExceptIntersect in case of timeout or exception | V2.x |
| 2580 | LIKE does not properly utilize index (slow) | V2.x |
| 2578 | Memory leak when running SQL statement | V2.x |
| 2577 | INTERSECT causes range check error | V2.x |
| 2576 | Query with IN does not appear to use index | V2.x |
| 2574 | select "SIN" from tablewithfieldsin throws error | V2.x |
| 2573 | Problem resolving column | V2.x |
| 2572 | STD() aggregate returns wrong values | V2.x |
| 2571 | nxserver /start reports "server started" even if service not installed | V2.x |
| 2570 | Join optimizer issues with relations using operator <> opEQ | V2.x |
| 2569 | Another slow left join | V2.x |
| 2568 | Left join on SubQuery hangs if result is empty | V2.x |
| 2567 | Website issues | V2.x |
| 2566 | Query throws AV | V2.x |
| 2565 | Multiple single quotes in string literal only result in one single quote in string | V2.x |
| 2564 | Slowdown | V2.x |
| 2563 | WHERE True throws AV | V2.x |
| 2562 | Result of function no set in TnxRequestReader | V2.x |
| 2561 | Null pointer free in nxptTCPRequestTransport | V2.x |
| 2559 | after Session.PasswordRemoveAll, server does not respond | V2.x |
| 2558 | Certain combination of outer and inner join raises AV | V2.x |
| 2557 | Left outer joins with secondary filters return wrong result | V2.x |
| 2556 | LIKE ... ESCAPE character should be able to escape itself | V2.x |
| 2555 | Outer join returns empty fields | V2.x |
| 2554 | Extremely slow outer joins | V2.x |
| 2553 | Query does not use any indexes when it should | V2.x |
| 2552 | Wrong Millisecond separator is not flagged as error | V2.x |
| 2550 | Accessing table in different database alias before system tables are created throws error | V2.x |
| 2549 | Problem with fieldname matching built-in functions | V2.x |
| 2548 | Performance problem with JOIN on string fields and WHERE clause | V2.x |
| 2547 | Problems with CAST() | V2.x |
| 2546 | Query on non-existent column causes AV | V2.x |
| 2544 | Running queries with RequestLive = TRUE makes server run out of memory | V2.x |
| 2542 | Linefeeds are not preserved in LIST() | V2.x |
| 2538 | CAST('10000000000' AS LARGEINT) fails | V2.x |
| 2537 | SQL causes leak of TNotification | V2.x |
| 2535 | Cached dataset is missing code to ignore filtertimeout error code | V2.x |
| 2533 | SQL statement does not free used memory | V2.x |
| 2532 | View with illegal parameter should not be added | V2.x |
| 2531 | Deleting stored proc with illegal parameter throws AV | V2.x |
| 2530 | Updating blob memo from nxCachedDataSet adds spurious characters to server table | V2.x |
| 2528 | Installing as a service does not show username/password dialog | V2.x |
| 2527 | Subquery with aggregate causes AV with Request Live = True | V2.x |
| 2525 | MAX() should use index to only read 1 row | V2.x |
| 2524 | Problem comparing boolean fields | V2.x |
| 2505 | Query on fulltext indexed table throws stack overflow error | V2.x |
| 2504 | Server ignores name and password if allowsystem parameter is True | V2.x |
| 2503 | SQL Performance issue | V2.x |
| 2501 | Incorrectly using SELECT storedproc(param) ... throws AV in server | V2.x |
| 2499 | Non-existing table alias does not throw error | V2.x |
| 2497 | TnxStoredProc: Support getting proc name and parameters at design-time | V2.x |
| 2495 | Problem resolving column in multi-JOIN | V2.x |
| 2494 | Use of various functions should force readonly resultsets on live request | V2.x |
| 2493 | Huge slowdown when using the TOSTRING function | V2.x |
| 2490 | Using ATOMIC in stored proc gives "no user transaction is currently in progress" error | V2.x |
| 2489 | AV raised on invalid column reference | V2.x |
| 2488 | Incorrect overflow check for BCD values | V2.x |
| 2487 | Query with not full qualified field user gives empty valuefor that field | V2.x |
| 2486 | Memory leak in nxsqlCondExp | V2.x |
| 2485 | Problem with NONSTRICTASSIGNMENT option in comparison of parameters | V2.x |
| 2484 | SetRange on Seq Index with invalid strings cancels range | V2.x |
| 2483 | AV is thrown when attempting to open table in latest code | V2.x |
| 2481 | Swapping WHERE clause parts around throws assertion | V2.x |
| 2480 | Query wrongly returns empty resultset | V2.x |
| 2476 | Attempting to create index on non-existing field throws AV | V2.x |
| 2475 | Event log Max Size not persistant | V2.x |
| 2474 | I just bought NexusDB for replacing some FlashFiler applications. Conversion went OK except some SQL queries that do not work... | V2.x |
| 2473 | I just bought NexusDB for replacing some FlashFiler applications. Conversion went OK except some SQL queries that do not work... | V2.x |
| 2472 | Query throws stringlist out of bounds error | V2.x |
| 2471 | Root table not found with INSERT INTO and temp tables | V2.x |
| 2470 | FULL JOIN returns non-matching rows | V2.x |
| 2467 | LIKE '...%' causes range check error when Request Live is True | V2.x |
| 2466 | Server writes config file although AutoSave is off | V2.x |
| 2465 | Query throws unknown exception in state of "capability not supported" | V2.x |
| 2464 | Sharedmem transport does not work with win9x | V2.x |
| 2463 | Check for grouped selection list items is faulty | V2.x |
| 2462 | Query throws AV in engine after division by 0 error is thrown | V2.x |
| 2460 | Missing UPPER() parameter causes AV | V2.x |
| 2457 | Compilation error in nxptTCPRequestTransport (.NET Provider support file) | V2.x |
| 2456 | SELECT distinct table_name FROM #indexes AV's | V2.x |
| 2455 | Widechar field returns ever changing data | V2.x |
| 2454 | Incorrect Unable to resolve the identifier message | V2.x |
| 2452 | Meta query throws roottable unknown... not found | V2.x |
| 2451 | Query without obligatory aliased table expression returns 1 record instead of raising error | V2.x |
| 2449 | Repeatedly running live query throws unexpected exception | V2.x |
| 2448 | INNER join USING is broken | V2.x |
| 2447 | Parser doesn't recognize "national character large object" and "nchar large object" anymore | V2.x |
| 2445 | Opening table with child table throws assertion | V2.x |
| 2444 | Other AV in SQL engine on Win98 | V2.x |
| 2443 | Adding blob to table slows down query with 2 orders of magnitude | V2.x |
| 2441 | Query throws AV | V2.x |
| 2440 | Query timeouts cause AVs | V2.x |
| 2439 | Blobfield.IsNull returns wrong value after Post | V2.x |
| 2436 | TnxBaseSessionPool.bspTimeout not initialized | V2.x |
| 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. | V2.x |
| 2434 | Server does not correctly remember windowposition between restarts | V2.x |
| 2432 | Stored procedure throws AV | V2.x |
| 2431 | Dropping table erroneously throws "referred to from another table" error | V2.x |
| 2430 | Query erroneously throws ambiguous column error | V2.x |
| 2429 | ADO ODBC Bridge: Queries with 0 rows result return 1 empty row | V2.x |
| 2428 | ADO ODBC Bridge: serverside cursors incorrectly return RecordCount=0 | V2.x |
| 2427 | Query throws AVs internally (they are handled but should not occur in the first place) | V2.x |
| 2424 | Range error thrown with this query | V2.x |
| 2423 | If started twice from the same folder, nxServer now shows error dialog twice | V2.x |
| 2421 | Remove #0 from Client IP log entry | V2.x |
| 2420 | New client-side selected locale does not work for parameters | V2.x |
| 2418 | Column binding error | V2.x |
| 2416 | Assert may trigger erroneously | V2.x |
| 2414 | Query throws "field out of range" error | V2.x |
| 2412 | TIME/TIMESTAMP assignment issues | V2.x |
| 2411 | Multiple EXTRACT() calls combined with AND returns too many records | V2.x |
| 2410 | Table with SQL filter created pre-localization switch code can't be opened with new server | V2.x |
| 2406 | Query throws integer overflow | V2.x |
| 2402 | Query never stops executing | V2.x |
| 2400 | Query throws integer overflow | V2.x |
| 2399 | Large object columns not allowed in grouping operations | V2.x |
| 2398 | Incorrect Union Result | V2.x |
| 2397 | SELECT ... DISTINCT ... returns NULL date fields | V2.x |
| 2396 | Add support for unicode special characters (NCHR function?) | V2.x |
| 2395 | Query throws range check error | V2.x |
| 2394 | Extra asterisks in comment specifier results in syntax error | V2.x |
| 2393 | Query throws AV in engine | V2.x |
| 2389 | GROUP BY on date/time fields from memorytable return strange values | V2.x |
| 2388 | Server does not Apply new settings but reverts to old | V2.x |
| 2387 | TnxTable.AddIndexEx updates datadictionary even if operation fails | V2.x |
| 2385 | SELECT LIST(field) FROM TABLE does not throw error on non-charachter fields | V2.x |
| 2384 | Query takes a long time and eats up memory | V2.x |
| 2383 | MIN/MAX on nonpadded nullstrings should not return padded strings | V2.x |
| 2382 | mapping empty string to blob can cause corruption | V2.x |
| 2380 | Nonexisting column name should throw error | V2.x |
| 2379 | Query throws assertion; result unable to resolve identifier | V2.x |
| 2377 | Query triggers assertion in nxSqlProxies.pas | V2.x |
| 2376 | ToString should allow for longer input than 256 characters | V2.x |
| 2374 | Query is slow/never times out (timeout = 10 sec) | V2.x |
| 2373 | Query throws "error in addindex list: unknown column..." | V2.x |
| 2372 | Query returning more than one column should not be allowed in calculations | V2.x |
| 2369 | Query on CHAR() variable in SELECT list gives "could not convert variant ..." eror | V2.x |
| 2367 | Problem resolving identifier in correlated subquery | V2.x |
| 2365 | Meta table caching problem | V2.x |
| 2364 | Query with ORDER BY...DESC does not correctly order the resultset | V2.x |
| 2363 | Using RETURN in stored procedure should produce sensible error message | V2.x |
| 2362 | Typing something other than a number in the MaxRam field throws AV | V2.x |
| 2360 | UPDATE query throws "Expected BlockOwnerID ..." error on temp table | V2.x |
| 2358 | UPPER() does not take table locale into consideration | V2.x |
| 2357 | Query in trigger throws scalar subquery expected error | V2.x |
| 2356 | Invalid column reference not caught | V2.x |
| 2355 | Query throws integer overflow error | V2.x |
| 2354 | CONTAINS(non-fulltext-index,...) should throw error | V2.x |
| 2353 | Problem with IN and repeated list value causing multiple copies of rows to be returned | V2.x |
| 2352 | Problem with IN and #temporary table | V2.x |
| 2351 | Northwind example script fails to run | V2.x |
| 2350 | ORDER BY orders on the wrong column | V2.x |
| 2348 | TnxSqlRowBuilder.ApplyFilterRange seriously broken | V2.x |
| 2347 | Query returns no records where matching records exist | V2.x |
| 2346 | Swapping WHERE clause parts around returns different resultsets | V2.x |
| 2345 | Problem with DWORD values | V2.x |
| 2344 | SELECT rightjoinalias.*, * From .. throws AV | V2.x |
| 2343 | Improve "alias does not exist" message with aliasname | V2.x |
| 2339 | Investigate massive slowdown with joins | V2.x |
| 2338 | Select field from v1 table with RequestLive = true throws AV | V2.x |
| 2337 | Engine does not delete blob contents from table (table size keeps growing when adding and clearing blob) | V2.x |
| 2336 | SELECT field, SUM()... without GROUP BY should throw error | V2.x |
| 2335 | Inconsistent line/pos error position values returned | V2.x |
| 2334 | nxServer /HELP only shows /NOICON info | V2.x |
| 2333 | Using multiple EXISTS in the WHERE clause fails with factor not found | V2.x |
| 2332 | WHERE field LIKE 'Y023 %' does not find matching records where matching records exist | V2.x |
| 2331 | Left Join returns null for some values when used inside stored procedure | V2.x |
| 2330 | Problem resolving tablename in join | V2.x |
| 2329 | Problem with left join in stored proc only returning data for first record | V2.x |
| 2328 | Problem with IN workaround in stored procedure | V2.x |
| 2327 | Problem with IN and local variable | V2.x |
| 2326 | SELECT ... IN (SELECT ...) does not return records | V2.x |
| 2325 | Refreshing table inside transaction throws Block 0 has not the correct signature error | V2.x |
| 2324 | Unable to resolve identifier in aliased table expression created with UNION | V2.x |
| 2323 | Temporary table is not removed when query execution stops on error | V2.x |
| 2321 | Server cannot start as service when explicitly started from commmand line | V2.x |
| 2320 | Stored proc returns no records | V2.x |
| 2319 | Stored procedure throws assertion | V2.x |
| 2318 | Bug when comparing blank, non-localized strings | V2.x |
| 2317 | Joins unnecessarily copy blobs under certain circumstances | V2.x |
| 2315 | TnxSqlRowBuilder.SetSortedState does not take ReadReversed into account | V2.x |
| 2314 | IN (CAST(NULL as [var]char()))... fails | V2.x |
| 2313 | IN (NULL, ...) fails | V2.x |
| 2312 | Autosave on Exit setting can't be turned off | V2.x |
| 2268 | Wrong query evaluation | V2.x |
| 2259 | Delimited identifiers resolved wrong in VIEWS | V2.x |
| 2241 | CONTAINS... used with ORDER BY does not correctly order | V2.x |
| 2216 | Error message when attempting to access deleted blob could be improved (Exprected BlockOwnerID ...) | V2.x |
| 2208 | Add rename table, rename column and changecolumn type to sql | V2.x |
| 2195 | Aggregate functions in the WHERE clause | V2.x |
| 2193 | Problem with outer reference in HAVING clause | V2.x |
| 2110 | Assert in SQL engine when cleaning up after client heartbeatfailure | V2.x |
| 2052 | The service should not allow itself to start if the server is already running from the same directory | V2.x |
| 2048 | Constraint name uniqueness should be enforced | V2.x |
| 2046 | Prepared stored proc always returns the same value | V2.x |
| 1987 | TnxQuery.RecordCount returns wrong value for filtered query | V2.x |
| 1556 | Problem with passed in proc parameter using INOUT/OUT | V2.x |
| 1512 | Consider how to rename duplicated fields from aliased tables | V2.x |
| 800 | If explorer.exe crashes, tray icons should be recreated | V2.x |
| Unverified fix |
| Verified and Closed |
