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: 2018-05-03 04:26 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
Comment 1 Fedora End Of Life 2018-05-03 04:26:32 EDT
This message is a reminder that Fedora 26 is nearing its end of life.
Approximately 4 (four) weeks from now Fedora will stop maintaining
and issuing updates for Fedora 26. It is Fedora's policy to close all
bug reports from releases that are no longer maintained. At that time
this bug will be closed as EOL if it remains open with a Fedora  'version'
of '26'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version'
to a later Fedora version.

Thank you for reporting this issue and we are sorry that we were not
able to fix it before Fedora 26 is end of life. If you would still like
to see this bug fixed and are able to reproduce it against a later version
of Fedora, you are encouraged  change the 'version' to a later Fedora
version prior this bug is closed as described in the policy above.

Although we aim to fix as many bugs as possible during every release's
lifetime, sometimes those efforts are overtaken by events. Often a
more recent Fedora release includes newer upstream software that fixes
bugs or makes them obsolete.

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