You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Sree Harsha Ramanavarapu (Jira)" <ji...@apache.org> on 2025/02/07 20:32:00 UTC
[jira] [Created] (CALCITE-6819) MSSQL doesn't support TRUE/FALSE keywords in its Join predicate
Sree Harsha Ramanavarapu created CALCITE-6819:
-------------------------------------------------
Summary: MSSQL doesn't support TRUE/FALSE keywords in its Join predicate
Key: CALCITE-6819
URL: https://issues.apache.org/jira/browse/CALCITE-6819
Project: Calcite
Issue Type: Bug
Reporter: Sree Harsha Ramanavarapu
CREATE TABLE t1 (c11 int, c12 int);
INSERT INTO t1 VALUES (1,10), (2,20), (3,30);
CREATE TABLE t2 (c21 int, c22 int);
SELECT * FROM t1 LEFT OUTER JOIN t2 ON TRUE;
Msg 4145, Level 15, State 1, Server a08c6f7cfc77, Line 9
An expression of non-boolean type specified in a context where a condition is expected, near ';'.
TRUE/FALSE are not supported in MSSQL (but it is supported in most DBs).
The MSSQL way would be to write the query as :
SELECT * FROM t1 LEFT OUTER JOIN t2 ON 1=1;
MSSQL dialect should support this syntax.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)