Skip to content

Preview doesn't support IN query condition #165

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
nyevgen opened this issue Feb 11, 2025 · 0 comments
Open

Preview doesn't support IN query condition #165

nyevgen opened this issue Feb 11, 2025 · 0 comments
Assignees
Labels
cosmosEmulatorVnextPreview issues raised for the vNext Linux based emulator (preview) feature
Milestone

Comments

@nyevgen
Copy link

nyevgen commented Feb 11, 2025

Describe the bug

Query by IN operator with placeholders is not supported:

  POST http://127.0.0.1:8081/dbs/integration-test-db/colls/test-table/docs
  --------------------------------------------------------------------------------
  RESPONSE 500: 500 Internal Server Error
  ERROR CODE: 500 Internal Server Error
  --------------------------------------------------------------------------------
  {
    "code": "InternalServerError",
    "message": "Index does not have options 16 Cosmos query text: select * from docs C WHERE C.StringAttribute IN (@StringAttribute0_0,@StringAttribute0_1,@StringAttribute0_2,@StringAttribute0_3)  OFFSET 0 LIMIT 1000 -\u003E SELECT * FROM %s AS C WHERE cosmos_catalog.cosmos_in(C.document, $1 ) OFFSET 0  LIMIT 1000"
  }
  --------------------------------------------------------------------------------

To Reproduce

  1. Create query with IN condition and placeholder values

select * from docs C WHERE C.StringAttribute IN (@StringAttribute0_0,@StringAttribute0_1,@StringAttribute0_2,@StringAttribute0_3) OFFSET 0 LIMIT 1000

Expected behavior

Query executed without errors

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • OS: macOS M4
  • Browser chrome
  • Version mcr.microsoft.com/cosmosdb/linux/azure-cosmos-emulator:vnext-preview
  • SDK github.com/Azure/azure-sdk-for-go/sdk/data/azcosmos v1.2.0
  • SDK golang

Additional context
Add any other context about the problem here.

@nyevgen nyevgen added cosmosEmulatorVnextPreview issues raised for the vNext Linux based emulator (preview) needs-triage labels Feb 11, 2025
@xgerman xgerman assigned DmitriMelnikov and unassigned xgerman Feb 11, 2025
@xgerman xgerman added this to the Backlog milestone Feb 11, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
cosmosEmulatorVnextPreview issues raised for the vNext Linux based emulator (preview) feature
Projects
None yet
Development

No branches or pull requests

3 participants