1 2 3 4 5 6 7 8 9 10 |
set @barrier_name= "dangling_barrier"; SELECT create_barrier(@barrier_name); create_barrier(@barrier_name) 1 SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME; USER_BARRIER_NAME dangling_barrier SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO") from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@barrier_name; if ((SESSION_ID = CONNECTION_ID()), "YES", "NO") YES |