Zeos 7.3 testers-thread

[miab3]

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

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

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

Tested: SQLite, Firebird, Oracle, PostgreSQL, MySQL, MariaDB, MSSQL(ADO, OLE DB, ODBC, FreeTDS), Access.
mORMot 1.18.4719 - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 1.8.4-Win32/Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 1.8.4-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

mORMot 1.18.4790_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 1.8.4-Win32/Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

mORMot 1.18.4790_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/1.8.4-Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

mORMot 1.18.4790_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/1.8.4-Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

mORMot 1.18.4790_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/1.8.4-Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2007-Win32 (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

mORMot 1.18.4838_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/1.8.4-Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2006-Win32 (Windows 10-32),
- Delphi 2007-Win32/C++32 with small hpp mod (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64),
- Delphi 10.2.3 Tokyo-Win32/Win64 (Windows 10-64).

mORMot 1.18.4849_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/1.8.4-Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Delphi 2006-Win32 (Windows 10-32),
- Delphi 2007-Win32/C++32 with small hpp mod (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64).

mORMot 1.18.4860_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/1.8.4-Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 1.8.4-Win64 (Windows 10-64),
- Lazarus 2.0.0RC2-Win64 (Windows 10-64),
- Delphi 2007-Win32/C++32 with small hpp mod (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64),
- Delphi 10.2.3 Tokyo-Win32/Win64 (Windows 10-64).

mORMot 1.18.4860_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/1.8.4-Win64).

Michal

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 2.0.0RC2-Win64 (Windows 10-64),
- Delphi 2007-Win32/C++32 with small hpp mod (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64),
- Delphi 10.2.3 Tokyo-Win32/Win64 (Windows 10-64).

mORMot 1.18.4860_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/2.0.0RC2-Win64).

Michal

[zl_frank]

Hi!

Some SIGSEGV when trying to insert into a table with a parameter as datatype ftInteger or ftLargeInt. I've tried datatypes integer as well as bigint in the table. Everthing works fine when using ftWord instead. No problems with string fields either.

Errors:
ftInteger -> Exception-Class "External: SIGSEGV" in file ZDbcPostgrSqlUtils.pas at line 1046
ftLargeInt -> Exception-Class "External: SIGSEGV" in file ZDbcPostgrSqlUtils.pas at line 1070

My configuration:
Windows 10 64-bit, Lazarus 2.0.0RC1 r59013 64-bit, ZeosLib 7.3 r5194 and r5240, PostgreSQL 9.6.10 64-bit, TZQuery with TZUpdateSQL

Frank

[marsupilami]

Hello Frank,

this is strange because we are doing automated tests with FPC 3.0.4 (Lazarus 1.8.4) on Windows 7 which should show that kind of problem. Could you share the code (Pascal, SQL and table definition) that creates these access violations? Which version of PostgreSQL do you use?

Best regards,

Jan

[zl_frank]

Hello Jan,

Thanks for your answer. To provide you with a well-arranged testcase I started a new project from scratch aaaaand ...
it works like a charm.

So, in all likelyhood the meat in front of the keyboard caused the problem. Sorry for any inconvenience!
I'll test my program thoroughly and let you know what went wrong.

Best regards,

Frank

[miab3]

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

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

compiles and run on:

- Lazarus 2.0.0RC1-Win32 (Windows 10-32),
- Lazarus 2.0.0RC2-Win64 (Windows 10-64),
- Delphi 2007-Win32/C++32 with small hpp mod (Windows 10-64),
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp mod (Windows 7-64),
- Delphi 10 Seattle-Win32/Win64 (Windows 10-64),

mORMot 1.18.4860_mod - passes the database test with ZEOS(Delphi 10 Seattle Win32/Win64, Delphi 2007).
LazSqlX_5.1.7.16.13_mod - Compiles and works(Lazarus 2.0.0RC1-Win32/2.0.0RC2-Win64).

Michal

[zl_frank]

Hello Jan,

I spent several hours on trying to find the bug, but all attempts were to no avail. I started the relevant part of my project from scratch and copied code from the old project in chunks to the new project to isolate the bug. Everthing went fine. The new project works exactly as expected and the old project still throws weird SIGSEGVs at me (identical environment for both projects).

I'm sorry, but I'm not allowed to provide you with the original failing project and I cannot spent more time on this at the moment.

So, I'll make an educated guess: While we went on with development, suddenly another database related part of the project failed with similar SIGSEGVs. But here the reason was obvious: A DataModule wasn't in the correct order within the list of Application.CreateForm(...) in the .lpr file. This is known to be a 'special feature' AFAIK. I had checked this at first before bothering you and it was ok. But maybe something went wrong with DataModules inside Lazarus that didn't come to my attention?

Best regards

Frank