[MCOL-4107] column alias for NULL lost in resultssets, if in conjunction with most functions. Created: 2020-06-25  Updated: 2023-07-01

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Task Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

To reproduce:

create database nulltest;
 
use nulltest;
 
CREATE TABLE `nulltestcol` (`a` int(11)) ENGINE=Columnstore;
 
insert into nulltestcol (a) values(1);

SELECT now() , NULL as alias3 FROM nulltestcol;

MariaDB [bugtest]> SELECT now() , NULL as alias3 FROM nulltestcol;
 
+---------------------+------+
 
| now()               | NULL |
 
+---------------------+------+
 
| 2020-06-25 09:53:07 | NULL |
 
+---------------------+------+
 
1 row in set (0.02 sec)

Works with Innodb table or without "from clause" fine.

with 1.4 / 1.5 it works.
Generated at Thu Feb 08 02:47:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.