Zeos 7.3 testers-thread

[miab3]

ZEOS 8.0.0 /trunk svn 7633(7634)
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ł

[miab3]

ZEOS 8.0.0 /trunk svn 7645(7646)
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.160),
- Delphi 7(on Windows 11 Pro 22000.160),
- 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

ZMemTable without ZConnect works.

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7657
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.176),
- 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

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

Compiles and run:
Delphi 11 Alexandria - Win32/Win64(/Android/Android64- compiles but requires more thorough testing) on Windows 11 Pro 22000.176.

Michał

[miab3]

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

Compiles:

- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus-2.2.0RC1-fpc-3.2.2-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 11 Alexandria - 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

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

Compiles and Works:

- 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.184),
- 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),
- Delphi 11 Alexandria - 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7717,7719
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/
NEW: SaveToStream and LoadFromStream for ZMemTable(It's easy to use SaveToFile/LoadFromFile).

Compiles and Works:

- 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.0RC2-fpc-3.2.2-win64(on Windows 11 Pro 22000.184),
- 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 11sp1 Alexandria - 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Michał

[miab3]

Hi Jan,

Zeos8_svn_trunk_7733 Delphi 10.3.3-Win32

An entry in ZCore.dpk is missing:
ZExceptions in '..\..\src\core\ZExceptions.pas',

Compilation notes:
[dcc32 Warning] ZDbcFirebirdInterbase.pas(4565): W1024 Combining signed and unsigned types - widened both operands
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5254): H2164 Variable 'P' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5255): H2164 Variable 'Digits' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5256): H2164 Variable 'IsNegative' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5257): H2164 Variable 'C' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetInt'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5315): H2164 Variable 'U' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5316): H2164 Variable 'P' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5317): H2164 Variable 'Digits' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5318): H2164 Variable 'IsNegative' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetLong'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5538): H2164 Variable 'P' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5539): H2164 Variable 'W' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5540): H2164 Variable 'Digits' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Hint] ZDbcFirebirdInterbase.pas(5541): H2164 Variable 'IsNegative' is declared but never used in 'TZAbstractFirebirdInterbasePreparedStatement.SetSmall'
[dcc32 Warning] ZDbcODBCResultSet.pas(1915): W1021 Comparison always evaluates to False

Michał

[aehimself]

Michal,

For the warnings please refer to this post.

I'll doublecheck the ZExceptions reference in all packages.

[miab3]

Hi Jan,

Continues remarks on svn 7733.
In svn 7733 Array BATCH-DML (e.g. for Firebird) stopped working, and it worked in svn7719.
Throws AV.
Test example in this thread:
viewtopic.php?f=50&t=146924

Michał

[miab3]

Hi aehimself,

I coped, as you can see.
But many don't.

Michał

[aehimself]

Added ZExceptions.pas to all packages. I hope I did CBuilder and Lazarus correctly and made no typos anywhere.
Commit is included in the already open pull request.

Thanks for pointing this out!

[miab3]

ZEOS 8.0.0 /trunk svn 7740, 7741, 7742
https://sourceforge.net/p/zeoslib/code- ... ree/trunk/

To be able to use ZMemTable SaveToStream and LoadFrom Stream, you should enable in the zeos.inc file:
{$DEFINE ZMEMTABLE_ENABLE_STREAM_EXPORT_IMPORT} // line 97

Compiles and Works:

- 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.0RC2-fpc-3.2.2-win64(on Windows 11 Pro 22000.376),
- CT 7.7-Win32/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 11sp1 Alexandria - 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

1. ZMemTable SaveToStream / LoadFromStream problems with fields of the type
varchar(max), nvarchar(max), varbinary(max)- cloned from MS SQL- FreeTDS.
viewtopic.php?f=50&t=148059&start=105#p184659

2. Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7772
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.0(fpc 3.2.2)-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 11sp1 Alexandria - 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał

[miab3]

ZEOS 8.0.0 /trunk svn 7793
https://sourceforge.net/p/zeoslib/code- ... tree/trunk

Compiles and Works:

- Lazarus 2.2.0(fpc 3.2.2)-Win32,
- Lazarus 2.0.12(fpc 3.2.0)-Win64,
- Lazarus 2.2.0(fpc 3.2.2)-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 11sp1 Alexandria - 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 r6302 PerfTest passes(Delphi 10.3.3 Rio Win32/Win64, Delphi 2007)

Problem with ZMemTable - no changes are detected in the MEMO field itself(Lazarus)
viewtopic.php?f=50&p=184847#p184847

Michał