wen-bing opened a new issue, #1982:
URL: https://github.com/apache/age/issues/1982

   **Describe the bug**
   load_labels_from_file produced duplicated graphId
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   - psql
   
   **What data setup do we need to do?**
   ```pgsql
   SELECT * FROM ag_catalog.create_graph('graph1');
   SELECT create_vlabel('graph1', 'Person');
   ----------
   1.first time import person.csv,which contains:
   name,age
   AAA,12
   BBB,32,
   CCC,33
   select load_labels_from_file('graph1', 'Person', 
'/home/postgres/ws/testdata/person.csv', false);
   
   select * from cypher ('graph1', $$
   Match(v)
   return v
    $$) as (v agtype);
                                                         v
   
-------------------------------------------------------------------------------------------------------------
    {"id": 844424930131969, "label": "Person", "properties": {"age": "12", 
"name": "AAA", "__id__": 1}}::vertex
    {"id": 844424930131970, "label": "Person", "properties": {"age": "32", 
"name": "BBB", "__id__": 2}}::vertex
    {"id": 844424930131971, "label": "Person", "properties": {"age": "33", 
"name": "CCC", "__id__": 3}}::vertex
   (3 rows)
   -----------------------------------------------
   2.  import person.csv second time, which contains:
   name,age
   DDD,54,
   EEE,66,
   FFF,73
   
   select load_labels_from_file('graph1', 'Person', 
'/home/postgres/ws/testdata/person.csv', false);
   
   select * from cypher ('graph1', $$
   Match(v)
   return v
   $$) as (v agtype);
                                                         v
   
-------------------------------------------------------------------------------------------------------------
    {"id": 844424930131969, "label": "Person", "properties": {"age": "12", 
"name": "AAA", "__id__": 1}}::vertex
    {"id": 844424930131970, "label": "Person", "properties": {"age": "32", 
"name": "BBB", "__id__": 2}}::vertex
    {"id": 844424930131971, "label": "Person", "properties": {"age": "33", 
"name": "CCC", "__id__": 3}}::vertex
    {"id": 844424930131969, "label": "Person", "properties": {"age": "54", 
"name": "DDD", "__id__": 1}}::vertex
    {"id": 844424930131970, "label": "Person", "properties": {"age": "66", 
"name": "EEE", "__id__": 2}}::vertex
    {"id": 844424930131971, "label": "Person", "properties": {"age": "73", 
"name": "FFF", "__id__": 3}}::vertex
   (6 rows)
   ```
   
   
   **Expected behavior**
   each vertex has an unique graphId
   
   **Environment (please complete the following information):**
   - Version: 
   - 1.5.0
   - PG 11
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to