Fix alphanumeric search which starts with number by vamsimanohar · Pull Request #4334 · opensearch-project/sql · GitHub
Skip to content

Fix alphanumeric search which starts with number#4334

Merged
vamsimanohar merged 1 commit into
opensearch-project:mainfrom
vamsimanohar:main
Sep 29, 2025
Merged

Fix alphanumeric search which starts with number#4334
vamsimanohar merged 1 commit into
opensearch-project:mainfrom
vamsimanohar:main

Conversation

@vamsimanohar

@vamsimanohar vamsimanohar commented Sep 19, 2025

Copy link
Copy Markdown
Member

Description

unquoted search literals which starts with numbers translate to wrong lucene query due to issue with ppl grammar.

Example Query

POST _plugins/_ppl/
{
  "query": "source =demo-logs-otel-v1-* 5a57f0a17fc6f59fb2ad8ec6b52ea3fa "
}

Truncated Explain Result:

"query_string":{"query":"(5) AND (a57f0a17fc6f59fb2ad8ec6b52ea3fa)"}

We fixed the issue by introducing proper grammar and as part of the fix, spanlength is moved to lexer above NUMERICID to avoid spanlengths like '1s 1month' to be parsed as NUMERICID

Related Issues

Resolves #[Issue number to be closed when this PR is merged]

Check List

  • New functionality includes testing.
  • New functionality has been documented.
  • New functionality has javadoc added.
  • New functionality has a user manual doc added.
  • New PPL command checklist all confirmed.
  • API changes companion pull request created.
  • Commits are signed per the DCO using --signoff or -s.
  • Public documentation issue/PR created.

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.
For more information on following Developer Certificate of Origin and signing off your commits, please check here.

@vamsimanohar vamsimanohar force-pushed the main branch 11 times, most recently from e2db081 to 840ea42 Compare September 27, 2025 01:10
@vamsimanohar vamsimanohar marked this pull request as ready for review September 27, 2025 02:29
@vamsimanohar vamsimanohar self-assigned this Sep 29, 2025
penghuo
penghuo previously approved these changes Sep 29, 2025
Comment thread integ-test/src/test/java/org/opensearch/sql/ppl/SearchCommandIT.java Outdated
Signed-off-by: Vamsi Manohar <reddyvam@amazon.com>
@vamsimanohar vamsimanohar merged commit e2df87b into opensearch-project:main Sep 29, 2025
33 checks passed
@opensearch-trigger-bot

Copy link
Copy Markdown
Contributor

vamsimanohar added a commit to vamsimanohar/sql that referenced this pull request Sep 30, 2025
Signed-off-by: Vamsi Manohar <reddyvam@amazon.com>
(cherry picked from commit e2df87b)
vamsimanohar added a commit that referenced this pull request Sep 30, 2025
Signed-off-by: Vamsi Manohar <reddyvam@amazon.com>
(cherry picked from commit e2df87b)
vamsimanohar added a commit that referenced this pull request Sep 30, 2025
Signed-off-by: Vamsi Manohar <reddyvam@amazon.com>
(cherry picked from commit e2df87b)
Signed-off-by: Vamsi Manohar <reddyvam@amazon.com>
vamsimanohar added a commit that referenced this pull request Sep 30, 2025
(cherry picked from commit e2df87b)

Signed-off-by: Vamsi Manohar <reddyvam@amazon.com>
@LantaoJin LantaoJin added the backport-manually Filed a PR to backport manually. label Oct 9, 2025
asifabashar added a commit to asifabashar/sql that referenced this pull request Oct 10, 2025
* main-apple: (218 commits)
  Add ignorePrometheus Flag for integTest and docTest (opensearch-project#4442)
  Create fab-radar.yml
  PPL `fillnull` command enhancement (opensearch-project#4421)
  reverting to _doc + _id (opensearch-project#4435)
  Support `multisearch` command in calcite (opensearch-project#4332)
  Add 3.3 release notes (opensearch-project#4422) (opensearch-project#4423)
  [SQL/PPL] Fix the `count(*)` and `dc(field)` to be capped at MAX_INTEGER opensearch-project#4416 (opensearch-project#4418)
  Change the default search sort tiebreaker to `_shard_doc` for PIT search (opensearch-project#4378)
  [Enhancement] Add error handling for known limitation of sql `JOIN` (opensearch-project#4344)
  Bugfix: SQL type mapping for legacy JDBC output (opensearch-project#3613)
  Version bump: 3.3 (opensearch-project#4417)
  Add max/min eval functions (opensearch-project#4333)
  Support time modifiers in search command  (opensearch-project#4224)
  Fix numbered token bug and make it optional output in patterns command (opensearch-project#4402)
  refactor span (opensearch-project#4334)
  Move release notes categories (opensearch-project#3818)
  [Doc] Enable doctest with Calcite (opensearch-project#4379)
  Mod function should return decimal instead of float when handle the operands are decimal literal (opensearch-project#4407)
  Scale of decimal literal should always be positive in Calcite (opensearch-project#4401)
  Enable Calcite by default and implicit fallback the unsupported commands (opensearch-project#4372)
  ...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

backport 2.19-dev backport-failed backport-manually Filed a PR to backport manually. bug Something isn't working v3.3.0

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants