dt-sql-parser

dt-sql-parser copied to clipboard

Next

[]

## Bug - [ ] #46 - [ ] #17 ## Feature - [ ] #13 - [ ] #20 - [ ] #16 ## Refactor ## Docs - [...

wewoor

Roadmap 2022

[]

## 三季度 - [ ] 完善 FlinkSQL, 补充单元测试 - [ ] 完善 SparkSQL, 补充单元测试 - [ ] Bug 修复 - [ ] 查看支持 Autocomplete 的方案 ## 四季度 - [ ]...

wewoor

sql内多层括号splitsql引起死循环

[{"_id":"634c16c13bcf8d7ee43fb7a3","body":"\u540c\u6837\u95ee\u9898\u3002\u3002\u3002","issue_id":1660544297647,"origin_id":1139198946,"user_origin_id":17474452,"create_time":1653615417,"update_time":1653615417,"id":1665930945789,"updated_at":"2022-10-16T14:35:45.789000Z","created_at":"2022-10-16T14:35:45.789000Z"}]

**The Type of SQL** 任意类型sql **Your Code** ```js import { splitSql } from 'dt-sql-parser'; const sql = `with category(name, cn_name) as (values('测试名称(test), 名称'))` const sqlList = splitSql(sql) console.log(sqlList) ``` **Problem**...

Rsnowing

build(deps): bump trim-off-newlines from 1.0.1 to 1.0.3

[]

Bumps [trim-off-newlines](https://github.com/stevemao/trim-off-newlines) from 1.0.1 to 1.0.3. Commits c3b28d3 1.0.3 6226c95 Merge pull request #4 from Trott/fix-it-again c77691d fix: remediate ReDOS further 76ca93c chore: pin mocha to version that works with...

dependabot[bot]

build(deps): bump ansi-regex from 3.0.0 to 3.0.1

[]

Bumps [ansi-regex](https://github.com/chalk/ansi-regex) from 3.0.0 to 3.0.1. Commits f545bdb 3.0.1 c57d4c2 fix a few old XO issues for backport 419250f Fix potential ReDoS (#37) See full diff in compare view [![Dependabot...

dependabot[bot]

build(deps): bump minimist from 1.2.5 to 1.2.6

[]

Bumps [minimist](https://github.com/substack/minimist) from 1.2.5 to 1.2.6. Commits 7efb22a 1.2.6 ef88b93 security notice for additional prototype pollution issue c2b9819 isConstructorOrProto adapted from PR bc8ecee test from prototype pollution PR See full...

dependabot[bot]

tsc编译报错

[{"_id":"634c06b83056137e2653430e","body":"@GongchuangSu \u53ef\u4ee5\u7ed9 tsconfig.json \u6dfb\u52a0\u4e00\u4e2a\u7f16\u8bd1\u9009\u9879\uff1a\r\n\r\n```json\r\n{\r\n \"compilerOptions\": {\r\n \"skipLibCheck\": true\r\n }\r\n}\r\n```","issue_id":1660544297664,"origin_id":1020742393,"user_origin_id":2766811,"create_time":1643077099,"update_time":1643077099,"id":1665926840068,"updated_at":"2022-10-16T13:27:20.068000Z","created_at":"2022-10-16T13:27:20.068000Z"},{"_id":"634c06b83056137e2653430f","body":"@wewoor \u5c1d\u8bd5\u8fc7\uff0c\u8fd8\u662f\u4e00\u6837\u7684\u62a5\u9519","issue_id":1660544297664,"origin_id":1020902797,"user_origin_id":15921183,"create_time":1643097375,"update_time":1643097375,"id":1665926840072,"updated_at":"2022-10-16T13:27:20.071000Z","created_at":"2022-10-16T13:27:20.071000Z"},{"_id":"634c06b83056137e26534310","body":"\u6c42\u52a9 \u78b0\u5230\u4e86\u540c\u6837\u7684\u95ee\u9898\r\n\u7248\u672c\u4fe1\u606f\uff1a\r\n \"typescript\": \"~3.9.3\",\r\n \"dt-sql-parser\": \"^4.0.0-beta.2.2\",\r\n \r\n build\u65f6\u5019\u62a5\u9519 npm run serve\u65f6\u5019\u4e0d\u62a5\u9519\r\n\r\n","issue_id":1660544297664,"origin_id":1060348245,"user_origin_id":43961915,"create_time":1646643338,"update_time":1646643338,"id":1665926840075,"updated_at":"2022-10-16T13:27:20.075000Z","created_at":"2022-10-16T13:27:20.075000Z"}]

**版本信息** - dt-sql-parser版本：4.0.0-beta.2.2 - tsc版本：4.5.4 ``` $ tsc -v Version 4.5.4 ``` **报错信息** 执行`npx tsc`，报错如下： ``` node_modules/dt-sql-parser/dist/lib/flinksql/FlinkSqlParserListener.d.ts:4:16 - error TS1005: '(' expected. 4 constructor: typeof FlinkSqlParserListener; ~ node_modules/dt-sql-parser/dist/lib/flinksql/FlinkSqlParserVisitor.d.ts:4:16 - error...

GongchuangSu

build(deps): bump shelljs from 0.8.4 to 0.8.5

[]

Bumps [shelljs](https://github.com/shelljs/shelljs) from 0.8.4 to 0.8.5. Release notes Sourced from shelljs's releases. v0.8.5 This was a small security fix for #1058. Commits 70668a4 0.8.5 d919d22 fix(exec): lockdown file permissions (#1060)...

dependabot[bot]

支持 Auto-complete

[{"_id":"634c0d533bcf8d7ee43fb0ac","body":"\u6709\u8fdb\u5c55\u5417\uff1f","issue_id":1660544297670,"origin_id":986701434,"user_origin_id":1145830,"create_time":1638791295,"update_time":1638791295,"id":1665928531024,"updated_at":"2022-10-16T13:55:31.024000Z","created_at":"2022-10-16T13:55:31.024000Z"},{"_id":"634c0d533bcf8d7ee43fb0ad","body":"> \u6709\u8fdb\u5c55\u5417\uff1f\r\n\r\n\u76ee\u524d\u56e2\u961f\u5728\u505a\u5176\u4ed6\u7684\u9879\u76ee\uff0c\u6682\u65f6\u6ca1\u8d44\u6e90\u505a\u8fd9\u4e2a","issue_id":1660544297670,"origin_id":986711085,"user_origin_id":2766811,"create_time":1638792176,"update_time":1638792176,"id":1665928531028,"updated_at":"2022-10-16T13:55:31.027000Z","created_at":"2022-10-16T13:55:31.027000Z"},{"_id":"634c0d533bcf8d7ee43fb0ae","body":"\u671f\u5f85\u65e9\u70b9\u6709\u8fdb\u5c55\u3002\u3002\u3002\n\nZiv ***@***.***> \u4e8e2021\u5e7412\u67086\u65e5\u5468\u4e00 20:03\u5199\u9053\uff1a\n\n> \u6709\u8fdb\u5c55\u5417\uff1f\n>\n> \u76ee\u524d\u56e2\u961f\u5728\u505a\u5176\u4ed6\u7684\u9879\u76ee\uff0c\u6682\u65f6\u6ca1\u8d44\u6e90\u505a\u8fd9\u4e2a\n>\n> \u2014\n> You are receiving this because you commented.\n> Reply to this email directly, view it on GitHub\n> <https:\/\/github.com\/DTStack\/dt-sql-parser\/issues\/13#issuecomment-986711085>,\n> or unsubscribe\n> <https:\/\/github.com\/notifications\/unsubscribe-auth\/AAIXXZUPE4KIXJDRK7P6EM3UPSQ7VANCNFSM4XCSYY4A>\n> .\n> Triage notifications on the go with GitHub Mobile for iOS\n> <https:\/\/apps.apple.com\/app\/apple-store\/id1477376905?ct=notification-email&mt=8&pt=524675>\n> or Android\n> <https:\/\/play.google.com\/store\/apps\/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.\n>\n>\n","issue_id":1660544297670,"origin_id":987528815,"user_origin_id":1145830,"create_time":1638846861,"update_time":1638846861,"id":1665928531031,"updated_at":"2022-10-16T13:55:31.031000Z","created_at":"2022-10-16T13:55:31.031000Z"},{"_id":"634c0d533bcf8d7ee43fb0af","body":"> \r\n\r\n\u8c22\u8c22\u5173\u6ce8\u6211\u4eec\u7684\u9879\u76ee","issue_id":1660544297670,"origin_id":987530006,"user_origin_id":2766811,"create_time":1638847000,"update_time":1638847000,"id":1665928531034,"updated_at":"2022-10-16T13:55:31.033000Z","created_at":"2022-10-16T13:55:31.033000Z"},{"_id":"6645116b4ecfda50de10935c","body":"\u81ea\u52a8\u8865\u5168\u6709\u8fdb\u5c55\u5417\uff1f","issue_id":1660544297670,"origin_id":1422267108,"user_origin_id":24789197,"create_time":1675847433,"update_time":1675847433,"id":1715802475381,"updated_at":"2024-05-15T19:47:55.380000Z","created_at":"2024-05-15T19:47:55.380000Z"},{"_id":"6645116b4ecfda50de10935d","body":"\u76ee\u524d\u5df2\u7ecf\u652f\u6301 FlinkSQL","issue_id":1660544297670,"origin_id":1692849468,"user_origin_id":2766811,"create_time":1692945760,"update_time":1692945760,"id":1715802475385,"updated_at":"2024-05-15T19:47:55.384000Z","created_at":"2024-05-15T19:47:55.384000Z"}]

如下 SQL 类型： - [ ] MySQL - [ ] Flink SQL - [ ] Spark SQL - [ ] Hive SQL - [ ] PL/SQL

wewoor

flink sql数据类型decimal语法不兼容以及注释为“----”报校验错误，实际语法是对的

[{"_id":"634c0ca0378063557c2df524","body":"@zhuhs \u76ee\u524d FlinkSQL \u6211\u4eec\u53ea\u505a\u4e86\u4e00\u4e2a\u57fa\u672c\u7684\u8bed\u6cd5\u652f\u6301 0.0","issue_id":1660544297674,"origin_id":954401160,"user_origin_id":2766811,"create_time":1635478091,"update_time":1635478091,"id":1665928352884,"updated_at":"2022-10-16T13:52:32.884000Z","created_at":"2022-10-16T13:52:32.884000Z"}]

注释问题如图：  decimal问题：  decimal只能支持精度参数，不支持小数位固定参数；开源语法是支持的  由于生产数据不方便截图，使用的是你们的开源在线项目进行测试的https://dtstack.github.io/monaco-sql-languages/

zhuhs