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

Remove the useless Project in plan #4171

Closed
Shylock-Hg opened this issue Apr 18, 2022 · 0 comments · Fixed by #4157
Closed

Remove the useless Project in plan #4171

Shylock-Hg opened this issue Apr 18, 2022 · 0 comments · Fixed by #4157
Assignees
Labels
type/enhancement Type: make the code neat or more efficient
Milestone

Comments

@Shylock-Hg
Copy link
Contributor

Introduction

Subjob of #4122

Contents

e.g.

      explain format = 'dot'
      MATCH (message:Message)
      WHERE message.Message.creationDate < "20110721220000000"
      WITH count(message) AS totalMessageCountInt
      WITH toFloat(totalMessageCountInt) AS totalMessageCount
      MATCH (message:Message)
      WHERE message.Message.creationDate < "20110721220000000"
        AND message.Message.content IS NOT NULL
      WITH
        totalMessageCount,
        message,
        toInteger(message.Message.creationDate)/10000000000000 AS year
      WITH
        totalMessageCount,
        year,
        "Comment" IN tags(message) AS isComment,
        CASE
          WHEN message.Message.length <  40 THEN 0
          WHEN message.Message.length <  80 THEN 1
          WHEN message.Message.length < 160 THEN 2
          ELSE                           3
        END AS lengthCategory,
        count(message) AS messageCount,
        floor(avg(message.Message.length)) AS averageMessageLength,
        sum(message.Message.length) AS sumMessageLength
      RETURN
        year,
        isComment,
        lengthCategory,
        messageCount,
        averageMessageLength,
        sumMessageLength,
        messageCount / totalMessageCount AS percentageOfMessages
      ORDER BY
        year DESC,
        isComment ASC,
        lengthCategory ASC

graphviz (2)

As above, Project_7 and Project_11 could be eliminated.

Related work

@Shylock-Hg Shylock-Hg added the type/enhancement Type: make the code neat or more efficient label Apr 18, 2022
@Shylock-Hg Shylock-Hg changed the title Remove the useless Project in plan Remove the useless Project in plan Apr 18, 2022
@Shylock-Hg Shylock-Hg added this to the v3.2.0 milestone Apr 18, 2022
@Shylock-Hg Shylock-Hg self-assigned this Apr 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement Type: make the code neat or more efficient
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant