What problem are you trying to solve?

Focus on the what and why of the need you have, not the how you'd like it solved.

using JDBC connector, when run a sql statement which contains duplicate name.

e.g.

SELECT
city.CITY,
city.CITY_ID,
region.COUNTRY_ID,
region.REGION,
region.REGION_ID,
city.REGION_ID
FROM
city,
region
WHERE
( city.REGION_ID=region.REGION_ID )

it returns error "Error executing command: algebrize error: Error 3023: found duplicate document key "REGION_ID""

What would you like to see happen?

Describe the desired outcome or enhancement.

I expected no error for executeQuery()

Why is this important to you or your team?

Explain how the request adds value or solves a business need.

it affects our products.

What steps, if any, are you taking today to manage this problem?