[MDEV-15230] column_json breaks cyrillic in 10.1.31 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.1.31, 10.0(EOL), 10.1(EOL)
Fix Version/s: 10.0.35, 10.1.32, 10.2.13, 10.3.5
Component/s: Dynamic Columns
Labels:
- regression
Environment:
Debian jessie amd64

Description

We have upgraded some clients from 10.1.30 to 10.1.31 (the latest package)
Then our app suddenly stopped working on certain places.
After investigation it turns out that column_json started produced invalid data as this:

select column_json(details) from b_client_order_details where client_order_id = 808636

| {"description":{"title":"\u0000\u000.\u0000\u000/\u0000\u000(\u000!\u000!\u0000\u0000\u0000\u000-\u0000\u000(\u0000\u000%","value":"\u0000\u000$\u0000\u000.\u0000\u000/\u000!\u000*\u0000\u000+\u0000\u000-\u0000\u000(\u000!\u000"\u0000\u000%\u0000\u000+\u0000\u000-\u0000\u000. \u000!\u000)\u0000\u000% \u000!\u000!\u0000\u000% \u0000\u000*\u0000\u0000\u0000\u000&\u0000\u000% \u0000\u000*\u0000\u0000\u0000\u000*\u000!\u000*\u0000\u000" \u000!\u000&\u0000\u000"\u000!\u000/\u000!\u000" \u000!\u000)\u0000\u000% \u000!\u000!\u0000\u0000 \u000!\u000&\u0000\u000%\u0000\u000+\u000!\u000#\u0000\u000"\u0000\u000*\u0000\u000(\u000!\u000"\u0000\u000%"}}

We've downgraded the package to 10.1.30 and it started working again:

select column_json(details) from b_client_order_details where client_order_id = 808636;

| {"description":{"title":"Описание","value":"Допълнително ще се каже какъв цвят ще са целувките"}}

This is a major blocker since it renders the hole app unusable.

Attachments

Activity

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2018-02-07 12:12

Thanks for the report. Reproducible on 10.0 and 10.1

set names utf8;

create table t1 (b blob);

insert into t1 values (column_create('description',column_create('title','Описание')));

select column_json(b) from t1;

drop table t1;

Elena Stepanova added a comment - 2018-02-07 12:12 Thanks for the report. Reproducible on 10.0 and 10.1 set names utf8; create table t1 (b blob); insert into t1 values (column_create( 'description' ,column_create( 'title' , 'Описание' ))); select column_json(b) from t1; drop table t1;

Oleksandr Byelkin added a comment - 2018-02-07 17:20

revision-id: b6455479e588fe1309157e8cc77cca10b90942b6 (mariadb-10.0.34-12-gb6455479e58)
parent(s): cb5374801e594282b41883bf38892d4788668df1
author: Oleksandr Byelkin
committer: Oleksandr Byelkin
timestamp: 2018-02-07 18:14:45 +0100
message:

~~MDEV-15230~~: column_json breaks cyrillic in 10.1.31

Use unsigned comparison.

—

Oleksandr Byelkin added a comment - 2018-02-07 17:20 revision-id: b6455479e588fe1309157e8cc77cca10b90942b6 (mariadb-10.0.34-12-gb6455479e58) parent(s): cb5374801e594282b41883bf38892d4788668df1 author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2018-02-07 18:14:45 +0100 message: MDEV-15230 : column_json breaks cyrillic in 10.1.31 Use unsigned comparison. —

People

Assignee:: Oleksandr Byelkin

Reporter:: Anton Avramov

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2018-02-07 10:25

Updated:: 2018-03-06 08:29

Resolved:: 2018-02-07 17:22

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server