ZeosLib 7.1 testers-thread

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
miab3
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 23.08.2013, 12:30

@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
You do not have the required permissions to view the files attached to this post.
Last edited by miab3 on 23.08.2013, 12:43, edited 2 times in total.

miab3
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 24.08.2013, 21:14

@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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Re: ZeosLib 7.1 testers-thread

Postby EgonHugeist » 26.08.2013, 20:47

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...
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

miab3
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 27.08.2013, 12:36

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2685:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 30.08.2013, 09:51

@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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 02.09.2013, 08:18

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2714:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 07.09.2013, 11:07

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2717:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 10.09.2013, 16:41

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2722:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 10.09.2013, 19:13

@EgonHugeist,

Speaking of speed SQLite, this article explains some:
http://blog.synopse.info/post/2013/06/14/SQLite3-performance-in-Exclusive-file-locking-mode

Michal

miab3
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 10.09.2013, 22:30

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2723:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 12.09.2013, 13:28

@EgonHugeist, @mdaems,

Zeos7.1.1-rc-(beta) branches_ testing_R2730:
http://svn.code.sf.net/p/zeoslib/code-0/branches/testing-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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 13.09.2013, 23:57

@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

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Re: ZeosLib 7.1 testers-thread

Postby EgonHugeist » 14.09.2013, 11:48

Thanx, Michael.

Patch done R2733. wrong working copy. Played to much with 7.2.....
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

miab3
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 14.09.2013, 13:19

@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
Zeos Test Team
Zeos Test Team
Posts: 907
Joined: 11.05.2012, 12:32
Location: Poland

Re: ZeosLib 7.1 testers-thread

Postby miab3 » 16.09.2013, 13:57

@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


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest