wrong reference in "paths to external files should be absolute"

[githubmanticore]

Here

mysql> create table test (body text indexed) exceptions='/home/snikolaev/exceptions'; 
Query OK, 0 rows affected (0.02 sec) 
 
mysql> alter table test exceptions=''; 
ERROR 1064 (42000): paths to external files should be absolute: 'data/test/exceptions' 

seems to be a wrong reference to the old exceptions file.

UPDATE

The above happens only if data_dir is a relative path. In case it's absolute the behaviour is different:

mysql> create table test (body text indexed) exceptions='/home/snikolaev/exceptions'; 
Query OK, 0 rows affected (0.01 sec) 
 
mysql> alter table test exceptions=''; 
Query OK, 0 rows affected (0.00 sec) 

[githubmanticore]

➤ Sergey Nikolaev commented:

The problem happens only if data_dir is a relative path. In case it's absolute the behaviour is different:

mysql> create table test (body text indexed) exceptions='/home/snikolaev/exceptions'; 
Query OK, 0 rows affected (0.01 sec) 
 
mysql> alter table test exceptions=''; 
Query OK, 0 rows affected (0.00 sec) 

[githubmanticore]

➤ Ilya Kuznetsov commented:

Can't reproduce on recent master (Manticore 6.0.3 0fde0b5@230217 dev):

mysql> create table test4 (body text indexed) exceptions='D:/Work/test/configless/exceptions.txt'; 
Query OK, 0 rows affected (0.01 sec) 
 
mysql> alter table test exceptions=''; 
Query OK, 0 rows affected (0.00 sec) 

config (path to data dir is relative):

searchd 
{ 
		data_dir = data 

[githubmanticore]

➤ Sergey Nikolaev commented:

Please try not in Windows. I can still reproduce the issue in Mac:

mysql> create table test (body text indexed) exceptions='/Users/sn/exceptions'; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> alter table test exceptions=''; 
ERROR 1064 (42000): paths to external files should be absolute: 'data/test/exceptions' 

mysql> show status like '%version%'; 
+---------------+---------------------------------------------------------------------------------------------+ 
| Counter       | Value                                                                                       | 
+---------------+---------------------------------------------------------------------------------------------+ 
| version       | 6.0.3 a5f9a920d@230219 dev (columnar 2.0.0 a7c703d@230130) (secondary 2.0.0 a7c703d@230130) | 
| mysql_version | 6.0.3 a5f9a920d@230219 dev (columnar 2.0.0 a7c703d@230130) (secondary 2.0.0 a7c703d@230130) | 
+---------------+---------------------------------------------------------------------------------------------+ 
2 rows in set (0.00 sec) 

[githubmanticore]

➤ Ilya Kuznetsov commented:

Fixed in be6b2ea

[githubmanticore]

➤ Sergey Nikolaev commented:

Please update the changelog.

[githubmanticore]

➤ Ilya Kuznetsov commented:

Done in beec098