Wrong results when the column with collation using option (NUMERIC-SORT=1) is
in where clause
---------------------------------------------------------------------------------------------
Key: CORE-3947
URL: http://tracker.firebirdsql.org/browse/CORE-3947
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.0
Environment: Win7 x64
Reporter: JDenk
Create database, table, init data :
---------------------------------------------------------------------------------------------------------------------------------------------
CREATE DATABASE 'c:\tmp\test.fdb' user 'SYSDBA' password 'masterkey' PAGE_SIZE
8192;
create collation utf8_num for UTF8 from UNICODE 'NUMERIC-SORT=1';
ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION utf8_num;
commit;
CREATE TABLE TEST_TABLE (TEST_FIELD VARCHAR(20) CHARACTER SET UTF8 COLLATE
UTF8_NUM);
commit;
INSERT into TEST_TABLE values('a1');
INSERT into TEST_TABLE values('a01');
INSERT into TEST_TABLE values('a001');
---------------------------------------------------------------------------------------------------------------------------------------------
Run select :
---------------------------------------------------------------------------------------------------------------------------------------------
select * from TEST_TABLE where TEST_FIELD = 'a1'
---------------------------------------------------------------------------------------------------------------------------------------------
This select returns three results : 'a1', 'a01', 'a001'.
When I run the same example (but with the default collation), everything seems
to be ok.
--
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
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
