Zeoslib Portal

Posted: **04.11.2013, 13:03**

@Miab3

miab3 wrote:This inaccuracy .001 (in 7.2) can not be the cause of the error?
This field is for me a timestamptz and has a value of
1997-02-25 (1997-02-25 00:00:00+01)

Hope so. Did commit a fix for that R2905 \testing-7.2.

Otherwise... I can't reproduce your issue.

Posted: **04.11.2013, 13:39**

@EgonHugeist,

Michael,
Add yet test with '1997-02-25'(only) to datetime.

Michal

Posted: **04.11.2013, 13:46**

@miab3

Code: Select all

  TestRawSQLTimeStampToDateTime('1997-02-25', EncodeDate(1997, 2, 25)+EncodeTime(0, 0, 0, 0), False, 'YYYY-MM-DD HH:NN:SS.ZZZ');//postgres 1997-02-25 00:00:00+01 f.e.

Works nice. Don't understand your hint..

Posted: **04.11.2013, 14:11**

@EgonHugeist,

Code: Select all

CREATE TABLE public."DT1" (
  "ID" INTEGER NOT NULL,
  "DATETIME1" TIMESTAMP(0) WITH TIME ZONE,
  CONSTRAINT "DT1_pkey" PRIMARY KEY("ID")
) 
WITH (oids = false);

ALTER TABLE public."DT1"
  ALTER COLUMN "ID" SET STATISTICS 0;

ZConnection1, Ztable1, DataSource1, Dbgrid1

Code: Select all

2013-11-04 13:58:44 cat: Connect, proto: postgresql-9, msg: CONNECT TO "dbdemos" AS USER "postgres"
2013-11-04 13:58:44 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 13:58:44 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 13:58:44 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-11-04 13:58:44 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-11-04 13:58:44 cat: Execute prepared, proto: postgresql-9, msg: Statement 1
2013-11-04 13:58:44 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description  FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog')  WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'DT1' ORDER BY nspname,relname,attnum
2013-11-04 13:58:44 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-11-04 13:58:53 cat: Bind prepared, proto: postgresql-9, msg: Statement 2 : 4,2001-01-01 00:00:00.000
2013-11-04 13:58:53 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 13:58:53 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 13:58:53 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 13:58:53 cat: Execute prepared, proto: postgresql-9, msg: Statement 2
2013-11-04 13:58:58 cat: Execute, proto: postgresql-9, msg: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, a.attnum AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_namespace n, pg_catalog.pg_class ct, pg_catalog.pg_class ci, pg_catalog.pg_attribute a, pg_catalog.pg_index i WHERE ct.oid=i.indrelid AND ci.oid=i.indexrelid AND a.attrelid=ci.oid AND i.indisprimary AND ct.relname = E'dt1' AND ct.relnamespace = n.oid AND n.nspname = E'public' ORDER BY table_name, pk_name, key_seq
2013-11-04 13:58:58 cat: Bind prepared, proto: postgresql-9, msg: Statement 3 : 2002-02-02 00:00:00.000,1,2001-01-01 00:00:00.001  <========================
2013-11-04 13:58:58 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 13:58:58 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 13:58:58 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 13:58:58 cat: Execute prepared, proto: postgresql-9, msg: Statement 3

4, 1-1-1
Insert success

ID=1
DATETIME1 old value = 2001-01-01
New value 2-2-2
Update error

Previously entered:
2001-01-01 00:00:00.000

after restarting the application reads:
2001-01-01 00:00:00.001

Michal

Posted: **04.11.2013, 14:38**

@miab3

2013-11-04 14:34:55 cat: Execute prepared, proto: postgresql-9, msg: Statement 11
2013-11-04 14:34:55 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'DT1' ORDER BY nspname,relname,attnum
2013-11-04 14:35:05 cat: Execute, proto: postgresql-9, msg: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, a.attnum AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_namespace n, pg_catalog.pg_class ct, pg_catalog.pg_class ci, pg_catalog.pg_attribute a, pg_catalog.pg_index i WHERE ct.oid=i.indrelid AND ci.oid=i.indexrelid AND a.attrelid=ci.oid AND i.indisprimary AND ct.relname = E'dt1' AND ct.relnamespace = n.oid AND n.nspname = E'public' ORDER BY table_name, pk_name, key_seq
2013-11-04 14:35:05 cat: Bind prepared, proto: postgresql-9, msg: Statement 12 : 2002-02-02 00:00:00.000,4,2001-01-01 00:00:00.000
2013-11-04 14:35:05 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 14:35:05 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 14:35:05 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 14:35:05 cat: Execute prepared, proto: postgresql-9, msg: Statement 12
2013-11-04 14:35:10 cat: Bind prepared, proto: postgresql-9, msg: Statement 12 : 2002-02-02 00:00:00.000,3,2001-01-01 00:00:00.000
2013-11-04 14:35:10 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 14:35:10 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 14:35:10 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 14:35:10 cat: Execute prepared, proto: postgresql-9, msg: Statement 12
2013-11-04 14:35:14 cat: Bind prepared, proto: postgresql-9, msg: Statement 12 : 2002-02-02 00:00:00.000,2,2001-01-01 00:00:00.000
2013-11-04 14:35:14 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 14:35:14 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 14:35:14 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 14:35:14 cat: Execute prepared, proto: postgresql-9, msg: Statement 12
2013-11-04 14:35:18 cat: Bind prepared, proto: postgresql-9, msg: Statement 12 : 2001-01-01 00:00:00.000,1,2002-02-02 00:00:00.000
2013-11-04 14:35:18 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 14:35:18 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 14:35:18 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 14:35:18 cat: Execute prepared, proto: postgresql-9, msg: Statement 12
2013-11-04 14:35:22 cat: Bind prepared, proto: postgresql-9, msg: Statement 12 : 2002-02-02 00:00:00.000,1,2001-01-01 00:00:00.000
2013-11-04 14:35:22 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 14:35:22 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 14:35:22 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 14:35:22 cat: Execute prepared, proto: postgresql-9, msg: Statement 12
2013-11-04 14:35:24 cat: Execute prepared, proto: postgresql-9, msg: Statement 13
2013-11-04 14:35:32 cat: Bind prepared, proto: postgresql-9, msg: Statement 14 : 2001-01-01 00:00:00.000,4,2002-02-02 00:00:00.000
2013-11-04 14:35:32 cat: Execute, proto: postgresql-9, msg: COMMIT

i give up. No idea. Everything i'm doing works like expected. Did insert ID=4, 1.1.1 Than the update to 2.2.2 works. Added some more rows (like you can see) and ... nothing.

Posted: **04.11.2013, 14:55**

@EgonHugeist,

Michael,
And what happens after restarting the application?

Michal

Posted: **04.11.2013, 15:03**

2013-11-04 15:00:36 cat: Connect, proto: postgresql-9, msg: CONNECT TO "zeoslib" AS USER "postgres"
2013-11-04 15:00:36 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:00:36 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:00:36 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-11-04 15:00:36 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-11-04 15:00:36 cat: Execute prepared, proto: postgresql-9, msg: Statement 1
2013-11-04 15:00:36 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-11-04 15:00:36 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-11-04 15:00:36 cat: Execute prepared, proto: postgresql-9, msg: Statement 2
2013-11-04 15:00:36 cat: Execute prepared, proto: postgresql-9, msg: Statement 3
2013-11-04 15:00:36 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-11-04 15:00:38 cat: Disconnect, proto: postgresql-9, msg: DISCONNECT FROM "zeoslib"
2013-11-04 15:00:38 cat: Connect, proto: postgresql-9, msg: CONNECT TO "zeoslib" AS USER "postgres"
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-11-04 15:00:38 cat: Connect, proto: postgresql-9, msg: CONNECT TO "zeoslib" AS USER "postgres"
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SET CLIENT_ENCODING = WIN1252
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-11-04 15:00:38 cat: Execute prepared, proto: postgresql-9, msg: Statement 4
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-11-04 15:00:38 cat: Execute prepared, proto: postgresql-9, msg: Statement 5
2013-11-04 15:00:38 cat: Execute prepared, proto: postgresql-9, msg: Statement 6
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-11-04 15:00:38 cat: Execute prepared, proto: postgresql-9, msg: Statement 7
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-11-04 15:00:38 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-11-04 15:00:38 cat: Execute prepared, proto: postgresql-9, msg: Statement 8
2013-11-04 15:00:38 cat: Execute prepared, proto: postgresql-9, msg: Statement 9
2013-11-04 15:00:42 cat: Execute prepared, proto: postgresql-9, msg: Statement 10
2013-11-04 15:00:42 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'DT1' ORDER BY nspname,relname,attnum
2013-11-04 15:00:47 cat: Execute, proto: postgresql-9, msg: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, a.attnum AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_namespace n, pg_catalog.pg_class ct, pg_catalog.pg_class ci, pg_catalog.pg_attribute a, pg_catalog.pg_index i WHERE ct.oid=i.indrelid AND ci.oid=i.indexrelid AND a.attrelid=ci.oid AND i.indisprimary AND ct.relname = E'dt1' AND ct.relnamespace = n.oid AND n.nspname = E'public' ORDER BY table_name, pk_name, key_seq
2013-11-04 15:00:47 cat: Bind prepared, proto: postgresql-9, msg: Statement 11 : 2001-01-01 00:00:00.000,4,2002-02-02 00:00:00.000
2013-11-04 15:00:47 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 15:00:47 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:00:47 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:00:47 cat: Execute prepared, proto: postgresql-9, msg: Statement 11
2013-11-04 15:00:50 cat: Bind prepared, proto: postgresql-9, msg: Statement 11 : 2002-02-02 00:00:00.000,1,2001-01-01 00:00:00.000
2013-11-04 15:00:50 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 15:00:50 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:00:50 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:00:50 cat: Execute prepared, proto: postgresql-9, msg: Statement 11
2013-11-04 15:00:56 cat: Bind prepared, proto: postgresql-9, msg: Statement 11 : 2002-02-02 00:00:00.000,2,2001-01-01 00:00:00.000
2013-11-04 15:00:56 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 15:00:56 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:00:56 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:00:56 cat: Execute prepared, proto: postgresql-9, msg: Statement 11
2013-11-04 15:00:59 cat: Bind prepared, proto: postgresql-9, msg: Statement 11 : 2003-03-03 00:00:00.000,1,2002-02-02 00:00:00.000
2013-11-04 15:00:59 cat: Execute, proto: postgresql-9, msg: COMMIT
2013-11-04 15:00:59 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:00:59 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:00:59 cat: Execute prepared, proto: postgresql-9, msg: Statement 11
2013-11-04 15:01:02 cat: Disconnect, proto: postgresql-9, msg: DISCONNECT FROM "zeoslib"
2013-11-04 15:01:02 cat: Disconnect, proto: postgresql-9, msg: DISCONNECT FROM "zeoslib"
2013-11-04 15:01:03 cat: Connect, proto: postgresql-9, msg: CONNECT TO "zeoslib" AS USER "postgres"
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-11-04 15:01:03 cat: Connect, proto: postgresql-9, msg: CONNECT TO "zeoslib" AS USER "postgres"
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SET CLIENT_ENCODING = WIN1252
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: BEGIN
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: select setting from pg_settings where name = 'bytea_output'
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-11-04 15:01:03 cat: Execute prepared, proto: postgresql-9, msg: Statement 12
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-11-04 15:01:03 cat: Execute prepared, proto: postgresql-9, msg: Statement 13
2013-11-04 15:01:03 cat: Execute prepared, proto: postgresql-9, msg: Statement 14
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SELECT version()
2013-11-04 15:01:03 cat: Execute prepared, proto: postgresql-9, msg: Statement 15
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'people' ORDER BY nspname,relname,attnum
2013-11-04 15:01:03 cat: Execute, proto: postgresql-9, msg: SELECT oid, typname, typbasetype,typtype FROM pg_type WHERE (typtype = 'b' and oid < 10000) OR typtype = 'p' OR typtype = 'e' OR typbasetype<>0 ORDER BY oid
2013-11-04 15:01:03 cat: Execute prepared, proto: postgresql-9, msg: Statement 16
2013-11-04 15:01:03 cat: Execute prepared, proto: postgresql-9, msg: Statement 17
2013-11-04 15:01:05 cat: Execute prepared, proto: postgresql-9, msg: Statement 18
2013-11-04 15:01:05 cat: Execute, proto: postgresql-9, msg: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin, def.adrelid) as adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum > 0 AND NOT a.attisdropped AND n.nspname = E'public' AND c.relname = E'DT1' ORDER BY nspname,relname,attnum
2013-11-04 15:01:06 cat: Disconnect, proto: postgresql-9, msg: DISCONNECT FROM "zeoslib"
2013-11-04 15:01:07 cat: Disconnect, proto: postgresql-9, msg: DISCONNECT FROM "zeoslib"

The same.. nothing changes.

Did you realy update to last rev?

Posted: **04.11.2013, 15:13**

@EgonHugeist,

Indeed, not updated, sorry.

Zeos7.2-alpha branches_ testing_R2905:
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)
Windows 8.1A pro-64 - C2D

Michal

Posted: **04.11.2013, 21:44**

miab3 wrote:Indeed, not updated, sorry.

good news... Don't worry about.

Posted: **04.11.2013, 22:37**

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R2906:
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)
Windows 8.1A pro-64 - C2D

Small dataset test:

=================================
server local MariaDB-64 client c2d 2GHz

select tint,tstring from test LIMIT ?
Limit 50000 0,17 sec
Limit 100000 0,31 sec
Limit 150000 0,47 sec
Limit 200000 0,60 sec
Limit 250000 0,76 sec
Limit 300000 0,90 sec
Limit 350000 1,06 sec
Limit 400000 1,21 sec
Limit 450000 1,35 sec
Limit 500000 1,50 sec

select tint,tstring, tblob from test LIMIT ?
Limit 50000 0,18 sec
Limit 100000 0,35 sec
Limit 150000 0,51 sec
Limit 200000 0,68 sec
Limit 250000 0,83 sec
Limit 300000 1,00 sec
Limit 350000 1,17 sec
Limit 400000 1,35 sec
Limit 450000 1,48 sec
Limit 500000 1,64 sec

select * from rob1p LIMIT ?
Limit 50000 0,95 sec
Limit 100000 1,88 sec
Limit 150000 2,77 sec
Limit 200000 3,68 sec
Limit 250000 4,57 sec

====================================
server local PostgreSQL-64 client c2d 2GHz

select tint,tstring from "test" LIMIT ?
Limit 50000 0,30 sec
Limit 100000 0,33 sec
Limit 150000 0,40 sec
Limit 200000 0,54 sec
Limit 250000 0,74 sec
Limit 300000 0,85 sec
Limit 350000 0,91 sec
Limit 400000 1,08 sec
Limit 450000 1,19 sec
Limit 500000 1,30 sec

select tint,tstring, tblob from "test" LIMIT ?
Limit 50000 0,21 sec
Limit 100000 0,36 sec
Limit 150000 0,52 sec
Limit 200000 0,70 sec
Limit 250000 0,88 sec
Limit 300000 1,06 sec
Limit 350000 1,21 sec
Limit 400000 1,40 sec
Limit 450000 1,55 sec
Limit 500000 1,71 sec

select * from "ROB1P" LIMIT ?
Limit 50000 2,05 sec
Limit 100000 3,89 sec
Limit 150000 5,84 sec
Limit 200000 7,67 sec
Limit 250000 9,58 sec

====================================
server local FB 2.53-64 client c2d 2GHz

select tint,tstring from "test" ROWS ?
Limit 50000 0,35 sec
Limit 100000 0,71 sec
Limit 150000 1,10 sec
Limit 200000 1,40 sec
Limit 250000 1,73 sec
Limit 300000 2,10 sec
Limit 350000 2,48 sec
Limit 400000 2,78 sec
Limit 450000 3,15 sec
Limit 500000 3,54 sec

select tint,tstring, tblob from "test" ROWS ?
Limit 50000 0,38 sec
Limit 100000 0,76 sec
Limit 150000 1,25 sec
Limit 200000 1,59 sec
Limit 250000 1,85 sec
Limit 300000 2,25 sec
Limit 350000 2,60 sec
Limit 400000 2,96 sec
Limit 450000 3,33 sec
Limit 500000 3,70 sec

select * from ROB1P ROWS ?
Limit 50000 1,34 sec
Limit 100000 2,25 sec
Limit 150000 3,20 sec
Limit 200000 4,40 sec
Limit 250000 5,39 sec

=====================================
server i7-3.5GHz MySQL-32 client c2d 2GHz

select tint,tstring from test LIMIT ?
Limit 50000 0,15 sec
Limit 100000 0,24 sec
Limit 150000 0,35 sec
Limit 200000 0,46 sec
Limit 250000 0,58 sec
Limit 300000 0,69 sec
Limit 350000 0,82 sec
Limit 400000 0,93 sec
Limit 450000 1,03 sec
Limit 500000 1,15 sec

select tint,tstring, tblob from test LIMIT ?
Limit 50000 0,14 sec
Limit 100000 0,27 sec
Limit 150000 0,40 sec
Limit 200000 0,52 sec
Limit 250000 0,66 sec
Limit 300000 0,79 sec
Limit 350000 0,91 sec
Limit 400000 1,04 sec
Limit 450000 1,20 sec
Limit 500000 1,28 sec

select * from rob1p LIMIT ?
Limit 50000 0,96 sec
Limit 100000 1,60 sec
Limit 150000 2,32 sec
Limit 200000 2,95 sec
Limit 250000 3,78 sec

======================================
server i7-3.5GHz FB 2.53-64 client c2d 2GHz

select tint,tstring from "test" ROWS ?
Limit 50000 0,30 sec
Limit 100000 0,58 sec
Limit 150000 0,88 sec
Limit 200000 1,16 sec
Limit 250000 1,46 sec
Limit 300000 1,73 sec
Limit 350000 2,01 sec
Limit 400000 2,30 sec
Limit 450000 2,59 sec
Limit 500000 2,93 sec

select tint,tstring, tblob from "test" ROWS ?
Limit 50000 0,34 sec
Limit 100000 0,67 sec
Limit 150000 0,99 sec
Limit 200000 1,36 sec
Limit 250000 1,67 sec
Limit 300000 2,01 sec
Limit 350000 2,27 sec
Limit 400000 2,70 sec
Limit 450000 2,98 sec
Limit 500000 3,30 sec

select * from ROB1P ROWS ?
Limit 50000 1,11 sec
Limit 100000 2,10 sec
Limit 150000 3,15 sec
Limit 200000 4,24 sec
Limit 250000 5,21 sec

Michal

Posted: **05.11.2013, 22:40**

@EgonHugeist,

A.Bouchez repeated benchmarks but probably not for 7.2.
http://blog.synopse.info/post/2013/11/0 ... ing-MS-SQL

Michl

Posted: **08.11.2013, 20:08**

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R2907:
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.

For me, this error also occurs:
http://sourceforge.net/p/zeoslib/tickets/54/

Michal

Posted: **08.11.2013, 23:53**

@EgonHugeist,

Delphi 2006 - Zeos 7.2.x_r2909:
[Pascal Error] ZEncoding.pas(1335): E2003 Undeclared identifier: 'DetectUTF8Encoding'
[Pascal Fatal Error] ZCompatibility.pas(364): F2063 Could not compile used unit '..\..\src\core\ZEncoding.pas'

DXE2 32/64 -> C++(32) can compile.

Michal

Posted: **09.11.2013, 08:07**

Zeos 7-2 testing and Zeos trunk branches do not compile with fpc 2.6.2. In unit ZFastCode there is this line:

Code: Select all

StrLen := {$IFDEF FPC}System.{$ELSE}SysUtils.{$ENDIF}StrLen;

But StrLen is not found in System.

Posted: **09.11.2013, 12:39**

@miab3

miab3 wrote:Delphi 2006 - Zeos 7.2.x_r2909:
[Pascal Error] ZEncoding.pas(1335): E2003 Undeclared identifier: 'DetectUTF8Encoding'
[Pascal Fatal Error] ZCompatibility.pas(364): F2063 Could not compile used unit '..\..\src\core\ZEncoding.pas'

fixed R2912. Michal i'm playing with the TFields actually. I got faster access by introducing TZ(Wide)StringFields. actually this code is disabled by a define in Zeos.inc: {.$Define WITH_ZSTRINGFIELDS}
These Field-Classes avoid moving mem and allow StringFields > 8128 Chars (e.g. FireBird, PostgreSQL, MySQL, Sqlite, Oracle) which was limited by the IDE-Fields.
added published property "EmtyStringAsNull".

BUT using them would break the current applications if there are TFields assigned to the formulars or datamoduls. IBX using such owned fields too. I could add a Check like TField(AField) id TZ()Field. But IMO isn't it what i want.
That's why they are undefined currently.
Going this route makes also TArrayFields, TDataSetFields etc. possible for FPC (Delphi supports it since D4) and some more properties like the newer IDE's do support them.

What do you think about it?

@Zoran

lorbs, what's that? It compiles well on my FPC2.6.2 LCL see attachment. Which environmet do you use? Did you compile ZCore.lpk first?

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