RE: Is PREPARE of ecpglib thread safe?

Horiguchi-san, Kuroda-san

> Horiguchi-san wrote:
> > A namespace of declared statement is not connection independent.
> > Therefore, we must manage the namespce in global and consider about race condition.
>
> Right, and but thread independent.

I was wrong. I understand that DECLARE STATEMENT should be same policy as the combination of PREPARE STATEMENT and SET CONNECTION.
We should fix the current implementation of DECLARE STATEMENT.

Current:
t1:Thread1: exec sql at conn1 declare st1 statement;
t2:Thread2: exec sql at conn2 declare st1 statement; // NG

ToBe:
t1:Thread1: exec sql at conn1 declare st1 statement;
t2:Thread2: exec sql at conn2 declare st1 statement; // OK
t3:Thread2: exec sql prepared st1 from "select 1"; // OK: prepared on conn2
t4:Thread1: exec sql execute st1; // NG: not prepared
t5:Thread2: exec sql execute st1; // OK: executed on conn2

t1:Thread1: exec sql at conn1 declare st1 statement;
t2:Thread1: exec sql at conn2 declare st1 statement; // NG

Regards
Ryo Matsumura