manticoresearch
manticoresearch copied to clipboard
SHOW CREATE TABLE does not show the STOPWORDS directive
Describe the bug SHOW CREATE TABLE does not show the STOPWORDS directive
To Reproduce Steps to reproduce the behavior:
- Create the table with stopword_file='/path/to/file.txt'
- show create table
- Isn't listed. But it also didn't give an error on creation, so assume it worked.
Expected behavior Show in 'show create table'
Latest build via Docker
Can't reproduce in Docker in 6.2.12:
snikolaev@dev2:~$ docker run -e EXTRA=1 --name manticore --rm -d manticoresearch/manticore:6.2.12 && echo "Waiting for Manticore docker to start. Consider mapping the data_dir to make it start faster next time" && until docker logs manticore 2>&1 | grep -q "accepting connections"; do sleep 1; echo -n .; done && echo && docker exec -it manticore mysql && docker stop manticore
43ba9f760c3dd585071adfeb7f497d0d17e70bc9ace773cce724269cb7a104c7
snikolaev@dev2:~$ docker exec -it manticore bash
root@43ba9f760c3d:/var/lib/manticore# echo "a" > /tmp/stops
root@43ba9f760c3d:/var/lib/manticore# searchd -v
Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2023, Manticore Software LTD (https://manticoresearch.com)
root@43ba9f760c3d:/var/lib/manticore# mysql -P9306 -h0 -e "drop table if exists t; create table t stopwords='/tmp/stops'; show create table t;"
+-------+---------------------------------------------------------------------+
| Table | Create Table |
+-------+---------------------------------------------------------------------+
| t | CREATE TABLE t (
id bigint
) stopwords='/var/lib/manticore/t/stops' |
+-------+---------------------------------------------------------------------+
stopword_file='/path/to/file.txt'
Could it be the case that you did stopword_file instead of stopwords (https://manual.manticoresearch.com/Creating_a_table/NLP_and_tokenization/Ignoring_stop-words#stopwords) ?