firebird-checkins Mailing List for Firebird

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: feeea1b51aee0aa107198c674078f1366130aa67
      https://github.com/FirebirdSQL/firebird/commit/feeea1b51aee0aa107198c674078f1366130aa67
  Author: hvlad <hv...@us...>
  Date:   2017-01-31 (Tue, 31 Jan 2017)

  Changed paths:
    M src/auth/trusted/AuthSspi.h

  Log Message:
  -----------
  Fixed Windows build. Alex, please check

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 4da3997b49c8ee3e9196e315d26f90090edafff9
      https://github.com/FirebirdSQL/firebird/commit/4da3997b49c8ee3e9196e315d26f90090edafff9
  Author: AlexPeshkoff <pes...@ma...>
  Date:   2017-01-31 (Tue, 31 Jan 2017)

  Changed paths:
    M builds/install/misc/firebird.conf.in
    M doc/Using_OO_API.html
    M examples/dbcrypt/CryptApplication.cpp
    M examples/dbcrypt/CryptKeyHolder.cpp
    M examples/dbcrypt/DbCrypt.cpp
    M src/auth/AuthDbg.cpp
    M src/auth/AuthDbg.h
    M src/auth/SecureRemotePassword/server/SrpServer.cpp
    M src/auth/SecurityDatabase/LegacyServer.cpp
    M src/common/classes/GetPlugins.h
    M src/common/classes/RefCounted.h
    M src/common/config/config.cpp
    M src/common/config/config.h
    M src/common/db_alias.cpp
    M src/common/db_alias.h
    M src/common/security.cpp
    M src/common/security.h
    M src/include/fb_api_proto.h
    M src/include/firebird/FirebirdInterface.idl
    M src/include/firebird/IdlFbInterfaces.h
    M src/jrd/CryptoManager.cpp
    M src/jrd/CryptoManager.h
    M src/jrd/Database.h
    M src/jrd/event.cpp
    M src/jrd/event_proto.h
    M src/jrd/ext.cpp
    M src/jrd/extds/IscDS.cpp
    M src/jrd/extds/IscDS.h
    M src/jrd/extds/ValidatePassword.cpp
    M src/jrd/jrd.cpp
    M src/jrd/svc.cpp
    M src/jrd/trace/TraceManager.cpp
    M src/lock/lock.cpp
    M src/lock/lock_proto.h
    M src/remote/client/interface.cpp
    M src/remote/inet.cpp
    M src/remote/inet_proto.h
    M src/remote/os/win32/wnet.cpp
    M src/remote/os/win32/wnet_proto.h
    M src/remote/os/win32/xnet.cpp
    M src/remote/os/win32/xnet_proto.h
    M src/remote/protocol.cpp
    M src/remote/protocol.h
    M src/remote/remot_proto.h
    M src/remote/remote.cpp
    M src/remote/remote.h
    M src/remote/server/os/posix/inet_server.cpp
    M src/remote/server/server.cpp
    M src/utilities/gsec/gsec.cpp
    M src/yvalve/PluginManager.cpp
    M src/yvalve/why.cpp

  Log Message:
  -----------
  Fixed CORE-5472: Problems with dbcrypt key transfer

Revision: 63669
          http://sourceforge.net/p/firebird/code/63669
Author:   tabloid
Date:     2017-01-31 07:31:03 +0000 (Tue, 31 Jan 2017)
Log Message:
-----------
See added / modified .fbt file(s)

Added Paths:
-----------
    qa/fbt-repository/trunk/tests/bugs/core_5434.fbt

Added: qa/fbt-repository/trunk/tests/bugs/core_5434.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_5434.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_5434.fbt	2017-01-31 07:31:03 UTC (rev 63669)
@@ -0,0 +1,132 @@
+{
+'id': 'bugs.core_5434',
+'qmid': None,
+'tracker_id': 'CORE-5434',
+'title': "Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change",
+'description': 
+ """
+   If current FB arch is SuperServer then we:
+       1. We make 'snapshot' of mon$io_stats.mon$page_writes value before test and then launch plently transactions (e.g, 50) 
+          in READ-ONLY mode. All of them then are immediately committed, w/o any actions.
+       2. After this we take 2nd 'snapshot' of mon$io_stats.mon$page_writes and compare it with 1st one.
+       3. Difference of 'mon$page_writes' values should be 1 (One).
+   Otherwise (SC/CS) we defer checking because improvement currently not implemented for these modes.
+
+   Checked on:
+   1) WI-T4.0.0.463, WI-V3.0.2.32670 - room for improvement DOES exist: page_diff = 102 pages
+   2) WI-T4.0.0.511, WI-V3.0.2.32676 - all OK, page_diff = 1 (One).
+ """,
+'min_versions': '3.0.2',
+'versions': [
+{
+ 'firebird_version': '3.0',
+ 'platform': 'All',
+ 'test_type': 'Python',
+ 'init_script':
+  """
+  """,
+ 'test_script':
+  """
+import os
+import sys
+os.environ["ISC_USER"] = user_name
+os.environ["ISC_PASSWORD"] = user_password
+
+def get_fb_arch(a_dsn):
+   try:
+      con1 = fdb.connect(dsn = a_dsn)
+      con2 = fdb.connect(dsn = a_dsn)
+
+      cur1 = con1.cursor()
+
+      sql=(
+             "select count(distinct a.mon$server_pid), min(a.mon$remote_protocol), max(iif(a.mon$remote_protocol is null,1,0))"
+            +" from mon$attachments a"
+            +" where a.mon$attachment_id in (%s, %s) or upper(a.mon$user) = upper('%s')"
+            % (con1.attachment_id, con2.attachment_id, 'cache writer')
+          )
+
+      cur1.execute(sql)
+      for r in cur1.fetchall():
+          server_cnt=r[0]
+          server_pro=r[1]
+          cache_wrtr=r[2]
+
+      if server_pro == None:
+          fba='Embedded'
+      elif cache_wrtr == 1:
+          fba='SS'
+      elif server_cnt == 2:
+          fba='CS'
+      else:
+
+          f1=con1.db_info(fdb.isc_info_fetches)
+          
+          cur2=con2.cursor()
+          cur2.execute('select 1 from rdb$database')
+          for r in cur2.fetchall():
+             pass
+
+          f2=con1.db_info(fdb.isc_info_fetches)
+
+          fba = 'SC' if f1 ==f2 else 'SS'
+
+      #print(fba, con1.engine_version, con1.version)
+      return fba
+
+   finally:
+      con1.close()
+      con2.close()
+
+fb_arch=get_fb_arch(dsn)
+
+if fb_arch == 'SS':
+
+    txParams = ( [ fdb.isc_tpb_read ] )
+    c2 = fdb.connect(dsn=dsn)
+
+    sql='select mon$page_writes from mon$io_stats where mon$stat_group=0'
+    cur=db_conn.cursor()
+
+    cur.execute(sql)
+    for r in cur:
+      page_writes_before_test = r[0]
+    db_conn.commit()
+
+    ta=[]
+    for i in range(0, 50):
+       ta.append( c2.trans( default_tpb = txParams ) )
+       ta[i].begin()
+
+    for i in range(0,len(ta)):
+       ta[i].rollback()
+
+
+    cur.execute(sql)
+    for r in cur:
+      page_writes_after_test = r[0]
+
+    pw_diff = page_writes_after_test - page_writes_before_test
+
+    db_conn.commit()
+    c2.close()
+
+    msg = 'Acceptable' if pw_diff == 1 else ('Too big value of page_writes diff: %s' % ( pw_diff ))
+else:
+    # FB works NOT in SuperServer. This currently must be SKIPPED from checking (see notes in the ticket).
+    msg = 'Deferred: fb_arch=%s' % fb_arch
+
+print(msg)
+
+  """,
+ 'expected_stdout': 
+  """
+    Acceptable
+  """,
+ 'expected_stderr': 
+  """
+  """,
+  'substitutions':[ ( 'Deferred: fb_arch=.*', 'Acceptable')]
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_5434.fbt
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 7fadd8e9f98c3b34723616fd4b0ba7bfcbcf16b1
      https://github.com/FirebirdSQL/firebird/commit/7fadd8e9f98c3b34723616fd4b0ba7bfcbcf16b1
  Author: Adriano dos Santos Fernandes <adr...@gm...>
  Date:   2017-01-30 (Mon, 30 Jan 2017)

  Changed paths:
    M builds/posix/make.shared.targets

  Log Message:
  -----------
  Make parse.y not build in every make call.

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: f8029760461a909745e7b9fc91c5ccc15dbdce89
      https://github.com/FirebirdSQL/firebird/commit/f8029760461a909745e7b9fc91c5ccc15dbdce89
  Author: Adriano dos Santos Fernandes <adr...@gm...>
  Date:   2017-01-30 (Mon, 30 Jan 2017)

  Changed paths:
    M src/dsql/parse.y

  Log Message:
  -----------
  Revert regression that disallows "CHARACTER SET BINARY" usage.

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: d23c7c1156dfcb6f262b4e03917d9c83a8c04765
      https://github.com/FirebirdSQL/firebird/commit/d23c7c1156dfcb6f262b4e03917d9c83a8c04765
  Author: Adriano dos Santos Fernandes <adr...@gm...>
  Date:   2017-01-30 (Mon, 30 Jan 2017)

  Changed paths:
    M src/jrd/scl.epp
    M src/jrd/scl.h
    M src/jrd/validation.cpp

  Log Message:
  -----------
  Misc.

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 7a83352a1da1c4513dec62ee8b0e4b701913260f
      https://github.com/FirebirdSQL/firebird/commit/7a83352a1da1c4513dec62ee8b0e4b701913260f
  Author: firebirds <>
  Date:   2017-01-31 (Tue, 31 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 0cb101c0859f8584a77ba3460fce04f56948fa1b
      https://github.com/FirebirdSQL/firebird/commit/0cb101c0859f8584a77ba3460fce04f56948fa1b
  Author: Michal Kubeček <mku...@su...>
  Date:   2017-01-30 (Mon, 30 Jan 2017)

  Changed paths:
    M builds/posix/prefix.linux
    M builds/posix/prefix.linux_amd64

  Log Message:
  -----------
  Do not enforce -std=c+11 on Linux. (#77)

Commit 52d9a05a0f3d ("Backport from master: Optimized hash function for
lock manager and hash join") adds "-std=c++11" to CXXFLAGS on Linux
unconditionally. This doesn't seem to be necessary (looks rather like an
omission) and breaks the build on distributions with old gcc versions
(e.g. SLES 11 SP4).

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: ae5d1b20cebb1dcc36b058433e56f6b1f68905a5
      https://github.com/FirebirdSQL/firebird/commit/ae5d1b20cebb1dcc36b058433e56f6b1f68905a5
  Author: firebirds <>
  Date:   2017-01-30 (Mon, 30 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: c8956bd1aeb8e7efb959282262f725a3c67c48b8
      https://github.com/FirebirdSQL/firebird/commit/c8956bd1aeb8e7efb959282262f725a3c67c48b8
  Author: hvlad <hv...@us...>
  Date:   2017-01-30 (Mon, 30 Jan 2017)

  Changed paths:
    M src/jrd/scl.epp
    M src/jrd/scl.h

  Log Message:
  -----------
  Fixed regression: performance penalty when check access rights of user with super privileges granted (such as SYSDBA, DBO, etc)

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 079dafd348cb533916c754de0227a8879c5a1a4b
      https://github.com/FirebirdSQL/firebird/commit/079dafd348cb533916c754de0227a8879c5a1a4b
  Author: firebirds <>
  Date:   2017-01-29 (Sun, 29 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 1deb7fb8b515cda5f74230125335c957740c8584
      https://github.com/FirebirdSQL/firebird/commit/1deb7fb8b515cda5f74230125335c957740c8584
  Author: firebirds <>
  Date:   2017-01-29 (Sun, 29 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 36b86a02e5df20d82855fe1af00bac27022bbf8e
      https://github.com/FirebirdSQL/firebird/commit/36b86a02e5df20d82855fe1af00bac27022bbf8e
  Author: Dmitry Yemanov <dye...@us...>
  Date:   2017-01-28 (Sat, 28 Jan 2017)

  Changed paths:
    M src/jrd/RecordSourceNodes.cpp

  Log Message:
  -----------
  Preserve the alias after the relation/procedure node copying

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: cbe9ac071f187e7766c2a67fdf47683604361059
      https://github.com/FirebirdSQL/firebird/commit/cbe9ac071f187e7766c2a67fdf47683604361059
  Author: Dmitry Yemanov <dye...@us...>
  Date:   2017-01-28 (Sat, 28 Jan 2017)

  Changed paths:
    M src/jrd/RecordSourceNodes.cpp

  Log Message:
  -----------
  Preserve the alias after the relation/procedure node copying

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 1d5ec591f6128503c739883ab00164ef4f32d82c
      https://github.com/FirebirdSQL/firebird/commit/1d5ec591f6128503c739883ab00164ef4f32d82c
  Author: firebirds <>
  Date:   2017-01-28 (Sat, 28 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 2226c6f7a4f503df952da912dad467a55e52252e
      https://github.com/FirebirdSQL/firebird/commit/2226c6f7a4f503df952da912dad467a55e52252e
  Author: firebirds <>
  Date:   2017-01-28 (Sat, 28 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/core-5419
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 2d2679485c3c8913ebf6d358f55510cf635a79e4
      https://github.com/FirebirdSQL/firebird/commit/2d2679485c3c8913ebf6d358f55510cf635a79e4
  Author: hvlad <hv...@us...>
  Date:   2017-01-27 (Fri, 27 Jan 2017)

  Changed paths:
    M src/jrd/Database.h
    M src/jrd/jrd.cpp

  Log Message:
  -----------
  This should fix bug CORE-5419 : Index garbage collection on varchar column causes server to hang

  Branch: refs/heads/core-5419
  Home:   https://github.com/FirebirdSQL/firebird

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 2cb8c9cffedd11087d47cb6232a6802cd7167e3e
      https://github.com/FirebirdSQL/firebird/commit/2cb8c9cffedd11087d47cb6232a6802cd7167e3e
  Author: Dmitry Yemanov <dye...@us...>
  Date:   2017-01-27 (Fri, 27 Jan 2017)

  Changed paths:
    M src/jrd/RecordSourceNodes.cpp

  Log Message:
  -----------
  Reworked bugfix for CORE-5456. Now it addresses CORE-5457 as well.

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 37e2aa350bb4a293f2899c52ac165cc267731338
      https://github.com/FirebirdSQL/firebird/commit/37e2aa350bb4a293f2899c52ac165cc267731338
  Author: Dmitry Yemanov <dye...@us...>
  Date:   2017-01-27 (Fri, 27 Jan 2017)

  Changed paths:
    M src/jrd/RecordSourceNodes.cpp

  Log Message:
  -----------
  Reworked bugfix for CORE-5456. Now it addresses CORE-5457 as well.

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: d8f0968ae6629499d72798efb13d5fd53ed8429d
      https://github.com/FirebirdSQL/firebird/commit/d8f0968ae6629499d72798efb13d5fd53ed8429d
  Author: firebirds <>
  Date:   2017-01-26 (Thu, 26 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/B3_0_Release
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: a051c78dd1b7c8d1e7153a42e5e5e814386e4ed5
      https://github.com/FirebirdSQL/firebird/commit/a051c78dd1b7c8d1e7153a42e5e5e814386e4ed5
  Author: hvlad <hv...@us...>
  Date:   2017-01-25 (Wed, 25 Jan 2017)

  Changed paths:
    M src/jrd/tra.cpp

  Log Message:
  -----------
  Improvement CORE-5434 : Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change

Revision: 63668
          http://sourceforge.net/p/firebird/code/63668
Author:   tabloid
Date:     2017-01-24 22:10:26 +0000 (Tue, 24 Jan 2017)
Log Message:
-----------
See added / modified .fbt file(s)

Added Paths:
-----------
    qa/fbt-repository/trunk/tests/bugs/core_3073.fbt

Added: qa/fbt-repository/trunk/tests/bugs/core_3073.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_3073.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_3073.fbt	2017-01-24 22:10:26 UTC (rev 63668)
@@ -0,0 +1,75 @@
+{
+'id': 'bugs.core_3073',
+'qmid': None,
+'tracker_id': 'CORE-3073',
+'title': 'Foreign key cascade with SET DEFAULT uses the default value of the moment of the FK creation',
+'description':
+ """
+    Confirmed bug on WI-T4.0.0.503.
+    Checked on WI-T4.0.0.511 - works fine.
+ """,
+'min_versions': '4.0',
+'versions': [
+{
+ 'firebird_version': '4.0',
+ 'platform': 'All',
+ 'init_script':
+  """
+  """,
+ 'test_type': 'ISQL',
+ 'test_script': 
+  """
+    recreate table tdetl(x int);
+    recreate table tmain(x int);
+    commit;
+    set term ^;
+    execute block as
+    begin
+      execute statement 'drop domain dm_name';
+      when any do begin end
+    end
+    ^
+    set term ;^
+    commit;
+
+    create domain dm_name varchar(15) default 'Old Trafford';
+    commit;
+
+    recreate table tmain(name dm_name primary key);
+    recreate table tdetl(name dm_name references tmain on delete set default);
+    commit;
+
+    alter domain dm_name set default 'New Vasyuki';
+    commit;
+
+    insert into tmain values('London');
+    insert into tmain values('Old Trafford');
+    insert into tmain values('New Vasyuki');
+
+    insert into tdetl values('London');
+    insert into tdetl values('Old Trafford');
+
+    set list on;
+
+    select 'before cascade on tdetl' as msg, d.* from tdetl d;
+    delete from tmain where name = 'London';
+    select 'after cascade on tdetl' as msg, d.* from tdetl d;
+  """,
+  'expected_stdout':
+  """
+    MSG                             before cascade on tdetl
+    NAME                            London
+    MSG                             before cascade on tdetl
+    NAME                            Old Trafford
+
+    MSG                             after cascade on tdetl
+    NAME                            New Vasyuki
+    MSG                             after cascade on tdetl
+    NAME                            Old Trafford
+  """,
+  'expected_stderr':
+  """
+  """
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_3073.fbt
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 8a2bc74159d4f19b903fd7c1c5856831617eca10
      https://github.com/FirebirdSQL/firebird/commit/8a2bc74159d4f19b903fd7c1c5856831617eca10
  Author: firebirds <>
  Date:   2017-01-24 (Tue, 24 Jan 2017)

  Changed paths:
    M src/jrd/build_no.h
    M src/misc/writeBuildNum.sh

  Log Message:
  -----------
  increment build number

  Branch: refs/heads/master
  Home:   https://github.com/FirebirdSQL/firebird
  Commit: 7f41b58b9855f61c11555e71eb5ebdb1ff2c1455
      https://github.com/FirebirdSQL/firebird/commit/7f41b58b9855f61c11555e71eb5ebdb1ff2c1455
  Author: Dmitry Yemanov <dye...@us...>
  Date:   2017-01-23 (Mon, 23 Jan 2017)

  Changed paths:
    M src/jrd/opt.cpp

  Log Message:
  -----------
  Fixed the regression I introduced 22-Jul-2016.