Questions tagged [fulltext-index]
123 questions
0
votes
0 answers
MySQL FullText Index is not managing Index for recent insert
I am using MYSQL Engine InnoDB.
I created fulltext index on my exisitng table but when I insert new record it couldn't pickup my new insert data.
Below query is working when I drop my index and regenerate it. But when I creat index and Insert new…
Humaira Faheem
- 1
- 3
0
votes
0 answers
Full text index not getting updated on Insertion of new records (Azure SQL Server 2017)
I have used full text index on two columns of one table. After applying, full text index applied on all the existing rows. So I am able to search through all the records using Contains. Then I have added one record into table but full text index…
Vivek Patel
- 1,028
- 1
- 10
- 22
0
votes
0 answers
T-SQL: How to all Full Text Index to include new columns?
I am hoping this is not a repeat, but I created my index and need to include more columns from my table to the index. I have been searching around, however, the general response is to delete it and start over.
Is there any way to just alter the Full…
Paradigm
- 189
- 1
- 5
- 21
0
votes
1 answer
SQL Server Full Text Search - contains
I have a really long filename stored in the database (the file name) with the full path: C:\folder\folder\my_supper_file_name_right_here.docx
If I use traditional
SELECT * FROM MYTABLE WHERE Name LIKE '%file%'
I will get all the results where the…
user2818430
- 5,853
- 21
- 82
- 148
0
votes
1 answer
Auto update of SQL Server full text index by the system causes blocking and timeouts
The internal system process that is automatically updating the full text indexes in a catalog (change tracking = on), takes too long to complete, locking other queries out that want to access the same table at the same time.
Is there something that…
Alpan
- 51
- 1
- 6
0
votes
0 answers
Can't find FULLTEXT index matching the column list in MySQL 5.7
I have an issue when executing a query with using MATCH AGAINST. I am using view for combining tables results and then I run a query on that view. The issue is that the query runs just fine in MariaDB 10.1, but the same query throws this error in…
Katerina
- 99
- 1
- 12
0
votes
1 answer
Negative numbers not indexed numbers without negative symbol in full text catalog
I store a docx file in sql server database that contains negative number like -56653.
I installed Microsoft Filter Pack 2.0 and execute this code:
EXEC sp_fulltext_service 'update_languages';
EXEC sp_fulltext_service 'load_os_resources', 1;
EXEC…
Fred
- 3,365
- 4
- 36
- 57
0
votes
1 answer
MariaDB fulltext search with special chars and "word starts with"
I can do a MariaDB fulltext query which searches for the word beginning like this:
select * from mytable
where match(mycol) against ('+test*' in boolean mode)>0.0;
This finds words like "test", "tester", "testing".
If my search string contains…
wknauf
- 160
- 1
- 7
0
votes
1 answer
wordforms on sphinx
If I use the wordforms file, to a word like this:
television > tv
If i search for television, i'd get results with TV on it, but i also want to have television results, is that possible?
williamhrs
- 35
- 7
0
votes
1 answer
Full text search asterisk returns wrong result
I have a Ship table with FTS index, which was created as:
CREATE FULLTEXT INDEX ON Ship
(
Name
)
KEY INDEX PK_Ship_Id
ON MyCatalog
WITH CHANGE_TRACKING AUTO, STOPLIST OFF;
And when I run query bellow:
select Name From Ship where…
Frad2
- 1
- 3
0
votes
1 answer
Search over multiple columns using fulltext
I seem to be having problems with my code and can't trace the issue. I want to have a search for multiple columns in my db, but I'm getting an error report.
I altered the table like so
"ALTER TABLE products ADD FULLTEXT alltext (`title`, `cat`,…
Makzino
- 43
- 9
0
votes
0 answers
same mysql database gives different fulltext index search results on 2 different servers
I have the same database running on 2 instances of mysql 5.7.20 (one on ubuntu, one on macosx). The osx-version gives sensible results in the InnoDB-fulltext search (e.g. searching for "facts and figures" gives 3 results on top with a relevance…
0
votes
1 answer
MySql - Error Code: 1215. Cannot add foreign key constraint if fulltext index added
I have a database and i took up a dump using --no-data.
I am trying to import that DB structure in an empty DB.
I am ignoring other queries, following the queries I am trying to execute,
set foreign_key_checks=0;
DROP TABLE IF EXISTS…
Akshay
- 3,558
- 4
- 43
- 77
0
votes
1 answer
FullText InnoDB Search with no response
i've a big problem using a fullText search in my innoDB database.
First of all the ns_pages table have more then 2.6m of records, with fulltext index with 3 keyblock.
This DB run on a Dell R710 with 128GB of Ram.
When i use this Query, the DB stop…
Andrea Rinaldi
- 1
- 1
0
votes
1 answer
Slow joins, index not being used on a varchar column
I have two tables and the join between them takes forever. Created relevant index but apparently its not being used is what my guess is.
Table 1:
CREATE TABLE `INTRADAY_PRICES_CASH` (
`TradingSymbol` varchar(100) CHARACTER SET latin1 NOT…
Kallol
- 264
- 1
- 12