Zeoslib Portal

Posted: **29.01.2014, 15:42**

@EgonHugeist, @mdaems,

Michael,

Indeed, there is something with spaces in field names(and aliases).

For the table(FB):

Code: Select all

CREATE TABLE A1 
(
  ID                INTEGER  NOT NULL,
  ST                VARCHAR(20),
  "ST 1"              VARCHAR(20),
  ST2               VARCHAR(20),
 CONSTRAINT PK_A1 PRIMARY KEY (ID)
);

such a query can be updated:

Code: Select all

select  ID, ST, "ST 1", ST2 from A1

and for such a:

Code: Select all

select  ID, ST, "ST 1" as ST1, ST2 from A1

field ST1 becomes readonly.

Michal

Posted: **01.02.2014, 12:46**

@mdaems, @EgonHugeist,

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

- 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. Current 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.34, 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.

@Michael,
Is that what you're doing for Oracle somehow useful for Firdbird, PostgreSQL arrays?
Have a look at these names and aliases with a space in Firebird?

Michal

Posted: **01.02.2014, 19:26**

@EgonHugeist, @mdaems,

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

- 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. Current 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.34, 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.

Michal

Posted: **02.02.2014, 20:27**

@miab3

@Michael,
Is that what you're doing for Oracle somehow useful for Firdbird, PostgreSQL arrays?
Have a look at these names and aliases with a space in Firebird?

Nope it isn't. The Array implementation is just the fastest way to insert/delete/update with Oracle and a thing i promissed A. Bouchez of Synopse. I know it provides a loads of source overheap. But i see clearly nice advantages for the DataSet components too.

But actually i've been start playing with the spaced field/alias names.. Weired only MySQL seems to be prepared for this case in all possibilities...

Posted: **02.02.2014, 21:14**

@ALL

some 7.2 ZDBC performance results:

http://blog.synopse.info/post/2013/11/0 ... ing-MS-SQL

As you can see: WE are loads faster than other professional component like UniDac in all tests.
Batch insertiations isn't tested here because we currenty didn't support it. I added first Array DML bindings for Oracle OCI.
Nice to see we can reach or top FireDac performance in some cases too. Let's see how the tests do behave if Array binding is completely implemented..
Some more optimations will follow up. E.g Oracle reading performance. Weired for me: the enormus diff of insertiation speed of FireDac vs. Zeos. That really make me courious! But i'll give my best to get better results.

Stay tuned!

Posted: **02.02.2014, 21:54**

@Michael,

If it is called "Array DML"(or batch insert), why do you limit it to Oracle if it is possible in Firebird, PostgreSQL and MySQL/MariaDB?
I thought you took for array fields(Oracle, PostgreSQL, Firebird).

Michal

Posted: **02.02.2014, 21:56**

Michal

do you know more about? Some links would be helpfull...
Edit: Did look to http://docwiki.embarcadero.com/RADStudi ... FireDAC%29
so FireBird -> EXECUTE BLOCK looks pretty cool!

MySQL is done by binding a large count of (?,?),(?,?) parameter indication and makes sence with the real-prepareds only, i think.
For postgres, SQLite the same as for MySQL but makes sence in all cases.

Microsoft SQL Server is planned on my side but i can't find an API except for bulk insertiation.

Michal, i'll do my best to get that running for all plains...

And of course i'll check the Array fields of PG, Oracle and FireBird too. But this also means we realy need the TZFields and TZParams, right? I'm affraid this will bring some incompatibility issues we actually didn't had.
And it's a loads af work too.

Posted: **02.02.2014, 23:16**

@Michael,

Michal, i'll do my best to get that running for all plains...

Now it's already pretty good / fast.

I see that similar things we seen.

And here two a little other:
http://tapoueh.org/blog/2013/03/15-batch-update
http://sgbd.arbinada.com/node/98

Michal

Posted: **03.02.2014, 13:22**

@EgonHugeist, @mdaems,

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

- 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.34, 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.

Are disclosed the problem with the names and aliases of fields with a space (in Query).

Michal

Posted: **03.02.2014, 23:53**

@EgonHugeist,

Michael,
R3089 in the Firebird worked:

Code: Select all

select  ID, ST, "ST 1", "ST 1" as "ST 11", "ST 1" as ST1,  ST2 as "ST 2"  from A1

updates without problems.

Michal

Posted: **04.02.2014, 10:44**

@EgonHugeist, @mdaems,

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

- 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.34, 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.

Problem with the names and aliases of fields with a space (in Query) for Firebird removed.
For some other bases (PostgreSQL, SQLite) could remain.

Michal

Posted: **05.02.2014, 10:26**

@EgonHugeist, @mdaems,

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

- 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.34, 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.

Michal

Posted: **06.02.2014, 01:59**

@EgonHugeist, @mdaems,

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

- Add: 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.34, 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.

Add:
As there are problems with *.dpk in DXE3-DXE5, I include an attachment with *.dpk to DXE2 which I use.
For other versions need to be corrected {$LIBSUFFIX '160 '}

Zeos72a_DPK_XE2.zip

Michal

Posted: **06.02.2014, 16:22**

@EgonHugeist, @mdaems,

Michael,
ZEOS 7.2a-r3099
Can you:
1. Make public:

Code: Select all

GetExplicitTransactionCounter function: integer;  // M.A. 

TZAbstractConnection.GetExplicitTransactionCounter function: integer;  // M.A. 
begin    
Result: = FExplicitTransactionCounter; 
end;

in ZAbstractConnection.pas.
Sometimes it is useful for me.

2 Correct ZAbstractRODataset.pas:
http://zeoslib.sourceforge.net/viewtopi ... 886#p25772
to avoid errors in C++ DXE5.

3. Maybe add my (unloved) dpk with appropriate correction {$LIBSUFFIX '160'} to DXE2-DXE5 (attached).
Until someone do it better.
And maybe this pack attached to D7:

zeos72a_pack_d7.zip

Zeos72a_DPK_XE2.zip

Michal

Posted: **09.02.2014, 13:35**

@EgonHugeist, @mdaems,

Continuing the(ZEOS 7.2a-r3099):
4. Applies to Ticket #62:

http://www.firebirdsql.org/refdocs/lang ... words.html
and
New Reserved Words in Firebird 3.0
DETERMINISTIC
OVER
RETURN
SCROLL
SQLSTATE

5. Applies to Ticket #63:

In ZEOS 7.2a_r3099 also occurs.
For two similar tables in FB database ZAPISY and ZAPI__(<--two underscores) always updated is ZAPISY.

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