manticoresearch icon indicating copy to clipboard operation
manticoresearch copied to clipboard

SHOW CREATE TABLE does not show the STOPWORDS directive

Open ctrlbrk42 opened this issue 1 year ago • 1 comments

Describe the bug SHOW CREATE TABLE does not show the STOPWORDS directive

To Reproduce Steps to reproduce the behavior:

  1. Create the table with stopword_file='/path/to/file.txt'
  2. show create table
  3. 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

ctrlbrk42 avatar Dec 20 '23 15:12 ctrlbrk42

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) ?

sanikolaev avatar Dec 26 '23 11:12 sanikolaev