Page 16 of 20
Re: Zeos 7.3 testers-thread
Posted: 02.05.2021, 14:07
by 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
Re: Zeos 7.3 testers-thread
Posted: 04.05.2021, 08:43
by 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
Re: Zeos 7.3 testers-thread
Posted: 06.05.2021, 10:49
by 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
Re: Zeos 7.3 testers-thread
Posted: 15.05.2021, 18:02
by 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ł
Re: Zeos 7.3 testers-thread
Posted: 11.06.2021, 09:15
by 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ł
Re: Zeos 7.3 testers-thread
Posted: 20.06.2021, 17:09
by 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ł
Re: Zeos 7.3 testers-thread
Posted: 02.07.2021, 04:32
by 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
Re: Zeos 7.3 testers-thread
Posted: 02.07.2021, 10:49
by 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
Re: Zeos 7.3 testers-thread
Posted: 04.07.2021, 14:25
by 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.
Re: Zeos 7.3 testers-thread
Posted: 06.07.2021, 07:33
by 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
Re: Zeos 7.3 testers-thread
Posted: 06.07.2021, 14:01
by miab3
@ BigTree,
On an ad hoc basis, you can connect to some even empty SQLite database(or actually used in the application).
Michał
Re: Zeos 7.3 testers-thread
Posted: 07.07.2021, 16:57
by 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ł
Re: Zeos 7.3 testers-thread
Posted: 11.07.2021, 11:18
by 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ł
Re: Zeos 7.3 testers-thread
Posted: 13.07.2021, 21:32
by 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ł
Re: Zeos 7.3 testers-thread
Posted: 11.08.2021, 12:23
by 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ł