Comments (10)
i have do some work about adding CTEs (WITH statement),
need some help to fix failed tests
from parser.
@tlightsky Thank you for the feature request. CTEs are currently on the roadmap.
from parser.
@morgo thanks for reply
need this feature recently,
maybe i can make a pr when i finish it,
is there any hint that i can add it quickly?
(maybe just point out where i should make changes)
from parser.
@tlightsky Common Table Expression is a huge feature, we need a detailed discuss and design document about it.
from parser.
I've created a github project to trace the progress: https://github.com/pingcap/tidb/projects/21
from parser.
@zz-jason
thanks for response,
Currently, my plan is to parse it to ast tree(without recursive),
then expand those CTEs
to form a SQL without WITH Statement
,
so i can use WITH Statement
in platforms like MySQL 5.7, Clickhouse
Also noticed OceanBase support non-recursive CTEs by only expanding them too,
would be nice to have CTEs support in TiDB even only just expand those subqueries
from parser.
Is this still on the roadmap? I don't need CTE support in TiDB, just in the parser.
from parser.
yes, compatibility with mysql 8 is always desirable.
(you may also want to follow pingcap/tidb#17472 for the overall roadmap of CTE support in TiDB, which drives the parser implementation.)
from parser.
Is this still on the roadmap? I don't need CTE support in TiDB, just in the parser.
@kyleconroy Oh, seems you are using this parser as a library in a project. May I know your use scenarios?
from parser.
Supported by #1207
/cc @tlightsky @kyleconroy
from parser.
Related Issues (20)
- Support attributes syntax for alter table/partition operations
- how to get the table names from BinaryOperationExpr of where clause HOT 2
- cannot run the demo in README.md because of broken dependencies HOT 1
- The Collate in types.FieldType in ColumnDef seems to be always empty
- Invalid characters generated by goyacc? HOT 2
- how can use "with xx select" syntax HOT 4
- Parsing errors from mysqldump 8.0
- Error parsing default values for tables
- Provide an interface for other packages to obtain the provided symbol type
- Is it possible to extract table and its related columns from sql query? HOT 2
- Test_driver failed to process escaped char in string literal
- Mention this repo has been moved to pingcap/tidb HOT 1
- Ss
- Parsing errors from mysql dump HOT 4
- question: why SelectStmt do not have the WHERE condition(Clause) but only the ExprNode ? HOT 3
- Optimize parser performance HOT 1
- How to beautify sql with this package ? HOT 4
- Window Function syntax error
- Node.OriginTextPosition() always return 0 and Text() return empty
- The current parser does not support multi-statement SQL parsing. Is there any alternative method to solve this problem?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from parser.