[jira] [Created] (CALCITE-5796) DELETE statement is not effective
Jiajun Xie created CALCITE-5796: --- Summary: DELETE statement is not effective Key: CALCITE-5796 URL: https://issues.apache.org/jira/browse/CALCITE-5796 Project: Calcite Issue Type: Bug Components: core, linq4j Environment: I try to use `DELETE FROM t`, but the table was not affected. {code:java} static void erase(SqlIdentifier name, CalcitePrepare.Context context) { // Generate, prepare and execute an "DELETE FROM table" statement. // (It's a bit inefficient that we convert from SqlNode to SQL and back // again.) final FrameworkConfig config = Frameworks.newConfigBuilder() .defaultSchema(context.getRootSchema().plus()) .build(); final Planner planner = Frameworks.getPlanner(config); try { final StringBuilder buf = new StringBuilder(); final SqlWriterConfig writerConfig = SqlPrettyWriter.config().withAlwaysUseParentheses(false); final SqlPrettyWriter w = new SqlPrettyWriter(writerConfig, buf); buf.append("DELETE FROM "); name.unparse(w, 0, 0); final String sql = buf.toString(); final SqlNode query1 = planner.parse(sql); final SqlNode query2 = planner.validate(query1); final RelRoot r = planner.rel(query2); final PreparedStatement prepare = context.getRelRunner().prepareStatement(r.rel); int rowCount = prepare.executeUpdate(); Util.discard(rowCount); prepare.close(); } catch (SqlParseException | ValidationException | RelConversionException | SQLException e) { throw Util.throwAsRuntime(e); } } {code} Because we use `EnumerableDefaults#remove()` to delete target rows. The rows is object array, they can't match. !image-2023-06-24-18-27-57-722.png! Reporter: Jiajun Xie Attachments: image-2023-06-24-18-27-57-722.png -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (CALCITE-5797) Release Calcite 1.35.0
xiong duan created CALCITE-5797: --- Summary: Release Calcite 1.35.0 Key: CALCITE-5797 URL: https://issues.apache.org/jira/browse/CALCITE-5797 Project: Calcite Issue Type: Test Reporter: xiong duan Assignee: xiong duan Fix For: 1.35.0 Release Calcite 1.35.0. -- This message was sent by Atlassian Jira (v8.20.10#820010)
Re: [DISCUSS] Towards Calcite 1.35.0
I have created CALCITE-5797 to release 1.35.0. If there are no objections, I will create an RC in the following days. [1]:https://issues.apache.org/jira/browse/CALCITE-5797 If there are other must fix for 1.35.0 please let us know so that we can plan accordingly. Julian Hyde 于2023年6月24日周六 01:58写道: > We said ‘mid-June’. Time to get this release rolling? > > > On Jun 20, 2023, at 10:34 PM, Gian Merlino wrote: > > > > I committed the patch for CALCITE-5477. I would appreciate a review on > CALCITE-5479, if someone has a chance. > > > > On 2023/06/07 09:53:08 Gian Merlino wrote: > >> Some more detail: > >> > >> - the PR for CALCITE-5477 is > https://github.com/apache/calcite/pull/3249 > >> - the PR for CALCITE-5479 is > https://github.com/apache/calcite/pull/3030 > >> > >> I've just pushed up some updates to reflect the new approach we > discussed for guava backwards-compat in CALCITE-5477, and to sync up with > latest main in CALCITE-5479. > >> > >> We've been doing a bunch of work on the Druid side to be able to update > our Calcite dependency (currently, we're on 1.21.0). From what we've seen > so far, we believe if these two patches are part of 1.35.0, then we could > target that version. > >> > >> Gian > >> > >> On 2023/06/07 06:32:34 Abhishek Agarwal wrote: > >>> We (Apache Druid) would also like > >>> https://issues.apache.org/jira/browse/CALCITE-5479 and > >>> https://issues.apache.org/jira/browse/CALCITE-5477 to be fixed in > 1.35.0. > >>> There are PRs for both of these fixes. We are working on addressing > review > >>> comments and just need a few days of time. > >>> > >>> On Thu, Jun 1, 2023 at 3:32 AM Julian Hyde wrote: > >>> > There's one Jira case we should fix: > https://issues.apache.org/jira/browse/CALCITE-5737 (support JDK 19 > and > 20). Can someone take that on? > > Julian > > On 2023/05/30 08:33:23 xiong duan wrote: > > Yes. I can release 1.35.0 when the PR is handled. > > > > Julian Hyde 于2023年5月30日周二 05:46写道: > > > >> Mid-June sounds like a good idea. > >> > >> I would like to see the following Jira cases finished: > >> * 5701 NAMED_STRUCT (MasseGuillaume) > >> * 5640 SAFE_ADD (DanZou) > >> * 5625 SEARCH (olivrlee) > >> * 5626 Fully-qualified names (herunkang2018) > >> * 5615 SQL Logic Test (mbudiu) > >> * 5607 JSON serialization (olivrlee) > >> * 5564 PERCENTILE_CONT (tanclary) > >> * 5526 Unparsing literals (TJ Banghart) > >> > >> If the authors have made changes they would like me to review, > please > >> add a comment to the Jira case. > >> > >> Any other cases, don't ask me personally, ask everyone on the dev > >> list. My capacity to review PRs is limited. > >> > >> Julian > >> > >> On Fri, May 26, 2023 at 11:16 PM Benchao Li > wrote: > >>> > >>> It's been a bit more than 2 months since our last release [1] and > there > >> are > >>> currently 80+ new commits in master. > >>> > >>> As usual, according to our Jira dashboard [2] and Github [3], there > are > >>> many pending issues that could / should be part of the release. I'd > >> propose > >>> to make a collective effort to try to clean up our 1.35 backlog and > merge > >>> the PRs which are in a good state. I'd propose to aim for **mid > June** to > >>> release 1.35.0, this will give us about 15-20 days to clean up > pending > >> PRs > >>> for next version. What do you think? > >>> > >>> According to [4], the following release managers would be: > >>> - 1.35.0 Duan Xiong > >>> - 1.36.0 Benchao Li > >>> - 1.37.0 Sergey Nuyanzin > >>> - 1.38.0 Julian Hyde > >>> > >>> @Duan Xiong, are you still available for being the release manager > for > >>> 1.35.0? > >>> > >>> And contributors, if you have any work that is in good shape and > want to > >> be > >>> included in 1.35.0, please mark the fixVersion to 1.35.0, this will > >> inform > >>> the release manager, and we'll try our best to get it in. > >>> > >>> [1] https://calcite.apache.org/docs/history.html#v1-34-0 > >>> [2] > >>> > >> > > https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333950 > >>> [3] https://github.com/apache/calcite/pulls > >>> [4] > https://lists.apache.org/thread/tm3t42qvpq3db24xtd2g468ofv83l6hk > >>> > >>> > >>> Best, > >>> Benchao Li > >> > > > > >>> > >> > >
Re: [DISCUSS] Towards Calcite 1.35.0
could we review this pr, so that it could be merged in 1.35. then the 1.35 will almost have the full spark collection function. I would very appreciate a review. if someone has time. https://github.com/apache/calcite/pull/3238 https://github.com/apache/calcite/pull/3263 xiong duan 于2023年6月25日周日 10:31写道: > I have created CALCITE-5797 to release 1.35.0. If there are no objections, > I will create an RC in the following days. > > [1]:https://issues.apache.org/jira/browse/CALCITE-5797 > > If there are other must fix for 1.35.0 please let us know so that we can > plan accordingly. > > Julian Hyde 于2023年6月24日周六 01:58写道: > > > We said ‘mid-June’. Time to get this release rolling? > > > > > On Jun 20, 2023, at 10:34 PM, Gian Merlino wrote: > > > > > > I committed the patch for CALCITE-5477. I would appreciate a review on > > CALCITE-5479, if someone has a chance. > > > > > > On 2023/06/07 09:53:08 Gian Merlino wrote: > > >> Some more detail: > > >> > > >> - the PR for CALCITE-5477 is > > https://github.com/apache/calcite/pull/3249 > > >> - the PR for CALCITE-5479 is > > https://github.com/apache/calcite/pull/3030 > > >> > > >> I've just pushed up some updates to reflect the new approach we > > discussed for guava backwards-compat in CALCITE-5477, and to sync up with > > latest main in CALCITE-5479. > > >> > > >> We've been doing a bunch of work on the Druid side to be able to > update > > our Calcite dependency (currently, we're on 1.21.0). From what we've seen > > so far, we believe if these two patches are part of 1.35.0, then we could > > target that version. > > >> > > >> Gian > > >> > > >> On 2023/06/07 06:32:34 Abhishek Agarwal wrote: > > >>> We (Apache Druid) would also like > > >>> https://issues.apache.org/jira/browse/CALCITE-5479 and > > >>> https://issues.apache.org/jira/browse/CALCITE-5477 to be fixed in > > 1.35.0. > > >>> There are PRs for both of these fixes. We are working on addressing > > review > > >>> comments and just need a few days of time. > > >>> > > >>> On Thu, Jun 1, 2023 at 3:32 AM Julian Hyde wrote: > > >>> > > There's one Jira case we should fix: > > https://issues.apache.org/jira/browse/CALCITE-5737 (support JDK 19 > > and > > 20). Can someone take that on? > > > > Julian > > > > On 2023/05/30 08:33:23 xiong duan wrote: > > > Yes. I can release 1.35.0 when the PR is handled. > > > > > > Julian Hyde 于2023年5月30日周二 05:46写道: > > > > > >> Mid-June sounds like a good idea. > > >> > > >> I would like to see the following Jira cases finished: > > >> * 5701 NAMED_STRUCT (MasseGuillaume) > > >> * 5640 SAFE_ADD (DanZou) > > >> * 5625 SEARCH (olivrlee) > > >> * 5626 Fully-qualified names (herunkang2018) > > >> * 5615 SQL Logic Test (mbudiu) > > >> * 5607 JSON serialization (olivrlee) > > >> * 5564 PERCENTILE_CONT (tanclary) > > >> * 5526 Unparsing literals (TJ Banghart) > > >> > > >> If the authors have made changes they would like me to review, > > please > > >> add a comment to the Jira case. > > >> > > >> Any other cases, don't ask me personally, ask everyone on the dev > > >> list. My capacity to review PRs is limited. > > >> > > >> Julian > > >> > > >> On Fri, May 26, 2023 at 11:16 PM Benchao Li > > > wrote: > > >>> > > >>> It's been a bit more than 2 months since our last release [1] and > > there > > >> are > > >>> currently 80+ new commits in master. > > >>> > > >>> As usual, according to our Jira dashboard [2] and Github [3], > there > > are > > >>> many pending issues that could / should be part of the release. > I'd > > >> propose > > >>> to make a collective effort to try to clean up our 1.35 backlog > and > > merge > > >>> the PRs which are in a good state. I'd propose to aim for **mid > > June** to > > >>> release 1.35.0, this will give us about 15-20 days to clean up > > pending > > >> PRs > > >>> for next version. What do you think? > > >>> > > >>> According to [4], the following release managers would be: > > >>> - 1.35.0 Duan Xiong > > >>> - 1.36.0 Benchao Li > > >>> - 1.37.0 Sergey Nuyanzin > > >>> - 1.38.0 Julian Hyde > > >>> > > >>> @Duan Xiong, are you still available for being the release > manager > > for > > >>> 1.35.0? > > >>> > > >>> And contributors, if you have any work that is in good shape and > > want to > > >> be > > >>> included in 1.35.0, please mark the fixVersion to 1.35.0, this > will > > >> inform > > >>> the release manager, and we'll try our best to get it in. > > >>> > > >>> [1] https://calcite.apache.org/docs/history.html#v1-34-0 > > >>> [2] > > >>> > > >> > > > > > https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333950 > > >>> [3] https://github.com/apache/calcite/pulls > > >>> [4] > > https://lists.apache.or