This is an automated email from the ASF dual-hosted git repository.
eldenmoon pushed a commit to branch branch-2.0-var
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0-var by this push:
new 6d6c4fc3f3d [regression-test](variant) fix variant case (#27001)
6d6c4fc3f3d is described below
commit 6d6c4fc3f3d7c8aaebb817940ab637a8f9e8ad88
Author: lihangyu <[email protected]>
AuthorDate: Thu Nov 16 10:36:08 2023 +0800
[regression-test](variant) fix variant case (#27001)
---
.../affinityByIssuesAndPRs1.out | 0
.../affinityByIssuesAndPRs2.out | 0
.../authorsWithTheMostPushes.out | 0
.../countingStar1.out | 0
.../countingStar2.out | 0
.../countingStar3.out | 0
.../distributionOfRepositoriesByStarCount.out | 0
.../githubRoulette.out | 0
...heListOfTopRepositoriesChangedOverTheYears1.out | 0
...heListOfTopRepositoriesChangedOverTheYears2.out | 0
...heListOfTopRepositoriesChangedOverTheYears3.out | 0
...heListOfTopRepositoriesChangedOverTheYears4.out | 0
...heListOfTopRepositoriesChangedOverTheYears5.out | 0
...heListOfTopRepositoriesChangedOverTheYears6.out | 0
.../howHasTheTotalNumberOfStarsChangedOverTime.out | 0
.../issuesWithTheMostComments1.out | 0
.../issuesWithTheMostComments2.out | 0
.../issuesWithTheMostComments3.out | 0
.../issuesWithTheMostComments4.out | 0
.../issuesWithTheMostComments5.out | 0
.../issuesWithTheMostComments6.out | 0
.../issuesWithTheMostComments7.out | 0
.../load.out | 0
.../mostForkedRepositories.out | 0
.../mostPopularCommentsOnGithub.out | 0
.../organizationsByTheNumberOfRepositories.out | 0
.../organizationsByTheNumberOfStars.out | 0
.../proportionsBetweenStarsAndForks1.out | 0
.../proportionsBetweenStarsAndForks2.out | 0
.../proportionsBetweenStarsAndForks3.out | 0
.../proportionsBetweenStarsAndForks4.out | 0
.../proportionsBetweenStarsAndForks5.out | 0
.../repositoriesByAmountOfModifiedCode.out | 0
.../repositoriesByTheNumberOfPushes.out | 0
...epositoriesWithClickhouse_related_comments1.out | 0
...epositoriesWithClickhouse_related_comments2.out | 0
.../repositoriesWithDoris_related_comments1.out | 0
.../repositoriesWithDoris_related_comments2.out | 0
.../repositoriesWithTheHighestGrowthYoY.out | 0
.../repositoriesWithTheMaximumAmountOfIssues1.out | 0
.../repositoriesWithTheMaximumAmountOfIssues2.out | 0
.../repositoriesWithTheMaximumAmountOfIssues3.out | 0
.../repositoriesWithTheMaximumAmountOfIssues4.out | 0
...sitoriesWithTheMaximumAmountOfPullRequests1.out | 0
...sitoriesWithTheMaximumAmountOfPullRequests2.out | 0
...esWithTheMaximumNumberOfAcceptedInvitations.out | 0
...sitoriesWithTheMostPeopleWhoHavePushAccess1.out | 0
.../repositoriesWithTheMostStarsOverOneDay1.out | 0
...repositoriesWithTheMostSteadyGrowthOverTime.out | 0
.../repositoriesWithTheWorstStagnation_order.out | 0
.../repositoryAffinityList1.out | 0
.../repositoryAffinityList2.out | 0
.../starsFromHeavyGithubUsers1.out | 0
.../starsFromHeavyGithubUsers2.out | 0
.../theLongestRepositoryNames1.out | 0
.../theLongestRepositoryNames2.out | 0
.../theMostToughCodeReviews.out | 0
.../theTotalNumberOfRepositoriesOnGithub.out | 0
.../theTotalNumberOfUsersOnGithub1.out | 0
.../theTotalNumberOfUsersOnGithub2.out | 0
.../theTotalNumberOfUsersOnGithub3.out | 0
.../theTotalNumberOfUsersOnGithub4.out | 0
.../topRepositoriesByStars.out | 0
.../whatIsTheBestDayOfTheWeekToCatchAStar.out | 0
.../whoAreAllThosePeopleGivingStars1.out | 0
.../whoAreAllThosePeopleGivingStars2.out | 0
.../whoAreAllThosePeopleGivingStars3.out | 0
regression-test/data/variant_p0/sql/gh_data.out | 73 ----------------------
.../affinityByIssuesAndPRs1.sql | 0
.../affinityByIssuesAndPRs2.sql | 0
.../authorsWithTheMostPushes.sql | 0
.../countingStar1.sql | 0
.../countingStar2.sql | 0
.../countingStar3.sql | 0
.../distributionOfRepositoriesByStarCount.sql | 0
.../variant_github_events_p0/githubRoulette.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears1.sql | 0
...heListOfTopRepositoriesChangedOverTheYears2.sql | 0
...heListOfTopRepositoriesChangedOverTheYears3.sql | 0
...heListOfTopRepositoriesChangedOverTheYears4.sql | 0
...heListOfTopRepositoriesChangedOverTheYears5.sql | 0
...heListOfTopRepositoriesChangedOverTheYears6.sql | 0
...heListOfTopRepositoriesChangedOverTheYears7.sql | 0
.../howHasTheTotalNumberOfStarsChangedOverTime.sql | 2 +
.../issuesWithTheMostComments1.sql | 0
.../issuesWithTheMostComments2.sql | 0
.../issuesWithTheMostComments3.sql | 0
.../issuesWithTheMostComments4.sql | 0
.../issuesWithTheMostComments5.sql | 0
.../issuesWithTheMostComments6.sql | 0
.../issuesWithTheMostComments7.sql | 0
.../issuesWithTheMostComments8.sql | 0
.../load.groovy | 0
.../mostForkedRepositories.sql | 0
.../mostPopularCommentsOnGithub.sql | 0
.../organizationsByTheNumberOfRepositories.sql | 0
.../organizationsByTheNumberOfStars.sql | 0
.../organizationsByTheSizeOfCommunity.sql | 0
.../proportionsBetweenStarsAndForks1.sql | 0
.../proportionsBetweenStarsAndForks2.sql | 0
.../proportionsBetweenStarsAndForks3.sql | 0
.../proportionsBetweenStarsAndForks4.sql | 0
.../proportionsBetweenStarsAndForks5.sql | 0
.../repositoriesByAmountOfModifiedCode.sql | 0
.../repositoriesByTheNumberOfPushes.sql | 0
...epositoriesWithClickhouse_related_comments1.sql | 0
...epositoriesWithClickhouse_related_comments2.sql | 0
.../repositoriesWithDoris_related_comments1.sql | 0
.../repositoriesWithDoris_related_comments2.sql | 0
.../repositoriesWithTheHighestGrowthYoY.sql | 21 +++++++
.../repositoriesWithTheMaximumAmountOfIssues1.sql | 0
.../repositoriesWithTheMaximumAmountOfIssues2.sql | 0
.../repositoriesWithTheMaximumAmountOfIssues3.sql | 0
.../repositoriesWithTheMaximumAmountOfIssues4.sql | 0
...sitoriesWithTheMaximumAmountOfPullRequests1.sql | 0
...sitoriesWithTheMaximumAmountOfPullRequests2.sql | 0
...esWithTheMaximumNumberOfAcceptedInvitations.sql | 0
...sitoriesWithTheMostPeopleWhoHavePushAccess1.sql | 0
...sitoriesWithTheMostPeopleWhoHavePushAccess2.sql | 0
...sitoriesWithTheMostPeopleWhoHavePushAccess3.sql | 0
.../repositoriesWithTheMostStarsOverOneDay1.sql} | 11 ++--
.../repositoriesWithTheMostStarsOverOneDay2.sql | 0
.../repositoriesWithTheMostStarsOverOneDay3.sql | 0
...repositoriesWithTheMostSteadyGrowthOverTime.sql | 21 +++++++
.../repositoriesWithTheWorstStagnation_order.sql | 21 +++++++
.../repositoryAffinityList1.sql | 0
.../repositoryAffinityList2.sql | 0
.../starsFromHeavyGithubUsers1.sql | 0
.../starsFromHeavyGithubUsers2.sql | 0
.../theLongestRepositoryNames1.sql | 0
.../theLongestRepositoryNames2.sql | 0
.../theMostToughCodeReviews.sql | 0
.../theTotalNumberOfRepositoriesOnGithub.sql | 0
.../theTotalNumberOfUsersOnGithub1.sql | 0
.../theTotalNumberOfUsersOnGithub2.sql | 0
.../theTotalNumberOfUsersOnGithub3.sql | 0
.../theTotalNumberOfUsersOnGithub4.sql | 0
.../topLabels1.sql | 0
.../topLabels2.sql | 0
.../topLabels3.sql | 0
.../topRepositoriesByStars.sql | 0
.../whatIsTheBestDayOfTheWeekToCatchAStar.sql | 1 +
.../whoAreAllThosePeopleGivingStars1.sql | 0
.../whoAreAllThosePeopleGivingStars2.sql | 0
.../whoAreAllThosePeopleGivingStars3.sql | 0
regression-test/suites/variant_p0/desc.groovy | 6 +-
.../variant_p0/github_events_p0/githubRoulette.sql | 1 -
.../howHasTheTotalNumberOfStarsChangedOverTime.sql | 2 -
.../repositoriesWithTheHighestGrowthYoY.sql | 20 ------
.../repositoriesWithTheMostStarsOverOneDay1.sql | 25 --------
...repositoriesWithTheMostSteadyGrowthOverTime.sql | 20 ------
.../repositoriesWithTheWorstStagnation_order.sql | 20 ------
.../whatIsTheBestDayOfTheWeekToCatchAStar.sql | 1 -
regression-test/suites/variant_p0/sql/gh_data.sql | 16 +----
154 files changed, 79 insertions(+), 183 deletions(-)
diff --git
a/regression-test/data/variant_p0/github_events_p0/affinityByIssuesAndPRs1.out
b/regression-test/data/variant_github_events_p0/affinityByIssuesAndPRs1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/affinityByIssuesAndPRs1.out
rename to
regression-test/data/variant_github_events_p0/affinityByIssuesAndPRs1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/affinityByIssuesAndPRs2.out
b/regression-test/data/variant_github_events_p0/affinityByIssuesAndPRs2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/affinityByIssuesAndPRs2.out
rename to
regression-test/data/variant_github_events_p0/affinityByIssuesAndPRs2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/authorsWithTheMostPushes.out
b/regression-test/data/variant_github_events_p0/authorsWithTheMostPushes.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/authorsWithTheMostPushes.out
rename to
regression-test/data/variant_github_events_p0/authorsWithTheMostPushes.out
diff --git a/regression-test/data/variant_p0/github_events_p0/countingStar1.out
b/regression-test/data/variant_github_events_p0/countingStar1.out
similarity index 100%
rename from regression-test/data/variant_p0/github_events_p0/countingStar1.out
rename to regression-test/data/variant_github_events_p0/countingStar1.out
diff --git a/regression-test/data/variant_p0/github_events_p0/countingStar2.out
b/regression-test/data/variant_github_events_p0/countingStar2.out
similarity index 100%
rename from regression-test/data/variant_p0/github_events_p0/countingStar2.out
rename to regression-test/data/variant_github_events_p0/countingStar2.out
diff --git a/regression-test/data/variant_p0/github_events_p0/countingStar3.out
b/regression-test/data/variant_github_events_p0/countingStar3.out
similarity index 100%
rename from regression-test/data/variant_p0/github_events_p0/countingStar3.out
rename to regression-test/data/variant_github_events_p0/countingStar3.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/distributionOfRepositoriesByStarCount.out
b/regression-test/data/variant_github_events_p0/distributionOfRepositoriesByStarCount.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/distributionOfRepositoriesByStarCount.out
rename to
regression-test/data/variant_github_events_p0/distributionOfRepositoriesByStarCount.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/githubRoulette.out
b/regression-test/data/variant_github_events_p0/githubRoulette.out
similarity index 100%
rename from regression-test/data/variant_p0/github_events_p0/githubRoulette.out
rename to regression-test/data/variant_github_events_p0/githubRoulette.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
b/regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
rename to
regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
b/regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
rename to
regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
b/regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
rename to
regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
b/regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
rename to
regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
b/regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
rename to
regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
b/regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
rename to
regression-test/data/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.out
b/regression-test/data/variant_github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.out
rename to
regression-test/data/variant_github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments1.out
b/regression-test/data/variant_github_events_p0/issuesWithTheMostComments1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments1.out
rename to
regression-test/data/variant_github_events_p0/issuesWithTheMostComments1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments2.out
b/regression-test/data/variant_github_events_p0/issuesWithTheMostComments2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments2.out
rename to
regression-test/data/variant_github_events_p0/issuesWithTheMostComments2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments3.out
b/regression-test/data/variant_github_events_p0/issuesWithTheMostComments3.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments3.out
rename to
regression-test/data/variant_github_events_p0/issuesWithTheMostComments3.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments4.out
b/regression-test/data/variant_github_events_p0/issuesWithTheMostComments4.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments4.out
rename to
regression-test/data/variant_github_events_p0/issuesWithTheMostComments4.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments5.out
b/regression-test/data/variant_github_events_p0/issuesWithTheMostComments5.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments5.out
rename to
regression-test/data/variant_github_events_p0/issuesWithTheMostComments5.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments6.out
b/regression-test/data/variant_github_events_p0/issuesWithTheMostComments6.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments6.out
rename to
regression-test/data/variant_github_events_p0/issuesWithTheMostComments6.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments7.out
b/regression-test/data/variant_github_events_p0/issuesWithTheMostComments7.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/issuesWithTheMostComments7.out
rename to
regression-test/data/variant_github_events_p0/issuesWithTheMostComments7.out
diff --git a/regression-test/data/variant_p0/github_events_p0/load.out
b/regression-test/data/variant_github_events_p0/load.out
similarity index 100%
rename from regression-test/data/variant_p0/github_events_p0/load.out
rename to regression-test/data/variant_github_events_p0/load.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/mostForkedRepositories.out
b/regression-test/data/variant_github_events_p0/mostForkedRepositories.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/mostForkedRepositories.out
rename to
regression-test/data/variant_github_events_p0/mostForkedRepositories.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/mostPopularCommentsOnGithub.out
b/regression-test/data/variant_github_events_p0/mostPopularCommentsOnGithub.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/mostPopularCommentsOnGithub.out
rename to
regression-test/data/variant_github_events_p0/mostPopularCommentsOnGithub.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/organizationsByTheNumberOfRepositories.out
b/regression-test/data/variant_github_events_p0/organizationsByTheNumberOfRepositories.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/organizationsByTheNumberOfRepositories.out
rename to
regression-test/data/variant_github_events_p0/organizationsByTheNumberOfRepositories.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/organizationsByTheNumberOfStars.out
b/regression-test/data/variant_github_events_p0/organizationsByTheNumberOfStars.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/organizationsByTheNumberOfStars.out
rename to
regression-test/data/variant_github_events_p0/organizationsByTheNumberOfStars.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks1.out
b/regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks1.out
rename to
regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks2.out
b/regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks2.out
rename to
regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks3.out
b/regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks3.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks3.out
rename to
regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks3.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks4.out
b/regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks4.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks4.out
rename to
regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks4.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks5.out
b/regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks5.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/proportionsBetweenStarsAndForks5.out
rename to
regression-test/data/variant_github_events_p0/proportionsBetweenStarsAndForks5.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesByAmountOfModifiedCode.out
b/regression-test/data/variant_github_events_p0/repositoriesByAmountOfModifiedCode.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesByAmountOfModifiedCode.out
rename to
regression-test/data/variant_github_events_p0/repositoriesByAmountOfModifiedCode.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesByTheNumberOfPushes.out
b/regression-test/data/variant_github_events_p0/repositoriesByTheNumberOfPushes.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesByTheNumberOfPushes.out
rename to
regression-test/data/variant_github_events_p0/repositoriesByTheNumberOfPushes.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments1.out
b/regression-test/data/variant_github_events_p0/repositoriesWithClickhouse_related_comments1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments1.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithClickhouse_related_comments1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments2.out
b/regression-test/data/variant_github_events_p0/repositoriesWithClickhouse_related_comments2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments2.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithClickhouse_related_comments2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithDoris_related_comments1.out
b/regression-test/data/variant_github_events_p0/repositoriesWithDoris_related_comments1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithDoris_related_comments1.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithDoris_related_comments1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithDoris_related_comments2.out
b/regression-test/data/variant_github_events_p0/repositoriesWithDoris_related_comments2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithDoris_related_comments2.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithDoris_related_comments2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheHighestGrowthYoY.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheHighestGrowthYoY.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheHighestGrowthYoY.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheHighestGrowthYoY.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay1.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay1.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoriesWithTheWorstStagnation_order.out
b/regression-test/data/variant_github_events_p0/repositoriesWithTheWorstStagnation_order.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoriesWithTheWorstStagnation_order.out
rename to
regression-test/data/variant_github_events_p0/repositoriesWithTheWorstStagnation_order.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoryAffinityList1.out
b/regression-test/data/variant_github_events_p0/repositoryAffinityList1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoryAffinityList1.out
rename to
regression-test/data/variant_github_events_p0/repositoryAffinityList1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/repositoryAffinityList2.out
b/regression-test/data/variant_github_events_p0/repositoryAffinityList2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/repositoryAffinityList2.out
rename to
regression-test/data/variant_github_events_p0/repositoryAffinityList2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/starsFromHeavyGithubUsers1.out
b/regression-test/data/variant_github_events_p0/starsFromHeavyGithubUsers1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/starsFromHeavyGithubUsers1.out
rename to
regression-test/data/variant_github_events_p0/starsFromHeavyGithubUsers1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/starsFromHeavyGithubUsers2.out
b/regression-test/data/variant_github_events_p0/starsFromHeavyGithubUsers2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/starsFromHeavyGithubUsers2.out
rename to
regression-test/data/variant_github_events_p0/starsFromHeavyGithubUsers2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theLongestRepositoryNames1.out
b/regression-test/data/variant_github_events_p0/theLongestRepositoryNames1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theLongestRepositoryNames1.out
rename to
regression-test/data/variant_github_events_p0/theLongestRepositoryNames1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theLongestRepositoryNames2.out
b/regression-test/data/variant_github_events_p0/theLongestRepositoryNames2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theLongestRepositoryNames2.out
rename to
regression-test/data/variant_github_events_p0/theLongestRepositoryNames2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theMostToughCodeReviews.out
b/regression-test/data/variant_github_events_p0/theMostToughCodeReviews.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theMostToughCodeReviews.out
rename to
regression-test/data/variant_github_events_p0/theMostToughCodeReviews.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theTotalNumberOfRepositoriesOnGithub.out
b/regression-test/data/variant_github_events_p0/theTotalNumberOfRepositoriesOnGithub.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theTotalNumberOfRepositoriesOnGithub.out
rename to
regression-test/data/variant_github_events_p0/theTotalNumberOfRepositoriesOnGithub.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub1.out
b/regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub1.out
rename to
regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub2.out
b/regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub2.out
rename to
regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub3.out
b/regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub3.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub3.out
rename to
regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub3.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub4.out
b/regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub4.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub4.out
rename to
regression-test/data/variant_github_events_p0/theTotalNumberOfUsersOnGithub4.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/topRepositoriesByStars.out
b/regression-test/data/variant_github_events_p0/topRepositoriesByStars.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/topRepositoriesByStars.out
rename to
regression-test/data/variant_github_events_p0/topRepositoriesByStars.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.out
b/regression-test/data/variant_github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.out
rename to
regression-test/data/variant_github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars1.out
b/regression-test/data/variant_github_events_p0/whoAreAllThosePeopleGivingStars1.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars1.out
rename to
regression-test/data/variant_github_events_p0/whoAreAllThosePeopleGivingStars1.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars2.out
b/regression-test/data/variant_github_events_p0/whoAreAllThosePeopleGivingStars2.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars2.out
rename to
regression-test/data/variant_github_events_p0/whoAreAllThosePeopleGivingStars2.out
diff --git
a/regression-test/data/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars3.out
b/regression-test/data/variant_github_events_p0/whoAreAllThosePeopleGivingStars3.out
similarity index 100%
rename from
regression-test/data/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars3.out
rename to
regression-test/data/variant_github_events_p0/whoAreAllThosePeopleGivingStars3.out
diff --git a/regression-test/data/variant_p0/sql/gh_data.out
b/regression-test/data/variant_p0/sql/gh_data.out
index 89f14fda752..232f4071d33 100644
--- a/regression-test/data/variant_p0/sql/gh_data.out
+++ b/regression-test/data/variant_p0/sql/gh_data.out
@@ -75,76 +75,3 @@ disclose/diodata 2
64890096 1
73801003 1
--- !gh_data_13 --
-7702
-
--- !gh_data_14 --
-prakhar1989/awesome-courses 6
-Anchor89/GithubHub 4
-imgix/imgix-emacs 4
-isohuntto/openbay 4
-kragniz/json-sempai 4
-
--- !gh_data_15 --
-2489395761
-
--- !gh_data_16 --
-19158286365944
-
--- !gh_data_17 --
-90304716
-
--- !gh_data_18 --
-0
-
--- !gh_data_19 --
-15512
-
--- !gh_data_20 --
-\N
-\N
-\N
-\N
-\N
-\N
-\N
-\N
-\N
-\N
-
--- !gh_data_21 --
-4323109
-631394
-2336602
-9909555
-6253494
-9761181
-631394
-10263666
-2035977
-5261908
-
--- !gh_data_22 --
-66
{"payload":{"action":"started"},"created_at":"2015-01-01T00:00:18Z","id":"2489368319","org":{"gravatar_id":"","url":"https://api.github.com/orgs/LinuxStandardBase","id":7116887,"login":"LinuxStandardBase","avatar_url":"https://avatars.githubusercontent.com/u/7116887?"},"public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/jchristi","id":642929,"login":"jchristi","avatar_url":"https://avatars.githubusercontent.com/u/642929?"},"repo":{"url":"https://api.github.com/rep
[...]
-73
{"payload":{"action":"started"},"created_at":"2015-01-01T00:00:24Z","id":"2489368389","public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/tategakibunko","id":1405427,"login":"tategakibunko","avatar_url":"https://avatars.githubusercontent.com/u/1405427?"},"repo":{"url":"https://api.github.com/repos/inf0rmer/blanket","id":28229924,"name":"inf0rmer/blanket"},"type":"WatchEvent"}
-92
{"payload":{"action":"started"},"created_at":"2015-01-01T00:00:35Z","id":"2489368485","public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/alfateam123","id":1429402,"login":"alfateam123","avatar_url":"https://avatars.githubusercontent.com/u/1429402?"},"repo":{"url":"https://api.github.com/repos/parrt/cs652","id":28676020,"name":"parrt/cs652"},"type":"WatchEvent"}
-120
{"payload":{"action":"started"},"created_at":"2015-01-01T00:00:42Z","id":"2489368584","org":{"gravatar_id":"","url":"https://api.github.com/orgs/Pathgather","id":5741669,"login":"Pathgather","avatar_url":"https://avatars.githubusercontent.com/u/5741669?"},"public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/senthilnathansk","id":7419955,"login":"senthilnathansk","avatar_url":"https://avatars.githubusercontent.com/u/7419955?"},"repo":{"url":"https://api.github.com/
[...]
-150
{"payload":{"action":"started"},"created_at":"2015-01-01T00:00:50Z","id":"2489368664","public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/teamcrisis","id":4693056,"login":"teamcrisis","avatar_url":"https://avatars.githubusercontent.com/u/4693056?"},"repo":{"url":"https://api.github.com/repos/jtsternberg/Shortcode_Button","id":24036844,"name":"jtsternberg/Shortcode_Button"},"type":"WatchEvent"}
-168
{"payload":{"action":"started"},"created_at":"2015-01-01T00:00:57Z","id":"2489368733","org":{"gravatar_id":"","url":"https://api.github.com/orgs/EnterpriseQualityCoding","id":5183851,"login":"EnterpriseQualityCoding","avatar_url":"https://avatars.githubusercontent.com/u/5183851?"},"public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/albertchau","id":6622162,"login":"albertchau","avatar_url":"https://avatars.githubusercontent.com/u/6622162?"},"repo":{"url":"https:/
[...]
-170
{"payload":{"action":"started"},"created_at":"2015-01-01T00:00:59Z","id":"2489368739","public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/coolsquid","id":9624459,"login":"coolsquid","avatar_url":"https://avatars.githubusercontent.com/u/9624459?"},"repo":{"url":"https://api.github.com/repos/VictiniX888/Illegal-Mod-Sites","id":28660659,"name":"VictiniX888/Illegal-Mod-Sites"},"type":"WatchEvent"}
-178
{"payload":{"action":"started"},"created_at":"2015-01-01T00:01:02Z","id":"2489368777","public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/timesking","id":1159474,"login":"timesking","avatar_url":"https://avatars.githubusercontent.com/u/1159474?"},"repo":{"url":"https://api.github.com/repos/robfig/cron","id":4925652,"name":"robfig/cron"},"type":"WatchEvent"}
-230
{"payload":{"action":"started"},"created_at":"2015-01-01T00:01:27Z","id":"2489368981","public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/alfateam123","id":1429402,"login":"alfateam123","avatar_url":"https://avatars.githubusercontent.com/u/1429402?"},"repo":{"url":"https://api.github.com/repos/brendangregg/FlameGraph","id":2992074,"name":"brendangregg/FlameGraph"},"type":"WatchEvent"}
-234
{"payload":{"action":"started"},"created_at":"2015-01-01T00:01:30Z","id":"2489369013","org":{"gravatar_id":"","url":"https://api.github.com/orgs/h5bp","id":1136800,"login":"h5bp","avatar_url":"https://avatars.githubusercontent.com/u/1136800?"},"public":1,"actor":{"gravatar_id":"","url":"https://api.github.com/users/shahar96","id":6722439,"login":"shahar96","avatar_url":"https://avatars.githubusercontent.com/u/6722439?"},"repo":{"url":"https://api.github.com/repos/h5bp/Front-end-Devel
[...]
-
--- !gh_data_23 --
-258620 1
-631394 2
-2035977 1
-2336602 1
-4323109 1
-5261908 1
-5975010 1
-6253494 1
-6491067 1
-7882662 1
-
diff --git
a/regression-test/suites/variant_p0/github_events_p0/affinityByIssuesAndPRs1.sql
b/regression-test/suites/variant_github_events_p0/affinityByIssuesAndPRs1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/affinityByIssuesAndPRs1.sql
rename to
regression-test/suites/variant_github_events_p0/affinityByIssuesAndPRs1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/affinityByIssuesAndPRs2.sql
b/regression-test/suites/variant_github_events_p0/affinityByIssuesAndPRs2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/affinityByIssuesAndPRs2.sql
rename to
regression-test/suites/variant_github_events_p0/affinityByIssuesAndPRs2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/authorsWithTheMostPushes.sql
b/regression-test/suites/variant_github_events_p0/authorsWithTheMostPushes.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/authorsWithTheMostPushes.sql
rename to
regression-test/suites/variant_github_events_p0/authorsWithTheMostPushes.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/countingStar1.sql
b/regression-test/suites/variant_github_events_p0/countingStar1.sql
similarity index 100%
rename from regression-test/suites/variant_p0/github_events_p0/countingStar1.sql
rename to regression-test/suites/variant_github_events_p0/countingStar1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/countingStar2.sql
b/regression-test/suites/variant_github_events_p0/countingStar2.sql
similarity index 100%
rename from regression-test/suites/variant_p0/github_events_p0/countingStar2.sql
rename to regression-test/suites/variant_github_events_p0/countingStar2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/countingStar3.sql
b/regression-test/suites/variant_github_events_p0/countingStar3.sql
similarity index 100%
rename from regression-test/suites/variant_p0/github_events_p0/countingStar3.sql
rename to regression-test/suites/variant_github_events_p0/countingStar3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/distributionOfRepositoriesByStarCount.sql
b/regression-test/suites/variant_github_events_p0/distributionOfRepositoriesByStarCount.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/distributionOfRepositoriesByStarCount.sql
rename to
regression-test/suites/variant_github_events_p0/distributionOfRepositoriesByStarCount.sql
diff --git a/regression-test/suites/variant_github_events_p0/githubRoulette.sql
b/regression-test/suites/variant_github_events_p0/githubRoulette.sql
new file mode 100644
index 00000000000..0a644baebce
--- /dev/null
+++ b/regression-test/suites/variant_github_events_p0/githubRoulette.sql
@@ -0,0 +1 @@
+-- SELECT cast(v:repo.name as string) FROM github_events WHERE cast(v:type as
string) = 'WatchEvent' ORDER BY cast(v:created_at as datetime),
cast(v:repo.name as string) LIMIT 50
\ No newline at end of file
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
b/regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
rename to
regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
b/regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
rename to
regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
b/regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
rename to
regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
b/regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
rename to
regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
b/regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
rename to
regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
b/regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
rename to
regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
b/regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
rename to
regression-test/suites/variant_github_events_p0/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
diff --git
a/regression-test/suites/variant_github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.sql
b/regression-test/suites/variant_github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.sql
new file mode 100644
index 00000000000..b299013d5c2
--- /dev/null
+++
b/regression-test/suites/variant_github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.sql
@@ -0,0 +1,2 @@
+-- SELECT year(cast(v:created_at as datetime)) AS year, count() AS stars FROM
github_events WHERE cast(v:type as string) = 'WatchEvent' GROUP BY year ORDER
BY year
+
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments1.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments1.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments2.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments2.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments3.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments3.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments4.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments4.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments4.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments4.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments5.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments5.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments5.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments5.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments6.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments6.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments6.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments6.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments7.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments7.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments7.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments7.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments8.sql
b/regression-test/suites/variant_github_events_p0/issuesWithTheMostComments8.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/issuesWithTheMostComments8.sql
rename to
regression-test/suites/variant_github_events_p0/issuesWithTheMostComments8.sql
diff --git a/regression-test/suites/variant_p0/github_events_p0/load.groovy
b/regression-test/suites/variant_github_events_p0/load.groovy
similarity index 100%
rename from regression-test/suites/variant_p0/github_events_p0/load.groovy
rename to regression-test/suites/variant_github_events_p0/load.groovy
diff --git
a/regression-test/suites/variant_p0/github_events_p0/mostForkedRepositories.sql
b/regression-test/suites/variant_github_events_p0/mostForkedRepositories.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/mostForkedRepositories.sql
rename to
regression-test/suites/variant_github_events_p0/mostForkedRepositories.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/mostPopularCommentsOnGithub.sql
b/regression-test/suites/variant_github_events_p0/mostPopularCommentsOnGithub.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/mostPopularCommentsOnGithub.sql
rename to
regression-test/suites/variant_github_events_p0/mostPopularCommentsOnGithub.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/organizationsByTheNumberOfRepositories.sql
b/regression-test/suites/variant_github_events_p0/organizationsByTheNumberOfRepositories.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/organizationsByTheNumberOfRepositories.sql
rename to
regression-test/suites/variant_github_events_p0/organizationsByTheNumberOfRepositories.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/organizationsByTheNumberOfStars.sql
b/regression-test/suites/variant_github_events_p0/organizationsByTheNumberOfStars.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/organizationsByTheNumberOfStars.sql
rename to
regression-test/suites/variant_github_events_p0/organizationsByTheNumberOfStars.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/organizationsByTheSizeOfCommunity.sql
b/regression-test/suites/variant_github_events_p0/organizationsByTheSizeOfCommunity.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/organizationsByTheSizeOfCommunity.sql
rename to
regression-test/suites/variant_github_events_p0/organizationsByTheSizeOfCommunity.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks1.sql
b/regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks1.sql
rename to
regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks2.sql
b/regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks2.sql
rename to
regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks3.sql
b/regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks3.sql
rename to
regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks4.sql
b/regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks4.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks4.sql
rename to
regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks4.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks5.sql
b/regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks5.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/proportionsBetweenStarsAndForks5.sql
rename to
regression-test/suites/variant_github_events_p0/proportionsBetweenStarsAndForks5.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesByAmountOfModifiedCode.sql
b/regression-test/suites/variant_github_events_p0/repositoriesByAmountOfModifiedCode.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesByAmountOfModifiedCode.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesByAmountOfModifiedCode.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesByTheNumberOfPushes.sql
b/regression-test/suites/variant_github_events_p0/repositoriesByTheNumberOfPushes.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesByTheNumberOfPushes.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesByTheNumberOfPushes.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments1.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithClickhouse_related_comments1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments1.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithClickhouse_related_comments1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments2.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithClickhouse_related_comments2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithClickhouse_related_comments2.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithClickhouse_related_comments2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithDoris_related_comments1.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithDoris_related_comments1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithDoris_related_comments1.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithDoris_related_comments1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithDoris_related_comments2.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithDoris_related_comments2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithDoris_related_comments2.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithDoris_related_comments2.sql
diff --git
a/regression-test/suites/variant_github_events_p0/repositoriesWithTheHighestGrowthYoY.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheHighestGrowthYoY.sql
new file mode 100644
index 00000000000..e5feb7b22a8
--- /dev/null
+++
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheHighestGrowthYoY.sql
@@ -0,0 +1,21 @@
+-- SELECT
+-- repo_name,
+-- sum(created_at_2022) AS stars2022,
+-- sum(created_at_2015) AS stars2015,
+-- round(sum(created_at_2022) / sum(created_at_2015), 3) AS yoy,
+-- min(created_at) AS first_seen
+-- FROM
+-- (
+-- SELECT
+-- cast(v:repo.name as string) as repo_name,
+-- CASE year(cast(v:created_at as datetime)) WHEN 2022 THEN 1 ELSE 0
END AS created_at_2022,
+-- CASE year(cast(v:created_at as datetime)) WHEN 2015 THEN 1 ELSE 0
END AS created_at_2015,
+-- cast(v:created_at as datetime) as created_at
+-- FROM github_events
+-- WHERE cast(v:type as string) = 'WatchEvent'
+-- ) t
+-- GROUP BY repo_name
+-- HAVING (min(created_at) <= '2023-01-01 00:00:00') AND (stars2022 >= 1) and
(stars2015 >= 1)
+-- ORDER BY yoy DESC, repo_name
+-- LIMIT 50
+--
\ No newline at end of file
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfIssues4.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumAmountOfPullRequests2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay2.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay1.sql
similarity index 63%
copy from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay2.sql
copy to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay1.sql
index 9f07d2270d1..65af5fa4d52 100644
---
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay2.sql
+++
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay1.sql
@@ -1,18 +1,18 @@
-- SELECT
--- cast(v:repo.name as string),
+-- repo_name,
-- day,
-- stars
-- FROM
-- (
-- SELECT
--- row_number() OVER (PARTITION BY cast(v:repo.name as string) ORDER
BY stars DESC) AS rank,
--- cast(v:repo.name as string),
+-- row_number() OVER (PARTITION BY repo_name ORDER BY stars DESC) AS
rank,
+-- repo_name,
-- day,
-- stars
-- FROM
-- (
-- SELECT
--- cast(v:repo.name as string),
+-- cast(v:repo.name as string) as repo_name,
-- to_date(cast(v:created_at as datetime)) AS day,
-- count() AS stars
-- FROM github_events
@@ -21,5 +21,6 @@
-- ) t1
-- ) t2
-- WHERE rank = 1
--- ORDER BY stars DESC
+-- ORDER BY stars DESC, 1
-- LIMIT 50
+--
\ No newline at end of file
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay2.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay2.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay3.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay3.sql
rename to
regression-test/suites/variant_github_events_p0/repositoriesWithTheMostStarsOverOneDay3.sql
diff --git
a/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.sql
new file mode 100644
index 00000000000..a886ea71ea5
--- /dev/null
+++
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.sql
@@ -0,0 +1,21 @@
+-- SELECT
+-- repo_name,
+-- max(stars) AS daily_stars,
+-- sum(stars) AS total_stars,
+-- sum(stars) / max(stars) AS rate
+-- FROM
+-- (
+-- SELECT
+-- cast(v:repo.name as string) as repo_name,
+-- to_date(cast(v:created_at as datetime)) AS day,
+-- count() AS stars
+-- FROM github_events
+-- WHERE cast(v:type as string) = 'WatchEvent'
+-- GROUP BY
+-- repo_name,
+-- day
+-- ) t
+-- GROUP BY repo_name
+-- ORDER BY rate DESC, 1
+-- LIMIT 50
+--
\ No newline at end of file
diff --git
a/regression-test/suites/variant_github_events_p0/repositoriesWithTheWorstStagnation_order.sql
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheWorstStagnation_order.sql
new file mode 100644
index 00000000000..5f08bdb13ec
--- /dev/null
+++
b/regression-test/suites/variant_github_events_p0/repositoriesWithTheWorstStagnation_order.sql
@@ -0,0 +1,21 @@
+-- SELECT
+-- repo_name,
+-- sum(created_at_2022) AS stars2022,
+-- sum(created_at_2015) AS stars2015,
+-- round(sum(created_at_2022) / sum(created_at_2015), 3) AS yoy,
+-- min(created_at) AS first_seen
+-- FROM
+-- (
+-- SELECT
+-- cast(v:repo.name as string) as repo_name,
+-- CASE year(cast(v:created_at as datetime)) WHEN 2022 THEN 1 ELSE 0
END AS created_at_2022,
+-- CASE year(cast(v:created_at as datetime)) WHEN 2015 THEN 1 ELSE 0
END AS created_at_2015,
+-- cast(v:created_at as datetime) as created_at
+-- FROM github_events
+-- WHERE cast(v:type as string) = 'WatchEvent'
+-- ) t
+-- GROUP BY repo_name
+-- HAVING (min(created_at) <= '2019-01-01 00:00:00') AND (max(created_at) >=
'2020-06-01 00:00:00') AND (stars2015 >= 2)
+-- ORDER BY yoy, repo_name
+-- LIMIT 50
+--
\ No newline at end of file
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoryAffinityList1.sql
b/regression-test/suites/variant_github_events_p0/repositoryAffinityList1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoryAffinityList1.sql
rename to
regression-test/suites/variant_github_events_p0/repositoryAffinityList1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoryAffinityList2.sql
b/regression-test/suites/variant_github_events_p0/repositoryAffinityList2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/repositoryAffinityList2.sql
rename to
regression-test/suites/variant_github_events_p0/repositoryAffinityList2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/starsFromHeavyGithubUsers1.sql
b/regression-test/suites/variant_github_events_p0/starsFromHeavyGithubUsers1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/starsFromHeavyGithubUsers1.sql
rename to
regression-test/suites/variant_github_events_p0/starsFromHeavyGithubUsers1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/starsFromHeavyGithubUsers2.sql
b/regression-test/suites/variant_github_events_p0/starsFromHeavyGithubUsers2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/starsFromHeavyGithubUsers2.sql
rename to
regression-test/suites/variant_github_events_p0/starsFromHeavyGithubUsers2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theLongestRepositoryNames1.sql
b/regression-test/suites/variant_github_events_p0/theLongestRepositoryNames1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theLongestRepositoryNames1.sql
rename to
regression-test/suites/variant_github_events_p0/theLongestRepositoryNames1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theLongestRepositoryNames2.sql
b/regression-test/suites/variant_github_events_p0/theLongestRepositoryNames2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theLongestRepositoryNames2.sql
rename to
regression-test/suites/variant_github_events_p0/theLongestRepositoryNames2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theMostToughCodeReviews.sql
b/regression-test/suites/variant_github_events_p0/theMostToughCodeReviews.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theMostToughCodeReviews.sql
rename to
regression-test/suites/variant_github_events_p0/theMostToughCodeReviews.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfRepositoriesOnGithub.sql
b/regression-test/suites/variant_github_events_p0/theTotalNumberOfRepositoriesOnGithub.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfRepositoriesOnGithub.sql
rename to
regression-test/suites/variant_github_events_p0/theTotalNumberOfRepositoriesOnGithub.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub1.sql
b/regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub1.sql
rename to
regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub2.sql
b/regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub2.sql
rename to
regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub3.sql
b/regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub3.sql
rename to
regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub4.sql
b/regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub4.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/theTotalNumberOfUsersOnGithub4.sql
rename to
regression-test/suites/variant_github_events_p0/theTotalNumberOfUsersOnGithub4.sql
diff --git a/regression-test/suites/variant_p0/github_events_p0/topLabels1.sql
b/regression-test/suites/variant_github_events_p0/topLabels1.sql
similarity index 100%
rename from regression-test/suites/variant_p0/github_events_p0/topLabels1.sql
rename to regression-test/suites/variant_github_events_p0/topLabels1.sql
diff --git a/regression-test/suites/variant_p0/github_events_p0/topLabels2.sql
b/regression-test/suites/variant_github_events_p0/topLabels2.sql
similarity index 100%
rename from regression-test/suites/variant_p0/github_events_p0/topLabels2.sql
rename to regression-test/suites/variant_github_events_p0/topLabels2.sql
diff --git a/regression-test/suites/variant_p0/github_events_p0/topLabels3.sql
b/regression-test/suites/variant_github_events_p0/topLabels3.sql
similarity index 100%
rename from regression-test/suites/variant_p0/github_events_p0/topLabels3.sql
rename to regression-test/suites/variant_github_events_p0/topLabels3.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/topRepositoriesByStars.sql
b/regression-test/suites/variant_github_events_p0/topRepositoriesByStars.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/topRepositoriesByStars.sql
rename to
regression-test/suites/variant_github_events_p0/topRepositoriesByStars.sql
diff --git
a/regression-test/suites/variant_github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.sql
b/regression-test/suites/variant_github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.sql
new file mode 100644
index 00000000000..2f3e17a494a
--- /dev/null
+++
b/regression-test/suites/variant_github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.sql
@@ -0,0 +1 @@
+-- SELECT dayofweek(cast(v:created_at as datetime)) AS day, count() AS stars
FROM github_events WHERE cast(v:type as string) = 'WatchEvent' GROUP BY day
ORDER BY day
diff --git
a/regression-test/suites/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars1.sql
b/regression-test/suites/variant_github_events_p0/whoAreAllThosePeopleGivingStars1.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars1.sql
rename to
regression-test/suites/variant_github_events_p0/whoAreAllThosePeopleGivingStars1.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars2.sql
b/regression-test/suites/variant_github_events_p0/whoAreAllThosePeopleGivingStars2.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars2.sql
rename to
regression-test/suites/variant_github_events_p0/whoAreAllThosePeopleGivingStars2.sql
diff --git
a/regression-test/suites/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars3.sql
b/regression-test/suites/variant_github_events_p0/whoAreAllThosePeopleGivingStars3.sql
similarity index 100%
rename from
regression-test/suites/variant_p0/github_events_p0/whoAreAllThosePeopleGivingStars3.sql
rename to
regression-test/suites/variant_github_events_p0/whoAreAllThosePeopleGivingStars3.sql
diff --git a/regression-test/suites/variant_p0/desc.groovy
b/regression-test/suites/variant_p0/desc.groovy
index 6157a005c79..c112a20988c 100644
--- a/regression-test/suites/variant_p0/desc.groovy
+++ b/regression-test/suites/variant_p0/desc.groovy
@@ -155,6 +155,7 @@ suite("regression_test_variant_desc", "variant_type_desc"){
// more variant
table_name = "more_variant_table"
+ sql "DROP TABLE IF EXISTS ${table_name}"
sql """
CREATE TABLE IF NOT EXISTS ${table_name} (
k bigint,
@@ -173,6 +174,7 @@ suite("regression_test_variant_desc", "variant_type_desc"){
// describe_extend_variant_column = false
sql """set describe_extend_variant_column = false"""
table_name = "no_extend_variant_column"
+ sql "DROP TABLE IF EXISTS ${table_name}"
sql """
CREATE TABLE IF NOT EXISTS ${table_name} (
k bigint,
@@ -183,12 +185,14 @@ suite("regression_test_variant_desc",
"variant_type_desc"){
properties("replication_num" = "1", "disable_auto_compaction" =
"false");
"""
sql """ insert into ${table_name} values (0, '{"a": 1123, "b" : [123,
{"xx" : 1}], "c" : {"c" : 456, "d" : null, "e" : 7.111}, "zzz" : null, "oooo" :
{"akakaka" : null, "xxxx" : {"xxx" : 123}}}')"""
+ sql "sync"
qt_sql_9 """desc ${table_name}"""
sql """set describe_extend_variant_column = true"""
- qt_sql_9_1 """desc ${table_name}"""
+ // qt_sql_9_1 """desc ${table_name}"""
sql "truncate table ${table_name}"
sql """insert into ${table_name} values (1, '{"中文": "这是中文"}')"""
sql """insert into ${table_name} values (2, '{"英文": "This is
english"}')"""
+ sql "sync"
qt_sql_9_2 """desc ${table_name}"""
qt_sql_9_2 """select cast(v:中文 as string) from ${table_name} order by
k"""
} finally {
diff --git
a/regression-test/suites/variant_p0/github_events_p0/githubRoulette.sql
b/regression-test/suites/variant_p0/github_events_p0/githubRoulette.sql
deleted file mode 100644
index cda527b69f6..00000000000
--- a/regression-test/suites/variant_p0/github_events_p0/githubRoulette.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v:repo.name as string) FROM github_events WHERE cast(v:type as
string) = 'WatchEvent' ORDER BY cast(v:created_at as datetime),
cast(v:repo.name as string) LIMIT 50
\ No newline at end of file
diff --git
a/regression-test/suites/variant_p0/github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.sql
b/regression-test/suites/variant_p0/github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.sql
deleted file mode 100644
index 97874a2d1e5..00000000000
---
a/regression-test/suites/variant_p0/github_events_p0/howHasTheTotalNumberOfStarsChangedOverTime.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-SELECT year(cast(v:created_at as datetime)) AS year, count() AS stars FROM
github_events WHERE cast(v:type as string) = 'WatchEvent' GROUP BY year ORDER
BY year
-
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheHighestGrowthYoY.sql
b/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheHighestGrowthYoY.sql
deleted file mode 100644
index e8ba7153a76..00000000000
---
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheHighestGrowthYoY.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT
- repo_name,
- sum(created_at_2022) AS stars2022,
- sum(created_at_2015) AS stars2015,
- round(sum(created_at_2022) / sum(created_at_2015), 3) AS yoy,
- min(created_at) AS first_seen
-FROM
-(
- SELECT
- cast(v:repo.name as string) as repo_name,
- CASE year(cast(v:created_at as datetime)) WHEN 2022 THEN 1 ELSE 0 END
AS created_at_2022,
- CASE year(cast(v:created_at as datetime)) WHEN 2015 THEN 1 ELSE 0 END
AS created_at_2015,
- cast(v:created_at as datetime) as created_at
- FROM github_events
- WHERE cast(v:type as string) = 'WatchEvent'
-) t
-GROUP BY repo_name
-HAVING (min(created_at) <= '2023-01-01 00:00:00') AND (stars2022 >= 1) and
(stars2015 >= 1)
-ORDER BY yoy DESC, repo_name
-LIMIT 50
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay1.sql
b/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay1.sql
deleted file mode 100644
index c7b81b2408d..00000000000
---
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostStarsOverOneDay1.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-SELECT
- repo_name,
- day,
- stars
-FROM
-(
- SELECT
- row_number() OVER (PARTITION BY repo_name ORDER BY stars DESC) AS
rank,
- repo_name,
- day,
- stars
- FROM
- (
- SELECT
- cast(v:repo.name as string) as repo_name,
- to_date(cast(v:created_at as datetime)) AS day,
- count() AS stars
- FROM github_events
- WHERE cast(v:type as string) = 'WatchEvent'
- GROUP BY cast(v:repo.name as string), day
- ) t1
-) t2
-WHERE rank = 1
-ORDER BY stars DESC, 1
-LIMIT 50
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.sql
b/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.sql
deleted file mode 100644
index 5c7d2d7c7b0..00000000000
---
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheMostSteadyGrowthOverTime.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT
- repo_name,
- max(stars) AS daily_stars,
- sum(stars) AS total_stars,
- sum(stars) / max(stars) AS rate
-FROM
-(
- SELECT
- cast(v:repo.name as string) as repo_name,
- to_date(cast(v:created_at as datetime)) AS day,
- count() AS stars
- FROM github_events
- WHERE cast(v:type as string) = 'WatchEvent'
- GROUP BY
- repo_name,
- day
-) t
-GROUP BY repo_name
-ORDER BY rate DESC, 1
-LIMIT 50
diff --git
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheWorstStagnation_order.sql
b/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheWorstStagnation_order.sql
deleted file mode 100644
index 2265f4b5e4f..00000000000
---
a/regression-test/suites/variant_p0/github_events_p0/repositoriesWithTheWorstStagnation_order.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT
- repo_name,
- sum(created_at_2022) AS stars2022,
- sum(created_at_2015) AS stars2015,
- round(sum(created_at_2022) / sum(created_at_2015), 3) AS yoy,
- min(created_at) AS first_seen
-FROM
-(
- SELECT
- cast(v:repo.name as string) as repo_name,
- CASE year(cast(v:created_at as datetime)) WHEN 2022 THEN 1 ELSE 0 END
AS created_at_2022,
- CASE year(cast(v:created_at as datetime)) WHEN 2015 THEN 1 ELSE 0 END
AS created_at_2015,
- cast(v:created_at as datetime) as created_at
- FROM github_events
- WHERE cast(v:type as string) = 'WatchEvent'
-) t
-GROUP BY repo_name
-HAVING (min(created_at) <= '2019-01-01 00:00:00') AND (max(created_at) >=
'2020-06-01 00:00:00') AND (stars2015 >= 2)
-ORDER BY yoy, repo_name
-LIMIT 50
diff --git
a/regression-test/suites/variant_p0/github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.sql
b/regression-test/suites/variant_p0/github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.sql
deleted file mode 100644
index 0c930308cf9..00000000000
---
a/regression-test/suites/variant_p0/github_events_p0/whatIsTheBestDayOfTheWeekToCatchAStar.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT dayofweek(cast(v:created_at as datetime)) AS day, count() AS stars FROM
github_events WHERE cast(v:type as string) = 'WatchEvent' GROUP BY day ORDER BY
day
diff --git a/regression-test/suites/variant_p0/sql/gh_data.sql
b/regression-test/suites/variant_p0/sql/gh_data.sql
index 1f03610b87d..7eae73a9faa 100644
--- a/regression-test/suites/variant_p0/sql/gh_data.sql
+++ b/regression-test/suites/variant_p0/sql/gh_data.sql
@@ -10,18 +10,4 @@ SELECT v:payload.commits.author.name FROM ghdata ORDER BY k
LIMIT 10;
SELECT v:payload.member.id FROM ghdata where cast(v:payload.member.id as
string) is not null ORDER BY k LIMIT 10;
-- select k, v:payload.commits.author.name AS name, e FROM ghdata as t lateral
view explode(cast(v:payload.commits.author.name as array<string>)) tm1 as e
order by k limit 5;
select k, v from ghdata WHERE cast(v:type as string) = 'WatchEvent' order by
k limit 10;
-SELECT cast(v:payload.member.id as bigint), count() FROM ghdata where
cast(v:payload.member.id as bigint) is not null group by
cast(v:payload.member.id as bigint) order by 1, 2 desc LIMIT 10;
-
-
-SELECT count() from github_events;
-SELECT cast(v:repo.name as string), count() AS stars FROM github_events WHERE
cast(v:type as string) = 'WatchEvent' GROUP BY cast(v:repo.name as string)
ORDER BY stars DESC, cast(v:repo.name as string) LIMIT 5;
-SELECT max(cast(cast(v:`id` as string) as bigint)) FROM github_events;
-SELECT sum(cast(cast(v:`id` as string) as bigint)) FROM github_events;
-SELECT sum(cast(v:payload.member.id as bigint)) FROM github_events;
-SELECT sum(cast(v:payload.pull_request.milestone.creator.site_admin as
bigint)) FROM github_events;
-SELECT sum(length(v:payload.pull_request.base.repo.html_url)) FROM
github_events;
-SELECT v:payload.commits.author.name FROM github_events ORDER BY k LIMIT 10;
-SELECT v:payload.member.id FROM github_events where cast(v:payload.member.id
as string) is not null ORDER BY k LIMIT 10;
--- select k, v:payload.commits.author.name AS name, e FROM github_events as t
lateral view explode(cast(v:payload.commits.author.name as array<string>)) tm1
as e order by k limit 5;
-select k, v from github_events WHERE cast(v:type as string) = 'WatchEvent'
order by k limit 10;
-SELECT cast(v:payload.member.id as bigint), count() FROM github_events where
cast(v:payload.member.id as bigint) is not null group by
cast(v:payload.member.id as bigint) order by 1, 2 desc LIMIT 10;
\ No newline at end of file
+SELECT cast(v:payload.member.id as bigint), count() FROM ghdata where
cast(v:payload.member.id as bigint) is not null group by
cast(v:payload.member.id as bigint) order by 1, 2 desc LIMIT 10;
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
