#1 2021-10-10 02:52:53

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)

Offline

#2 2021-10-10 06:37:43

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,609
Website

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

You are right.
sad

Should be fixed now.
smile

Offline

Board footer

Powered by FluxBB