Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.25, 10.2, 10.3, 10.4
-
None
-
None
Description
There is a garbage in virutal column in big tables with utf8 encoding.
Table:
CREATE TABLE clients_copy4 (
|
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
|
col1 VARCHAR(255) NOT NULL DEFAULT '',
|
col2 VARCHAR(255) NOT NULL DEFAULT '',
|
col3 VARCHAR(32) NULL DEFAULT NULL,
|
col_virtual VARCHAR(255) AS (concat(col1,' ',col2,' (',ifnull(col3,''),')')) VIRTUAL
|
)ENGINE=InnoDB
|
|
|
for($i=0; $i < 14000; $i++){
|
ENV::$dbi->insert("INSERT INTO clients_copy4(col1, col2, col3) VALUES ('мама', 'мыла', 'раму')");
|
}
|
Query:
SELECT id, col_virtual FROM clients_copy4 ORDER BY col_virtual; |
Result:
http://prntscr.com/od0vcs
If table contains less than 14k rows - it works ok, only big table has this bug.