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
