Bug 1477918 - sqlite built without operation support on accented characters (ICU)
sqlite built without operation support on accented characters (ICU)
Status: NEW
Product: Fedora
Classification: Fedora
Component: sqlite (Show other bugs)
26
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: Jakub Dorňák
Fedora Extras Quality Assurance
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2017-08-03 04:22 EDT by srakitnican
Modified: 2017-08-03 04:22 EDT (History)
4 users (show)

See Also:
Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description srakitnican 2017-08-03 04:22:41 EDT
Description of problem: Tried out sqlite only to find out that support for manipulating unicode accented characters is missing. Thus a database containing such characters can't make use of ORDER BY.


Version-Release number of selected component (if applicable):
sqlite-3.14.2-2.fc25.x86_64


How reproducible: Easily


Steps to Reproduce:
1. rm /tmp/test.db; sqlite3 /tmp/test.db "create table t1(t1key CHAR(50)); INSERT INTO t1 VALUES('z'); INSERT INTO t1 VALUES('a'); INSERT INTO t1 VALUES('s'); INSERT INTO t1 VALUES('š'); INSERT INTO t1 VALUES('č');"
2. sqlite3 /tmp/test.db "SELECT * FROM t1 ORDER BY t1key"


Actual results:
a
s
z
č
š


Expected results:
a
č
s
š
z

Additional info:
https://bugs.mageia.org/show_bug.cgi?id=16814

Note You need to log in before you can comment on or make changes to this bug.