Jerome Isaac Haltom created CALCITE-7777:
--------------------------------------------
Summary: JDBC adapter generates || for concatenation, which SQL
Server rejects
Key: CALCITE-7777
URL: https://issues.apache.org/jira/browse/CALCITE-7777
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.42.0
Reporter: Jerome Isaac Haltom
SQL Server has no || operator, and the JDBC adapter generates one.
{code:sql}
select "brand_name" || "product_name" from "product"
{code}
comes out as
{code:sql}
SELECT [brand_name] || [product_name]
FROM [foodmart].[product]
{code}
which SQL Server answers with:
{code}
Incorrect syntax near '|'.
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
