Closed Marian2701 closed 9 months ago
Describe the bug (must be provided)
Also not working in plain console.
Your Environments (must be provided)
Docker extension
How To Reproduce(must be provided)
Steps to reproduce the behavior:
CREATE TAG `City` ( `name` string, `geographic_location` geography(point), `wiki_data_id` string) ttl_duration = 0, ttl_col = "";
CREATE TAG Country ( average_income double, low_income double, middle_income double, high_income double, minimum_wage double, country_name string, ISO3_country_code string, ISO2_country_code string, phone_code string, region string, sub_region string) ttl_duration = 0, ttl_col = "";
Country
average_income
low_income
middle_income
high_income
minimum_wage
country_name
ISO3_country_code
ISO2_country_code
phone_code
region
sub_region
CREATE EDGE city_belongs_to_country () ttl_duration = 0, ttl_col = "";
city_belongs_to_country
INSERT VERTEX City (name, wiki_data_id) VALUES "CITY_1":("CITY_1_name", "CITY_1_wiki_data_id"); INSERT VERTEX City (name, wiki_data_id) VALUES "CITY_1":("CITY_2_name", "CITY_2_wiki_data_id"); INSERT VERTEX City (name, wiki_data_id) VALUES "CITY_1":("CITY_3_name", "CITY_3_wiki_data_id"); INSERT VERTEX City (name, wiki_data_id) VALUES "CITY_1":("CITY_4_name", "CITY_4_wiki_data_id"); INSERT VERTEX City (name, wiki_data_id) VALUES "CITY_1":("CITY_5_name", "CITY_5_wiki_data_id");
City
name
wiki_data_id
INSERT VERTEX Country (country_name, average_income, region) VALUES "COUN_1":("COUN_1_country_name",1.11, "COUN_1_region"); INSERT VERTEX Country (country_name, average_income, region) VALUES "COUN_2":("COUN_2_country_name",2.22, "COUN_2_region"); INSERT VERTEX Country (country_name, average_income, region) VALUES "COUN_3":("COUN_3_country_name",3.33, "COUN_3_region"); INSERT VERTEX Country (country_name, average_income, region) VALUES "COUN_4":("COUN_4_country_name",4.44, "COUN_4_region"); INSERT VERTEX Country (country_name, average_income, region) VALUES "COUN_5":("COUN_5_country_name",5.55, "COUN_5_region");
INSERT EDGE city_belongs_to_country () VALUES "CITY_1"->"COUN_1":(); INSERT EDGE city_belongs_to_country () VALUES "CITY_2"->"COUN_2":(); INSERT EDGE city_belongs_to_country () VALUES "CITY_3"->"COUN_3":(); INSERT EDGE city_belongs_to_country () VALUES "CITY_4"->"COUN_4":(); INSERT EDGE city_belongs_to_country () VALUES "CITY_5"->"COUN_5":();
2. Query without alias:
MATCH (tag1:City) WHERE id(tag1) == "CITY_1" MATCH (tag1)-[:city_belongs_to_country]->(tag2:Country) RETURN tag1, tag2;
3. Query with alias:
MATCH (tag1:City) WHERE id(tag1) == "CITY_1" MATCH (tag1)-[:city_belongs_to_country]->(tag2:Country) RETURN tag1, tag2 AS alias;
**Expected behavior** Query without alias must work as Query with alias.
Describe the bug (must be provided)
Also not working in plain console.
Your Environments (must be provided)
Docker extension
How To Reproduce(must be provided)
Steps to reproduce the behavior:
CREATE TAG
Country
(average_income
double,low_income
double,middle_income
double,high_income
double,minimum_wage
double,country_name
string,ISO3_country_code
string,ISO2_country_code
string,phone_code
string,region
string,sub_region
string) ttl_duration = 0, ttl_col = "";CREATE EDGE
city_belongs_to_country
() ttl_duration = 0, ttl_col = "";INSERT VERTEX
City
(name
,wiki_data_id
) VALUES "CITY_1":("CITY_1_name", "CITY_1_wiki_data_id"); INSERT VERTEXCity
(name
,wiki_data_id
) VALUES "CITY_1":("CITY_2_name", "CITY_2_wiki_data_id"); INSERT VERTEXCity
(name
,wiki_data_id
) VALUES "CITY_1":("CITY_3_name", "CITY_3_wiki_data_id"); INSERT VERTEXCity
(name
,wiki_data_id
) VALUES "CITY_1":("CITY_4_name", "CITY_4_wiki_data_id"); INSERT VERTEXCity
(name
,wiki_data_id
) VALUES "CITY_1":("CITY_5_name", "CITY_5_wiki_data_id");INSERT VERTEX
Country
(country_name
,average_income
,region
) VALUES "COUN_1":("COUN_1_country_name",1.11, "COUN_1_region"); INSERT VERTEXCountry
(country_name
,average_income
,region
) VALUES "COUN_2":("COUN_2_country_name",2.22, "COUN_2_region"); INSERT VERTEXCountry
(country_name
,average_income
,region
) VALUES "COUN_3":("COUN_3_country_name",3.33, "COUN_3_region"); INSERT VERTEXCountry
(country_name
,average_income
,region
) VALUES "COUN_4":("COUN_4_country_name",4.44, "COUN_4_region"); INSERT VERTEXCountry
(country_name
,average_income
,region
) VALUES "COUN_5":("COUN_5_country_name",5.55, "COUN_5_region");INSERT EDGE
city_belongs_to_country
() VALUES "CITY_1"->"COUN_1":(); INSERT EDGEcity_belongs_to_country
() VALUES "CITY_2"->"COUN_2":(); INSERT EDGEcity_belongs_to_country
() VALUES "CITY_3"->"COUN_3":(); INSERT EDGEcity_belongs_to_country
() VALUES "CITY_4"->"COUN_4":(); INSERT EDGEcity_belongs_to_country
() VALUES "CITY_5"->"COUN_5":();MATCH (tag1:
City
) WHERE id(tag1) == "CITY_1" MATCH (tag1)-[:city_belongs_to_country
]->(tag2:Country
) RETURN tag1, tag2;MATCH (tag1:
City
) WHERE id(tag1) == "CITY_1" MATCH (tag1)-[:city_belongs_to_country
]->(tag2:Country
) RETURN tag1, tag2 AS alias;