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

DATE - INTERVAL operation failed in sqlness with distributed mode #2319

Closed
QuenKar opened this issue Sep 4, 2023 · 1 comment · Fixed by #2912
Closed

DATE - INTERVAL operation failed in sqlness with distributed mode #2319

QuenKar opened this issue Sep 4, 2023 · 1 comment · Fixed by #2912
Assignees
Labels
C-bug Category Bugs

Comments

@QuenKar
Copy link
Contributor

QuenKar commented Sep 4, 2023

What type of bug is this?

Unexpected error

What subsystems are affected?

Other

What happened?

#2265 (comment)
As shown in the link above, when I run this statement locally, it runs failed in distributed mode.

What operating system did you use?

Mac OS Ventura 13.2 ARM

Relevant log output and stack trace

Result unexpected, path:"/Users/zouwei/rust-project/greptimedb/tests/cases/standalone/common/types/interval/interval.sql"
[
    ... skip(205) ...,
~   -- SELECT DATE '2000-10-30' - interval_value from intervals; -> SELECT DATE '2000-10-30' - interval_value from intervals;,
+   ,
+   +-----------------------------------------------+,
+   | Utf8("2000-10-30") - intervals.interval_value |,
+   +-----------------------------------------------+,
+   | 1999-10-30                                    |,
+   | 1999-10-30                                    |,
+   | 1998-08-30                                    |,
+   | 1997-10-30                                    |,
+   | 1996-10-30                                    |,
+   | 1995-10-30                                    |,
+   | 1994-10-30                                    |,
+   | 1993-10-30                                    |,
+   | 1992-10-30                                    |,
+   | 1991-10-21                                    |,
+   | 1990-10-30                                    |,
+   | 1989-10-19                                    |,
+   | 1988-10-18                                    |,
+   +-----------------------------------------------+,
+   ,
    ... skip(63) ...
]
...
-----------------------------------------------------------------------------------
...
Result unexpected, path:"/Users/zouwei/rust-project/greptimedb/tests/cases/distributed/common/types/interval/interval.sql"
[
    ... skip(207) ...,
~   +-----------------------------------------------+ -> Error: 1003(Internal), This feature is not implemented: Unsupported function name: "substract",
-   | Utf8("2000-10-30") - intervals.interval_value |,
-   +-----------------------------------------------+,
-   | 1999-10-30                                    |,
-   | 1999-10-30                                    |,
-   | 1998-08-30                                    |,
-   | 1997-10-30                                    |,
-   | 1996-10-30                                    |,
-   | 1995-10-30                                    |,
-   | 1994-10-30                                    |,
-   | 1993-10-30                                    |,
-   | 1992-10-30                                    |,
-   | 1991-10-21                                    |,
-   | 1990-10-30                                    |,
-   | 1989-10-19                                    |,
-   | 1988-10-18                                    |,
-   +-----------------------------------------------+,
    ... skip(64) ...
]
...

How can we reproduce the bug?

run cargo sqlness interval twice.

@QuenKar QuenKar added the C-bug Category Bugs label Sep 4, 2023
@waynexia waynexia self-assigned this Sep 4, 2023
@killme2008
Copy link
Contributor

@QuenKar Is this fixed?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Category Bugs
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants