Error -3007: Invalid sequence for DML and DDL statements - on Linux-Vs 7.6, whereas no such error occurs in WinXP-Vs 7.5

Michael Neuber <[email protected]>
Newsgroups gmane.comp.db.maxdb
Message-ID <[email protected]>
Hi to all,
I am doing some tests on mass uploads based on batch runs on the WinXP 
variant of MaxDB (Vs 7.5.00.38) as well as with shell scripts written 
for the Linux variant (Vs 7.6.00.34).
Meanwhile, I am doing pretty well although lots of scripts are executed.

However, for the first time (!) in quite some months of work with MaxDB, 
I stumbled across a very strange bug:

On the Linux system (2 Dual Opteron à 1.8GHz, 4GB RAM) Memory, in a 
certain command such as

Insert into table(..)
	select attribute1,attribute2,...attribute9
	from table2
	where attribute10 in (2222)

the DB on the Linux system prompts this:

Error -3007: Invalid sequence for DML and DDL statements .


This Insert-Into-Select statement is structurally completely ok,
as are more than ~3000 other insert statements of the same kind
(all are created via script), which have indeed been successfully executed.

On the WinXP laptop (MaxDB Vs 7.5.00.38, Pentium-M 1.7GHz, 1.256GB), 
this error does not occur.

The where-condition '... where attribute10 in (2222) ...'
looks a bit strange at 1st sight, I know, but it is due to the way the 
plenty of similar commands are created: I just have many of them with 
more than one number in the in-clause.

Could anybody give me a valuable hint for the reason of this strange and 
hardly explicable error, and maybe some recommendation on possible 
work-arounds, too?
Do I maybe witness some hitherto unseen bug in Vs 7.6.00.34?

Regards

Michael Neuber


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.