v5.0 [Sep 1, 2014]
- SQL Query Fix: Quoted table name or alias with a wildcard (such as [Table Name].* fails to parse correctly.
- SQL Query Fix: IN operator against a sub-query can result in a NullReferenceException.
- SQL Query Fix: REPLACE function returns NULL instead of original string when first string argument is shorter than second string.
- SQL Query Fix: REPLACE function raises error instead of returning original string if second argument is empty.
- SQL Query Fix: Cache optimized JOINs can produce incorrect results when OR is used in WHERE or ON clauses to combine conditions referencing different tables.
- Transaction Fix: Disposing an ADO.NET transaction object can throw an exception complaining that the connection must be open.
- Entity Framework Provider Fix: Adding new rows fails on tables with Identity keys under EF 6 in some cases.
v3.3 [Mar 15, 2008]
VistaDB 3.3 now supports TSQL Procs, and Visual Studio 2008. A newly redesigned Server Explorer designer allows users to create databases and tables, alter tables and indexes all within Visual Studio 2005 or 2008.
Over 40 changes for TSQL syntax parsing to be more compliant with SQL Server 2005.
