The Wayback Machine - https://web.archive.org/web/20201011180448/https://github.com/JSQLParser/JSqlParser/issues/802
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

Mysql Database: Count(... or null) is not supported #802

Open
GitHub4ZhangJX opened this issue May 24, 2019 · 4 comments
Open

Mysql Database: Count(... or null) is not supported #802

GitHub4ZhangJX opened this issue May 24, 2019 · 4 comments

Comments

@GitHub4ZhangJX
Copy link

@GitHub4ZhangJX GitHub4ZhangJX commented May 24, 2019

Actual Behavior

Expected Behavior

Steps to Reproduce the Problem

Specifications

  • Version:
  • Platform:
  • Subsystem:
@GitHub4ZhangJX GitHub4ZhangJX changed the title Count(... or null) is not supported Mysql Database: Count(... or null) is not supported May 24, 2019
@wumpz
Copy link
Member

@wumpz wumpz commented Jul 21, 2019

Please provide a test sql.

@mi521
Copy link

@mi521 mi521 commented Apr 21, 2020

select count(*) from node It's not going to be resolved
select count(id) from node it`s ok

@wumpz
Copy link
Member

@wumpz wumpz commented Apr 21, 2020

Both sqls are parsed successfully:

select count(*) from node;
select count(id) from node;

and how does this relate to the issue title?

@melin
Copy link

@melin melin commented Jun 29, 2020

Please provide a test sql.

select count(pay_partner='test001' or null) from table

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

Successfully merging a pull request may close this issue.

None yet
4 participants
You can’t perform that action at this time.