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

fix: move sql operators to include file #3901

Open
wants to merge 2 commits into
base: main
Choose a base branch
from

Conversation

Xhoenix
Copy link
Member

@Xhoenix Xhoenix commented Oct 28, 2024

No description provided.

@Xhoenix
Copy link
Member Author

Xhoenix commented Oct 28, 2024

Does the logical operators need to be moved too?

Copy link
Member

@fzipi

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Very good question. What do you think is better?

Comment on lines 15 to 17
##! sql operators

[|&<>*\/%=^+-]{1,3}
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
##! sql operators
[|&<>*\/%=^+-]{1,3}
##!> include sql-operators

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Why do we have there the *, % and ^ chars? Are those valid part of the sql language operators 🤔 ?

Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Those characters are causing tests to fail. Which is why I revert my initial commit.

Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Also, if you read a little above, a url points to the same SQLITE operators page I mentioned earlier.

Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Looks like those are valid operators for MySQL: https://dev.mysql.com/doc/refman/8.4/en/non-typed-operators.html

Copy link
Member Author

@Xhoenix Xhoenix Oct 30, 2024

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Looks like we've to add *, ^, %, |, +, - to fix the tests for 942520. What do you say, should we add them alongwith other MySQL operators? Will adding single chars cause FPs?

Copy link
Member Author

@Xhoenix Xhoenix Oct 30, 2024

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Also, the main question is should we include the logical operators too. I think we should, including logical operators for other engines too. But then, what about 942120.ra? Only the include statement will be left. 😄

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

Successfully merging this pull request may close these issues.

2 participants