Weird error message

drop procedure if exists test_proc;
drop table if exists t1;

create table t1 (c1 integer);

create procedure test_proc()
modifies sql data
begin atomic
insert into t1 values (1);
insert into t1 values (2,1); // forced error here
end;

call test_proc();

NexusDB: Query execution failed:
NexusDB: No user transaction is currently in progress. [$2811/10257]
[$2811/10257]

The actual error condition is that there's a column number mismatch between
the insert source and target, as correctly thrown if the compound statement
is defined with NOT ATOMIC:

drop procedure if exists test_proc;
drop table if exists t1;

create table t1 (c1 integer);

create procedure test_proc()
modifies sql data
begin not atomic
insert into t1 values (1);
insert into t1 values (2,1); // forced error here
end;

call test_proc();

NexusDB: Query execution failed:
Unexpected exception object raised: [Exception] Column number mismatch.
Source has more columns than target (2 vs 1) [$3CA1/15521]

Ole

> The actual error condition is that there's a column number mismatch
> between the insert source and target, as correctly thrown if the
> compound statement is defined with NOT ATOMIC:

Thanks, issue #2174.

--
Eivind Bakkestuen
Nexus Database Systems Pty Ltd