What's New
This page tracks notable new capabilities as they're added to Velocity. Each entry links back to the change that introduced it.
| Reference | Feature | Description |
|---|---|---|
| #197 | Full-text index columns on PostgreSQL | Full-text indexes on PostgreSQL loaded with no columns when the column names were lowercase. They now load with the columns they were created on. |
| #198 | SQL views survive a load and rebuild | A view defined with SQL no longer carries a leading CREATE VIEW when it is loaded from DB2, SQL Server or SQLite, so a loaded schema can be built again on the same database. |
| #200 | Oracle spatial support in the NuGet packages | The NetTopologySuite.IO.Oracle assembly that reads Oracle SDO_GEOMETRY values is now packed beside YndigoBlue.Velocity.dll, so applications that use Velocity through NuGet get it. Before, it was missing from the packages and reading geometry or geography from Oracle failed. |
| #201 | Dropping an index on SQL Server and Teradata | DropIndex now writes the form each engine accepts: DROP INDEX <index> ON <schema>.<table>. Before, SQL Server rejected the statement and Teradata had no form of its own. |
| #202 | Adding a column to a SQLite schema from a new connection | Adding a column to a table in a SQLite schema now works from a connection that has not built or loaded the schema. The statement names the schema and attaches it, where before it failed with no such table. |
| #204 | Keeping identity values on DB2 | An import that keeps identity values into an integer identity column now completes on DB2 and restarts the identity after the highest imported value. Before, it failed with an Int32 to Int64 cast error after the rows were loaded. |
| #205 | Dropping a SQLite schema | Dropping a SQLite schema now deletes its database file and the WAL files beside it, so the schema no longer exists afterwards. If another open connection still has the file attached, the file stays until that connection lets go. |
| #206 | Reading Oracle geometry first | Reading an Oracle SDO_GEOMETRY column as the first geometry operation in a process no longer fails with ORA-50071. The Oracle adaptor now loads the geometry type before the first read. |
See Also
- Managing Schemas - Building schemas and loading them back from an existing database
- Views - Code views and SQL views
- Indexing - Creating and managing indexes, including full-text indexes
- Full-Text Search - Searching full-text indexed columns