7.2 testers-thread

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Locked
woec
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 23.04.2013, 20:47

Re: 7.2-Beta testers-thread

Post by woec »

Hi,

actually for some mistake I made in getting the source, I used not the last source code. After correcting this, ADO works in my environment.
Furthermore I noticed, that connections with ADO work with TZConnection Object, but not when I use TZConnectionGroup. In this case I get a connection error from the Microsoft ODBC Driver Manager telling me "Data Source not found. No default driver supplied". Obviously ADO is not used by TZConnectiongroup at all, even if this protocol is selected.
Maybe this is a bug?

regards,
Johann
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3481 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- new ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.488 2014-11-10 09:15:19 from:
http://synopse.info/fossil/info/0ae7f37 ... f066e16455
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3484 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- new ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.498 2014-11-12 09:37:18 from:
http://synopse.info/fossil/info/cdf6bb8 ... 4eb7fd5ddc
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, all

Zeos7.2-beta branches_ testing_Revision 3489 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- new ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.516 2014-11-14 23:31:24 from:
http://synopse.info/fossil/info/7f710d1 ... 02d907d8cd
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor bug:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3501 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- new ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.552 2014-11-21 13:10:39 from:
http://synopse.info/fossil/info/c13d3ce ... 1aeac5eac3
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor problems:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086 - duplicated additional parameters in Firebird
http://zeoslib.sourceforge.net/viewtopi ... 38&t=19192 - select * from INFORMATION_SCHEMA.TABLES in msdblib

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3513 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success- new ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX 4.5.0.1436 -Win-32/64-bit build with success -
new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.578 2014-11-26 20:41:52 from:
http://synopse.info/fossil/info/4dafa2d ... 0092a8fb11
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor problems:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086 - duplicated additional parameters in Firebird
http://zeoslib.sourceforge.net/viewtopi ... 38&t=19192 - select * from INFORMATION_SCHEMA.TABLES in msdblib

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3516 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D7 on Windows XP Mode (on W7-32),
- D2006 (W7-32),
- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success- new ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success -
new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.588 2014-11-28 12:00:04 from:
http://synopse.info/fossil/info/f003456 ... 537995fdf0
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Minor problems:
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086 - duplicated additional parameters in Firebird
http://zeoslib.sourceforge.net/viewtopi ... 38&t=19192 - select * from INFORMATION_SCHEMA.TABLES in msdblib

Michal
patyit
Junior Boarder
Junior Boarder
Posts: 37
Joined: 10.02.2012, 18:39

Re: 7.2-Beta testers-thread

Post by patyit »

Hi !
I'm updated Lazarus and ZeosDBO rev.: 3520, from svn and can't compile it with FPC 2.7.1 svn i386, the error is :
Compiling package ZCore 7.2: Exit code 256, Errors 1
Fatal: I/O Error: File not open

while with FPC 2.6.5 svn is OK !
Lazarus 1.3 svn, XUbuntu 14.04 LTS i386.
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: 7.2-Beta testers-thread

Post by EgonHugeist »

@patyit

it's a FPC problem which also makes trouble with outher projects: http://bugs.freepascal.org/view.php?id=27071
Best regards, Michael

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

Image
riv1329
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 30.11.2014, 20:20

Re: 7.2-Beta testers-thread

Post by riv1329 »

Bug in all versions ZEOS DBO v7.x include revision 3532 with MySQL and MariaDB

I create ZConnection1 and connect it to the database.
Then, I create ZQuery with SQL

Code: Select all

SELECT * FROM ref_companys 
The code that creates the table ref_companys

Code: Select all

CREATE TABLE `ref_companys` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`INN` DECIMAL(10,0) UNSIGNED NOT NULL COMMENT 'INN',
`KPP` DECIMAL(9,0) UNSIGNED NOT NULL COMMENT 'CAT',
`NAME` CHAR(200) NOT NULL COMMENT 'name of the legal entity' COLLATE 'utf8_bin',
`ADDRESS` CHAR(200) NULL DEFAULT NULL COMMENT 'Address (location) of the legal entity' COLLATE 'utf8_bin',
`BIN` DECIMAL(13,0) UNSIGNED NULL DEFAULT NULL COMMENT 'OGRN',
`BIN_DATE` DATE NULL DEFAULT NULL COMMENT 'date of appropriation OGRN',
`END_DATE` DATE NULL DEFAULT NULL COMMENT 'date of entry on termination of activities',
PRIMARY KEY (`id`),
INDEX `INN` (`INN`),
INDEX `BIN` (`BIN`),
INDEX `NAME` (`NAME`)
)
COLLATE='utf8_bin'
ENGINE=InnoDB
AUTO_INCREMENT=234
;

Description of the error
If I do so:

Code: Select all

ZQueryCmp.Edit;
ZQueryCmp.FieldByName('name').AsString:='it is wery long company name, wery wery long.... long... long...';
ZQueryCmp.Post;
ZQueryCmp.ApplyUpdates;
But it only saves "it is wery long company na"

And if you do so:

Code: Select all

ZQueryCmp.Edit;
ZQueryCmp.Post;
ZQueryCmp.Edit;
ZQueryCmp.FieldByName('name').AsString:='it is wery long company name, wery wery long.... long... long...';
ZQueryCmp.Post;
ZQueryCmp.ApplyUpdates;
Then all is well saved: "it is wery long company name, wery wery long.... long... long..."

Because of this behavior, is almost impossible to work with visual components. Instead TDBedit have to use TEdit, etc...

Sorry for my bad English
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches_ testing_Revision 3533 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2007 -> C++ (W8.1-64),
- DXE2 32/64 -> C++(32) (W7-64),
- Lazarus 1.2.6-W64 (fpc 2.6.2) on Windows 8.1-64 - compiles and builds without a problem - new ADO operates on Windows,
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.90) - CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success- new ADO operates on Windows
- Lazarus 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 5.10) - CodeTyphon ver 5.10 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success -
new ADO operates on Windows,
- Lazarus 64(fpc 2.7.1) on Fedora-x86_64-20-1(CodeTyphon ver 4.80) - CodeTyphon ver 4.80 rebuilt without a problem; Tested:
SQLite and client: Firebird, MySQL- MariaDB, PostgreSQL, Oracle, MSSQL(FreeTDS).


Passes Test-Benchmark mORMot 15 - External DB performance(mod) ver 1.18.601 2014-11-30 from:
http://synopse.info/fossil/info/d989624 ... cae26c9d30
Delphi XE2-32 localhost and remote (also Firebird 3.0).

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.40, MariaDB 5.5.40, NEW: MariaDB 10.1.1 Alpha, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0,SQLite 3.8.7, NEW: Firebird 3.0 Beta 1.

Duplicated additional parameters in Firebird (tiNone) resolved.

Minor problems:
http://zeoslib.sourceforge.net/viewtopi ... 38&t=19192 - select * from INFORMATION_SCHEMA.TABLES in msdblib

ADD: CodeTyphon ver 5.20 (5131) 32/64 on Windows7-64 rebuilt without a problem. LazSqlX v4.6.3.1524 -Win-32/64-bit build with success -new ADO operates on Windows 32/64.

Michal
sternas
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 15.12.2013, 18:09

Re: 7.2-Beta testers-thread

Post by sternas »

We test LAB CT 5.2 with Zeos SVN Rev 3502 and on MacOS now...

oh in CT 5.2 use can use
{$IFDEF CODETYPHON} directive
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, All

Patch to the Firebird r3526-27 cause new bugs.
Blocks hard_commit=true
and
http://zeoslib.sourceforge.net/viewtopi ... 40&t=19829

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

Re: 7.2-Beta testers-thread

Post by miab3 »

@EgonHugeist, @mdaems, All

Zeos7.2-beta branches testing Revision 3539 :
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/

Remained a problem with:
- hard_commit=true in Firebird,
- select * from INFORMATION_SCHEMA.TABLES in msdblib.

Michal
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: 7.2-Beta testers-thread

Post by EgonHugeist »

@riv1329

i think there went something wrong with the DisplayWidth alignment.

Please check the TZDataSet-Option [doNotAlignDisplayWidth]. I think your IDE cut's the string before Zeos can get the Value. Wondering why 2. approach works. What's your default CodePage and OS?

@Sternas

Thank you! That's pretty nice to have! Note we use our own ZOleDB for FPC+ADO inbetwen. If you've trouble or if we can do something else 4U: Just mail me!
Best regards, Michael

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

Image
Locked