Zeos 7.3 testers-thread

[miab3]

ZEOS 8.0.0 /trunk svn 7518
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2007,
- RAD Studio XE2 -Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, PostgreSQL, MariaDB, MySQL, Oracle, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[miab3]

ZEOS 8.0.0 /trunk svn 7526
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

NEW: The time date formatting has been improved.

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)? - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL, MariaDB and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2006,
- Delphi 2007,
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1(1,2,3) Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[miab3]

ZEOS 8.0.0 /trunk svn 7530
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)? - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL, MariaDB and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2006,
- Delphi 2007,
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1(1,2,3) Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michal

[miab3]

ZEOS 8.0.0 /trunk svn 7538
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)? - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL, MariaDB and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2006,
- Delphi 2007,
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1(1,2,3) Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7579
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1(1,2,3) Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7589
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL, MariaDB and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1(1,2,3) Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[BigTree]

Hi!
@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZMemTable1.Locate('NO','00005',[]);

Errors:
Exception Class "External: SIGSEGV" in file ZabstractRODataset.pas at line 4906
FieldRefs := DefineFields(Self, KeyFields, OnlyDataFields,
Connection.DbcConnection.GetTokenizer);

My configuration:
Windows 7 64-bit, Lazarus 2.0.12 r64642 64-bit, ZeosLib 8.0 r7591

[marsupilami]

Hello BigTree,

could you please try to create a small sample application that demonstrates the problem? This greatly helps in debugging.

Best regards,

Jan

[BigTree]

Hello marsupilami，
Test Application:

unit Unit1;

{$mode objfpc}{$H+}

interface

uses
Classes, SysUtils, DB, Forms, Controls, Graphics, Dialogs, StdCtrls, DBGrids,
ZDataset;

type

{ TForm1 }

TForm1 = class(TForm)
Button1: TButton;
Button2: TButton;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
ZMemTable1: TZMemTable;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private

public

end;

var
Form1: TForm1;

implementation

{$R *.lfm}

{ TForm1 }

procedure TForm1.Button1Click(Sender: TObject);
var
I:integer;
begin
ZMemTable1.Close;
ZMemTable1.FieldDefs.Clear;
ZMemTable1.FieldDefs.Add('ID',ftInteger);
ZMemTable1.Open;
For I := 1 To 9 Do
Begin
ZMemTable1.Append;
ZMemTable1.FieldByName('ID').Value := I;
End;
ZMemTable1.Post;
//ZMemTable1.Open;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
ZMemTable1.Locate('ID',8,[]);
end;

end.

[marsupilami]

Hello BigTree,

I can confirm the bug and created a bug report and a test case. Unfortunately this is not fixed easily. For more information see https://sourceforge.net/p/zeoslib/tickets/525/

Best regards,

Jan

[miab3]

@ BigTree,

On an ad hoc basis, you can connect to some even empty SQLite database(or actually used in the application).

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7600
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1(1,2,3) Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7605
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Delphi 7,
- Delphi 2006,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1(1,2,3) Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

Hi,

ZEOS 8.0 /trunk svn 7605 compiles, install and works
on lazarus-2.2.0RC1-fpc-3.2.2-win64 and Windows 11 Pro 22000.65

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7624(7625)
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1)?(-ZBase64.pas) - Raspberry Pi OS(Debian - ARM Linux 32b)- Firebird, MS SQL(FreeTDS), PostgreSQL, MySQL and SQLite,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC1-fpc-3.2.2-win64(on Windows 11 Pro 22000.120),
- Delphi 7(on Windows 11 Pro 22000.120),
- Delphi 2006,
- Delphi 2007(-ZBase64.pas),
- RAD Studio XE2-Win32/Win64/OSX32/C++32,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/(Android/Android64- compiles but requires more thorough testing),
- Delphi 10.4.2 Sp1,2,3 Sydney-Win32/Win64/(Android/Android64- compiles but requires more thorough testing).

Tested: SQLite, Firebird, MariaDB, MySQL, PostgreSQL, Oracle Database, MS SQL(ADO, OLE DB, ODBC, FreeTDS)

My mORMot 1.18 r6140 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał