[MDEV-14231] MATCH() AGAINST( IN BOOLEAN MODE), results mismatch - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 10.5.27
Component/s: Full-text Search, Storage Engine - InnoDB, Tests
Labels:
None

Description

https://github.com/MariaDB/server/tree/bb-10.2-alice/mysql-test/suite/innodb_fts/t/multiple_index.test

results are different in mysql/mariadb, need check which ones are correct
testcase

drop table if exists t1;

CREATE TABLE t1 (

id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,

a VARCHAR(200),

b TEXT

) ENGINE = InnoDB STATS_PERSISTENT=0;

INSERT INTO t1 (a,b) VALUES

        ('MySQL Tutorial','DBMS stands for DataBase ...')  ,

        ('How To Use MySQL Well','After you went through a ...'),

        ('Optimizing MySQL','In this tutorial we will show ...');

ALTER TABLE t1 ADD FULLTEXT INDEX idx_1 (a);

ALTER TABLE t1 ADD FULLTEXT INDEX idx_2 (b);

SHOW CREATE TABLE t1;

START TRANSACTION;

INSERT INTO t1 (a,b) VALUES

        ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),

        ('MySQL vs. YourSQL','In the following database comparison ...'),

        ('MySQL Security','When configured properly, MySQL ...');

ROLLBACK;

select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;

in MariaDb 10.2

MariaDB [test]> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;

+----+-----------------------+-----------------------------------+----------------------------+

| id | a                     | b                                 | x                          |

+----+-----------------------+-----------------------------------+----------------------------+

|  1 | MySQL Tutorial        | DBMS stands for DataBase ...      | 0.000000001885928302414186 |

|  2 | How To Use MySQL Well | After you went through a ...      | 0.000000001885928302414186 |

|  3 | Optimizing MySQL      | In this tutorial we will show ... |        0.22764469683170319 |

+----+-----------------------+-----------------------------------+----------------------------+

3 rows in set (0.00 sec)

Mysql 5.7

mysql> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;

+----+-----------------------+-----------------------------------+--------------------+

| id | a                     | b                                 | x                  |

+----+-----------------------+-----------------------------------+--------------------+

|  1 | MySQL Tutorial        | DBMS stands for DataBase ...      | 0.0906190574169159 |

|  2 | How To Use MySQL Well | After you went through a ...      | 0.0906190574169159 |

|  3 | Optimizing MySQL      | In this tutorial we will show ... | 0.6961383819580078 |

+----+-----------------------+-----------------------------------+--------------------+

3 rows in set (0,00 sec)

Attachments

Issue Links

is part of

MDEV-13626 Merge InnoDB test cases from MySQL 5.7

Closed

relates to

MDEV-14252 innodb_fts.limit_union failed, results mismatch, MATCH .. AGAINST (.. IN BOOLEAN MODE)

Open

Activity

Ascending order - Click to sort in descending order

Alice Sherepa created issue - 2017-10-31 12:37

Alice Sherepa made changes - 2017-10-31 12:41

Field	Original Value	New Value
Priority	Major [ 3 ]	Minor [ 4 ]

Alice Sherepa made changes - 2017-11-02 11:31

Description

https://github.com/MariaDB/server/blob/mdev-13626/mysql-test/suite/innodb_fts/t/multiple_index.test
results are different in mysql/mariadb, need check which ones are correct
{noformat}
innodb_fts.multiple_index 'innodb' [ fail ]
Test ended at 2017-10-31 13:24:02

CURRENT_TEST: innodb_fts.multiple_index
--- /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/multiple_index.result 2017-10-31 13:23:44.235957120 +0100
+++ /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/multiple_index.reject 2017-10-31 13:24:02.727933024 +0100
@@ -46,9 +46,9 @@
1 MySQL Tutorial DBMS stands for DataBase ...
select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
id a b x
-1 MySQL Tutorial DBMS stands for DataBase ... 0.0906190574169159
-2 How To Use MySQL Well After you went through a ... 0.0906190574169159
-3 Optimizing MySQL In this tutorial we will show ... 0.6961383819580078
+1 MySQL Tutorial DBMS stands for DataBase ... 0.000000001885928302414186
+2 How To Use MySQL Well After you went through a ... 0.000000001885928302414186
+3 Optimizing MySQL In this tutorial we will show ... 0.22764469683170319
select *, MATCH(b) AGAINST("collections support" IN BOOLEAN MODE) as x from t1;
id a b x
1 MySQL Tutorial DBMS stands for DataBase ... 0
@@ -90,9 +90,9 @@
1 MySQL Tutorial DBMS stands for DataBase ...
select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
id a b x
-1 MySQL Tutorial DBMS stands for DataBase ... 0.0906190574169159
-2 How To Use MySQL Well After you went through a ... 0.0906190574169159
-3 Optimizing MySQL In this tutorial we will show ... 0.6961383819580078
+1 MySQL Tutorial DBMS stands for DataBase ... 0.000000001885928302414186
+2 How To Use MySQL Well After you went through a ... 0.000000001885928302414186
+3 Optimizing MySQL In this tutorial we will show ... 0.22764469683170319
select *, MATCH(b) AGAINST("collections support" IN BOOLEAN MODE) as x from t1;
id a b x
1 MySQL Tutorial DBMS stands for DataBase ... 0

mysqltest: Result length mismatch

{noformat}

https://github.com/MariaDB/server/blob/mdev-13626/mysql-test/suite/innodb_fts/t/multiple_index.test
results are different in mysql/mariadb, need check which ones are correct
testcase

{code:sql}
drop table if exists t1;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) ENGINE = InnoDB STATS_PERSISTENT=0;

INSERT INTO t1 (a,b) VALUES
        ('MySQL Tutorial','DBMS stands for DataBase ...') ,
        ('How To Use MySQL Well','After you went through a ...'),
        ('Optimizing MySQL','In this tutorial we will show ...');

ALTER TABLE t1 ADD FULLTEXT INDEX idx_1 (a);
ALTER TABLE t1 ADD FULLTEXT INDEX idx_2 (b);
SHOW CREATE TABLE t1;

START TRANSACTION;

INSERT INTO t1 (a,b) VALUES
        ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
        ('MySQL vs. YourSQL','In the following database comparison ...'),
        ('MySQL Security','When configured properly, MySQL ...');
ROLLBACK;

select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
{code}

in MariaDb 10.2
{noformat}
MariaDB [test]> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
+----+-----------------------+-----------------------------------+----------------------------+
| id | a | b | x |
+----+-----------------------+-----------------------------------+----------------------------+
| 1 | MySQL Tutorial | DBMS stands for DataBase ... | 0.000000001885928302414186 |
| 2 | How To Use MySQL Well | After you went through a ... | 0.000000001885928302414186 |
| 3 | Optimizing MySQL | In this tutorial we will show ... | 0.22764469683170319 |
+----+-----------------------+-----------------------------------+----------------------------+
3 rows in set (0.00 sec)
{noformat}

Mysql 5.7
{noformat}
mysql> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
+----+-----------------------+-----------------------------------+--------------------+
| id | a | b | x |
+----+-----------------------+-----------------------------------+--------------------+
| 1 | MySQL Tutorial | DBMS stands for DataBase ... | 0.0906190574169159 |
| 2 | How To Use MySQL Well | After you went through a ... | 0.0906190574169159 |
| 3 | Optimizing MySQL | In this tutorial we will show ... | 0.6961383819580078 |
+----+-----------------------+-----------------------------------+--------------------+
3 rows in set (0,00 sec)
{noformat}

Alice Sherepa made changes - 2017-11-02 11:32

Priority

Minor [ 4 ]

Major [ 3 ]

Alice Sherepa made changes - 2017-11-02 11:34

Summary

innodb_fts.multiple_index failed with results mismatch

MATCH() AGAINST( IN BOOLEAN MODE), results mismatch

Alice Sherepa added a comment - 2017-11-02 14:38

also in plugin_debug test https://github.com/MariaDB/server/blob/mdev-13626/mysql-test/suite/innodb_fts/t/plugin_debug.test

CURRENT_TEST: innodb_fts.plugin_debug

--- /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/plugin_debug.result	2017-11-02 13:01:39.827614000 +0100

+++ /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/plugin_debug.reject	2017-11-02 15:33:28.110118532 +0100

@@ -1,4 +1,4 @@

-INSTALL PLUGIN simple_parser SONAME 'mypluglib.so';

+INSTALL PLUGIN simple_parser SONAME 'mypluglib';

 # Test Part 2: Create Index Test(CREATE TABLE WITH FULLTEXT INDEX)

 CREATE TABLE articles (

 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,

@@ -131,7 +131,6 @@

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

 id	title	body

-1	MySQL Tutorial	DBMS stands for MySQL DataBase ...

 DROP TABLE articles;

 # Test Part 5: Row Merge Create Index Test with Default/Internal Parser

 CREATE TABLE articles (

@@ -173,7 +172,6 @@

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

 id	title	body

-1	MySQL Tutorial	DBMS stands for MySQL DataBase ...

 DROP TABLE articles;

 # Test Part 6: Test Query Parser with Default/Internal Parser

 SET GLOBAL innodb_ft_enable_diag_print = 1;

@@ -232,15 +230,12 @@

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

 id	title	body

-1	MySQL Tutorial	DBMS stands for MySQL DataBase ...

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('"full text search"' IN BOOLEAN MODE);

 id	title	body

-5	1001 MySQL Tricks	How to use full-text search engine

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('"full text search engine"' IN BOOLEAN MODE);

 id	title	body

-5	1001 MySQL Tricks	How to use full-text search engine

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('+"dbms stands" -good' IN BOOLEAN MODE);

 id	title	body

@@ -257,7 +252,6 @@

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('+("dbms stands" "full text") -good' IN BOOLEAN MODE);

 id	title	body

-5	1001 MySQL Tricks	How to use full-text search engine

 1	MySQL Tutorial	DBMS stands for MySQL DataBase ...

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('("msyql database")@3' IN BOOLEAN MODE);

@@ -298,7 +292,6 @@

 SELECT * FROM articles WHERE

 MATCH(title, body) AGAINST('"计算机 数据库"' IN BOOLEAN MODE);

 id	title	body

-3	要 想 将 数据 添加 到 数据库	或 访问、处理 计算机 数据库 中 保存 的 数据

 DROP TABLE articles;

 SET GLOBAL innodb_ft_enable_diag_print = 0;

 SET SESSION DEBUG_DBUG="-d,fts_instrument_use_default_parser";

Alice Sherepa added a comment - 2017-11-02 14:38 also in plugin_debug test https://github.com/MariaDB/server/blob/mdev-13626/mysql-test/suite/innodb_fts/t/plugin_debug.test CURRENT_TEST: innodb_fts.plugin_debug --- /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/plugin_debug.result 2017-11-02 13:01:39.827614000 +0100 +++ /home/alice/aliska/10.2/mysql-test/suite/innodb_fts/r/plugin_debug.reject 2017-11-02 15:33:28.110118532 +0100 @@ -1,4 +1,4 @@ -INSTALL PLUGIN simple_parser SONAME 'mypluglib.so'; +INSTALL PLUGIN simple_parser SONAME 'mypluglib'; # Test Part 2: Create Index Test(CREATE TABLE WITH FULLTEXT INDEX) CREATE TABLE articles ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, @@ -131,7 +131,6 @@ SELECT * FROM articles WHERE MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE); id title body -1 MySQL Tutorial DBMS stands for MySQL DataBase ... DROP TABLE articles; # Test Part 5: Row Merge Create Index Test with Default/Internal Parser CREATE TABLE articles ( @@ -173,7 +172,6 @@ SELECT * FROM articles WHERE MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE); id title body -1 MySQL Tutorial DBMS stands for MySQL DataBase ... DROP TABLE articles; # Test Part 6: Test Query Parser with Default/Internal Parser SET GLOBAL innodb_ft_enable_diag_print = 1; @@ -232,15 +230,12 @@ SELECT * FROM articles WHERE MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE); id title body -1 MySQL Tutorial DBMS stands for MySQL DataBase ... SELECT * FROM articles WHERE MATCH(title, body) AGAINST('"full text search"' IN BOOLEAN MODE); id title body -5 1001 MySQL Tricks How to use full-text search engine SELECT * FROM articles WHERE MATCH(title, body) AGAINST('"full text search engine"' IN BOOLEAN MODE); id title body -5 1001 MySQL Tricks How to use full-text search engine SELECT * FROM articles WHERE MATCH(title, body) AGAINST('+"dbms stands" -good' IN BOOLEAN MODE); id title body @@ -257,7 +252,6 @@ SELECT * FROM articles WHERE MATCH(title, body) AGAINST('+("dbms stands" "full text") -good' IN BOOLEAN MODE); id title body -5 1001 MySQL Tricks How to use full-text search engine 1 MySQL Tutorial DBMS stands for MySQL DataBase ... SELECT * FROM articles WHERE MATCH(title, body) AGAINST('("msyql database")@3' IN BOOLEAN MODE); @@ -298,7 +292,6 @@ SELECT * FROM articles WHERE MATCH(title, body) AGAINST('"计算机数据库"' IN BOOLEAN MODE); id title body -3 要想将数据添加到数据库或访问、处理计算机数据库中保存的数据 DROP TABLE articles; SET GLOBAL innodb_ft_enable_diag_print = 0; SET SESSION DEBUG_DBUG="-d,fts_instrument_use_default_parser";

Alice Sherepa made changes - 2017-11-15 11:59

Description

https://github.com/MariaDB/server/blob/mdev-13626/mysql-test/suite/innodb_fts/t/multiple_index.test
results are different in mysql/mariadb, need check which ones are correct
testcase

{code:sql}
drop table if exists t1;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) ENGINE = InnoDB STATS_PERSISTENT=0;

INSERT INTO t1 (a,b) VALUES
        ('MySQL Tutorial','DBMS stands for DataBase ...') ,
        ('How To Use MySQL Well','After you went through a ...'),
        ('Optimizing MySQL','In this tutorial we will show ...');

ALTER TABLE t1 ADD FULLTEXT INDEX idx_1 (a);
ALTER TABLE t1 ADD FULLTEXT INDEX idx_2 (b);
SHOW CREATE TABLE t1;

START TRANSACTION;

INSERT INTO t1 (a,b) VALUES
        ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
        ('MySQL vs. YourSQL','In the following database comparison ...'),
        ('MySQL Security','When configured properly, MySQL ...');
ROLLBACK;

select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
{code}

in MariaDb 10.2
{noformat}
MariaDB [test]> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
+----+-----------------------+-----------------------------------+----------------------------+
| id | a | b | x |
+----+-----------------------+-----------------------------------+----------------------------+
| 1 | MySQL Tutorial | DBMS stands for DataBase ... | 0.000000001885928302414186 |
| 2 | How To Use MySQL Well | After you went through a ... | 0.000000001885928302414186 |
| 3 | Optimizing MySQL | In this tutorial we will show ... | 0.22764469683170319 |
+----+-----------------------+-----------------------------------+----------------------------+
3 rows in set (0.00 sec)
{noformat}

Mysql 5.7
{noformat}
mysql> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
+----+-----------------------+-----------------------------------+--------------------+
| id | a | b | x |
+----+-----------------------+-----------------------------------+--------------------+
| 1 | MySQL Tutorial | DBMS stands for DataBase ... | 0.0906190574169159 |
| 2 | How To Use MySQL Well | After you went through a ... | 0.0906190574169159 |
| 3 | Optimizing MySQL | In this tutorial we will show ... | 0.6961383819580078 |
+----+-----------------------+-----------------------------------+--------------------+
3 rows in set (0,00 sec)
{noformat}

https://github.com/MariaDB/server/tree/bb-10.2-alice/mysql-test/suite/innodb_fts/t/multiple_index.test

results are different in mysql/mariadb, need check which ones are correct
testcase

{code:sql}
drop table if exists t1;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
a VARCHAR(200),
b TEXT
) ENGINE = InnoDB STATS_PERSISTENT=0;

INSERT INTO t1 (a,b) VALUES
        ('MySQL Tutorial','DBMS stands for DataBase ...') ,
        ('How To Use MySQL Well','After you went through a ...'),
        ('Optimizing MySQL','In this tutorial we will show ...');

ALTER TABLE t1 ADD FULLTEXT INDEX idx_1 (a);
ALTER TABLE t1 ADD FULLTEXT INDEX idx_2 (b);
SHOW CREATE TABLE t1;

START TRANSACTION;

INSERT INTO t1 (a,b) VALUES
        ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
        ('MySQL vs. YourSQL','In the following database comparison ...'),
        ('MySQL Security','When configured properly, MySQL ...');
ROLLBACK;

select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
{code}

in MariaDb 10.2
{noformat}
MariaDB [test]> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
+----+-----------------------+-----------------------------------+----------------------------+
| id | a | b | x |
+----+-----------------------+-----------------------------------+----------------------------+
| 1 | MySQL Tutorial | DBMS stands for DataBase ... | 0.000000001885928302414186 |
| 2 | How To Use MySQL Well | After you went through a ... | 0.000000001885928302414186 |
| 3 | Optimizing MySQL | In this tutorial we will show ... | 0.22764469683170319 |
+----+-----------------------+-----------------------------------+----------------------------+
3 rows in set (0.00 sec)
{noformat}

Mysql 5.7
{noformat}
mysql> select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;
+----+-----------------------+-----------------------------------+--------------------+
| id | a | b | x |
+----+-----------------------+-----------------------------------+--------------------+
| 1 | MySQL Tutorial | DBMS stands for DataBase ... | 0.0906190574169159 |
| 2 | How To Use MySQL Well | After you went through a ... | 0.0906190574169159 |
| 3 | Optimizing MySQL | In this tutorial we will show ... | 0.6961383819580078 |
+----+-----------------------+-----------------------------------+--------------------+
3 rows in set (0,00 sec)
{noformat}

Sergei Golubchik made changes - 2021-12-06 21:33

Workflow

MariaDB v3 [ 83372 ]

MariaDB v4 [ 140487 ]

Julien Fritsch made changes - 2023-10-31 10:30

Fix Version/s		10.6 [ 24028 ]
Fix Version/s	10.2 [ 14601 ]

Marko Mäkelä added a comment - 2023-11-08 11:05

Similar to MDEV-14252, I think that this needs to be analyzed by thiru.

Marko Mäkelä added a comment - 2023-11-08 11:05 Similar to MDEV-14252 , I think that this needs to be analyzed by thiru .

Marko Mäkelä made changes - 2023-11-08 11:05

Link

This issue relates to MDEV-14252 [ MDEV-14252 ]

Marko Mäkelä made changes - 2023-11-08 11:06

Component/s		Full-text Search [ 10104 ]
Component/s		Storage Engine - InnoDB [ 10129 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Assignee		Thirunarayanan Balathandayuthapani [ thiru ]

Julien Fritsch made changes - 2024-04-02 09:52

Parent	~~MDEV-13626~~ [ 62822 ]
Affects Version/s	10.2 [ 14601 ]
Affects Version/s	10.3 [ 22126 ]
Affects Version/s	10.4 [ 22408 ]
Issue Type	Technical task [ 7 ]	Task [ 3 ]

Julien Fritsch made changes - 2024-04-02 09:53

Link

This issue is part of ~~MDEV-13626~~ [ ~~MDEV-13626~~ ]

Thirunarayanan Balathandayuthapani added a comment - 2024-04-05 09:42

multiple_index.test - behaves correctly in MariaDB. In mysql, statistics n_rows value is 6 (wrong one). So it leads to different rank value.
To prove that the behaviour of test case changes after analyze table.

In mysql:

select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;

id      a       b       x

1       MySQL Tutorial  DBMS stands for DataBase ...    0.0906190574169159

2       How To Use MySQL Well   After you went through a ...    0.0906190574169159

3       Optimizing MySQL        In this tutorial we will show ...       0.6961383819580078

ANALYZE TABLE t1;

Table   Op      Msg_type        Msg_text

test.t1 analyze status  OK

select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1;

id      a       b       x

1       MySQL Tutorial  DBMS stands for DataBase ...    0.000000001885928302414186

2       How To Use MySQL Well   After you went through a ...    0.000000001885928302414186

3       Optimizing MySQL        In this tutorial we will show ...       0.22764469683170319

plugin_debug test case needs code changes in mariadb.

Thirunarayanan Balathandayuthapani added a comment - 2024-04-05 09:42 multiple_index.test - behaves correctly in MariaDB. In mysql, statistics n_rows value is 6 (wrong one). So it leads to different rank value. To prove that the behaviour of test case changes after analyze table. In mysql: select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1; id a b x 1 MySQL Tutorial DBMS stands for DataBase ... 0.0906190574169159 2 How To Use MySQL Well After you went through a ... 0.0906190574169159 3 Optimizing MySQL In this tutorial we will show ... 0.6961383819580078 ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK select *, MATCH(a) AGAINST("Optimizing MySQL" IN BOOLEAN MODE) as x from t1; id a b x 1 MySQL Tutorial DBMS stands for DataBase ... 0.000000001885928302414186 2 How To Use MySQL Well After you went through a ... 0.000000001885928302414186 3 Optimizing MySQL In this tutorial we will show ... 0.22764469683170319 plugin_debug test case needs code changes in mariadb.

Thirunarayanan Balathandayuthapani made changes - 2024-08-13 10:36

Fix Version/s		10.5.27 [ 29902 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2024-11-12 19:37

Issue Type

Task [ 3 ]

Bug [ 1 ]

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2017-10-31 12:37

Updated:: 2024-11-12 19:37

Resolved:: 2024-08-13 10:36

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration