7.2 testers-thread

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1pro-64 - C2D

Michal

[miab3]

@EgonHugeist,

R2775 works,
R2776 compile but AV; stop in file ZAbstractRODataset.pas line 1373:
Result := inherited GetFieldData(Field, Buffer, NativeFormat);

Firebird, DXE2-32

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1pro-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1pro-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1pro-64 - C2D

It begins to be significantly faster.

Michal

[EgonHugeist]

@Miab3

Michal, can you make some benchmarks again? I'm sure we're much faster inbetween.

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1pro-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1pro-64 - C2D

Michal

[miab3]

@EgonHugeist, @mdaems,

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

- Delphi XE2 32/64 -> C++(32)
Windows8.1pro-64 - C2D

Michal

[miab3]

@EgonHugeist,

They are not recognized parameter types.
For example, the Firebird:
'select * form table1 where numint =: n1'
Instead ftInteger ptInput is ftUnknown ptUnknown.
Similary that:
http://zeoslib.sourceforge.net/viewtopi ... =38&t=4893

Michal

[EgonHugeist]

@Miab3,

does this issue persist for all plains? Actually i have no test behavior changes..

[miab3]

@EgonHugeist,

Yes, the same (error) for MSSQL, MySQL and PostgreSQL.
I think he goes on for some time.
In 7.1 also exists.

Michal

[EgonHugeist]

@Miab3

Did a behavior compare of 7.0 to 7.1 and 7.2 accordingly the ParamType and DataType determination you wrote. That was never supported AFAIK. I can not find any line which does the job. Params allways have a floating behavior except assign them to dfm/lfm on the formular. Than the TFiler writes the properties a user set before. Or similar: TZUpdateSQL -> assign the stmts, declare types and here we go.

Well the user here http://zeoslib.sourceforge.net/viewtopi ... =38&t=4893 seems to have a different problem. His paramname was not found, which can have differnet reasons. I'll check it tomorrow.

[miab3]

@EgonHugeist,

Well, in that case, the problem is of a different type.
Why is?:

Code: Select all

procedure TForm1.Button1Click(Sender: TObject);
begin
 ZQuery1.Close;
 ZQuery1.SQL.Clear;
 ZQuery1.SQL.Add('SELECT count(*) as ile from zapisy where NR_KONTRA = :u');
 ZQuery1.ParamByName('u').AsString:='20';
 ZQuery1.Open;  // The answer PG -17, MS - 17, MA -17; FB -0 <---!!!
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
 ZQuery1.Close;
 ZQuery1.SQL.Clear;
 ZQuery1.SQL.Add('SELECT count(*) as ile from zapisy where NR_KONTRA = :u');
 ZQuery1.ParamByName('u').AsInteger:=20;
 ZQuery1.Open; //The answer PG -17, MS - 17, MA -17; FB -17
end;

Michal

[mdaems]

Michael,
Michal,

I suppose there is some behaviour changes between 7.0, 7.1 a,d 7.2.
This is/might be justified. Let's decide case by case. And file a bug report for each different case. So we can decide per case if it's a bug and how we can resolve it.

To have a valid case we need:
- a piece of code against our test database definitions OR a database/table creation script
- the desired/expected outcome
- the real outcome on your system for the 'good' and the 'bad' release.
- The prove doesn't have to be in our test suite format, but should work in 'batch execution mode', so please don't expect that we start editing visual component contents during a test run or debug session. Just pusshing the 'run' button should show the error.

Mark