Skip to content

Conversation

@alamb
Copy link
Contributor

@alamb alamb commented May 22, 2023

Which issue does this PR close?

Closes #6407

Rationale for this change

@dependabot did most of the work but the code changes were non trivial enough I wanted to make a separate PR

What changes are included in this PR?

Update sqlparser-rs dependecy
Update datafusion for changes in API (mostly add error about new syntax not being supported)

Are these changes tested?

Yes

Are there any user-facing changes?

dependabot bot and others added 2 commits May 22, 2023 09:20
Updates the requirements on [sqlparser](https://github.com/sqlparser-rs/sqlparser-rs) to permit the latest version.
- [Changelog](https://github.com/sqlparser-rs/sqlparser-rs/blob/main/CHANGELOG.md)
- [Commits](apache/datafusion-sqlparser-rs@v0.33.0...v0.34.0)

---
updated-dependencies:
- dependency-name: sqlparser
  dependency-type: direct:production
...

Signed-off-by: dependabot[bot] <support@github.com>
@alamb alamb marked this pull request as ready for review May 22, 2023 21:11
@github-actions github-actions bot added core Core DataFusion crate logical-expr Logical plan and expressions sql SQL Planner labels May 22, 2023
Comment on lines +356 to +361
let order_by = match order_by.len() {
0 => {
return Err(DataFusionError::NotImplemented(
"ARRAY_AGG with empty ORDER BY not supported".to_string(),
))
}
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Hmm isn't ORDER BY an optional clause?

For example, in aggregate_functions.md:

array_agg(expression [ORDER BY expression])

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Oh, nvm, this is the expressions of ORDER BY.

@github-actions github-actions bot added the sqllogictest SQL Logic Tests (.slt) label May 23, 2023
self.update_to_plan(table, assignments, from, selection)
}

Statement::Delete {
Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This is due to changes in apache/datafusion-sqlparser-rs#855

@alamb alamb merged commit a8246bf into apache:main May 23, 2023
@alamb alamb deleted the alamb/udpate_sqlparser branch May 23, 2023 14:09
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

core Core DataFusion crate logical-expr Logical plan and expressions sql SQL Planner sqllogictest SQL Logic Tests (.slt)

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants