[TRAFODION-1887] Upsert into aligned format table with no primary keys fails with error 3241 after the patch from PR 340

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-incubating
• Fix Version/s: 2.0-incubating
• Component/s: sql-cmp
• Assignee: Selvaganesan Govindarajan
• Reporter: Selvaganesan Govindarajan
• Created: 11/Mar/16 07:28
• Updated: 15/Sep/18 07:31
• Resolved: 06/Apr/16 00:15

Description

>>create table ta (c1 int) attribute aligned format

— SQL operation complete.
>>>>upsert into ta values (1) ;

• • • ERROR[3241] This MERGE statement is not supported. Reason: SYSKEY not allowed.

• • • ERROR[8822] The statement was not prepared.