Zeos 7.3 testers-thread

[miab3]

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 6461:
http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

Compiles:

- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.8(fpc 3.0.4)-Win64,
- Delphi 7,
- RAD Studio 2007-Win32/C++32 with small hpp fixes,
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp fixes,
- Delphi 10.3.3 Rio-Win32/Win64/Android/Android64.

My mORMot PerfTest passes(Delphi 10.3.3 Rio Win32/Win64; D2007)

Michal

[tkamphuis]

I did a test with Zeos-7.3 rev 6462 on Lazarus 2.08 fpc 3.2.0 beta-4480 64 and I got a problem when compiling the package. I get the error:

Compile package zdbc 7.3: Exit code 1, Errors: 1, Hints: 3

ZDbcOracleStatement.pas(958,13) Error: Can't determine which overloaded function to call
ZCompatibility.pas(956,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(1891,30) Hint: Variable "OraPreparableTokens" of a managed type does not seem to be initialized

Max(Descriptor.DataSize, Descriptor.Precision), Descriptor.Scale);

[miab3]

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 6467:
https://sourceforge.net/p/zeoslib/code- ... sting-7.3/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1) - Raspbian32 Buster for Raspberry Pi https://www.getlazarus.org/setup/?download#raspberry_pi,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.8(fpc 3.0.4)-Win64,
- Delphi 7,
- RAD Studio 2007-Win32/C++32 with small hpp fixes,
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp fixes,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/Android/Android64.

mORMot PerfTest r5960 passes(Delphi 10.3.3 Rio Win32/Win64; Delphi 2007)

Michal

[marsupilami]

Hello tkamphuis,

this problem should be fixed with Rev. 6364. Could you please check if it compiles now?

Best regards,

Jan

I did a test with Zeos-7.3 rev 6462 on Lazarus 2.08 fpc 3.2.0 beta-4480 64 and I got a problem when compiling the package. I get the error:

Compile package zdbc 7.3: Exit code 1, Errors: 1, Hints: 3

ZDbcOracleStatement.pas(958,13) Error: Can't determine which overloaded function to call
ZCompatibility.pas(956,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(1891,30) Hint: Variable "OraPreparableTokens" of a managed type does not seem to be initialized

Max(Descriptor.DataSize, Descriptor.Precision), Descriptor.Scale);

[tkamphuis]

I tried version 7.3 version 6468 and still got problems, this time oracle statements. I also tried 7.2.8 and that version works

Compile package zdbc 7.3: Exit code 1, Errors: 6, Hints: 17
ZDbcOracleStatement.pas(882,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(886,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(889,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(1361,22) Hint: Local variable "OraLobs" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(1490,28) Hint: Local variable "ClientStrings" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(2467,40) Hint: Local variable "tmp" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(2630,40) Hint: Local variable "tmp" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(2890,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(2894,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(2897,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(2940,30) Hint: Variable "OraPreparableTokens" of a managed type does not seem to be initialized

Max(Descriptor.DataSize, Descriptor.Precision), Descriptor.Scale)

[marsupilami]

Hello tkamphuis,

I can confirm, the bug existed in Rev. 6468. The current revision (6478) compiles for me on Lazarus 2.0-fixes (62945) and FPC 3.2-fixes (45049).

Best regards,

Jan

[tkamphuis]

Hello Jan,

It compiles fine now (6478), but now there is a problem when I use it with SQLite. It can't find the driver for SQLite in the executable folder. That is for Lazarus 2.08 FPC 3.04 and also for Lazarus 2.08 and FPC 3.2

Zeos 7.2 does not have that problem

With Regards,

Theo

[marsupilami]

Hello Theo,

It can't find the driver for SQLite in the executable folder.

I am not 100% sure what you mean. Do you get an error or are you missing files that you expect to be generated?

Best regards,

Jan

[tkamphuis]

When I develop a database application with SQLite I put the sqlite dll files in my executable folder ( sqlite3.dll). The TZconnection always was able to find that labrary. Version 7.2.6 and also version 7.3 in the past was ok. But the last build of 7.3 does not find the dll anymore. I get the error: Requested database driver not found:

error.png

[marsupilami]

Hello Theo,

erm - this problem means that Zeos was not able to locate the Zeos internal driver you request. Did you remove the version numers from the protocol name in TZConnection? Make sure, you use the protocol "sqlite" there. "sqlite-3" doesn't exist on Zeos 7.3 anymore. We announced that change in the release notes for Zeos 7.2.4 - basically in the last sentence of the chapter "The future development of Zeos".

Maybe Zeos creates ambiguity there by talking about a driver in the error message and not a protocol...

Best regards,

Jan

[tkamphuis]

Hello Jan,

Exelent, that was the problem, I did not change the protocol from sqlite-3 to sqlite. I think I missed the release notes for version 7.2.4.

Everything works fine now. Thank you for quick answer. You make my day.

Kind regards,

Theo

[tkamphuis]

Hello Jan,

I tried several applications in Lazarus 2.0.8, SQLite and zeos 7.3 build 6486 and I see some errors. One of the errors is a strange behaviour of the date field when I paste the fields in the query editor. The dates are sometimes not visble, or only when I click in the field to edit the value.

I met also some other errors, I try to find out.

Version 2.6 has no problems and also not the older 7.3 versions. I also tried version 'testing-7.3-aehimself' and that version is also ok (what are the differences?).

Best Regards,

Theo

[aehimself]

testing-7.3-aehimself is obsolete, not updated for a really long time and the branch should be deleted from the (un)official Zeos git repository.
We used that to test how exactly patches can be pushed the easiest; but abandoned the idea a long time ago.

[marsupilami]

Hello Theo,

I do have some questions:

I tried several applications in Lazarus 2.0.8, SQLite and zeos 7.3 build 6486 and I see some errors.

For any errors you see we are interested in finding out what happens. This is what this thread is about It also might make sense to use the bug tracker on sourceforge. There we can discuss each error separately. Sometimes it gets hard to track things in a single thread. It will be good if we have only one unstable factor in the equation - Zeos. So it will be good if everything else - Lazarus, FPC and sqlite stay the same. So I assume the following: Lazarus 2.0.8, FPC 3.0.4. Do you use SQLite 3.31.1? Are you on Windows or Linux?

One of the errors is a strange behaviour of the date field when I paste the fields in the query editor. The dates are sometimes not visble, or only when I click in the field to edit the value.

In the query editor? I assume you mean the DBGrid? This sounds strange. Can you reproduce this problem in a predictable way? Or does it only happen from time to time? Do you have the time to test different revisions of Zeos to see when the problem was introduced? From experience I do know that the last bit is very time consuming.

I met also some other errors, I try to find out.

Ok. Maybe together we can find the root of the problem.

Version 2.6 has no problems and also not the older 7.3 versions.

Which older 7.3 versions did you test? I assume with "Version 2.6" you mean that you don't get that problem when compiling with FPC 2.6? Which version of Lazarus do you use there?

I also tried version 'testing-7.3-aehimself' and that version is also ok (what are the differences?).

As aehimself said - this version was very old. It was part of a test to see how we can integrate users that use git. I deleted that branch now.

Best regards,

Jan

[tkamphuis]

Hello Jan,

I did some tests with an existing project.

I use Windows 64 bits (1909 - 18363.778)
Lazaus 64 bits 2.08 R62944
fpc 3.,04
SQLite version x64 3310100

zeos version 7.3 - 5939 everything works ok
zeos version 7.3 - 6069 The problem with the date fields arises
zeos version 7.3 - 6491 I now get the error again 'requested databasedriver not found for SQLite protocol (i used sqlite in the conection component)

By pasting the fields in the query edito I mean dubbeclick the zeos query component and add all queru fields:

query editor.png

I have a quick demo to demonstrate (reproduce) the datefield problem, but is is too huge to submit as attachment

Best regards,

Theo