Skip to content

Issues: cockroachdb/cockroach

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Author
Filter by author
Loading
Label
Filter by label
Loading
Use alt + click/return to exclude labels
or + click/return for logical OR
Projects
Filter by project
Loading
Milestones
Filter by milestone
Loading
Assignee
Filter by who’s assigned
Sort

Issues list

sql: transaction error for post-queries during EXPLAIN ANALYZE A-sql-trigger Triggers and Trigger Functions branch-master Failures and bugs on the master branch. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-queries SQL Queries Team
#135157 opened Nov 14, 2024 by DrewKimball
sql: show AFTER triggers in EXPLAIN output A-sql-trigger Triggers and Trigger Functions C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#135155 opened Nov 14, 2024 by DrewKimball
Creating an empty trigger on a view causes a nil pointer exception A-sql-trigger Triggers and Trigger Functions branch-master Failures and bugs on the master branch. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. P-2 Issues/test failures with a fix SLA of 3 months T-sql-queries SQL Queries Team
#135131 opened Nov 14, 2024 by mw5h
opt,plpgsql: apply tail-call optimization to subqueries A-sql-plpgsql PL/pgSQL language C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. T-sql-queries SQL Queries Team
#135063 opened Nov 13, 2024 by DrewKimball
opt: invisible index improvements C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#135018 opened Nov 12, 2024 by mgartner
Performance of Query 7 on TPC-H Benchmark C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-community Originated from the community T-sql-queries SQL Queries Team X-blathers-triaged blathers was able to find an owner
#135001 opened Nov 12, 2024 by bajinsheng
sql: consider disallowing NOT VISIBLE, UNIQUE indexes C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
#134856 opened Nov 11, 2024 by mgartner
pkg/ccl/logictestccl/tests/local-repeatable-read/local-repeatable-read_test: TestRepeatableReadLogic_upsert_non_metamorphic failed branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
#134822 opened Nov 11, 2024 by cockroach-teamcity
roachtest: unoptimized-query-oracle/disable-rules=half/rand-multi-region failed branch-release-24.2.5-rc C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
#134817 opened Nov 11, 2024 by cockroach-teamcity
roachtest: unoptimized-query-oracle/disable-rules=half/rand-multi-region failed B-runtime-assertions-enabled branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. O-rsg Random Syntax Generator release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
#134816 opened Nov 11, 2024 by cockroach-teamcity
pkg/ccl/logictestccl/tests/3node-tenant/3node-tenant_test: TestTenantLogic_synthetic_privileges failed branch-release-24.2.5-rc C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
#134806 opened Nov 11, 2024 by cockroach-teamcity
Question of the Performance on TPC-H Benchmark Query 2 C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-community Originated from the community T-sql-queries SQL Queries Team X-blathers-triaged blathers was able to find an owner
#134803 opened Nov 10, 2024 by bajinsheng
internal error: unexpected error from the vectorized engine: runtime error: slice bounds out of range [:10] with capacity 6 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-community Originated from the community T-sql-queries SQL Queries Team X-blathers-triaged blathers was able to find an owner
#134798 opened Nov 10, 2024 by r33s3n6
pkg/ccl/logictestccl/tests/local-read-committed/local-read-committed_test: TestReadCommittedLogic_upsert_non_metamorphic failed branch-release-24.2 Used to mark GA and release blockers, technical advisories, and bugs for 24.2 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
#134792 opened Nov 10, 2024 by cockroach-teamcity
pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
#134766 opened Nov 9, 2024 by cockroach-teamcity
Trigger firings should show up in EXPLAIN output A-sql-trigger Triggers and Trigger Functions C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-qa T-sql-queries SQL Queries Team
#134747 opened Nov 8, 2024 by mw5h
sql: add PG builtin suppress_redundant_updates_trigger A-sql-builtins SQL built-in functions and semantics thereof. A-sql-pgcompat Semantic compatibility with PostgreSQL A-sql-trigger Triggers and Trigger Functions C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-qa T-sql-queries SQL Queries Team
#134680 opened Nov 8, 2024 by michae2
colexec: clean up fragile eager cancellation mechanism in the parallel unordered sync needed for LOS C-cleanup Tech debt, refactors, loose ends, etc. Solution not expected to significantly change behavior. T-sql-queries SQL Queries Team
#134615 opened Nov 8, 2024 by yuzefovich
sql: find a way to use generic queries with the internal executor (2% cpu) C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) o-perf-efficiency Related to performance efficiency T-sql-queries SQL Queries Team
#134588 opened Nov 7, 2024 by mgartner
opt: reduce overhead of norm.CombineComputedColFilters (0% cpu) C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) o-perf-efficiency Related to performance efficiency T-sql-queries SQL Queries Team
#134587 opened Nov 7, 2024 by mgartner
sql: support replacing a trigger function A-sql-trigger Triggers and Trigger Functions C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) docs-known-limitation T-sql-queries SQL Queries Team
#134555 opened Nov 7, 2024 by DrewKimball
sql-queries: 25.1 release checklist C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
#134462 opened Nov 6, 2024 by mgartner
7 tasks
sql: partial table statistics are not used in row count estimates A-sql-optimizer SQL logical planning and optimizations. A-sql-table-stats Table statistics (and their automatic refresh). branch-master Failures and bugs on the master branch. branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-qa T-sql-queries SQL Queries Team
#134461 opened Nov 6, 2024 by mgartner
sql: automatic partial stats collection does not work as expected A-sql-table-stats Table statistics (and their automatic refresh). branch-master Failures and bugs on the master branch. branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-qa T-sql-queries SQL Queries Team
#134460 opened Nov 6, 2024 by mgartner
jobs: auto create stats job fails with poisoned latch A-jobs A-sql-table-stats Table statistics (and their automatic refresh). branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-24.3-scale-testing Issue found during scale testing of 24.3. O-testcluster Issues found or occurred on a test cluster, i.e. a long-running internal cluster T-sql-queries SQL Queries Team
#134413 opened Nov 6, 2024 by shailendra-patel
ProTip! no:milestone will show everything without a milestone.