Known issues






Main Links

Home

Products

Support

Downloads

Testimonials

Articles

DEV Snapshots

Company Info


Prices & Ordering

Logon

 

NexusDB V2.07 Known issues

This list is live from our issue tracker and shows all known issues reported (or reopened) since release of V2.07.

For access to the develop snapshots including the latest fixes please check here.

Unverified fix
Open Performance Issue, functionality correct
Open Issue
Deferred to V3

Issues in Engines

#SummaryComponentTypeTarget
2622Negative DEFAULT value for float field not accepted (1)
SQL
Issue
  V3
2621Errors in SQL Filters need to be properly accumulated (1)
SQL
Issue
  V3
2620SQL engine does not properly raise error when TnxTable.Filter contains faulty SQL filter (1)
SQL
Issue
  V3
2615TOSTRING(field) should not need a CAST to work (1)
SQL
Issue
  V3
2610Slow SQL (1)
SQL
Issue
  V3
2608Key violation inside stored proc incorrectly returns stored proc does not exist exception (1)
SQL
Issue
  V3
2606Random AVs in sql engine (1)
SQL
Issue
  V2
2604Invalid pointer operation happens spuriously (1)
SQL
Issue
  V2
2601LIKE '...%' should use locale aware compare functions to limit/include the correct range of records (1)
SQL
Issue
  V3
2600Widestring fieldmapper should check for Assigned(aMapperDesc) (1)
Core
Issue
  V2
2597AV in server during heartbeat failure cleanup (1)
Core
Issue
  V2
2596Restoring backed up table throws "the cursor dictionaries are incompatible" error (1)
Core
Issue
  V2
2595Grouping on byte array field throws error (1)
SQL
Issue
  V3
2594Running query repeatedly increases table and cursor count in server statistics (1)
SQL
Issue
  V2
2593Query throws Unable to set active index to "$AUTO_JOIN_INDEX#1" (1)
SQL
Issue
  V2
2560Index with idNull duplicate setting can end up having non-NULL duplicates - not reproducable, happened once at customer (1)
Core
Issue
  V3
2536WHERE field IS NOT NULL is not optimized with index (1)
SQL
Perf.
  V3
2526Query with both MIN() and MAX() functions could be optimized (1)
SQL
Perf.
  V3
2500AV calling CloseInactiveTables after opening and closing query (3)
Core
Issue
  V2
2499Non-existing table alias does not throw error (2)
SQL
Issue
  V3
2495Problem resolving column in multi-JOIN (2)
SQL
Issue
  V2
2491Renaming physical table to ###table or vice-versa should not be allowed (engine becomes unstable) (1)
Core
Issue
  V3
2490Using ATOMIC in stored proc gives "no user transaction is currently in progress" error (2)
SQL
Issue
  V2
2487Query with not full qualified field user gives empty valuefor that field (2)
SQL
Issue
  V2
2469Timeout is not respected in FULL JOIN (1)
SQL
Issue
  V3
2453Correlated query only exceuted once (1)
SQL
Issue
  V3
2446Error should not be thrown when only spaces overflow on assigment from long to shorter string (1)
SQL
Issue
  V3
2442Adding long strings to fulltext indexed field greatly slows down server operations (1)
Core
Perf.
  V3
2390Extremely slow Commit at the end of Recover operations on quad-cpu machines (1)
Core
Perf.
  V3
2386Server could throw an AV if client is killed while it is connected with ShareMem transport (1)
Core
Issue
  V3
2381SQL Engine unusable on Win98; throws AV (1)
SQL
Issue
  V2
2371AVs appear in nxServer log after client has caused illegal reentry (1)
Core
Issue
  V3
2370nxtFmtBcd fieldtype does not have any fieldmappers, making restructuring impossible (1)
Core
Issue
  V3
2361Refreshing tableview with blobs after deleting the visible records using SQL ends in endless "Block number is either < 0, or >= number of blocks" errors (1)
Core
Issue
  V3
2341Problem resolving outer field reference in subquery (3)
SQL
Issue
  V3
2299Heap engine cutoff size for management info free space calc needs to be dynamic (1)
Core
Perf.
  V3
2281Bacupcontroller should close database at end of operation if it was opened at the start (1)
Design
Issue
  V3
2254Sudoku SQL: endless loop in function (3)
SQL
Issue
  V3
2251Nested joins should not require parentheses (1)
SQL
Issue
  V3
2234Subquery only executed once in stored procedure (3)
SQL
Issue
  V3
2003Setting table.active to true at designtime on table with childtable gives AV (1)
Design
Issue
  V3
2002Crash in sqlengine during restore (1)
SQL
Issue
  V3
1985Query.Clear causes AV (1)
Design
Issue
  V3
1644Stack overflow in filter handling makes the server process die and exit (1)
Core
Issue
  V3
1615TnxBaseSqlFilterStatement.MatchesBuffer should not swallow any and all exceptions (1)
Core
Issue
  V3

Issues in Drivers/Connectors

#SummaryComponentTypeTarget
2617ODBC INstallation issues (1)
ODBC
Issue
  
2579Combining secured transport and defined username/passwords fails to connect (1)
ODBC
Issue
  
2392nxdEngines. Stringlist not sorted but using Find; RegisterServerEngine should prevent dups (1)
RO/DA
Issue
  
2260I am attempting to use Cognos Data Manager and your ODBC driver to connect to an Nexus database and extract the data. I get ... (1)
ODBC
Issue
  

Issues in other areas

#SummaryComponentTypeTarget
2619Update /? display with CONFIG (1)
Server
Issue
  V3
2599Control has no parent window message when opening table to unpinned tablewindow (1)
EM
Issue
  V3
2581EncryptionEngine property not set correctly (1)
DDCG
Issue
  V3
2575Checkboxes in checklistboxes in GUI do not refresh properly (1)
Server
Issue
  V3
2543Cant make SAI default index after another has been default (1)
EM
Issue
  V3
2541Maximized window state is not properly restored on restart (1)
EM
Issue
  V3
2540Problem setting default index (1)
EM
Issue
  V3
2539NXDDCG bugs and feature requests (1)
DDCG
Issue
  V3
2523Typing too fast into dict editor fieldname column erases first letter typed (1)
EM
Issue
  V3
2519Set field to 0 command does not work unless field is in edit mode (1)
EM
Issue
  V3
2510Button to turn on devex grid loading of all records (1)
EM
Issue
  V3
2509Check block footer corruption (1)
EM
Issue
  V2
2508Set range on one field (null, null) out of multiple in index should work (1)
EM
Issue
  V3
2507Check double table.open calls (1)
EM
Issue
  V3
2498Closing SQL window while search dialog is open causes AVs (1)
EM
Issue
  V2
2496Opening restructure window is very slow in database with many tables (1)
EM
Perf.
  V3
2492CSV import should allow no import to required fields when they have default value descriptors (1)
EM
Issue
  V3
2482Server soemtimes seems to throw "file in use by other process" dialog - not readily reproducible (1)
Server
Issue
  V3
2477Wrong description of date/time literals in delphi guide (various doc issues) (1)
Install
Issue
  V3
2459Create (Trial) MM Installer for D2007 (1)
Docs
Issue
  V3
2438Check/Add help file integration into D2005 to D2007 (1)
Docs
Issue
  V2
2419Table with huge amounts of fields opens very slowly (1)
EM
Perf.
  V3
2407Query returns wrong line/pos error info (3)
EM
Issue
  V3
2342Make CursorRecordIsLocked into global option (default to OFF) (1)
EM
Perf.
  V3
2306Displayed Recordcount disappears when editing live query (1)
EM
Issue
  V3
2264Nullifying dates in EM doesn't work (1)
EM
Issue
  V3
2204SQL window doesnt use correct font when first opening (1)
EM
Issue
  V3
2013EM throws AV when started on Win9x (1)
EM
Issue
  V3
2012Server throws AV when shutting down on Win9x (1)
Server
Issue
  V3
2004Default value descriptor will not "stick" to new field if you try to move the field (1)
EM
Issue
  V2
1873LIKE with no % should be optimized with index (3)
Server
Issue
  V3
1708Type of problem -- very slow execution!... (1)
EM
Issue
  V3
1700Pressing the 'Position at Error' button does not always correctly position the cursor at the erroneous line.... (1)
EM
Issue
  V3
1683Blowfish key should be stored and reloaded upon server restart (1)
EM
Issue
  V3
1664In the dictionary editor, after making another index default, SAI cant be reverted to be the default (1)
EM
Issue
  V3
1578Directory is not properly set and gives unable to open database "" error (1)
Importer
Issue
  V3
1340"NexusDB Dataset cannot open its database." on CSV import (1)
EM
Issue
  V3
1337The view "RI -> Target Index" should show the sql constraint name. (1)
EM
Issue
  V3
1336The "reindex" combo selection should show the sql constraint name, please (1)
EM
Issue
  V3
1283Annoying Tab handling in Field editor (1)
EM
Issue
  V3
1282EM Variant Conversion error when inserting fields (1)
EM
Issue
  V3
1273AV when changing RI target index (1)
EM
Issue
  V3
1162Indexes created by SQL on table having default locale should not display "byte compare" in dict editor (1)
EM
Issue
  V3
1115MM installer does not include overwrite- and hook-dlls (1)
Docs
Issue
  V3
1051RI editor lines do not line up straight even with snap to grid turned on (1)
EM
Issue
  V3
1030Range check error when importing negative values into integer column from CSV (1)
EM
Issue
  V3
974Show descriptive text instead of locale ID in indexed fields grid (Locale field) (1)
EM
Issue
  V3
973Fieldname combo in index fields grid becomes blank when going into edit mode (1)
EM
Issue
  V3
959remove invalid chars in column names when creating table from CSV file (1)
EM
Issue
  V3
555FF2NX does not convert a table if it has extra dots '.' in it. (1)
Importer
Issue
  V3
453problems with single table mode and configuration files (1)
Importer
Issue
  V3
364Importer puts converted file into the Importer.exe directory instead of the directory typed in (1)
Importer
Issue
  V3
358After switching engines to NX (source), FF (target), selecting table gives "tablenames out of sync" error (1)
Importer
Issue
  V3
357When switching engines, Invalid selection is displayed if source and target is the same. This should not happen. (1)
Importer
Issue
  V3
289Select all Fields in single table mode (1)
Importer
Issue
  V3

Unverified fix
Open Performance Issue, functionality correct
Open Issue
Deferred to V3