7.2 testers-thread
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Re: 7.2-alfa testers-thread
@Maib3,
does it mean it does not compile? Than i've small patch ready..
does it mean it does not compile? Than i've small patch ready..
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/
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/
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2926:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Ticket54 error disappeared.
Michal
Zeos7.2-alpha branches_ testing_R2926:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Ticket54 error disappeared.
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2926 with {$DEFINE WITH_ZSTRINGFIELDS}:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michael, looked at the "Type mismatch..." in FB?
Michal
Zeos7.2-alpha branches_ testing_R2926 with {$DEFINE WITH_ZSTRINGFIELDS}:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michael, looked at the "Type mismatch..." in FB?
Michal
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Re: 7.2-alfa testers-thread
@Miab3,
The TZFields (had no time to continue) wouldn't use a static buffer (no more mem-moves happen, just direct accassing and localizing the values on demand), they simply use the RowAccessor like a variant. If conversions are required, than they happen in Dbc-Layer. That's why i added a generic TZField descandant of TField. I have an idea how to make this code running optional (for each dataset) without a define. But i think i'll keep a define to exclude this code if someone is against it. That would would also avoid incompatibility issues.
Sure. This is not solvable, yet. It would be possible by using the coming TZFields IMO. The type checks happen because of the internal TZSQLTypes. Zeos converts these values to integers which are faster than Floating values(i think) and it's alltime Zeos-Code. The current TField implementation moves the Mem to the FieldBuffers. If we would ignore the checks, than a Stack overflow could happen, like we had with the TCurrency-Fields. SizeOf(Integer) = 4, SizeOf(Single) too. But if it would be a double, currency, Extended value > Stack-overflow.Michael, looked at the "Type mismatch..." in FB?
The TZFields (had no time to continue) wouldn't use a static buffer (no more mem-moves happen, just direct accassing and localizing the values on demand), they simply use the RowAccessor like a variant. If conversions are required, than they happen in Dbc-Layer. That's why i added a generic TZField descandant of TField. I have an idea how to make this code running optional (for each dataset) without a define. But i think i'll keep a define to exclude this code if someone is against it. That would would also avoid incompatibility issues.
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/
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/
Re: 7.2-alfa testers-thread
@EgonHugeist
Michael,
To have two sets of datasets, Classic and New.
Then you will have more freedom to changes.
Michal
Michael,
And can you also add new datasets leaving old.I have an idea how to make this code running optional (for each dataset) without a define.
To have two sets of datasets, Classic and New.
Then you will have more freedom to changes.
Michal
Last edited by miab3 on 15.11.2013, 12:11, edited 1 time in total.
Re: 7.2-alfa testers-thread
@EgonHugeist
Sorry to disturb just to give you some feedback, I tried with the latest alpha source and indeed mORMot tests showed improvements, did't have to do big changes, I decided to continue using the alpha an will be reporting any issues that appear
http://synopse.info/forum/viewtopic.php?pid=9007#p9007
Regards
Sorry to disturb just to give you some feedback, I tried with the latest alpha source and indeed mORMot tests showed improvements, did't have to do big changes, I decided to continue using the alpha an will be reporting any issues that appear
http://synopse.info/forum/viewtopic.php?pid=9007#p9007
Regards
Re: 7.2-alfa testers-thread
@EgonHugeist
Michael,
Is the problem occurring(in many posts) "0 record (s) updated. Only one record should have been update"
is not due to very small differences in the data on the server side and the client side?
(When the key to update is all fields.)
Michal
Michael,
Is the problem occurring(in many posts) "0 record (s) updated. Only one record should have been update"
is not due to very small differences in the data on the server side and the client side?
(When the key to update is all fields.)
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2937:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Zeos7.2-alpha branches_ testing_R2937:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2941:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
(DXE2 - [DCC Hint] ZFastCode.pas(3111): H2164 Variable 'C' is declared but never used in 'IntToRaw')
Michal
Zeos7.2-alpha branches_ testing_R2941:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
(DXE2 - [DCC Hint] ZFastCode.pas(3111): H2164 Variable 'C' is declared but never used in 'IntToRaw')
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist,
Michael,
I do not know whether something can be useful, but in Delphi XE2-64 and higher there is no true type extended
http://blog.synopse.info/post/2011/09/1 ... XE2-64-bit
https://forums.embarcadero.com/thread.j ... adID=60551
But there is something like this:
http://cc.embarcadero.com/Item/28488
Michal
Michael,
I do not know whether something can be useful, but in Delphi XE2-64 and higher there is no true type extended
http://blog.synopse.info/post/2011/09/1 ... XE2-64-bit
https://forums.embarcadero.com/thread.j ... adID=60551
But there is something like this:
http://cc.embarcadero.com/Item/28488
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2945:
http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
([Pascal Warning] ZDbcMySqlResultSet.pas(570): W1036 Variable 'Buffer' might not have been initialized
[Pascal Hint] ZDbcMySqlResultSet.pas(561): H2164 Variable 'Len' is declared but never used in 'TZMySQLResultSet.GetLong')
Michal
Zeos7.2-alpha branches_ testing_R2945:
http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
([Pascal Warning] ZDbcMySqlResultSet.pas(570): W1036 Variable 'Buffer' might not have been initialized
[Pascal Hint] ZDbcMySqlResultSet.pas(561): H2164 Variable 'Len' is declared but never used in 'TZMySQLResultSet.GetLong')
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2946:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Zeos7.2-alpha branches_ testing_R2946:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist,
Michael,
Zeos7.2_R2949
D2006 compiles
but
DXE2-32 not:
[DCC Error] ZSysUtils.pas(3041): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Error] ZSysUtils.pas(3042): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Error] ZSysUtils.pas(3043): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Fatal Error] ZEncoding.pas(942): F2063 Could not compile used unit 'ZSysUtils.pas'
Michal
Michael,
Zeos7.2_R2949
D2006 compiles
but
DXE2-32 not:
[DCC Error] ZSysUtils.pas(3041): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Error] ZSysUtils.pas(3042): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Error] ZSysUtils.pas(3043): E2251 Ambiguous overloaded call to 'IntToStr'
System.SysUtils.pas(6591): Related method: function IntToStr(Integer): string;
ZFastCode.pas(343): Related method: function IntToStr(Integer): string;
[DCC Fatal Error] ZEncoding.pas(942): F2063 Could not compile used unit 'ZSysUtils.pas'
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2951:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Zeos7.2-alpha branches_ testing_R2951:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006,
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Re: 7.2-alfa testers-thread
@EgonHugeist, @mdaems,
Zeos7.2-alpha branches_ testing_R2955:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006, ([Pascal Error] ZAbstractRODataset.pas(3849): E2029 Expression expected but ',' found <-- ,,)
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal
Zeos7.2-alpha branches_ testing_R2955:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2006, ([Pascal Error] ZAbstractRODataset.pas(3849): E2029 Expression expected but ',' found <-- ,,)
- DXE2 32/64 -> C++(32),
Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.32, PostgreSQL 9.3.0.1, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Michal