[CR #401753] If you have enabled parallel plan, and you insert into a table with an identity column using select distinct and one of the select distinct list items is an expression or an implicit convert() expression, this query may cause cause a stacktrace. Here is an example query:
create table tt(id numeric(5) identity not null, c1 int, c2 int) go insert into tt select distinct c1, c2+1 from t go
Workaround: Disable parallel plan for the query. For the above example query, you can disable parallel plan for it using:
insert into tt select distinct c1, c2+1 from t (parallel 1)
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
