BUG: SELECT INTO from a View May Cause Extra Error Messages

• Microsoft SQL Server for OS/2, version 4.2
• Microsoft SQL Server version 4.2x

SYMPTOMS

A SELECT from a view with an INTO clause may cause an error indicating a type mismatch in the WHERE clause when one does not exist. This happens if the WHERE clause contains two consecutive comparisons of a given type followed by a third involving an implicit conversion.

Possible messages would be:

Msg 206, Level 16
State 2 Operand type clash: int is incompatible with smalldatetime

Msg 257, Level 16
State 1 Implicit conversion from datatype 'int' to 'char' is not
allowed. Use the CONVERT function to run this query.

WORKAROUND

Create the target table and use an INSERT with a SELECT instead of a SELECT INTO.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2a for OS/2 and Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Windows NT

Keywords : kbprg kbbug4.20 kbbug4.20a SSrvServer SSrvWinNT
Version : 4.2 | 4.2a
Platform : OS/2 WINDOWS
Issue type :