[Firebird-devel] [FB-Tracker] Created: (CORE-5633) Recalculating computed fields that depend on altering field

2017-10-09 Thread Vasiliy Yashkov (JIRA) 
Recalculating computed fields that depend on altering field
---

 Key: CORE-5633
 URL: http://tracker.firebirdsql.org/browse/CORE-5633
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0
 Environment: Ubuntu 17.04 x86_64 Linux 4.10
Reporter: Vasiliy Yashkov


When field is altered, a computed fields, that depend on it, don't altered.
Example:
create table test(f1 varchar(6));
commit;
create table test1(f1 integer, f2 computed by((select first 1 f1 from test)));
commit;
create view v1 as select f1 from test;
commit;
alter table test alter column f1 type varchar(8);
commit;
insert into test(f1) values('qwertyqw');
commit;
insert into test1(f1) values(1);
commit;
select * from test1; --arithmetic exception, numeric overflow, or string 
truncation

-- 
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

[Firebird-devel] [FB-Tracker] Created: (CORE-5632) SuperServer FB3 has entered in infinite loop (hang up)

2017-10-09 Thread Kovalenko Dmitry (JIRA) 
SuperServer FB3 has entered in infinite loop (hang up)
--

 Key: CORE-5632
 URL: http://tracker.firebirdsql.org/browse/CORE-5632
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.3
 Environment: Windows 10 Pro x64, 6950x/128GB, FB3 SuperServer x64, 
IBProvider Test System.
Reporter: Kovalenko Dmitry


- Firebird 3.0.3.32802 x64 (SuperServer)
- Connection through TCP/IP (localhost)

Server has entered in infinite loop(?) in one own thread (ID: 24436)

I waited 24 hours.

At client side (multithreaded test system) all test threads wait the answer 
from server:
 - 1 thread wait answer for COMMIT_TR
 - 3 threads wait answers for START_TR
 - 7 threads wait answers for DETACH_DB

Sources, dumps, binaries ...: http://dropmefiles.com/h0au4  (valid within 14 
days)

Stack of thread with infinite loop (24436)
>   engine12.dll!Jrd::LockManager::find_lock(unsigned short series, const 
> unsigned char * value, unsigned short length, unsigned short * slot) Line 
> 2129C++ Symbols loaded.
engine12.dll!Jrd::LockManager::enqueue(Jrd::thread_db * tdbb, 
Firebird::CheckStatusWrapper * statusVector, long prior_request, const unsigned 
short series, const unsigned char * value, const unsigned short length, 
unsigned char type, int(*)(void *) ast_routine, void * ast_argument, __int64 
data, short lck_wait, long owner_offset) Line 581C++ Symbols loaded.
engine12.dll!enqueue(Jrd::thread_db * tdbb, 
Firebird::CheckStatusWrapper * statusVector, Jrd::Lock * lock, unsigned short 
level, short wait) Line 934   C++ Symbols loaded.
[Inline Frame] engine12.dll!ENQUEUE(Jrd::thread_db *) Line 149  C++ 
Symbols loaded.
engine12.dll!LCK_lock(Jrd::thread_db * tdbb, Jrd::Lock * lock, unsigned 
short level, short wait) Line 663   C++ Symbols loaded.
engine12.dll!transaction_start(Jrd::thread_db * tdbb, Jrd::jrd_tra * 
trans) Line 3259   C++ Symbols loaded.
engine12.dll!TRA_start(Jrd::thread_db * tdbb, int tpb_length, const 
unsigned char * tpb, Jrd::jrd_tra * outer) Line 1715C++ Symbols 
loaded.
engine12.dll!start_transaction(Jrd::thread_db * tdbb, bool 
transliterate, Jrd::jrd_tra * * tra_handle, Jrd::Attachment * attachment, 
unsigned int tpb_length, const unsigned char * tpb) Line 7848  C++ 
Symbols loaded.

engine12.dll!Jrd::JAttachment::startTransaction(Firebird::CheckStatusWrapper * 
user_status, unsigned int tpbLength, const unsigned char * tpb) Line 4195   
 C++ Symbols loaded.

engine12.dll!Firebird::IAttachmentBaseImpl > > >::cloopstartTransactionDispatcher(Firebird::IAttachment * self, 
Firebird::IStatus * status, unsigned int tpbLength, const unsigned char * tpb) 
Line 8654C++ Symbols loaded.
[Inline Frame] 
fbclient.dll!Firebird::IAttachment::startTransaction(Firebird::CheckStatusWrapper
 *) Line 1827   C++ Symbols loaded.

fbclient.dll!Why::YAttachment::startTransaction(Firebird::CheckStatusWrapper * 
status, unsigned int tpbLength, const unsigned char * tpb) Line 5070 C++
 Symbols loaded.

fbclient.dll!Firebird::IAttachmentBaseImpl > > >::cloopstartTransactionDispatcher(Firebird::IAttachment * self, 
Firebird::IStatus * status, unsigned int tpbLength, const unsigned char * tpb) 
Line 8654C++ Symbols loaded.
[Inline Frame] 
firebird.exe!Firebird::IAttachment::startTransaction(Firebird::CheckStatusWrapper
 *) Line 1827   C++ Symbols loaded.
firebird.exe!rem_port::start_transaction(P_OP operation, p_sttr * 
stuff, packet * sendL) Line 5849  C++ Symbols loaded.
firebird.exe!process_packet(rem_port * port, packet * sendL, packet * 
receive, rem_port * * result) Line 4398   C++ Symbols loaded.
firebird.exe!loopThread(void * __formal) Line 5954  C++ Symbols 
loaded.
[Inline Frame] firebird.exe!`anonymous-namespace'::ThreadArgs::run() 
Line 78C++ Symbols loaded.
firebird.exe!threadStart(void * arg) Line 93C++ Symbols loaded.


-- 
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