khaidot commented on issue #64464:
URL: https://github.com/apache/doris/issues/64464#issuecomment-4763996589
Hi @zclllyybb, the Doris version I am using is doris-4.0.5-rc01-59de8c4c524,
i have also attached the ### EXPLAIN VERBOSE ### of both Doris versions, and
the generated ### QUERY: ### is indeed different.
4.0.5
QUERY: SELECT [Id], [Name], [CompanyId], [SystemCreatedAreaGroup] FROM
[dbo].[AreaGroupTypes] WHERE (([SystemCreatedAreaGroup] = TRUE))
2.1.10
QUERY: SELECT [Id], [Name], [CompanyId], [SystemCreatedAreaGroup] FROM
[dbo].[AreaGroupTypes] WHERE (([SystemCreatedAreaGroup] = 1))
[dorisexplainverbose.txt](https://github.com/user-attachments/files/29187040/dorisexplainverbose.txt)
Here's the SQL server DDL
CREATE TABLE MSSQL.dbo.AreaGroupTypes (
Id uniqueidentifier NOT NULL,
Name nvarchar(MAX) COLLATE Latin1_General_CI_AS NULL,
CompanyId bigint NOT NULL,
SystemCreatedAreaGroup bit NOT NULL,
CONSTRAINT [PK_dbo.AreaGroupTypes] PRIMARY KEY (Id)
);
Hi @lazyfetch, I am not working on this
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
