ZeosLib 7.1 testers-thread

[miab3]

@EgonHugeist,

Referring to:
http://sourceforge.net/p/zeoslib/tickets/44/
I can reproduce.
Attached x 2 :
Lazarus-32

pglazarus_32.png

Delphi xe2-32

pgdxe2_32.png

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2676:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Ticket-44 PostgreSQL fixed.
Still in mySQL nonlinear slow opening table.


Michal

[EgonHugeist]

Sorry Michal for your my missing responce.

We plan to release 7.0.5-stable and 7.1.1-rc. And i'm currently a bit bussy with other things.

Always thank you for your tests, Michal. Hop i got the most remaining issues solved...

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2685:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

With the slowdown in MySQL / MariaDB is explained.
Client library libmariadb.dll give this effect.

Michal

[miab3]

@EgonHugeist, @mdaems,

For version:
Zeos7.1-(beta) branches_ testing_R2699
in Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40) - 32-bits
I gets an error:

Code: Select all

C:\codetyphon\typhon\components\pl_ZeosDBO\source\dbc\ZDbcSqLiteStatement.pas(521,43) Error: Wrong number of parameters specified for call to "bind_text"
C:\codetyphon\typhon\components\pl_ZeosDBO\source\dbc\ZDbcSqLiteStatement.pas(521,43) Fatal: Syntax error, ";" expected but "," found

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2714:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2717:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2722:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Memory leak was gone.
Previously, the Firebird I watched the leak 4MB per 1000 connect / disconnect

It would be else nice to do something with the performance read / write in SQLite.

Michal

[miab3]

@EgonHugeist,

Speaking of speed SQLite, this article explains some:
http://blog.synopse.info/post/2013/06/1 ... cking-mode

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2723:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2730:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist,

Zeos7.1.1-rc-(beta) branches_ testing_R2731:
Do not compile (Delphi2006)

'IZResultSetMetadata' does not contain a member named 'GetColumnType' at line 676 (676:24) and at line 693 (693:94)

Code: Select all

[Pascal Error] ZDbcSqLiteResultSet.pas(693): E2125 EXCEPT or FINALLY expected
[Pascal Error] ZDbcSqLiteResultSet.pas(695): E2066 Missing operator or semicolon
[Pascal Error] ZDbcSqLiteResultSet.pas(698): E2029 '.' expected but ';' found
[Pascal Fatal Error] ZDbcSqLiteStatement.pas(130): F2063 Could not compile used unit '..\..\src\dbc\ZDbcSqLiteResultSet.pas'

Michal

[EgonHugeist]

Thanx, Michael.

Patch done R2733. wrong working copy. Played to much with 7.2.....

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2733:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)

Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17.

Michal

[miab3]

@EgonHugeist,

Played to much with 7.2.....

Updating Windows 8 to 8.1 killed my Oracle, PostgreSQL, MariaDB, Firebird, Delphi 2007 (and antivirus).
So that I will have to sit on it a while.

Michal