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
 
 -