SAP Knowledge Base Article - Preview

2162189 - Wrong resultset for INSERT...SELECT and SELECT INTO for null value of DATETIME from partitioned table - ASE

Symptom

  • Source table of SELECT statement has a datetime type column
  • Source table of SELECT statement is partitioned the column by range partition
  • Source table of SELECT statement allowed null value and its value are NULL
  • Wrong results are report when running INSERT..SELECT/SELECT INTO

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

"INSERT SELECT" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.