pingcap / tidb

52 Pull requests merged by 26 people

• store/tikv: move metrics shortcuts to /metrics

  #22693 merged Feb 4, 2021

• plan, mpp: refine the precision of avg(decimal) & avg(null) for mpp

  #22668 merged Feb 4, 2021

• bindinfo: use new sql apis

  #22653 merged Feb 4, 2021

• client: update PD client to make sure the TSO uniqueness

  #22476 merged Feb 4, 2021

• *: adapt new api for the executor package

  #22644 merged Feb 4, 2021

• *: add some explain tests for cluster index

  #22720 merged Feb 4, 2021

• session, exectutor: Guarantee external consistency by default; Add an explicit begin statement to disable it

  #22597 merged Feb 4, 2021

• planner, executor, statistics: add tests for version 2 and fix bugs

  #22461 merged Feb 4, 2021

• README: change mailing list from google group to lists.tidb.io

  #22719 merged Feb 4, 2021

• config: use label key instead of txn-scope

  #22639 merged Feb 4, 2021

• executor: support checking schemaVer before staleness transaction begins

  #22679 merged Feb 4, 2021

• store/tikv: prepare for moving coprocessor out

  #22709 merged Feb 4, 2021

• *: refactor ExecuteInternal to return single resultset (#22546)

  #22655 merged Feb 4, 2021

• ddl, session: add tidb_enable_exchange_partition variable (#22638)

  #22706 merged Feb 3, 2021

• ddl, session: add tidb_enable_exchange_partition variable

  #22638 merged Feb 3, 2021

• executor: fix invalid txn when using prepare under @@tidb_snapshot (#22697)

  #22702 merged Feb 3, 2021

• executor: fix invalid txn when using prepare under @@tidb_snapshot

  #22697 merged Feb 3, 2021

• store:move tikv/gcworker to store/gcworker

  #22678 merged Feb 3, 2021

• store/tikv: move EtcdBackend out

  #22676 merged Feb 3, 2021

• store/tikv: remove util/codec dependency

  #22681 merged Feb 3, 2021

• statistics: refactor the statistics package use the RestrictedSQLExecutor API

  #22636 merged Feb 3, 2021

• privilege: remove any string concat

  #22523 merged Feb 3, 2021

• *: introduce new API ParseWithParams (#22499)

  #22547 merged Feb 2, 2021

• *: redact some error code, part(3/3) (#21866)

  #22669 merged Feb 2, 2021

• infoschema: show query disk usage in information_schema.processlist

  #22417 merged Feb 2, 2021

• store: add OpenWithOptions to avoid caller modifying global config

  #22170 merged Feb 2, 2021

• store/tikv: cleanup warnings and unused code

  #22648 merged Feb 2, 2021

• metric: record prepare execute fail as "Failed Query OPM" in monitor

  #22596 merged Feb 2, 2021

• store/tikv: move tikv driver out

  #22651 merged Feb 2, 2021

• planner: change the content of AnalyzeTableID to build global-stats

  #22554 merged Feb 2, 2021

• cmd: migrate the Execute interface to ExecuteInternal in cmd package

  #22647 merged Feb 2, 2021

• unistore/cophandler: change the logic of mpp execution in unit test.

  #22428 merged Feb 1, 2021

• store/tikv:remove tidb/config from store/tikv

  #22606 merged Feb 1, 2021

• store/tikv: export types

  #22645 merged Feb 1, 2021

• *: do not report error for prepared stmt execution if tidb_snapshot is set

  #22568 merged Feb 1, 2021

• *: refactor ExecuteInternal to return single resultset

  #22546 merged Feb 1, 2021

• statistics: fix bug when bootstrap version 2 stats

  #22608 merged Feb 1, 2021

• *: move new api out of session package

  #22591 merged Jan 29, 2021

• store/tikv: key range refactor

  #22610 merged Jan 29, 2021

• store/tikv: Add failpoints to inject error when prewriting secondary keys

  #22623 merged Jan 29, 2021

• util: change point array to *point array

  #22422 merged Jan 29, 2021

• store/tikv: resolve sessionctx dependency

  #22584 merged Jan 29, 2021

• table: fix zero date in different sqlmode (#20206)

  #21553 merged Jan 29, 2021

• store/tikv: resolve variable dependency

  #22609 merged Jan 29, 2021

• expression: allow function coercibility derive to DERIVATIO ... (#19462)

  #22615 merged Jan 29, 2021

• expression: incorporate unicode_ci into constant propagation (#19555)

  #22614 merged Jan 29, 2021

• ddl: support placement rules for exchanging partitions

  #22380 merged Jan 29, 2021

• expression: do not rewrite like to eq when using unicode ci

  #22583 merged Jan 29, 2021

• executor: specially handle empty input for apply's outer child aggregate (#20544)

  #21137 merged Jan 29, 2021

• *: refactor the RestrictedSQLExecutor interface

  #22579 merged Jan 29, 2021

• metrics: fix wrong bucket name of coprocessor cache

  #22454 merged Jan 29, 2021

• gc_worker: Set endKey parameter of ScanLock request

  #22519 merged Jan 29, 2021

54 Pull requests opened by 25 people

• gc_worker: Set endKey parameter of ScanLock request (#22519)

  #22613 opened Jan 29, 2021

• expression: from_unixtime accept 64-bit integers

  #22616 opened Jan 29, 2021

• metrics: fix wrong bucket name of coprocessor cache (#22454)

  #22617 opened Jan 29, 2021

• *: refactor the RestrictedSQLExecutor interface (#22579)

  #22621 opened Jan 29, 2021

• planner: not pruning column used by union scan condition (#21640)

  #22624 opened Jan 29, 2021

• planner, statistics: allow (auto) analyze single partition in dynamic-only mode

  #22625 opened Jan 29, 2021

• executor: Improve max/min window function with deque-based sliding window

  #22628 opened Jan 30, 2021

• executor: refine window processor

  #22631 opened Jan 31, 2021

• *: refactor ExecuteInternal to return single resultset (#22546)

  #22640 opened Feb 1, 2021

• *: do not report error for prepared stmt execution if tidb_snapshot is set (#22568)

  #22641 opened Feb 1, 2021

• planner: decorrelate LogicalApply with inner join as the inner child

  #22649 opened Feb 1, 2021

• docs: add design document for foreign data wrapper

  #22650 opened Feb 1, 2021

• session, util: update session to use new APIs

  #22652 opened Feb 1, 2021

• *: move new api out of session package (#22591)

  #22656 opened Feb 2, 2021

• *: move new api out of session package (#22591)

  #22657 opened Feb 2, 2021

• cmd: migrate the Execute interface to ExecuteInternal in cmd package (#22647)

  #22660 opened Feb 2, 2021

• planner/core: let mpp support partition tables

  #22662 opened Feb 2, 2021

• expression: correct constant propagation for collation

  #22666 opened Feb 2, 2021

• statistics: merge the partition-level stats to global-level stats

  #22667 opened Feb 2, 2021

• ddl: migrate part of ddl package code from Execute/ExecRestricted to safe API (1)

  #22670 opened Feb 2, 2021

• metric: record prepare execute fail as "Failed Query OPM" in monitor (#22596)

  #22671 opened Feb 2, 2021

• metric: record prepare execute fail as "Failed Query OPM" in monitor (#22596)

  #22672 opened Feb 2, 2021

• metric: record prepare execute fail as "Failed Query OPM" in monitor (#22596)

  #22673 opened Feb 2, 2021

• *: introduce FormatSQL and MustFormatSQL

  #22674 opened Feb 2, 2021

• store: add OpenWithOptions to avoid caller modifying global config (#22170)

  #22675 opened Feb 2, 2021

• *: use `explain format = 'brief'` for tests

  #22677 opened Feb 2, 2021

• statistics: introduce new estimation logic when index histogram fails to estimate

  #22682 opened Feb 2, 2021

• expression: support enum pushdown

  #22686 opened Feb 3, 2021

• *: refactor the RestrictedSQLExecutor interface (#22579)

  #22687 opened Feb 3, 2021

• privilege: remove any string concat (#22523)

  #22688 opened Feb 3, 2021

• privilege: remove any string concat (#22523)

  #22689 opened Feb 3, 2021

• privilege: remove any string concat (#22523)

  #22690 opened Feb 3, 2021

• planner, expression: support enum index scan

  #22691 opened Feb 3, 2021

• cmd: restore the old Execute API only for the test

  #22692 opened Feb 3, 2021

• expression: enable arithmetic Mod push down

  #22696 opened Feb 3, 2021

• store/tikv_driver: move gcworker into tikv_driver

  #22698 opened Feb 3, 2021

• brie: add error info column and history backup/restore info in sql

  #22699 opened Feb 3, 2021

• expression: refine performance of EXTRACT function

  #22701 opened Feb 3, 2021

• statistics,executor: fix some unit tests that run twice

  #22705 opened Feb 3, 2021

• util: fix `Host` column of `show processlist` to host_name:client_port format

  #22707 opened Feb 3, 2021

• executor: Fix inline schema name

  #22711 opened Feb 3, 2021

• expression: Add warning info for exprs that can not be pushed to storage layer

  #22713 opened Feb 4, 2021

• executor: add close recordSet in executor

  #22714 opened Feb 4, 2021

• planner, errno: make error code of ErrMixOfGroupFuncAndFields consistent with MySQL

  #22722 opened Feb 4, 2021

• store/tikv: not setting special ts when resolving async locks

  #22723 opened Feb 4, 2021

• executor: fix load data losing connection when batch_dml_size is set

  #22724 opened Feb 4, 2021

• planner, distsql: fix the behaviour of building ranges for TiFlash

  #22725 opened Feb 4, 2021

• planner: do not ban tiflash engine when statement not read-only

  #22727 opened Feb 4, 2021

• store/tikv_driver:move MemManager from KVStore to tikvStore

  #22728 opened Feb 4, 2021

• ddl: migrate part of ddl package code from Execute/ExecRestricted to safe API (2)

  #22729 opened Feb 4, 2021

• brie/: add GetVersion function for tidbGlueSession

  #22731 opened Feb 4, 2021

• store/tikv: prepare for moving coprocessor out

  #22732 opened Feb 4, 2021

• bindinfo: use new sql apis (#22653)

  #22733 opened Feb 4, 2021

• bindinfo: use new sql apis (#22653)

  #22734 opened Feb 4, 2021

10 Issues closed by 5 people

• mpp: the precision of avg(decimal) is wider than that from mysql

  #22685 closed Feb 4, 2021

• Window_test failed on CI but passed in local

  #22632 closed Feb 3, 2021

• Show disk usage of a query in information_schema.processlist

  #13931 closed Feb 2, 2021

• Execute Error in prepare stmt didn't report as Failed Query OPM in Granafa

  #17345 closed Feb 2, 2021

• enhancement for planner

  #12309 closed Feb 1, 2021

• disk spill for sort may not be triggered properly

  #22410 closed Feb 1, 2021

• Plan cache doesn't need snapshot timestamp in the cache key

  #22497 closed Feb 1, 2021

• prepared stmt cannot execute when tidb_snapshot is set

  #22567 closed Feb 1, 2021

• ddl: support placement rules for exchanging partitions

  #22376 closed Jan 29, 2021

• Can't find column when using group concat

  #22573 closed Jan 29, 2021

37 Issues opened by 26 people

• Duplicate rows occur in primary/unique key in optimistic transaction

  #22730 opened Feb 4, 2021

• runtime error: makeslice: cap out of range

  #22726 opened Feb 4, 2021

• grant USAGE privilege operation fail

  #22721 opened Feb 4, 2021

• mpp: avg(null) returns error

  #22718 opened Feb 4, 2021

• Wrong enum calculation result in where condition.

  #22717 opened Feb 4, 2021

• remove MaxOneRow if filters in subquery fully cover a composite unique index

  #22716 opened Feb 4, 2021

• Support push down `ast.Mod` to TiKV and TiFlash.

  #22715 opened Feb 4, 2021

• Panic on rocksdb.

  #22710 opened Feb 3, 2021

• write conflict when create index on partition table

  #22708 opened Feb 3, 2021

• TRUNCATE PARTITION ALL gets stuck, ddl_worker retries, error returned

  #22704 opened Feb 3, 2021

• grant Super/GRANT for user failed

  #22703 opened Feb 3, 2021

• Implementation of EXTRACT function is very inefficient

  #22700 opened Feb 3, 2021

• Find and close recordset by Exec

  #22695 opened Feb 3, 2021

• Unmatched error code with MySQL for a same error (only_full_group_by)

  #22694 opened Feb 3, 2021

• Simplify window processor interface

  #22684 opened Feb 3, 2021

• information_schema.tikv_region_status incorrect for partitioned tables

  #22683 opened Feb 2, 2021

• executor: creating view errors when set @@tidb_isolation_read_engines='tiflash,tidb';

  #22680 opened Feb 2, 2021

• constant propagation is wrong used for some collation.

  #22665 opened Feb 2, 2021

• Some test case run twice

  #22664 opened Feb 2, 2021

• support explain format = 'test' for fewer meaningless test updates

  #22663 opened Feb 2, 2021

• use SchemaName in utils

  #22659 opened Feb 2, 2021

• read only transactions are read/write

  #22658 opened Feb 2, 2021

• Aggregation query returns wrong results on TiFlash

  #22654 opened Feb 2, 2021

• db.Exec is blocked when executing empty statement

  #22646 opened Feb 1, 2021

• The return value `rollbackFn` is always nil in activateTxnForRowCount

  #22643 opened Feb 1, 2021

• some sql plans with clustered index are worse the none clustered index

  #22642 opened Feb 1, 2021

• BR in sql performance issue

  #22637 opened Feb 1, 2021

• runtime error: slice bounds out of range [:2] with capacity 1

  #22635 opened Jan 31, 2021

• what does 'actRows' mean when the operator is TableRangeScan decided by columns?

  #22634 opened Jan 31, 2021

• Common test failed on CI but passed in local

  #22633 opened Jan 31, 2021

• Improve max/min sliding window function algorithm with deque

  #22630 opened Jan 30, 2021

• Aggregation function COUNT(NULL) will return error

  #22629 opened Jan 30, 2021

• BenchmarkWindowFunctionsWithSlidingWindow failed on master branch

  #22627 opened Jan 30, 2021

• implicit cast in where condition causes where not work, result in wrong result

  #22626 opened Jan 29, 2021

• range columns partition table doesn't check the column values for partition

  #22622 opened Jan 29, 2021

• pd server keeps reboot when deployed with docker-compose, with error "failed to create WAL"

  #22620 opened Jan 29, 2021

• Some partitions will never be used, we should ignore them

  #22619 opened Jan 29, 2021

67 Unresolved conversations

Sometimes conversations happen on old items that aren’t yet closed. Here is a list of all the Issues and Pull Requests with unresolved conversations.

• executor: make memory tracker for aggregate more accurate.

  #22463 commented on Feb 4, 2021 • 14 new comments

• server: retry executing sql without tiflash after tiflash is down

  #22459 commented on Feb 4, 2021 • 13 new comments

• statistics: merge the partition-level histograms to a global-level histogram

  #22603 commented on Feb 4, 2021 • 10 new comments

• Function name is missing in error message.

  #11181 commented on Jan 31, 2021 • 7 new comments

• double type precision does not display in `show create table` while D is 0

  #22604 commented on Jan 29, 2021 • 5 new comments

• types: fix the bug about the wrong query result for decimal type

  #22507 commented on Feb 4, 2021 • 5 new comments

• Got unexpected `Error 1105: Can't find column` when executing tp-test

  #22404 commented on Jan 29, 2021 • 4 new comments

• reduce optimizer cpu usage when handling very large IN(...) expression

  #22412 commented on Feb 3, 2021 • 4 new comments

• executor: fix unstable test Issue16696 (#22009)

  #22014 commented on Feb 4, 2021 • 4 new comments

• test: stabilize test case (#22276)

  #22281 commented on Feb 4, 2021 • 4 new comments

• *: introduce new API ParseWithParams (#22499)

  #22548 commented on Feb 2, 2021 • 4 new comments

• server: use ParseWithParams for internal SQLs (#22545)

  #22552 commented on Feb 4, 2021 • 4 new comments

• *: use CLUSTERED and NONCLUSTERED to control primary key type

  #22409 commented on Feb 4, 2021 • 3 new comments

• ddl: refine the error message for the expression index for PRIMARY KEY

  #20402 commented on Feb 1, 2021 • 2 new comments

• planner: fix confused and unnecessary double-projection in plans.

  #20903 commented on Feb 1, 2021 • 2 new comments

• planner: do not use indexMerge when the path only use a single index (#22168)

  #22187 commented on Jan 29, 2021 • 2 new comments

• planner: do not use indexMerge when the path only use a single index (#22168)

  #22188 commented on Jan 29, 2021 • 2 new comments

• planner: do not cache prepared plan if optimization depends on mutable constant (#22349)

  #22354 commented on Feb 4, 2021 • 2 new comments

• *: add infoschema client errors

  #22382 commented on Feb 2, 2021 • 2 new comments

• expression: Optimize builtinArithmeticModRealSig and builtinGreatestDecimalSig using MergeNull method

  #22418 commented on Feb 1, 2021 • 2 new comments

• server: use ParseWithParams for internal SQLs (#22545)

  #22551 commented on Feb 3, 2021 • 2 new comments

• The current statistics histogram of a multi-column index actually serves as a single column index

  #22589 commented on Jan 29, 2021 • 1 new comment

• Inconsistenet error reporting format with MySQL

  #22399 commented on Jan 31, 2021 • 1 new comment

• Support `STORING` columns INDEX

  #18616 commented on Feb 2, 2021 • 1 new comment

• Optimize the performance and stability of TiDB running on No-NVMe SSD and Cloud disk

  #18024 commented on Feb 2, 2021 • 1 new comment

• Add clear explanation to CLA of PingCAP's ability to relicense contributions

  #10742 commented on Feb 4, 2021 • 1 new comment

• executor: add builtin aggregate function `json_arrayagg`

  #19957 commented on Feb 4, 2021 • 1 new comment

• executor: add diagnosis rule to check Transparent Huge Pages(THP) enabled (#20611)

  #20825 commented on Feb 1, 2021 • 1 new comment

• test: convert test to benchmard test to make ci stable (#21616)

  #21626 commented on Feb 1, 2021 • 1 new comment

• planner: report error when ORDER BY conflicts with DISTINCT (#21286)

  #21680 commented on Feb 4, 2021 • 1 new comment

• range: fix overflow value access index

  #21994 commented on Feb 1, 2021 • 1 new comment

• expression: separated arithmeticPlusIntSig

  #22026 commented on Feb 1, 2021 • 1 new comment

• test: fix globalkilltest (#21987)

  #22114 commented on Feb 4, 2021 • 1 new comment

• planner: join reorder should not change the order of output columns (#16852)

  #22129 commented on Feb 1, 2021 • 1 new comment

• session: set process info before building plan (#22101)

  #22149 commented on Feb 4, 2021 • 1 new comment

• expression: speed up Column.VecEvalReal by using MergeNulls

  #22191 commented on Feb 1, 2021 • 1 new comment

• time: fix parse datetime won't truncate the reluctant string (#22232)

  #22259 commented on Jan 29, 2021 • 1 new comment

• store/tikv: fix a concurrency bug that may cause the batchClient timeout (#22239)

  #22335 commented on Feb 3, 2021 • 1 new comment

• expression: separated arithmeticIntDivideSig

  #22374 commented on Feb 3, 2021 • 1 new comment

• planner: check schema stale for plan cache when forUpdateRead

  #22381 commented on Jan 30, 2021 • 1 new comment

• *:Fix the fetchHotRegion bug that the count always zero

  #22504 commented on Jan 29, 2021 • 1 new comment

• docs: RFC for better staleness read syntax.

  #22506 commented on Jan 31, 2021 • 1 new comment

• server: use ParseWithParams for internal SQLs (#22545)

  #22550 commented on Feb 3, 2021 • 1 new comment

• planner: split test data from test cases in cbo_test.go

  #22559 commented on Feb 3, 2021 • 1 new comment

• Failed to read auto-increment value from storage engine

  #22592 commented on Jan 29, 2021 • 0 new comments

• TPS decline during go-tpc run

  #22612 commented on Jan 29, 2021 • 0 new comments

• The Host and Info column of `show processlist` are not same as mysql

  #10903 commented on Jan 31, 2021 • 0 new comments

• result of `show [global|session] bindings` is unordered

  #15702 commented on Feb 1, 2021 • 0 new comments

• planner: rule_decorrelate cannot handle correlated join condition in subquery

  #15272 commented on Feb 1, 2021 • 0 new comments

• Support Changing Column Type in the TiDB Side

  #18283 commented on Feb 2, 2021 • 0 new comments

• 01-06 performance regression on batch_insert

  #22398 commented on Feb 3, 2021 • 0 new comments

• Unexpected constant overflow error

  #21509 commented on Feb 3, 2021 • 0 new comments

• load data with auto-random may panic if too many rows

  #22540 commented on Feb 3, 2021 • 0 new comments

• Error `Unsupported type: Null` occurred when updating the table using a no else CASE.

  #17486 commented on Feb 4, 2021 • 0 new comments

• Bug Fixing Challenge [Welcome to contribute]

  #20804 commented on Feb 4, 2021 • 0 new comments

• Support timestamp bounded read-only transactions on data replicas Tasklist

  #21094 commented on Feb 4, 2021 • 0 new comments

• Provide standalone Go client

  #22513 commented on Feb 4, 2021 • 0 new comments

• session: Support global variables tidb_replica_read

  #20639 commented on Feb 2, 2021 • 0 new comments

• planner: fix the inappropriate out-of-range range estimation rule

  #21207 commented on Jan 29, 2021 • 0 new comments

• statistics: fix a bug which causes panic when using the clustered index and the new collation (#21379)

  #21408 commented on Jan 29, 2021 • 0 new comments

• misc: Update kvproto

  #21919 commented on Feb 1, 2021 • 0 new comments

• expression: separated arithmeticModIntSig

  #22137 commented on Feb 2, 2021 • 0 new comments

• time: fix parse datetime won't truncate the reluctant string (#22232)

  #22260 commented on Feb 2, 2021 • 0 new comments

• expression: fix bugs in builtinfunction ArithmeticMinusInt logic

  #22426 commented on Feb 1, 2021 • 0 new comments

• ddl, executor: fix creating unique index without partition column error when enable-global-index is true

  #22471 commented on Feb 2, 2021 • 0 new comments

• util: pre alloc memory

  #22501 commented on Jan 31, 2021 • 0 new comments

• expression: Support builtin function SOUNDEX

  #22541 commented on Jan 29, 2021 • 0 new comments