VistaDB 5
Gibraltar VistaDB > What's New - Version 5.5 > What's New - Version 5.0 > Getting Started - What's New - Version 5.0.2
Getting Started - What's New - Version 5.0.2
Version 5.0.2 is a minor update to VistaDB 5 with fixes to issues discovered since the release of 5.0.  For a complete description of what's new in VistaDB 5 see What's New - Version 5.0.

New Features In This Release

Engine

SET ANSI_PADDING Ignored

Any attempt to set ANSI_PADDING in a SQL Script is parsed and ignored as the VistaDB engine doesn't implement non-ANSI padding and non-ANSI padding is deprecated in SQL Server.  Despite this, many auto-generated SQL Scripts by various SQL Tools will explicitly set this value to ON which previously caused a parsing failure in VistaDB.

Data Migration Wizard

Improved OleDbType mapping during migration process

With the new Date-related datatypes supported in VistaDB 5 the default mapping from OleDB types has been improved.  It now maps OleDB Date to DateTime to catch the full possible range of values, DBDate to Date, DBTime to Time, and Filetime to DateTime2.

DataBuilder

Query Log Viewer

Whenever a query is run in DataBuilder the detailed logging output of the VistaDB engine is captured and displayed.  This is particularly useful for identifying performance issues such as missing indexes since it will display the index choices made by the engine when parsing the query and warnings when temporary indexes are made or other performance-degrading situations are detected by the VistaDB optimizer.

Defects Fixed In This Release

Engine

  • DDA Fix: IVistaDBTable.GetToFile/PutFromFile methods fail for Image/Binary columns.
  • DDA Fix: Querying a view may lock out DDA access to included tables by the same connection.
  • Fixed: Connections fail to open once pool is filled to Max Pool Size with open connections.

DataBuilder

  • Fixed: List of views in tree node is not refreshed correctly after adding a new view.
  • Fixed: Licensing system may display automatic activation dialog when switching between DataBuilder and Visual Studio on Windows 8.1 systems.
See Also