bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.34k stars 148 forks source link

ROW_COUNT expected to show # of created/updated rows #650

Open jshen-noetic opened 4 months ago

jshen-noetic commented 4 months ago

ROW_COUNT reports the number of updated or created rows in a plpgsql block, but seems not to work with any Agensgraph DML.

test=*# DO $$
DECLARE
    dummy INTEGER;
BEGIN
    CREATE (m {"name": 'M1'});

    GET DIAGNOSTICS dummy = ROW_COUNT;

    RAISE NOTICE 'Number of rows created: %', dummy;
END;
$$;
NOTICE:  Number of rows created: 0
DO