Icon New Incident Reports for 1.00

The following is a list of the new incidents reported for version 1.00. Click on the incident # in order to view the details of the incident report.

Serious Problems

12230ElevateDB Reading Ahead Too Much Data During Query ExecutionNo
12231Defining Circular Foreign Key Constraints Causes a Lock ErrorNo
12232Unique Key Constraints Causing Index Corruption on Index Used for ConstraintNo
12234Table-Prefaced Asterisk in SELECT List Causes All Columns from Both Tables to be SelectedNo
12235Temporary Table Creation Not Working on Non-Networked MachinesNo
12237IDENTITY Columns Defined with ALWAYS Results in Incorrect Metadata In TableColumns TableNo
12241NULL Column Values Are Causing Check Constraints to FailNo
12242Using Parameters in Sub-Queries Causes Hard Loop and LockupYes
12244CASTing a TIMESTAMP Value to a VARCHAR or CHAR Value Results in Incorrect ValueNo
12245Subtracting Two TimeStamp Values Results in an Incorrect ValueNo
12246Altering a Table and then Trying to Drop it Causes AV or Weird Error MessageNo

Minor Problems

12227SQL Execution Plans Showing Multiple WHERE Clauses for SELECT QueriesNo
12233Referencing Invalid Column Names From Tables that Are Not in the FROM Clause Causes AVYes
12236IDENTITY Column Definitions with No Seed Value or Increment Value Specified Causes an AVYes
12238ALTER TABLE Not Handling Comma Separators ProperlyNo
12239Configuration DataTypes Table Returns Incorrect Interval Data TypeNo
12243Subtracting Two Timestamps Results in a Generic Day-Time IntervalYes
12247ALTER TABLE Constraint Violations Being Logged and Not Raised as an ExceptionNo
12248The SQL Reference Manual Incorrectly Lists LARGEINT as the Proper 64-bit Integer Data TypeNo
12249DROP TRIGGER SQL Standard Deviation Section IncorrectNo