[Firebird-net-provider] attempted retrieval of more segments than exist

[paha <ch_...@ya...>]

Hi Jiri, i think we might have a problem with GTTs. I can't reproduce error
in a simple scenario, but i work  on it. 
So, what i have: Fb 2.1 final, FbProvider 2.5 from svn and  following code:

using (FbConnection conn = new
FbConnection(@"charset=WIN1252;connectionlifetime=30;database=192.168.100.5:C:\test\test.fdb;password=masterkey;port=3050;pooling=True;servertype=Default;userid=sysdba"))
            {
                conn.Open();
                FbTransaction tran = conn.BeginTransaction();
                FbCommand command = new FbCommand("insert into TMP
values(@id)", conn, tran);
                command.Parameters.Add("@id", 1);
                command.ExecuteNonQuery();
                command.Parameters[0].Value = 2;
                command.ExecuteNonQuery();
                command.Parameters.Clear();
                command.CommandText = "select count(*) from TMP";
                int count = (int)command.ExecuteScalar();                

                command = new FbCommand("test$tmp_test", conn, tran);
                command.CommandType = CommandType.StoredProcedure;
                command.ExecuteNonQuery();
                tran.Commit();
            }
If the bolded line is not commented (i don't need it really, but with it i
can reproduce exception, i'm getting), i get exception "attempted retrieval
of more segments than exist
internal gds software consistency check (EVL_assign_to: invalid operation
(229), file: evl.cpp line: 276)"
so what we have:
1) TMP - is a GTT with on commit delete rows - so that data exist only in
transaction. It is used to pass multiple values to stored procedure for read
only access. If i replace this table with common one - there is no
exception.
2) test$tmp_test is a complex sp, that makes use of this GTT, it also calls
another complex sp, that also reads from GTT. If i omit call of the other
sp, there is also no exception even if GTT and not common table is used. 

overall results are following: if one sp uses GTT and calls other sp, that
uses GTT - there is an exception (of course if call to select * from GTT is
made before calling sp - but i've also got exception in some other
scenarious, i can't quite remember). If none of sp or only one is using GTT,
everything is ok.

What i failed to do till now is to reproduce the problem with simple sp
scenario, i work on it now. But those SP do only read from this GTT, select
some data and put it in some other common tables. Oh, and the major reason,
i write here - it does work when called from IBExperts within execute block
that simulates the behaviour 

execute block as
declare variable cnt integer;
begin
  insert into tmp values(1);
  insert into tmp values(2);
  select count(*) from tmp into :cnt;
  execute procedure test$tmp_test;
end

I understand, that without having reproducible example it is difficult to
make guess, but maybe the error message tells you something, maybe possible
reasons.

Regards, Pavel.
-- 
View this message in context: http://www.nabble.com/attempted-retrieval-of-more-segments-than-exist-tp16834567p16834567.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.