#1  
Old 9th August 2006, 11:03 PM
Ole Willy Tuv
 
Posts: n/a
Default 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


  #2  
Old 10th August 2006, 12:20 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Weird error message

> 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




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL error message incorrect Martijn Tonies nexusdb.public.support.sql 2 21st June 2006 09:59 PM
What is the cause for this error message? MS nexusdb.public.support.adoprovider 7 3rd September 2005 10:18 AM
v 2.01 : Error Message Request Surjanto nexusdb.public.support.sql 1 10th August 2005 04:28 PM
V2 - Low level error message in SQL Ole Willy Tuv nexusdb.public.support.sql 1 29th July 2005 04:06 AM
Weird error when autoinc field has value of -1 Nathan Sutcliffe nexusdb.public.support.sql 4 1st April 2004 02:59 PM


All times are GMT +11. The time now is 11:24 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.