Submitted by: @ibprovider

Attachments:
2015_10_30__fbbug4983.7z
2015_10_30__fbbug4983__v02.7z

[Stack]

> fb_inet_server.exe!EXE_unwind(Jrd::thread_db * tdbb, Jrd::jrd_req * request) Line 1080 C++
fb_inet_server.exe!JRD_start(Jrd::thread_db * tdbb, Jrd::jrd_req * request, Jrd::jrd_tra * transaction, short level) Line 7005 C++
fb_inet_server.exe!execute_request(Jrd::thread_db * tdbb, Jrd::dsql_req * request, Jrd::jrd_tra * * tra_handle, unsigned short in_blr_length, const unsigned char * in_blr, unsigned short in_msg_length, const unsigned char * in_msg, unsigned short out_blr_length, unsigned char * out_blr, unsigned short out_msg_length, unsigned char * out_msg, bool singleton) Line 1271 C++
fb_inet_server.exe!DSQL_execute(Jrd::thread_db * tdbb, Jrd::jrd_tra * * tra_handle, Jrd::dsql_req * request, unsigned short in_blr_length, const unsigned char * in_blr, unsigned short in_msg_type, unsigned short in_msg_length, const unsigned char * in_msg, unsigned short out_blr_length, unsigned char * out_blr, unsigned short out_msg_length, unsigned char * out_msg) Line 273 C++
fb_inet_server.exe!jrd8_execute(__int64 * user_status, Jrd::jrd_tra * * tra_handle, Jrd::dsql_req * * stmt_handle, unsigned short in_blr_length, const char * in_blr, unsigned short in_msg_type, unsigned short in_msg_length, const char * in_msg, unsigned short out_blr_length, char * out_blr, unsigned short __formal, unsigned short out_msg_length, char * out_msg) Line 4045 C++
fb_inet_server.exe!isc_dsql_execute2_m(__int64 * user_status, unsigned int * tra_handle, unsigned int * stmt_handle, unsigned short in_blr_length, const char * in_blr, unsigned short in_msg_type, unsigned short in_msg_length, char * in_msg, unsigned short out_blr_length, char * out_blr, unsigned short out_msg_type, unsigned short out_msg_length, char * out_msg) Line 2725 C++
fb_inet_server.exe!rem_port::execute_statement(P_OP op, p_sqldata * sqldata, packet * sendL) Line 2328 C++
fb_inet_server.exe!process_packet(rem_port * port, packet * sendL, packet * receive, rem_port * * result) Line 3531 C++
fb_inet_server.exe!loopThread(void * __formal) Line 5260 C++

[Local variables]

+ tdbb 0x000000000487f1c0 {tdbb_default=0x00000000052e9ff0 {parent_redirect=false freeBlocks={pool=0x00000000052e9ff0 {...} ...} ...} ...} Jrd::thread_db *
+ request 0x0000000000000000 <NULL> Jrd::jrd_req *

Commits: 150896f ec6d38e e22cca3 FirebirdSQL/fbt-repository@1033697 FirebirdSQL/fbt-repository@ec40c06 FirebirdSQL/fbt-repository@06b1423

====== Test Details ======

Seems that non-prepared statement can not be issued by python.

Any suggestion from guru in fdb will be appreciated.
Following python code:

import fdb

conn = fdb.connect(dsn='localhost/3333:e30', user='SYSDBA', password='masterke')
conn.begin()
conn.execute_immediate("update test set x = -x")
conn.commit()

-- *does* prepare statement as it can be seen in trace.

But according to fdb doc ( http://www.firebirdsql.org/file/documentation/drivers_documentation/python/fdb/reference.html#connection ) class Connection has method execute_immediate which "Executes a statement in context of main_transaction without caching its prepared form".

So, I'm interesting: is it possible to send unprepared statement to FB using Python or no (and if yes, then how can it be done) ?