Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.4, 11.8
-
None
Description
SELECT ..MATCH AGAINST does not find inserted values inside transaction
--source include/have_innodb.inc
|
|
CREATE TABLE t ( name varchar(45) NOT NULL, fulltext INDEX ftx_name (name)) engine=innodb; |
begin; |
INSERT INTO t VALUE ('franco'),('franco'),('franco'); |
SELECT name FROM t WHERE MATCH(name) AGAINST ('franco' IN BOOLEAN MODE); |
|
analyze table t; |
|
SELECT name FROM t WHERE MATCH(name) AGAINST ('franco' IN BOOLEAN MODE); |
|
commit; |
drop table t; |
MariaDB [test]> SELECT name FROM t WHERE MATCH(name) AGAINST ('franco' IN BOOLEAN MODE);
|
Empty set (0,012 sec)
|
|
MariaDB [test]> analyze table t;
|
+--------+---------+----------+----------+
|
| Table | Op | Msg_type | Msg_text |
|
+--------+---------+----------+----------+
|
| test.t | analyze | status | OK |
|
+--------+---------+----------+----------+
|
1 row in set (0,018 sec)
|
|
MariaDB [test]> SELECT name FROM t WHERE MATCH(name) AGAINST ('franco' IN BOOLEAN MODE);
|
+--------+
|
| name |
|
+--------+
|
| franco |
|
| franco |
|
| franco |
|
+--------+
|
3 rows in set (0,004 sec)
|
MariaDB [test]> CREATE TABLE t ( name varchar(45) NOT NULL, fulltext INDEX ftx_name (name)) engine=innodb;
|
Query OK, 0 rows affected (0,126 sec)
|
|
MariaDB [test]> begin;
|
Query OK, 0 rows affected (0,000 sec)
|
|
MariaDB [test]> INSERT INTO t VALUE ('franco'),('franco'),('franco');
|
Query OK, 3 rows affected (0,004 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> SELECT name FROM t WHERE MATCH(name) AGAINST ('franco' IN BOOLEAN MODE);
|
Empty set (0,004 sec)
|
|
MariaDB [test]> commit;
|
Query OK, 0 rows affected (0,013 sec)
|
|
MariaDB [test]> SELECT name FROM t WHERE MATCH(name) AGAINST ('franco' IN BOOLEAN MODE);
|
+--------+
|
| name |
|
+--------+
|
| franco |
|
| franco |
|
| franco |
|
+--------+
|
3 rows in set (0,005 sec)
|