7.2 testers-thread

miab3 · Post by **miab3** » 13.02.2014, 01:53

@EgonHugeist, @mdaems,

Continuing the(ZEOS 7.2a-r3099):
Mormot Test 15 - External DB performance(2014-02-12)
http://synopse.info/fossil/info/be65b4c730:

Insertion speed
Direct Batch Trans Batch Trans
SQLite3 (file full) 11 10 29679 29320
ZEOS SQlite3 10 10 22409 18364
AnyDAC SQlite3 21962 37571 47862 135685 <-- other default settings
ZEOS Firebird 1788 1715 19141 20981
AnyDAC Firebird 20814 45946 21308 45721
Jet 4345 4507 5144 5352
Oracle 975 78376 2446 77733
AnyDAC Oracle 1036 58699 2533 59306
ZEOS Oracle Error

Read speed
By one All Virtual All Direct
SQLite3 (file full) 8415 478148 475194
ZEOS SQlite3 33443 198051 311429
AnyDAC SQlite3 7475 80861 110619
ZEOS Firebird 13645 122366 179250
AnyDAC Firebird 1231 61017 78907
Jet 2787 149767 240003
Oracle 2507 123328 183999
AnyDAC Oracle 1945 54171 69586
ZEOS Oracle Error

But for ZEOS-Oracle I get an error:

ZEOS Oracle read failure: Value.Amount=(i+1)*0.01 0<>0.02 Value.LastChange>=Start 0>=135163020504Value.FirstName=ValueFirstName ""<>"Namé 2"
(C:\Program Files (x86)\Embarcadero\RAD Studio\9.0\Libs\mORMot\SQLite3\Samples\15 - External DB performance\PerfMain.pas, line 324)

Michal

miab3 · Post by **miab3** » 24.02.2014, 13:35

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_r3103:
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.70)
CodeTyphon ver 4.70 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

1. The problem with underscores in FB TableNames.

2. This little thing is disclose in D2006, D2007:
[DCC Warning] ZAbstractRODataset.pas(5200): W1000 Symbol 'ExtractFieldName' is deprecated
From db.pas:
function ExtractFieldName(const Fields: string; var Pos: Integer): string; overload; deprecated; <--
function ExtractFieldName(const Fields: WideString; var Pos: Integer): WideString; overload;

3. One thing I noticed:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=10940
2014-02-13 12:30:16 cat: Execute, proto: mysql-5, msg: Statement 85 : SHOW TABLES FROM xc_7614s LIKE 'fw_delivery_zone'
LIKE and underscores - not enough that a slow but dangerous.

4. Interesting question:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=10947
I also do not know how to deal with the parameter for IN Operator.

5. Do not pass Oracle test in mORMot.
Previous Post:
Mormot Test 15 - External DB performance(2014-02-12)
http://synopse.info/fossil/info/be65b4c730

ZEOS Oracle read failure: Value.Amount=(i+1)*0.01 0<>0.02 Value.LastChange>=Start 0>=135163020504Value.FirstName=ValueFirstName ""<>"Namé 2"
(C:\Program Files (x86)\Embarcadero\RAD Studio\9.0\Libs\mORMot\SQLite3\Samples\15 - External DB performance\PerfMain.pas, line 324)

6. For tiNone in Firebird are created duplicates of additional parameters. This is causing error.
I gave temporary solution, because I can not find the source of this error:
http://zeoslib.sourceforge.net/viewtopi ... 086#p26024

Michal

papelhigienico · Post by **papelhigienico** » 12.03.2014, 21:12

A long time passed since I wrote my last code for ZeosLib. So, I did many changes to keep the compatibility of Zeos 7.2 with older Lazarus (0.9.30) and FPC versions (2.4.2). So If I coded something that violates the ZeosLib code patterns, please tell me.

I ran tests before and after changes, and test suite don't changed after changes.

Now, ZeosLib compiles on:

CodeTyphon 4.7 (Lazarus 1.3 and FPC 2.7.1) Linux x64
CodeTyphon 4.7 (Lazarus 1.3 and FPC 2.7.1) Linux i386
CodeTyphon 4.7 (Lazarus 1.3 and FPC 2.7.1) Linux ARM
CodeTyphon 4.7 (Lazarus 1.3 and FPC 2.7.1) FreeBSD x64
CodeTyphon 4.7 (Lazarus 1.3 and FPC 2.7.1) FreeBSD i386
Lazarus 0.9.30 FPC 2.4.2 Linux i386
Lazarus 0.9.30.4 FPC 2.4.2 Linux i386
Lazarus 1.0.14 FPC 2.6.0 Linux x64
Lazarus 1.3 FPC 2.7.1 Linux x64
Lazarus 1.0.8 FPC 2.6.2 Win32

miab3 · Post by **miab3** » 13.03.2014, 00:30

@EgonHugeist, @papelhigienico, @mdaems,

Zeos7.2-alpha branches_ testing_r3107:
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.70)
CodeTyphon ver 4.70 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

1. The problem with underscores in FB TableNames.

2. This little thing is disclose in D2006, D2007:
[DCC Warning] ZAbstractRODataset.pas(5200): W1000 Symbol 'ExtractFieldName' is deprecated
From db.pas:
function ExtractFieldName(const Fields: string; var Pos: Integer): string; overload; deprecated; <--
function ExtractFieldName(const Fields: WideString; var Pos: Integer): WideString; overload;

For D7, D2006, D2007, DXE2:
[Pascal Warning] ZEncoding.pas(295): W1021 Comparison always evaluates to False
line295: {$if defined(FPC) AND (lcl_fullversion>=1000000)} //Lazarus >= 1.0.0 with delphi fix.
But it should not matter for Delphi.

3. One thing I noticed:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=10940
2014-02-13 12:30:16 cat: Execute, proto: mysql-5, msg: Statement 85 : SHOW TABLES FROM xc_7614s LIKE 'fw_delivery_zone'
LIKE and underscores - not enough that a slow but dangerous.

4. Interesting question:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=10947
I also do not know how to deal with the parameter for IN Operator.

5. Do not pass Oracle test in mORMot.
Mormot Test 15 - External DB performance(2014-03-09)
http://synopse.info/fossil/info/4dea2816a4
ZEOS Oracle read failure: Value.Amount=(i+1)*0.01 0<>0.02 Value.LastChange>=Start 0>=135163020504Value.FirstName=ValueFirstName ""<>"Namé 2"
(C:\Program Files (x86)\Embarcadero\RAD Studio\9.0\Libs\mORMot\SQLite3\Samples\15 - External DB performance\PerfMain.pas, line 324)

6. For tiNone in Firebird are created duplicates of additional parameters. This is causing error.
I gave temporary solution, because I can not find the source of this error:
http://zeoslib.sourceforge.net/viewtopi ... 086#p26024

Michal

papelhigienico · Post by **papelhigienico** » 13.03.2014, 12:57

miab3 wrote: For D7, D2006, D2007, DXE2:
[Pascal Warning] ZEncoding.pas(295): W1021 Comparison always evaluates to False
line295: {$if defined(FPC) AND (lcl_fullversion>=1000000)} //Lazarus >= 1.0.0 with delphi fix.
But it should not matter for Delphi.

Yes, for Delphi, this will be always false. Lazarus 0.9.30.x don't have functions to handle CP852 codepage. I don't know where is the best place to put this check. To fix this, I should check if the Lazarus version greater or equal than 1.0, and to do this, I should include the unit LCLVersion. I don't know if moving this check to ZeosLazarus.inc will work. I'll test and report it soon.

papelhigienico · Post by **papelhigienico** » 13.03.2014, 13:19

I rewrite the header of ZEncoding.pas to:

Code: Select all


{$I ZCore.inc} // -> First use of ZCore.inc, and this is OK.

uses
  Classes, {$IFDEF MSEgui}mclasses,{$ENDIF}
  {$IFDEF WITH_LCONVENCODING}
   LCLVersion, LConvEncoding,
  {$ENDIF}
  {$IF defined(MSWINDOWS) and not defined(WITH_UNICODEFROMLOCALECHARS)}
  Windows,
  {$IFEND}
  {$IF defined(MSWINDOWS) or defined(WITH_UNICODEFROMLOCALECHARS)}
  Math,
  {$IFEND}
  ZCompatibility;

{$I ZCore.inc} // -> Second use of ZCore.inc, because LCLVersion is included now and Defines must be recalculated. I little strange  :)

The check with problem has been moved to ZeosLazarus.inc, so this will avoid the Delphi Warning.

Maybe create a ZeosFPC.inc (to check things related with FPC) ZeosLazarus.inc (to check things related with Lazarus) and ZeosMSEIde.inc for MSEide/MSEgui?

miab3 · Post by **miab3** » 24.03.2014, 20:43

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3108:
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.70)
CodeTyphon ver 4.70 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

[DCC Warning] ZAbstractRODataset.pas(5200): W1000 Symbol 'ExtractFieldName' is deprecated - gone.

The rest of the errors, such as in the recent posts.

In particular:
Mormot Test 15 - External DB performance - Date:2014-03-21 15:51:28
http://synopse.info/fossil/info/92364b21a9
ZEOS Oracle read failure:
Value.Amount=(i+1)*0.01 0<>0.02
Value.LastChange>=Start 0>=135168739050
Value.FirstName=ValueFirstName ""<>"Namé 2"
(C:\Program Files (x86)\Embarcadero\RAD Studio\9.0\Libs\mORMot\SQLite3\Samples\15 - External DB performance\PerfMain.pas, line 321)

Michal

miab3 · Post by **miab3** » 02.04.2014, 12:23

@mdaems, @EgonHugeist, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3109:
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.80)
CodeTyphon ver 4.80 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Errors as in my several previous posts.
And http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390

Michal

juliomar_m · Post by **juliomar_m** » 22.04.2014, 14:27

Hi
testers Win 8 64bit
Lazarus 1.3 fpc 2.6.2

the error occurs because of the circular reference from three units

http://zeoslib.sourceforge.net/viewtopi ... 40&t=11527

miab3 · Post by **miab3** » 23.04.2014, 11:14

@mdaems, @EgonHugeist, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3116(3119):
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
with DelphiXE6 dieltro (and my) modyfication in zeos.inc and ZAbstractRODataset.pas:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11735
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.80)
CodeTyphon ver 4.80 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Errors as in my several previous posts.
And:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 40&t=13184 !!!
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086
And the new: (2014.05.12)
http://zeoslib.sourceforge.net/viewtopi ... 38&t=13368
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11735

Michal

papelhigienico · Post by **papelhigienico** » 12.05.2014, 13:11

I'll check this soon...

miab3 · Post by **miab3** » 01.06.2014, 11:23

@EgonHugeist, @papelhigienico, @mdaems,

Zeos7.2-alpha branches_ testing_r3127, (r3130):
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.80)
CodeTyphon ver 4.80 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Errors as in my several previous posts(No major).
Especially:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 40&t=13184 !!!
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086
http://zeoslib.sourceforge.net/viewtopi ... 38&t=13368
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11735

Michal

miab3 · Post by **miab3** » 08.06.2014, 09:53

@EgonHugeist, @papelhigienico, @mdaems,

Zeos7.2-alpha branches_ testing_r3133:
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.80)
CodeTyphon ver 4.80 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Errors as in my several previous posts(No major).
Especially:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 40&t=13184 !!! The problem with underscores in TableNames.
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086
http://zeoslib.sourceforge.net/viewtopi ... 38&t=13368
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11735 Installing Zeos 7.2 in Delphi XE6

Resolved: Delphi - [Pascal Warning] ZEncoding.pas(295): W1021 Comparison always evaluates to False

Michal

miab3 · Post by **miab3** » 08.06.2014, 13:00

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3134:
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.80)
CodeTyphon ver 4.80 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Errors as in my several previous posts(No major).
Especially:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086
http://zeoslib.sourceforge.net/viewtopi ... 38&t=13368
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11735 Installing Zeos 7.2 in Delphi XE6

Important:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=13184 !!! The problem with underscores in TableNames.

Code: Select all

ZDbcMetadata.pas
line 2058:   WildcardsSet := ['%']; // M.A. was WildcardsSet := GetWildcardsSet;

Mormot Test 15 - External DB performance
http://synopse.info/fossil/info/03c51d043b
ZEOS Oracle read failure:

Code: Select all

Value.Amount=(i+1)*0.01 0<>0.02 
Value.LastChange>=Start 0>=135179187815
Value.FirstName=ValueFirstName[i] ""<>"Namé 2" 
(C:\Program Files (x86)\Embarcadero\RAD Studio\9.0\Libs\mORMot\SQLite3\Samples\15 - External DB performance_myn\PerfMain.pas, line 323)

For ZEOS 7.1.13a no this error.

Michal

miab3 · Post by **miab3** » 14.06.2014, 10:59

@EgonHugeist, @mdaems, @papelhigienico,

Zeos7.2-alpha branches_ testing_r3152:
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 32/64(fpc 2.7.1) on Windows7-64(CodeTyphon ver 4.80)
CodeTyphon ver 4.80 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.

Test databases and 32/64-bits clients:
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.

Errors as in my several previous posts(No major).
Especially:
http://zeoslib.sourceforge.net/viewtopi ... 40&t=11390
http://zeoslib.sourceforge.net/viewtopi ... 17&t=11086

Important:
Mormot Test 15 - External DB performance
http://synopse.info/fossil/info/c6f33429d0

Code: Select all

ZEOS Oracle read failure: Value.Amount=(i+1)*0.01 0<>0.02 Value.LastChange>=Start 
0>=135179967544Value.FirstName=ValueFirstName[i] ""<>"Namé 2" (C:\Program Files (x86)\Embarcadero\RAD 
Studio\9.0\Libs\mORMot\SQLite3\Samples\15 - External DB performance_myn\PerfMain.pas, line 323)

For ZEOS 7.1.13a no this error.

Problem with underscores in TableNames - removed. !!!

Michal

Zeoslib Portal

7.2 testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread

Re: 7.2-alfa testers-thread