Re: [Firebird-devel] Start transaction from base transaction
> The trick words is how to shortly tell this "the snapshot used to start > transaction ". > > And it's even more trick when we think about commit retaining. > > My understand is that if transaction had a commit retaining, subsequent > new derived transactions will use the snapshot after the commit retaining in > . > > However, a already established derived transaction from will ignore > subsequent commit retaining done in . IMO, nothing says that we need to support all transaction 'modes' with this feature -- nor should we. Sean -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Fwd: SF.net SVN: firebird:[63716] qa/fbt-repository/trunk/tests/functional/ basic/db/db_30.fbt
Alex, Pavel, Isn't this misleading? Seems these RDB$TYPES entries should be DECLFLOAT, not DECIMAL. Adriano PS: I still do not receive Alex responses. :( Forwarded Message Subject:[Firebird-checkins] SF.net SVN: firebird:[63716] qa/fbt-repository/trunk/tests/functional/ basic/db/db_30.fbt Date: Mon, 08 May 2017 07:44:21 + From: tabl...@users.sourceforge.net To: firebird-check...@lists.sourceforge.net Revision: 63716 http://sourceforge.net/p/firebird/code/63716 Author: tabloid Date: 2017-05-08 07:44:21 + (Mon, 08 May 2017) Log Message: --- Adjusted output to current FB 4.0 version. Modified Paths: -- qa/fbt-repository/trunk/tests/functional/basic/db/db_30.fbt Modified: qa/fbt-repository/trunk/tests/functional/basic/db/db_30.fbt === --- qa/fbt-repository/trunk/tests/functional/basic/db/db_30.fbt 2017-04-07 10:20:10 UTC (rev 63715) +++ qa/fbt-repository/trunk/tests/functional/basic/db/db_30.fbt 2017-05-08 07:44:21 UTC (rev 63716) @@ -3910,6 +3910,18 @@ RDB$SYSTEM_FLAG 1 RDB$FIELD_NAME RDB$FIELD_TYPE +RDB$TYPE24 +RDB$TYPE_NAME DECIMAL(16) +RDB$DESCRIPTION +RDB$SYSTEM_FLAG 1 + +RDB$FIELD_NAME RDB$FIELD_TYPE +RDB$TYPE25 +RDB$TYPE_NAME DECIMAL(34) +RDB$DESCRIPTION +RDB$SYSTEM_FLAG 1 + +RDB$FIELD_NAME RDB$FIELD_TYPE RDB$TYPE27 RDB$TYPE_NAME DOUBLE RDB$DESCRIPTION @@ -4641,8 +4653,7 @@ RDB$DESCRIPTION RDB$SYSTEM_FLAG 1 - -Records affected: 277 +Records affected: 279 """ } ] This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-checkins mailing list firebird-check...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-checkins -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Start transaction from base transaction
On 10/05/2017 16:01, Leyne, Sean wrote: >> "Starting from"? > That would be misleading, the connection would not be able to see commits > from later transactions, which is certainly not the case. > > The trick words is how to shortly tell this "the snapshot used to start transaction ". And it's even more trick when we think about commit retaining. My understand is that if transaction had a commit retaining, subsequent new derived transactions will use the snapshot after the commit retaining in . However, a already established derived transaction from will ignore subsequent commit retaining done in . Adriano -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Object types in RDB$TYPES vs. obj.h
On 05/11/17 15:06, Jiří Činčura wrote: > Hi *, > > getting all object types from RDB$TYPES in Firebird 3.0.2 gives me 0-19 > values. But in obj.h I see > . > Why the 20-32 isn't there? > Because that's not real objects - they just need to be in same digits space to ensure correct operation of GRANT/REVOKE operators providing access to pe r-type of object rights (like GRANT CREATE TABLE ). -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Object types in RDB$TYPES vs. obj.h
Hi *, getting all object types from RDB$TYPES in Firebird 3.0.2 gives me 0-19 values. But in obj.h I see const int obj_relation = 0; const int obj_view = 1; const int obj_trigger = 2; const int obj_computed = 3; const int obj_validation= 4; const int obj_procedure = 5; const int obj_expression_index = 6; const int obj_exception = 7; const int obj_user = 8; const int obj_field = 9; const int obj_index = 10; const int obj_charset = 11; const int obj_user_group= 12; const int obj_sql_role = 13; const int obj_generator = 14; const int obj_udf = 15; const int obj_blob_filter = 16; const int obj_collation = 17; const int obj_package_header= 18; const int obj_package_body = 19; // objects types for ddl operations const int obj_database = 20; const int obj_relations = 21; const int obj_views = 22; const int obj_procedures= 23; const int obj_functions = 24; const int obj_packages = 25; const int obj_generators= 26; const int obj_domains = 27; const int obj_exceptions= 28; const int obj_roles = 29; const int obj_charsets = 30; const int obj_collations= 31; const int obj_filters = 32; const int obj_type_MAX = 33; // keep this last! // used in the parser only / no relation with obj_type_MAX const int obj_user_or_role = 34; const int obj_schema= 35; const int obj_parameter = 36; Why the 20-32 isn't there? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5535) Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function
Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function - Key: CORE-5535 URL: http://tracker.firebirdsql.org/browse/CORE-5535 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.2 Environment: Win10 CU x64, FB x64 Reporter: Jiri Cincura Altering the function to same function changes the RDB$FIELD_SUB_TYPE to garbage value. Here's repro: $ .\isql.exe Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'localhost:test' user 'SYSDBA' password 'masterkey'; SQL> create function test (i int) returns int as begin end; SQL> commit; SQL> select rdb$field_sub_type from rdb$function_arguments; RDB$FIELD_SUB_TYPE == 0 0 SQL> create or alter function test (i int) returns int as begin end; SQL> commit; SQL> select rdb$field_sub_type from rdb$function_arguments; RDB$FIELD_SUB_TYPE == 17490 17490 SQL> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
