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

Write test for parsing all ANSI SQL:2011 data types #2

Open
andygrove opened this issue Sep 3, 2018 · 1 comment
Open

Write test for parsing all ANSI SQL:2011 data types #2

andygrove opened this issue Sep 3, 2018 · 1 comment

Comments

@andygrove
Copy link
Member

Use https://jakewheat.github.io/sql-overview/sql-2011-foundation-grammar.html as a reference
benesch pushed a commit that referenced this issue Aug 6, 2019
@quodlibetor
Merge pull request #2 from MaterializeInc/show-columns
9aac761 
Support `SHOW COLUMNS FROM mytable`
flaneur2020 pushed a commit to flaneur2020/sqlparser-rs that referenced this issue Feb 18, 2022
@sundy-li
Merge pull request apache#2 from datafuse-extras/tinyint
314873f 
Tinyint
@AugustoFKL
Copy link
Contributor

@andygrove can https://jakewheat.github.io/sql-overview/sql-2016-foundation-grammar.html#character-string-type be used instead?

I'm working on this, but the repository states that this one is our standard, so following the 2011 shouldn't be recommended.

@AugustoFKL AugustoFKL mentioned this issue Oct 2, 2022
Merged
step-baby added a commit to step-baby/sqlparser-rs that referenced this issue Nov 28, 2022
@step-baby
Merge pull request apache#2 from step-baby/feature/fix_create_index
fe9a78b 
fix: create index using function
serprex pushed a commit to serprex/sqlparser-rs that referenced this issue Nov 6, 2023
@iskakaushik
Merge pull request apache#2 from PeerDB-io/fork-sync-fix
e037227 
remove auto-merge
jmhain pushed a commit to jmhain/sqlparser-rs that referenced this issue Mar 15, 2024
@donhcd @markwongsk
merge Sigma changes into main branch (apache#9)
8dcc913 
* cargo fmt

* add json index for snowflake, bq

* add flatten

* add snowflake dateparts

* useful parsing errors

* parse decimals without 0 prefix

* snowflake: within group

* snowflake: json bracket syntax

* snowflake: join where

* snowflake: ilike

* snowflake: handle like ... escape ...

* snowflake: try_cast

* snowflake: qualify

* snowflake: handle pivot

* snowflake: allow idents to start with $

* snowflake: fix parsing for position

* snowflake: minus set operator

* snowflake json: cleanup/fix bracket and dot notation

* snowflake: number

* snowflake: string literal parse esc quotes

* snowflake: nested exprs can be lists

* join constraints are not required

* smarter number literal parsing with state machine for scientific notation

* snowflake: date/time field variants

* rs/pg: AT TIME ZONE

* rs: ignore/respect nulls

* tokenizer: treat zwsp as whitespace

* pg/rs: SIMILAR TO

* rs: allow brackets around idents

* rs: allow str literal date/time parts

* rs: more IS [NOT] *

* pg: add json ops

* add BigQueryDialect

* bq: backtick quoted idents

* bq: be resilient to trailing commas

* bq: be much more flexible with parsing function args

* bq: handle idents using backticks

* bq: handle interval parsing

* bq: parse regex literals (consider merging with snowflake str parsing)

* bq: add in more date/time parts

* bq: allow aliases with backtick quoting

* bq: parse wildcard modifiers except/replace

* bq: named window specs

* bq: IN <expr>

* snowflake: remove special position handling? maybe should remove more

* bq: double quoted string

* bq: typeless structs

* bq: add secret datetime fields

* fixup bq args bs

* snowflake: ignore/respect nulls for window funcs

* Added Unpivot. Fixed some Pivot (apache#2)

-- Technically, unpivot has some stricter
   expr requirements (eg instead of expr for ident in col_list
   it should be <column> for ident in col_list). I haven't been
   able to navigate to find this stricter definition yet, but
   maybe we want this fix ASAP.

* [SIG-13647] allow idents for limits and offsets (apache#3)

* Fix compilation issues (apache#5)

* Use enum to prevent &'static str lifetime issues

-- Could also use `serde(bound(deserialize = "'de: 'static"))`
-- But I think that will need to be applied on all structs
-- that depend on Expr... which I assume will be ubiquitous

* Make WindowSpec serializable

* Fix more static str stuff

* Fixed tests

* Fixed all compilation errors

* Run clippy --fix

* Fixd lint errors

* Fix more lint errors

* Fix remaining lint issues

* Fix tests pass (apache#7)

* Fixed trivial tests failures

* Fixed more tests

* Ignored backcompat breaks... for now

* More simple tests fixes

* Fixed tests... but not sure whether this is right

* Clippy

* cargo fmt

* Fixed regression apache#1

* Fixed second regression

* Ignore snowflake numeric failing test

* Added tests for sigma-related parser changes (apache#8)

* Added regression tests

* Added test for sigma-related parser changes

* Amended comments

* Removed extraneous println

* Fixed build errors part 1

* Manual cargo fmt because it's hanging on my machine

* When you fail at %s

Co-authored-by: Mark Wong Siang Kai <markwongsk@gmail.com>
alamb pushed a commit to alamb/sqlparser-rs that referenced this issue Apr 9, 2024
@JichaoS
Merge pull request apache#2 from luabase/jichaos/secrets
4cc4f9a 
ATTACH duckdb database support
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@andygrove @AugustoFKL