Skip to content
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

[BUG] Formatted query got truncated after clicked “Run” #1852

Open
A-Gray-Cat opened this issue Aug 1, 2024 · 3 comments
Open

[BUG] Formatted query got truncated after clicked “Run” #1852

A-Gray-Cat opened this issue Aug 1, 2024 · 3 comments
Labels
bug Something isn't working

Comments

@A-Gray-Cat
Copy link

What is the bug?
A clear and concise description of the bug.

How can one reproduce the bug?
Steps to reproduce the behavior:

  1. Go to Data sources -> securitylake -> query data -> open log explorer
  2. Copy and paste the following query to the query editor
SELECT * 
FROM
securitylake.amazon_security_lake_glue_db_us_east_1.amazon_security_lake_table_us_east_1_cloud_trail_mgmt_2_0
WHERE time_dt > "2024-07-31 00:00:00"
    AND region = "us-east-1"
LIMIT 10

source = securitylake.amazon_security_lake_glue_db_us_east_1.amazon_security_lake_table_us_east_1_cloud_trail_mgmt_2_0
| where time_dt > "2024-07-31 00:00:00" and region = "us-east-1"
| head 10
  1. Formatted queries will be truncated and becoming a single-line query. If you click "search" again, the query will fail because two functions or keywords became one.

What is the expected behavior?
Query's format won't be changed.

What is your host/environment?

  • OS: [e.g. iOS]
  • Version 2.13
  • Plugins

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Add any other context about the problem.

@A-Gray-Cat A-Gray-Cat added bug Something isn't working untriaged labels Aug 1, 2024
@dblock dblock removed the untriaged label Aug 19, 2024
@dblock
Copy link
Member

dblock commented Aug 19, 2024

Catch All Triage - 1, 2, 3

@joshuali925
Copy link
Member

Version 2.13

on 2.13 only query workbench and devtools support SQL, log explorer does not

Copy and paste the following query to the query editor

There are two queries being pasted, one is SQL one is PPL. They cannot run together

could you clarify where you are running the sql query?

@A-Gray-Cat
Copy link
Author

Hello. This is run in the direct query interface where both PPL and SQL are supported.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants