executor、server、planner: Increase the support of the returning keyword (

#83)

* Add returning keyword plan and executor for supporting PG compliant DML (#69)

* Support return result set after deletion

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

* add returning plan and exectuor
modify adapter.go to execute returning separately

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

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

* upload delete returning.png

* upgrade DCparser and fix lint issues (#70)

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

* Hacking demo (#71)

* Readme: Updated readme and modified the version of TiDB cluster deployed  (#50)

* privileges: fixed unit test of user authentication

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

* fixed error msg and added const

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

* executor: Modify encrypted ciphertext in ut

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

* planner: Implement some interfaces in the test to solve the problem of build failed

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

* planner: Implement some interfaces in the test to solve the problem of build failed

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

* update readme

* Go Mod, Makefile: Dependency update (#51)

* added coverage report to gitignore

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

* added dev-tmp to skip explaintest

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

* update DCParser version to v1.3-alpha

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

* changed dependency requirement for HdrHistogram

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

* downgraded DCParser version to 1.25-alpha

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

* Explaintest, Server: Changed Explaintest's driver (#52)

* changed driver for explaintest

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

* improves status handling for server during transaction

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

* Executor: Added support for setting isolation level in begin (#57)

* update DCParser reference

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

* added setting isolation level capability in begin

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

* adding documents for BEGIN statement

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

* readme: update url for build status (#56)

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

* executor: uncommented some previously skipped test (#54)

* uncommented some previously skipped test

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

* wait longer for update version

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

* further enlarge test wait time for better stability

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

* variable,session: add search_path system variable. (#58)

* Fixed unit test bugs

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

* style: fmt check

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

* style： fmt check , delete blank lines

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

* style: fmt check

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

* Add postgres search_path system variable

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

* Modifying Comment Information

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

* Added extra_float_digit system variable

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

* fix:Delete unnecessary comments,Change the DCParser version

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

* formatting: fixed formatting issues (#59)

* fixing formatting issues

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

* typo fix

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

* fixed a bug that params description will be sent when no params in handleStmtDescription (#61)

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

* infoschema , util, autoid: Compatible with some tables in pg_catalog (#63)

* Compatible with some tables in pg_catalog

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

* add the correct license information and fix unit test

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

* expression：PostgreSQL system function support (#64)

* Added the logic realization of some system functions.
Added unit tests for PostgreSQL system functions.

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

* update DCParser version

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

* fixed built in function unit tests (#66)

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

* core, executor: add the implemet of setparamtype at show, showddl, datasource, limit plan. (#67)

* handle the implement of setparamtype at show, showddl or datasource plan

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

* handle the implement of setparamtype at limit plan

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

* add ut for setparamtype

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

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

* upgrade DCparser and fix lint issues

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

Co-authored-by: pupillord <[email protected]>
Co-authored-by: AmoebaProtozoa <[email protected]>
Co-authored-by: Cue Ray <[email protected]>
Co-authored-by: David <[email protected]>
Co-authored-by: studiolee <[email protected]>

* merge main into hacking-demo (#79)

* Readme: Updated readme and modified the version of TiDB cluster deployed  (#50)

* privileges: fixed unit test of user authentication

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

* fixed error msg and added const

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

* executor: Modify encrypted ciphertext in ut

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

* planner: Implement some interfaces in the test to solve the problem of build failed

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

* planner: Implement some interfaces in the test to solve the problem of build failed

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

* update readme

* Go Mod, Makefile: Dependency update (#51)

* added coverage report to gitignore

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

* added dev-tmp to skip explaintest

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

* update DCParser version to v1.3-alpha

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

* changed dependency requirement for HdrHistogram

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

* downgraded DCParser version to 1.25-alpha

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

* Explaintest, Server: Changed Explaintest's driver (#52)

* changed driver for explaintest

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

* improves status handling for server during transaction

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

* Executor: Added support for setting isolation level in begin (#57)

* update DCParser reference

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

* added setting isolation level capability in begin

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

* adding documents for BEGIN statement

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

* readme: update url for build status (#56)

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

* executor: uncommented some previously skipped test (#54)

* uncommented some previously skipped test

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

* wait longer for update version

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

* further enlarge test wait time for better stability

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

* variable,session: add search_path system variable. (#58)

* Fixed unit test bugs

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

* style: fmt check

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

* style： fmt check , delete blank lines

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

* style: fmt check

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

* Add postgres search_path system variable

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

* Modifying Comment Information

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

* Added extra_float_digit system variable

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

* fix:Delete unnecessary comments,Change the DCParser version

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

* formatting: fixed formatting issues (#59)

* fixing formatting issues

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

* typo fix

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

* fixed a bug that params description will be sent when no params in handleStmtDescription (#61)

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

* infoschema , util, autoid: Compatible with some tables in pg_catalog (#63)

* Compatible with some tables in pg_catalog

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

* add the correct license information and fix unit test

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

* expression：PostgreSQL system function support (#64)

* Added the logic realization of some system functions.
Added unit tests for PostgreSQL system functions.

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

* update DCParser version

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

* fixed built in function unit tests (#66)

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

* core, executor: add the implemet of setparamtype at show, showddl, datasource, limit plan. (#67)

* handle the implement of setparamtype at show, showddl or datasource plan

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

* handle the implement of setparamtype at limit plan

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

* add ut for setparamtype

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

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

* Executor: Sort param (#72)

* added test suites for sortParamOrder

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

* removed magic

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

* redo ParamMakerSorter

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

* use 0 index

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

* added ut case and fixed compatibility with MySQL

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

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

* Conn: Improved extended query handling (#73)

* removed unnecessary write back to client

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

* fixed extended query describe

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

* Server: Improved Extended Query Protocol (#74)

* binary long input

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

* binary float support

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

* new field to save pg oid

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

* Bind binary (#75)

* binary long input

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

* binary float support

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

* new field to save pg oid

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

* passed BenchMarkSQL

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

* Server: Restructure Parse OID handling (#77)

* handle OID and formatCode

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

* add pgOID conversion to parse handler

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

* handle OID of 0

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

* restructured parse oid handling

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

* removed unnecessary OID structure in bind

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

Co-authored-by: pupillord <[email protected]>
Co-authored-by: Cue Ray <[email protected]>
Co-authored-by: studiolee <[email protected]>

* add DML statement returning compatibility

* add insert returning support

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

* update go mod

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

* update go mod

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

Co-authored-by: pupillord <[email protected]>
Co-authored-by: RogueJin <[email protected]>
Co-authored-by: AmoebaProtozoa <[email protected]>
Co-authored-by: David <[email protected]>
Co-authored-by: studiolee <[email protected]>