github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-12 02:24:21 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

[PR #5136] [MERGED] This commit will reduce join star, repo_topic, topic tables on repo search, so that fix extra columns problem on mssql #17663

New Issue
Closed
opened 2025-11-02 14:50:43 -06:00 by GiteaMirror · 0 comments
GiteaMirror commented 2025-11-02 14:50:43 -06:00
Owner
Copy Link

📋 Pull Request Information

Original PR: https://github.com/go-gitea/gitea/pull/5136
Author: @lunny
Created: 10/22/2018
Status: ✅ Merged
Merged: 10/30/2018
Merged by: @techknowlogick

Base: master ← Head: lunny/fix_mssql_repo_search

📝 Commits (9)

  • 9c5fce4 This commit will reduce join star, repo_topic, topic tables on repo search, so that fix extra columns problem on mssql
  • 0d2dd17 fix tests
  • b91aba8 Merge branch 'master' into lunny/fix_mssql_repo_search
  • 2a282be Merge branch 'master' into lunny/fix_mssql_repo_search
  • 95b3de3 Merge branch 'master' into lunny/fix_mssql_repo_search
  • d8e8c42 Merge branch 'master' into lunny/fix_mssql_repo_search
  • 874e302 Merge branch 'master' into lunny/fix_mssql_repo_search
  • eb075bc Merge branch 'master' into lunny/fix_mssql_repo_search
  • 49217f5 Merge branch 'master' into lunny/fix_mssql_repo_search

📊 Changes

2 files changed (+17 additions, -37 deletions)

View changed files

📝 models/repo_list.go (+16 -36)
📝 models/repo_list_test.go (+1 -1)

📄 Description

This commit removed join star, repo_topic, topic tables on repo search, so that fix extra columns problem on mssql database. Also, it maybe results in some performance reduce since it used some sub query instead join query.
This will partilly fix #4282.

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/go-gitea/gitea/pull/5136 **Author:** [@lunny](https://github.com/lunny) **Created:** 10/22/2018 **Status:** ✅ Merged **Merged:** 10/30/2018 **Merged by:** [@techknowlogick](https://github.com/techknowlogick) **Base:** `master` ← **Head:** `lunny/fix_mssql_repo_search` --- ### 📝 Commits (9) - [`9c5fce4`](https://github.com/go-gitea/gitea/commit/9c5fce46277f6ecbb56a0a6fe4e40ce43d326c92) This commit will reduce join star, repo_topic, topic tables on repo search, so that fix extra columns problem on mssql - [`0d2dd17`](https://github.com/go-gitea/gitea/commit/0d2dd1789202f84d083fcdac9f5776693a948462) fix tests - [`b91aba8`](https://github.com/go-gitea/gitea/commit/b91aba8eee84030647c9dc7881b7eebf30edf1fe) Merge branch 'master' into lunny/fix_mssql_repo_search - [`2a282be`](https://github.com/go-gitea/gitea/commit/2a282be92f156a4f7a438946ca7eac5bda2b2101) Merge branch 'master' into lunny/fix_mssql_repo_search - [`95b3de3`](https://github.com/go-gitea/gitea/commit/95b3de3672269d777c6ffb3fefded43087afc0af) Merge branch 'master' into lunny/fix_mssql_repo_search - [`d8e8c42`](https://github.com/go-gitea/gitea/commit/d8e8c4248813e7f1dd04f8aac5b42f1629d91509) Merge branch 'master' into lunny/fix_mssql_repo_search - [`874e302`](https://github.com/go-gitea/gitea/commit/874e3024df92fc0d9e7fac9482a370097b690420) Merge branch 'master' into lunny/fix_mssql_repo_search - [`eb075bc`](https://github.com/go-gitea/gitea/commit/eb075bc786a4844ab2a402a2e5fba55af0a1bb0e) Merge branch 'master' into lunny/fix_mssql_repo_search - [`49217f5`](https://github.com/go-gitea/gitea/commit/49217f54ff6025b6df869b42d346f78d1e76e1c1) Merge branch 'master' into lunny/fix_mssql_repo_search ### 📊 Changes **2 files changed** (+17 additions, -37 deletions) <details> <summary>View changed files</summary> 📝 `models/repo_list.go` (+16 -36) 📝 `models/repo_list_test.go` (+1 -1) </details> ### 📄 Description This commit removed join star, repo_topic, topic tables on repo search, so that fix extra columns problem on mssql database. Also, it maybe results in some performance reduce since it used some sub query instead join query. This will partilly fix #4282. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2025-11-02 14:50:43 -06:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#17663
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?