Full database table scan
Open
Nobody has claimed this yet.
1. to develop
bug
- Dominant language
- JavaScript
- Stars
- 177
- Forks
- 68
- Avg merge
- 2d 22h
- Merged PRs (30d)
- 60
Description
SELECT
`cc`.`unique_id`,
`cc`.`name`,
`cc`.`display_name`,
`cc`.`sanitized_name`,
`cc`.`source`,
`cc`.`description`,
`cc`.`settings`,
`cc`.`config`,
`cc`.`contact_addressbook`,
`cc`.`contact_groupname`,
`cc`.`creation`,
`cc_wn`.`circle_id` AS `cc_wn_circle_id`,
`cc_wn`.`member_id` AS `cc_wn_member_id`,
`cc_wn`.`single_id` AS `cc_wn_single_id`,
`cc_wn`.`user_id` AS `cc_wn_user_id`,
`cc_wn`.`instance` AS `cc_wn_instance`,
`cc_wn`.`user_type` AS `cc_wn_user_type`,
`cc_wn`.`level` AS `cc_wn_level`,
`cc_wn`.`status` AS `cc_wn_status`,
`cc_wn`.`note` AS `cc_wn_note`,
`cc_wn`.`contact_id` AS `cc_wn_contact_id`,
`cc_wn`.`cached_name` AS `cc_wn_cached_name`,
`cc_wn`.`cached_update` AS `cc_wn_cached_update`,
`cc_wn`.`contact_meta` AS `cc_wn_contact_meta`,
`cc_wn`.`joined` AS `cc_wn_joined`,
`cc_wn_on`.`unique_id` AS `cc_wn_on_unique_id`,
`cc_wn_on`.`name` AS `cc_wn_on_name`,
`cc_wn_on`.
(truncated)
The full query and the feature triggering this are unknown.
Query ID: c331886a84959a9d6aa62e86f7f6acc4
Nextcloud v27.1.11
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No source file, test, or entry point is mentioned; the report contains only a truncated SQL query, Query ID c331886a84959a9d6aa62e86f7f6acc4, and Nextcloud v27.1.11. Start by locating that query in the relevant instance or logs and identify the feature that triggers it. Done should include a reproducible trigger and a verified resolution for the full table scan.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100