SQL/MP Version Management Guide

Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-1
A
Summary of Feature, Catalog, and Data
Structure Changes
This appendix describes:
•
Changes in features that define different versions of the NonStop SQL/MP software.
•
Format changes made to catalogs and SQL data structures for different versions of
the software.
For an overview of SQL/MP version management, see Section 1, Overview of Version
Management. For a description of object and catalog versions, see Section 3, Database
Versions. For a description of SQL data structure versions, see Section 5, Program
Versions.
Features Introduced by Different Versions
The version of an object is the same as the version of the SQL/MP software that
introduced the newest features used in the object definition.
Version 1 Features
Features introduced in the original version of SQL are known as version 1 features. A
version 1 object definition is a definition that includes only version 1 features.
Version 2 Features
Version 2 object definitions can include all version 1 features, in addition to the version
2 features listed in Table A-1
.
Table A-1. Version 2 Features (page 1 of 2)
Feature Description
Data types FLOAT, REAL, and DOUBLE PRECISION, DATETIME
(including DATE, TIME, and TIMESTAMP), INTERVAL
Attribute of data types UPSHIFT for CHAR and VARCHAR
Functions Exponentiation (**)
Date-time Functions CONVERTTIMESTAMP
CURRENT
DATEFORMAT
DAYOFWEEK
EXTEND
JULIANTIMESTAMP
File attribute NO AUDITCOMPRESS