Menu

#427 Some statment stucks with EXECUTE DIRECT

1.3 Dev Q
open
nobody
6
2013-12-02
2013-06-06
No

The following satement stucks. It used to work at 1.0.x.
Running this with direct connection to a datanode works correctly.

EXECUTE DIRECT ON (someDataNode) $$
SELECT
count(*)
FROM
(SELECT * FROM pg_locks l LEFT JOIN
(SELECT * FROM pg_stat_activity) s ON l.database = s.datid) a
$$

Discussion

  • Koichi Suzuki

    Koichi Suzuki - 2013-06-11
    • milestone: 2663467 --> 1,2 Dev Q
     
  • Koichi Suzuki

    Koichi Suzuki - 2013-12-02

    Test this with 1.2.

     
  • Koichi Suzuki

    Koichi Suzuki - 2013-12-02
    • Group: 1.2 Dev Q --> 1.3 Dev Q
     

Log in to post a comment.