mORMot Open Source

wxinix

Member

Registered: 2020-09-07

Posts: 121

BatchAdd bug? (Direct SQL Memory DB Inserts)

@ab

This is related to this discussion https://synopse.info/forum/viewtopic.php?id=5998

With the latest performance optimization,  it seems the BatchAdd for Direct SQLite in Memory DB has some problem

The following entity has 10 fields (if counted RowID, then all together 11 fields). However, when BatchAdd to DirectSQL Memory DB,  I got the error : "ESqlite3Exception with message 'Error SQLITE_ERROR (1)"[insert into MyRecord (RowID,CreateAt,WeekTime,GID,ZID,WKT,Attrs,Len,Num,Spd,TTS) values (?,?,?,?,?,?,?,?,?)....
sing 3.36.0 - 9 values for 11 columns, extended_errcode=1'

If I call BatchAdd for an external DB (e.g., postgresql) - for the same ORM entity, everything is working, and the insert was successful.

Any advice?

TMyRecord = class(TOrm)
...
published
  property CreateAt: TDateTimeMS;
  property WeekTime: Integer;
  property GID: Int64;
  property ZID: Integer;
  property WKT: RawUtf8;
  property Attrs: Variant;
  property Len: Double;
  property Num: Double;
  property Spd: Double;
  property TTS: Double;
end;

Last edited by wxinix (2021-10-10 02:54:13)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,237

Website

Re: BatchAdd bug? (Direct SQL Memory DB Inserts)

You are right.

Should be fixed now.