Jenkins build is back to normal : Calcite » Calcite-snapshots #327

[Apache Jenkins Server]

See 

Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

[Benchao Li]

Thanks Ruben for being a great chair for the last year, and congratulations
to Stamatis!

Francis Chuang  于2023年1月20日周五 05:04写道：

> Congratulations, Stamatis, and thanks to Ruben for being a great chair!
>
> On 20/01/2023 5:47 am, Gavin Ray wrote:
> > Congratulations Stamatis, well-deserved!
> >
> >
> > On Thu, Jan 19, 2023 at 1:34 PM Julian Hyde  wrote:
> >
> >> As many of you remember, Stamatis has served as Chair before. This is
> >> the first time that Calcite has re-elected a previous Chair, and that
> >> speaks to Stamatis' excellent qualities. Stamatis' style is very
> >> similar to Ruben's style - serving the project by quietly getting
> >> things done, defusing arguments and personality conflicts, and getting
> >> us all to work together better.
> >>
> >> Congratulations Stamatis, and thank you for your service to the project,
> >> Ruben.
> >>
> >> Julian
> >>
> >> On Thu, Jan 19, 2023 at 9:57 AM Michael Mior  wrote:
> >>>
> >>> Congratulations Stamatis and thanks Reuben!
> >>>
> >>> --
> >>> Michael Mior
> >>> mm...@apache.org
> >>>
> >>>
> >>> On Thu, Jan 19, 2023 at 12:04 PM Ruben Q L  wrote:
> >>>
>  Calcite community members,
> 
>  I am pleased to announce that we have a new PMC chair and VP as per
> our
>  tradition of rotating the chair once a year. I have resigned, and
> >> Stamatis
>  Zampetakis
>  was duly elected by the PMC and approved unanimously by the Board.
> 
>  Please join me in congratulating Stamatis!
> 
>  Best regards,
>  Ruben
> 
> >>
> >
>


-- 

Best,
Benchao Li

[jira] [Created] (CALCITE-5488) Calcite double-adjusts timestamps when calling Array.getResultSet()

[Will Noble (Jira)]

Will Noble created CALCITE-5488:
---

 Summary: Calcite double-adjusts timestamps when calling 
Array.getResultSet()
 Key: CALCITE-5488
 URL: https://issues.apache.org/jira/browse/CALCITE-5488
 Project: Calcite
  Issue Type: Bug
Reporter: Will Noble


If you go into {{AvaticaResultSetConversionTest}} and delete the 
[timeZone|https://github.com/apache/calcite-avatica/blob/dbe9b1d8c2e53474eb40cfaf5721aceca3bdb57f/core/src/test/java/org/apache/calcite/avatica/AvaticaResultSetConversionsTest.java#L1121]
 property for the connection, which is currently set to "GMT", several 
{{getString()}} and {{getArray()}} tests start to fail. The {{getString()}} 
failures are self-explanatory -- the expected value has become incorrect 
because of the time zone change -- but the {{getArray()}} failures are tricky. 
They're double-adjusting the timestamps:
* Once when they call 
[getObject()|https://github.com/apache/calcite-avatica/blob/810acf80771310431d7ef576f3404299ebb8eaf2/core/src/main/java/org/apache/calcite/avatica/util/AbstractCursor.java#L1432]
 (which invokes {{getTimestamp()}} with the connection's default calendar, 
which was previously GMT but is now the system default).
* Then, in 
[ArrayImpl.equalContents()|https://github.com/apache/calcite-avatica/blob/820edf6f653607afb5a2a280a32f315aff1f64cb/core/src/main/java/org/apache/calcite/avatica/util/ArrayImpl.java#L233]
 the arrays are converted to result sets for traversal via 
[Array.getResultSet()|https://docs.oracle.com/javase/8/docs/api/java/sql/Array.html#getResultSet--]
 , which uses the same time zone as the "factory" result set and eventually 
invokes {{getObject()}} again, thus applying the time zone offset twice.

This is a bug in the implementation of {{Array.getResultSet()}} that only 
manifests when the array contains timestamps and when the connection default 
time zone is anything besides GMT, and this is not currently covered by tests. 
It's easy to cause the failure, however, by changing the connection default 
time zone for {{AvaticaResultSetConversionTest}} to anything besides GMT or UTC.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[ANNOUNCE] Apache Calcite Avatica 1.23.0 Released

[Julian Hyde]

The Apache Calcite team is pleased to announce the release of Apache
Calcite Avatica 1.23.0.

Avatica is a framework for building database drivers. Avatica defines a
wire API and serialization mechanism for clients to communicate with a
server as a proxy to a database. The reference Avatica client and server
are implemented in Java and communicate over HTTP. Avatica is a
sub-project of Apache Calcite.

Apache Calcite Avatica 1.23.0 is a periodic release (coming 6 months
after 1.22.0) that contains several bug fixes and new features. New
features include support for HTTP_BAD_REQUEST and configuring fetch
size and SSL key-store type. Also, there are various improvements to
DateTimeUtils and ByteString. For a full list of changes, please see
the release notes:

  https://calcite.apache.org/avatica/docs/history.html#v1-23-0

The release is available here:

  https://calcite.apache.org/avatica/downloads/avatica.html

We welcome your help and feedback. For more information on how to report
problems and get involved, visit the project website at:

  https://calcite.apache.org/avatica/

or the Apache Calcite project website:

  https://calcite.apache.org/

Thanks to everyone involved!

Julian Hyde, on behalf of the Apache Calcite team

Generated Aliases for Expressions - $f and expr$

[Abbas Gadhia]

Hi,I noticed that while converting from Sql to Rel in SqlToRelConverter, the 
method deriveAlias is used which creates aliases of the type EXPR$0 (when there 
is no specific alias assigned to an expression)However, if we use 
RelBuilder.project_ , it creates aliases/field names using 
SqlValidatorUtil.F_SUGGESTER. 
It is apparent that F_SUGGESTER is used for deriving field names, however, it 
also gets used for deriving names for unnamed expressions (in RelBuilder)
There are checks in SqlUtil.isGeneratedAlias that checks only the EXPR aliases 
and not the $f aliases.
Question:Can we also additionally check $f aliases as part of the 
SqlUtil.isGeneratedAlias check?Is there any specific background to $f aliases 
that is not simply apparent?

ThanksAbbas

Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

[Francis Chuang]

Congratulations, Stamatis, and thanks to Ruben for being a great chair!

On 20/01/2023 5:47 am, Gavin Ray wrote:

Congratulations Stamatis, well-deserved!


On Thu, Jan 19, 2023 at 1:34 PM Julian Hyde  wrote:


As many of you remember, Stamatis has served as Chair before. This is
the first time that Calcite has re-elected a previous Chair, and that
speaks to Stamatis' excellent qualities. Stamatis' style is very
similar to Ruben's style - serving the project by quietly getting
things done, defusing arguments and personality conflicts, and getting
us all to work together better.

Congratulations Stamatis, and thank you for your service to the project,
Ruben.

Julian

On Thu, Jan 19, 2023 at 9:57 AM Michael Mior  wrote:


Congratulations Stamatis and thanks Reuben!

--
Michael Mior
mm...@apache.org


On Thu, Jan 19, 2023 at 12:04 PM Ruben Q L  wrote:


Calcite community members,

I am pleased to announce that we have a new PMC chair and VP as per our
tradition of rotating the chair once a year. I have resigned, and

Stamatis

Zampetakis
was duly elected by the PMC and approved unanimously by the Board.

Please join me in congratulating Stamatis!

Best regards,
Ruben

[jira] [Created] (CALCITE-5487) Avatica Result Sets do not properly handle TIMESTAMP WITH LOCAL TIME ZONE

[Will Noble (Jira)]

Will Noble created CALCITE-5487:
---

 Summary: Avatica Result Sets do not properly handle TIMESTAMP WITH 
LOCAL TIME ZONE
 Key: CALCITE-5487
 URL: https://issues.apache.org/jira/browse/CALCITE-5487
 Project: Calcite
  Issue Type: Bug
  Components: avatica
Reporter: Will Noble


With the addition of proper support for {{TIMESTAMP WITH LOCAL TIME ZONE}} to 
Calcite being done as part of CALCITE-5346, Avatica needs to support the proper 
semantics for this type. Whereas a regular {{TIMESTAMP}} always has the same 
string representation but can have different instants depending on the calendar 
(time zone) passed to the result set getter, a {{TIMESTAMP WITH LOCAL TIME 
ZONE}} does the inverse: it always represents the same instant, but could have 
a different string representation depending on the calendar passed to the 
result set getter.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

[Gavin Ray]

Congratulations Stamatis, well-deserved!


On Thu, Jan 19, 2023 at 1:34 PM Julian Hyde  wrote:

> As many of you remember, Stamatis has served as Chair before. This is
> the first time that Calcite has re-elected a previous Chair, and that
> speaks to Stamatis' excellent qualities. Stamatis' style is very
> similar to Ruben's style - serving the project by quietly getting
> things done, defusing arguments and personality conflicts, and getting
> us all to work together better.
>
> Congratulations Stamatis, and thank you for your service to the project,
> Ruben.
>
> Julian
>
> On Thu, Jan 19, 2023 at 9:57 AM Michael Mior  wrote:
> >
> > Congratulations Stamatis and thanks Reuben!
> >
> > --
> > Michael Mior
> > mm...@apache.org
> >
> >
> > On Thu, Jan 19, 2023 at 12:04 PM Ruben Q L  wrote:
> >
> > > Calcite community members,
> > >
> > > I am pleased to announce that we have a new PMC chair and VP as per our
> > > tradition of rotating the chair once a year. I have resigned, and
> Stamatis
> > > Zampetakis
> > > was duly elected by the PMC and approved unanimously by the Board.
> > >
> > > Please join me in congratulating Stamatis!
> > >
> > > Best regards,
> > > Ruben
> > >
>

[RESULT] [VOTE] Release Apache Calcite Avatica 1.23.0 (release candidate 0)

[Julian Hyde]

With 4 +1 votes (3 of which are binding) and no 0 or -1 votes, the vote passes.

Thank you to all who voted. I'll roll the release out to the mirrors.

Julian


On 2023/01/19 11:33:45 Benchao Li wrote:
> +1
> 
> * downloaded and verified checksum/signature (OK)
> * checked diff between git tag and release source (OK)
> * checked NOTICE year (OK)
> * building from release source (./gradlew test) (OK)
> * checked releases notes (OK)
> * checked staged maven repo (OK)
> 
> Stamatis Zampetakis  于2023年1月16日周一 18:19写道：
> 
> > Ubuntu 20.04.4 LTS, jdk1.8.0_261, Gradle wrapper, Gradle 7.4.2
> >
> >  * Checked signatures and checksums OK
> >  * Went over release note OK
> >  * Checked README, NOTICE, and LICENSE files OK
> >  * Built from git tag and run tests (./gradlew test) OK
> >  * Built from release sources and run tests (gradle test) OK
> >  * Run tests with docker-compose KO (
> > https://issues.apache.org/jira/browse/CALCITE-5482)
> >  * Checked diff between git repo and release sources OK
> >  * Spot check maven artifacts for general structure, LICENSE, NOTICE,
> > META-INF content OK
> >
> > +1 (binding)
> >
> > Best,
> > Stamatis
> >
> > On Mon, Jan 16, 2023 at 6:21 AM Francis Chuang 
> > wrote:
> >
> > > Thanks for being RM for this release, Julian!
> > >
> > > My vote is: +1 (binding)
> > >
> > > - Verified GPG signature - OK
> > > - Verified SHA512 - OK
> > > - Diffed source release and git repository - OK
> > > - Checked release notes on tag
> > > (
> > >
> > https://github.com/apache/calcite-avatica/blob/avatica-1.23.0-rc0/site/_docs/history.md
> > )
> > >
> > > - OK
> > > - Checked year in NOTICE, README and HOWTO - OK
> > > - Ran tests (gradle check) - OK
> > > - Spot checked Nexus artifacts - OK
> > >
> > > Environment:
> > > Eclipse-temurin:17-jammy docker container in WSL2 (Ubuntu 22.04.1) on
> > > Windows 11 22h2
> > >
> > >  > docker version
> > > Client: Docker Engine - Community
> > >   Cloud integration: v1.0.29
> > >   Version:   20.10.21
> > >   API version:   1.41
> > >   Go version:go1.18.7
> > >   Git commit:baeda1f
> > >   Built: Tue Oct 25 18:02:28 2022
> > >   OS/Arch:   linux/amd64
> > >   Context:   default
> > >   Experimental:  true
> > >
> > > Server: Docker Desktop
> > >   Engine:
> > >Version:  20.10.21
> > >API version:  1.41 (minimum version 1.12)
> > >Go version:   go1.18.7
> > >Git commit:   3056208
> > >Built:Tue Oct 25 18:00:19 2022
> > >OS/Arch:  linux/amd64
> > >Experimental: false
> > >   containerd:
> > >Version:  1.6.10
> > >GitCommit:770bd0108c32f3fb5c73ae1264f7e503fe7b2661
> > >   runc:
> > >Version:  1.1.4
> > >GitCommit:v1.1.4-0-g5fd4c4d
> > >   docker-init:
> > >Version:  0.19.0
> > >GitCommit:de40ad0
> > >
> > >  > gradle -v
> > >
> > > 
> > > Gradle 7.4.2
> > > 
> > >
> > > Build time:   2022-03-31 15:25:29 UTC
> > > Revision: 540473b8118064efcc264694cbcaa4b677f61041
> > >
> > > Kotlin:   1.5.31
> > > Groovy:   3.0.9
> > > Ant:  Apache Ant(TM) version 1.10.11 compiled on July 10 2021
> > > JVM:  17.0.5 (Eclipse Adoptium 17.0.5+8)
> > > OS:   Linux 5.15.79.1-microsoft-standard-WSL2 amd64
> > >
> > >  > java -version
> > > openjdk version "17.0.5" 2022-10-18
> > > OpenJDK Runtime Environment Temurin-17.0.5+8 (build 17.0.5+8)
> > > OpenJDK 64-Bit Server VM Temurin-17.0.5+8 (build 17.0.5+8, mixed mode,
> > > sharing)
> > >
> > > Francis
> > >
> > > On 16/01/2023 2:10 pm, Julian Hyde wrote:
> > > > Hi all,
> > > >
> > > > I have created a build for Apache Calcite Avatica 1.23.0, release
> > > > candidate 0.
> > > >
> > > > Thanks to everyone who has contributed to this release.
> > > >
> > > > You can read the release notes here:
> > > >
> > >
> > https://github.com/apache/calcite-avatica/blob/avatica-1.23.0-rc0/site/_docs/history.md
> > > >
> > > > The commit to be voted upon:
> > > >
> > >
> > https://gitbox.apache.org/repos/asf?p=calcite-avatica.git;a=commit;h=fab03540de866faa783194ed58beb4319f3066c7
> > > >
> > > > Its hash is fab03540de866faa783194ed58beb4319f3066c7
> > > >
> > > > Tag:
> > > > https://github.com/apache/calcite-avatica/tree/avatica-1.23.0-rc0
> > > >
> > > > The artifacts to be voted on are located here:
> > > >
> > >
> > https://dist.apache.org/repos/dist/dev/calcite/apache-calcite-avatica-1.23.0-rc0
> > > > (revision 59365)
> > > >
> > > > The hashes of the artifacts are as follows:
> > > >
> > >
> > c369d5010d7c62b2be7037d28e35ed1681181c521fa8d7f92a5d3c0e93887a96077b3bf26435806533c701d97e9fbf17e1488d846e9dffcc9a10a3a1fc3f2220
> > > > *apache-calcite-avatica-1.23.0-src.tar.gz
> > > >
> > > > A staged Maven repository is available for review at:
> > > >
> > >
> > 

Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

[Julian Hyde]

As many of you remember, Stamatis has served as Chair before. This is
the first time that Calcite has re-elected a previous Chair, and that
speaks to Stamatis' excellent qualities. Stamatis' style is very
similar to Ruben's style - serving the project by quietly getting
things done, defusing arguments and personality conflicts, and getting
us all to work together better.

Congratulations Stamatis, and thank you for your service to the project, Ruben.

Julian

On Thu, Jan 19, 2023 at 9:57 AM Michael Mior  wrote:
>
> Congratulations Stamatis and thanks Reuben!
>
> --
> Michael Mior
> mm...@apache.org
>
>
> On Thu, Jan 19, 2023 at 12:04 PM Ruben Q L  wrote:
>
> > Calcite community members,
> >
> > I am pleased to announce that we have a new PMC chair and VP as per our
> > tradition of rotating the chair once a year. I have resigned, and Stamatis
> > Zampetakis
> > was duly elected by the PMC and approved unanimously by the Board.
> >
> > Please join me in congratulating Stamatis!
> >
> > Best regards,
> > Ruben
> >

Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

[Michael Mior]

Congratulations Stamatis and thanks Reuben!

--
Michael Mior
mm...@apache.org


On Thu, Jan 19, 2023 at 12:04 PM Ruben Q L  wrote:

> Calcite community members,
>
> I am pleased to announce that we have a new PMC chair and VP as per our
> tradition of rotating the chair once a year. I have resigned, and Stamatis
> Zampetakis
> was duly elected by the PMC and approved unanimously by the Board.
>
> Please join me in congratulating Stamatis!
>
> Best regards,
> Ruben
>

Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

[Alessandro Solimando]

Congratulations, Stamatis!

Thanks Ruben for being a great PMC chair!

Best regards,
Alessandro

On Thu, 19 Jan 2023 at 18:04, Ruben Q L  wrote:

> Calcite community members,
>
> I am pleased to announce that we have a new PMC chair and VP as per our
> tradition of rotating the chair once a year. I have resigned, and Stamatis
> Zampetakis
> was duly elected by the PMC and approved unanimously by the Board.
>
> Please join me in congratulating Stamatis!
>
> Best regards,
> Ruben
>

[ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

[Ruben Q L]

Calcite community members,

I am pleased to announce that we have a new PMC chair and VP as per our
tradition of rotating the chair once a year. I have resigned, and Stamatis
Zampetakis
was duly elected by the PMC and approved unanimously by the Board.

Please join me in congratulating Stamatis!

Best regards,
Ruben

Re: Contribution to Calcite

[Ruben Q L]

Hello Nikolay,

I have added you as a Calcite contributor.

Best regards,
Ruben


On Thu, Jan 19, 2023 at 1:41 PM Николай Ижиков  wrote:

> Hello, Calcite.
>
> My name is Nikolay Izhikov.
> Please, add me to the Calcite contributors so I can assign tickets to
> myself and resolve them.
>
> My jira id - nizhikov

Contribution to Calcite

[Николай Ижиков]

Hello, Calcite.

My name is Nikolay Izhikov.
Please, add me to the Calcite contributors so I can assign tickets to myself 
and resolve them.

My jira id - nizhikov

Re: Help converting a SHA1 hash to Oracle

[Benchao Li]

Hi Jonathan,

# For the first question: "how I get VARCHAR(200) in my cast function"

You passed wrong operand now (new SqlIdentifier("VARCHAR(200)",
SqlParserPos.ZERO);), it should be a SqlDataTypeSpec, not a SqlIdentifier
for the cast's second operand.

# For the second question: "everything included the CAST AS has been quoted"

SqlWriterConfig#quoteAllIdentifiers controls whether to quote all
identifiers while translating SqlNode to string. You can pass your own
config to SqlNode#toSqlString.

Jonathan Farina  于2023年1月19日周四 07:12写道：

> Hi
> I am trying to write some code that will take a MySQL SQL statement that
> includes a SHA1 hash statement and have it translate successfully to Oracle
> and in doing so add a cast function.
>
> Eg:
>
> select sha1(address) from locations limit 10
>
> Should translate to:
>
> SELECT CAST(STANDARD_HASH(ADDRESS) AS VARCHAR(200)) FROM LOCATIONS FETCH
> FIRST 10 ROWS ONLY
>
> I have 90% done but am struggling with the last part. I have via creating
> my own SqlNodes done the following:
>
> SELECT CAST(STANDARD_HASH("LOCATIONS"."ADDRESS") AS "VARCHAR(200)")
> "ADDRESS" FROM “LOCATIONS"
>
> This has been achieved by the following code:
>
> …skipping setup code…
>
> //create Hash function
> SqlNode[] HashFunctionOperandList = new SqlNode[1];
> HashFunctionOperandList[0] = sqlIdentifier;
> //ORACLE_HASH is a UDF defined elsewhere
> SqlBasicCall innerFunction = new SqlBasicCall(ORACLE_HASH,
> HashFunctionOperandList, new SqlParserPos(0, 0));
>
> //Create the Cast function
> SqlNode[] functionOperandList = new SqlNode[2];
> functionOperandList[0] = innerFunction;
> functionOperandList[1] = new SqlIdentifier("VARCHAR(200)",
> SqlParserPos.ZERO);
> compliantFunction =  new SqlBasicCall(new
> SqlCastFunction(),functionOperandList, new SqlParserPos(0, 0));
> …skipping to output code…
> SqlDialect translationDialect;
> translationDialect = OracleSqlDialect.DEFAULT;;
> String Query =
> compliantFunction.toSqlString(translationDialect).toString();
> My key issue seems to be how I get VARCHAR(200) in my cast function,
> secondly everything included the CAST AS has been quoted.
> I’ve tried SO for support and according to the Calcite website, It
> recommended I try here.  So any help would be appreciated?
>
> Thanks
>


-- 

Best,
Benchao Li

Re: [VOTE] Release Apache Calcite Avatica 1.23.0 (release candidate 0)

[Benchao Li]

+1

* downloaded and verified checksum/signature (OK)
* checked diff between git tag and release source (OK)
* checked NOTICE year (OK)
* building from release source (./gradlew test) (OK)
* checked releases notes (OK)
* checked staged maven repo (OK)

Stamatis Zampetakis  于2023年1月16日周一 18:19写道：

> Ubuntu 20.04.4 LTS, jdk1.8.0_261, Gradle wrapper, Gradle 7.4.2
>
>  * Checked signatures and checksums OK
>  * Went over release note OK
>  * Checked README, NOTICE, and LICENSE files OK
>  * Built from git tag and run tests (./gradlew test) OK
>  * Built from release sources and run tests (gradle test) OK
>  * Run tests with docker-compose KO (
> https://issues.apache.org/jira/browse/CALCITE-5482)
>  * Checked diff between git repo and release sources OK
>  * Spot check maven artifacts for general structure, LICENSE, NOTICE,
> META-INF content OK
>
> +1 (binding)
>
> Best,
> Stamatis
>
> On Mon, Jan 16, 2023 at 6:21 AM Francis Chuang 
> wrote:
>
> > Thanks for being RM for this release, Julian!
> >
> > My vote is: +1 (binding)
> >
> > - Verified GPG signature - OK
> > - Verified SHA512 - OK
> > - Diffed source release and git repository - OK
> > - Checked release notes on tag
> > (
> >
> https://github.com/apache/calcite-avatica/blob/avatica-1.23.0-rc0/site/_docs/history.md
> )
> >
> > - OK
> > - Checked year in NOTICE, README and HOWTO - OK
> > - Ran tests (gradle check) - OK
> > - Spot checked Nexus artifacts - OK
> >
> > Environment:
> > Eclipse-temurin:17-jammy docker container in WSL2 (Ubuntu 22.04.1) on
> > Windows 11 22h2
> >
> >  > docker version
> > Client: Docker Engine - Community
> >   Cloud integration: v1.0.29
> >   Version:   20.10.21
> >   API version:   1.41
> >   Go version:go1.18.7
> >   Git commit:baeda1f
> >   Built: Tue Oct 25 18:02:28 2022
> >   OS/Arch:   linux/amd64
> >   Context:   default
> >   Experimental:  true
> >
> > Server: Docker Desktop
> >   Engine:
> >Version:  20.10.21
> >API version:  1.41 (minimum version 1.12)
> >Go version:   go1.18.7
> >Git commit:   3056208
> >Built:Tue Oct 25 18:00:19 2022
> >OS/Arch:  linux/amd64
> >Experimental: false
> >   containerd:
> >Version:  1.6.10
> >GitCommit:770bd0108c32f3fb5c73ae1264f7e503fe7b2661
> >   runc:
> >Version:  1.1.4
> >GitCommit:v1.1.4-0-g5fd4c4d
> >   docker-init:
> >Version:  0.19.0
> >GitCommit:de40ad0
> >
> >  > gradle -v
> >
> > 
> > Gradle 7.4.2
> > 
> >
> > Build time:   2022-03-31 15:25:29 UTC
> > Revision: 540473b8118064efcc264694cbcaa4b677f61041
> >
> > Kotlin:   1.5.31
> > Groovy:   3.0.9
> > Ant:  Apache Ant(TM) version 1.10.11 compiled on July 10 2021
> > JVM:  17.0.5 (Eclipse Adoptium 17.0.5+8)
> > OS:   Linux 5.15.79.1-microsoft-standard-WSL2 amd64
> >
> >  > java -version
> > openjdk version "17.0.5" 2022-10-18
> > OpenJDK Runtime Environment Temurin-17.0.5+8 (build 17.0.5+8)
> > OpenJDK 64-Bit Server VM Temurin-17.0.5+8 (build 17.0.5+8, mixed mode,
> > sharing)
> >
> > Francis
> >
> > On 16/01/2023 2:10 pm, Julian Hyde wrote:
> > > Hi all,
> > >
> > > I have created a build for Apache Calcite Avatica 1.23.0, release
> > > candidate 0.
> > >
> > > Thanks to everyone who has contributed to this release.
> > >
> > > You can read the release notes here:
> > >
> >
> https://github.com/apache/calcite-avatica/blob/avatica-1.23.0-rc0/site/_docs/history.md
> > >
> > > The commit to be voted upon:
> > >
> >
> https://gitbox.apache.org/repos/asf?p=calcite-avatica.git;a=commit;h=fab03540de866faa783194ed58beb4319f3066c7
> > >
> > > Its hash is fab03540de866faa783194ed58beb4319f3066c7
> > >
> > > Tag:
> > > https://github.com/apache/calcite-avatica/tree/avatica-1.23.0-rc0
> > >
> > > The artifacts to be voted on are located here:
> > >
> >
> https://dist.apache.org/repos/dist/dev/calcite/apache-calcite-avatica-1.23.0-rc0
> > > (revision 59365)
> > >
> > > The hashes of the artifacts are as follows:
> > >
> >
> c369d5010d7c62b2be7037d28e35ed1681181c521fa8d7f92a5d3c0e93887a96077b3bf26435806533c701d97e9fbf17e1488d846e9dffcc9a10a3a1fc3f2220
> > > *apache-calcite-avatica-1.23.0-src.tar.gz
> > >
> > > A staged Maven repository is available for review at:
> > >
> >
> https://repository.apache.org/content/repositories/orgapachecalcite-1186/org/apache/calcite/
> > >
> > > Release artifacts are signed with the following key:
> > > https://people.apache.org/keys/committer/jhyde.asc
> > > https://www.apache.org/dist/calcite/KEYS
> > >
> > > To create the jars and test Apache Calcite Avatica: "gradle build
> > > -Prelease -PskipSign".
> > >
> > > If you do not have a Java/Gradle environment available, you can run the
> > tests
> > > using docker. To do so, install docker and 

[jira] [Created] (CALCITE-5486) Subquery not support having alias in condition.

[Jiajun Xie (Jira)]

Jiajun Xie created CALCITE-5486:
---

 Summary: Subquery not support having alias in condition.
 Key: CALCITE-5486
 URL: https://issues.apache.org/jira/browse/CALCITE-5486
 Project: Calcite
  Issue Type: Improvement
  Components: core
Reporter: Jiajun Xie


{code:java}
sql("select * from emp where sal >\n"
+ " (select avg(sal) as s"
+ "from emp having ^s^ > 0"
+ "  )")
.withConformance(SqlConformanceEnum.LENIENT)
.fails("Column 'S' not found in any table");{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)