Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.02.11, 23.10.2
-
None
-
None
-
2025-2
Description
Here I compare Columnstore to Innodb. They should return identical values, but they do not:
create schema if not exists Z213035;
|
use Z213035;
|
CREATE TABLE `CS_LEG` (`ID` bigint(20) DEFAULT NULL, `sess_count` smallint(6) DEFAULT NULL) ENGINE=Columnstore;
|
CREATE TABLE `INNO_LEG` (`ID` bigint(20) DEFAULT NULL, `sess_count` smallint(6) DEFAULT NULL) ENGINE=InnoDB;
|
insert into CS_LEG(ID) values(1);
|
insert into INNO_LEG(ID) values(1);
|
select NULLIF(sess_count,0) from CS_LEG;
|
+----------------------+
|
| NULLIF(sess_count,0) |
|
+----------------------+
|
| -32768 |
|
+----------------------+
|
select NULLIF(sess_count,0) from INNO_LEG;
|
+----------------------+
|
| NULLIF(sess_count,0) |
|
+----------------------+
|
| NULL |
|
+----------------------+
|
Attachments
Issue Links
- relates to
-
MCOL-6057 Backport MCOL-5922 to 23.02.x
-
- Closed
-