Matching CHAR column with LIKE does not ignore padding, so doesn't match
expected values
----------------------------------------------------------------------------------------
Key: CORE-4278
URL: http://tracker.firebirdsql.org/browse/CORE-4278
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1, 2.5.2 Update 1
Reporter: Mark Rotteveel
Using LIKE on a CHAR column does not ignore the padding of the column. This
leads to rows not being returned when the value should match.
Reproduction:
CREATE TABLE CHARCOLUMN_TEST (
CHARCOLUMN CHAR(32)
);
COMMIT;
INSERT INTO CHARCOLUMN_TEST (CHARCOLUMN) VALUES ('A');
COMMIT;
SELECT * FROM CHARCOLUMN_TEST WHERE CHARCOLUMN LIKE 'A';
Expected: A single row with value 'A'.
Actual result: No rows
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
