[MCOL-1673] Different trailing behaviour between columnstore and innodb Created: 2018-08-23  Updated: 2020-11-19  Resolved: 2019-04-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.5, 1.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: David Hall (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Tested on Debian 9, MCS 1.1.5

Issue Links:
Blocks
blocks MCOL-1246 Trailing whitespace in CHAR/VARCHAR b... Closed
blocks MCOL-1403 Trailing whitespace in CHAR/VARCHAR b... Closed
Duplicate
duplicates MCOL-1559 Regression on working_tpch1/misc/bug3... Closed
Relates
relates to MCOL-4403 Trailing spaces not behaving as InnoDB Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

Another different behaviour regarding trailing spaces between InnoDB and Columnstore.

Coliumnstore engine:

CREATE TABLE `save` (
 
`code` varchar(255) DEFAULT NULL
 
) ENGINE=Columnstore DEFAULT CHARSET=utf8
 
;
 
 
 
INSERT INTO save
 
VALUES
 
('15 hours '),
 
('14 hours');
 
 
 
select code
 
from save
 
where code IN ('15 hours ', '14 hours');


 select code
 
  from save
 
 where code IN ('15 hours ', '14 hours');
 
+----------+
 
| code     |
 
+----------+
 
| 14 hours |
 
+----------+
 
1 row in set, 1 warning (0.08 sec)

InnoDB:

DROP table if exists `save2`;
 
 
 
CREATE TABLE `save2` (
 
`code` varchar(255) DEFAULT NULL
 
) ENGINE=Innodb DEFAULT CHARSET=utf8
 
;
 
 
 
INSERT INTO save2
 
VALUES
 
('15 hours '),
 
('14 hours');
 
 
 
select code
 
from save2
 
where code IN ('15 hours ', '14 hours');


select code from save2 where code IN ('15 hours ', '14 hours');
 
+-----------+
 
| code      |
 
+-----------+
 
| 15 hours  |
 
| 14 hours  |
 
+-----------+


Generated at Thu Feb 08 02:30:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.