DROP TABLE IF EXISTS t1;

CREATE TABLE `t1` (

  `p_mfgr` char(6) DEFAULT NULL

) ENGINE=Columnstore DEFAULT CHARSET=latin1;

INSERT INTO `t1` VALUES ('MFGR#1');

select p_mfgr from t1 where p_mfgr <='MFGR#1' or p_mfgr is null;

select p_mfgr from t1 where p_mfgr <='MFGR#1' or p_mfgr is null;

commit ad32abdf491322703cf3cf25732a76dd44436f36

Author: Alexander Barkov <bar@mariadb.com>

Date:   Tue Dec 1 10:48:59 2020 +0400

    Part#1 MCOL-495 Make string comparison not case sensitive

    Fixing field='str' for long (Dict) string data types.

diff --git a/dbcon/joblist/lbidlist.cpp b/dbcon/joblist/lbidlist.cpp

index 1ce5f5a9..9a9e3787 100644

--- a/dbcon/joblist/lbidlist.cpp

+++ b/dbcon/joblist/lbidlist.cpp

@@ -775,14 +775,14 @@ bool LBIDList::CasualPartitionPredicate(const int64_t Min,

             }

         }

+        MsgDataPtr += ct.colWidth;

+

         // Should we also check for empty here?

         if (isNull(value, ct)) // This will work even if the data column is unsigned.

         {

             continue;

         }

-        MsgDataPtr += ct.colWidth;

-

         if (bIsChar && 1 < ct.colWidth)

         {

             datatypes::Charset cs(ct.charsetNumber);