Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Time related function supported. #419

Closed
qiuyesuifeng opened this issue Oct 20, 2015 · 0 comments
Closed

Time related function supported. #419

qiuyesuifeng opened this issue Oct 20, 2015 · 0 comments
Assignees
@zimulala

Comments

@qiuyesuifeng
Copy link
Member

Now we have supported DATE_ADD, u can try to add DATE_SUB, ADDDATE and SUBDATE.

Refer doc:
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
This was referenced Oct 30, 2015
Merged
Merged
@zimulala zimulala closed this as completed Nov 9, 2015
YuJuncen pushed a commit to YuJuncen/tidb that referenced this issue Apr 23, 2021
@glorv @kennytm
backend/local: do not retry epochNotMatch error when ingest sst (ping…
2660ffe 
…cap#419)

* do not retry epochNotMatch error when ingest sst

* add retry ingest for 'Raft raft: proposal dropped' error in ingest

* change some retryable error log level from Error to Warn

* fix nextKey

* add a comment for nextKey

* fix comment and add a unit test

* wrap time.Sleep in select

Co-authored-by: kennytm <[email protected]>
YuJuncen pushed a commit to YuJuncen/tidb that referenced this issue Apr 23, 2021
@glorv @kennytm
backend/local: use range properties to optimize region range estimate (…
51d0e7b 
…pingcap#422)

* use range propreties to estimate region range

* post-restore: add optional level for post-restore operations (pingcap#421)

* add optional level for opst-restore operations

* trim leading and suffix '"

* use UnmarshalTOML to unmarshal post restore op level

* resolve comments and fix unit test

* backend/local: do not retry epochNotMatch error when ingest sst (pingcap#419)

* do not retry epochNotMatch error when ingest sst

* add retry ingest for 'Raft raft: proposal dropped' error in ingest

* change some retryable error log level from Error to Warn

* fix nextKey

* add a comment for nextKey

* fix comment and add a unit test

* wrap time.Sleep in select

Co-authored-by: kennytm <[email protected]>

* update

* use range properties to optimze region range estimate

* update pebble

* change the default value for batch-size

* add unit tests and reslove comments

* add a comment to range properties test

* add a comment

* add a test for range property with pebble

* rename const variable

Co-authored-by: kennytm <[email protected]>
YuJuncen pushed a commit to YuJuncen/tidb that referenced this issue Apr 23, 2021
@lance6716
glue: add GlueCheckpointDB and remove external TiDB usage (pingcap#478)
da8b24e 
* save my work

add notes

save work

save work

fix unit test

remove tidbMgr in RestoreController

remove some comments

remove some comments

change logger in SQLWithRetry

revert replace log.Logger to *zap.Logger

dep: update uuid dependency to latest google/uuid (pingcap#452)

* dep: update satori/go.uuid to latest

* fix tests

* change to google/uuid

* fix build

* try fix test

* get familiar with google/uuid

* address comment

tidb-lightning-ctl: change default of -d to 'noop://' (pingcap#453)

also add noop:// to supported storage types (to represent an empty store)

replace tab to space

try another port to fix CI

remove some comment

*: more glue

restore: fix the bug that gc life time ttl does not take effect (pingcap#448)

* fix gc ttl loop

* resolve comment and add tests

fix CI

report info to host TiDB

config: filter out all system schemas by default (pingcap#459)

backend: fix auto random default value for primary key (pingcap#457)

* fix auto generate auto random primary key column

* fix default for auto random primary key

* fix test

* use prev row id for auto random and add a test

* replace chunck with session opt

* fix

* fix

mydumper: fix parquet data parser (pingcap#435)

* fix parquet

* reorder imports

* fix test

* use empty collation

* fix a error and add more test cases

* add pointer type tests

* resolve comments

Co-authored-by: kennytm <[email protected]>

address comment

backend/local: use range properties to optimize region range estimate (pingcap#422)

* use range propreties to estimate region range

* post-restore: add optional level for post-restore operations (pingcap#421)

* add optional level for opst-restore operations

* trim leading and suffix '"

* use UnmarshalTOML to unmarshal post restore op level

* resolve comments and fix unit test

* backend/local: do not retry epochNotMatch error when ingest sst (pingcap#419)

* do not retry epochNotMatch error when ingest sst

* add retry ingest for 'Raft raft: proposal dropped' error in ingest

* change some retryable error log level from Error to Warn

* fix nextKey

* add a comment for nextKey

* fix comment and add a unit test

* wrap time.Sleep in select

Co-authored-by: kennytm <[email protected]>

* update

* use range properties to optimze region range estimate

* update pebble

* change the default value for batch-size

* add unit tests and reslove comments

* add a comment to range properties test

* add a comment

* add a test for range property with pebble

* rename const variable

Co-authored-by: kennytm <[email protected]>

fix pd service id is empty (pingcap#460)

fix s3 parquet reader (pingcap#461)

Co-authored-by: Neil Shen <[email protected]>

fix service gc ttl again (pingcap#465)

address comment

mydumper: verify file routing config (pingcap#470)

* fix file routing

* remove useless line

* remove redundant if check

rename a method in interface

save work

try fix CI

could work

change ctx usage

try fix CI

try fix CI

refine function interface

refine some fucntion interface

debug CI

address comment

config: allow four byte-size config to be specified using human-readable units ("100 GiB") (pingcap#471)

* Makefile: add `make finish-prepare` action

* config: accept human-readable size for most byte-related config

e.g. allow `region-split-size = '96M'` in additional to `= 100663296`

(known issue: these values' precisions will be truncated to 53 bits
instead of supporting all 63 bits)

* restore: reduce chance of spurious errors from TestGcTTLManagerSingle

Co-authored-by: glorv <[email protected]>

remove debug log

test: change double type syntax (pingcap#474)

address comment

checkpoint: add glue checkpoint

resolve cycle import

expose Retry

refine

change interface to cope with TiDB

fix SQL string

fix SQL

adjust interface to embedded in TiDB

could import now

reduce TLS

restore: add `glue.Glue` interface and other function (pingcap#456)

* save my work

* add notes

* save work

* save work

* fix unit test

* remove tidbMgr in RestoreController

* remove some comments

* remove some comments

* change logger in SQLWithRetry

* revert replace log.Logger to *zap.Logger

* replace tab to space

* try another port to fix CI

* remove some comment

* *: more glue

* report info to host TiDB

* fix CI

* address comment

* address comment

* rename a method in interface

* save work

* try fix CI

* could work

* change ctx usage

* try fix CI

* try fix CI

* refine function interface

* refine some fucntion interface

* debug CI

* address comment

* remove debug log

* address comment

modify code

add comment

refine some code

* address comment

* add some comments

* fix CI and change CREATE TABLE
iosmanthus pushed a commit to iosmanthus/tidb that referenced this issue Jun 6, 2023
@nolouch
update the pd client and client go (pingcap#419)
5dbf050 
Signed-off-by: nolouch <[email protected]>
rleungx pushed a commit to rleungx/tidb that referenced this issue Feb 26, 2024
@disksing @zeminzhou
@AmoebaProtozoa @ystaticy @nolouch
[cherry-pick-7.1] *: default resource group (pingcap#526)
2877fb2 
* default resource group (pingcap#245)

* default resource group

Signed-off-by: disksing <[email protected]>

* enable resource control

Signed-off-by: disksing <[email protected]>

* add comments

Signed-off-by: disksing <[email protected]>

* move DefaultResourceGroup to config

Signed-off-by: disksing <[email protected]>

---------

Signed-off-by: disksing <[email protected]>
Co-authored-by: zzm <[email protected]>

* Resource Control: fix segmentation violation when keyspace not set (pingcap#251)

* fix segmentation violation when setting up ru

Signed-off-by: David <[email protected]>

* only setup resource control when cluster id not empty

Signed-off-by: David <[email protected]>

---------

Signed-off-by: David <[email protected]>

* skip ur (pingcap#279)

Signed-off-by: ystaticy <[email protected]>

* disable resource group sql interface (pingcap#309)

Signed-off-by: disksing <[email protected]>

* *: update pd client and increase maxWaitDuration (pingcap#321)

Signed-off-by: disksing <[email protected]>

* update pd client and ru config (pingcap#325)

Signed-off-by: disksing <[email protected]>

* update max wait duration (pingcap#351)

Signed-off-by: disksing <[email protected]>

* update the pd client and client go (pingcap#419)

Signed-off-by: nolouch <[email protected]>

* update main

Signed-off-by: disksing <[email protected]>

---------

Signed-off-by: disksing <[email protected]>
Signed-off-by: David <[email protected]>
Signed-off-by: ystaticy <[email protected]>
Signed-off-by: nolouch <[email protected]>
Co-authored-by: zzm <[email protected]>
Co-authored-by: David <[email protected]>
Co-authored-by: ystaticy <[email protected]>
Co-authored-by: ShuNing <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@zimulala zimulala

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@qiuyesuifeng @zimulala