Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.8.4, 10.9.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
-
None
Description
create a CONNECT BIN table with a unsigned field is not creating the .bop block_index file,
also fails on optimize table as well.:
create table tm ( |
time INT4 unsigned not null DEFAULT 0 field_format='X' DISTRIB=sorted, |
data INT4 unsigned not null DEFAULT 0 field_format='X' |
) engine=CONNECT table_type=BIN block_size=128 file_name='tm.dat'; |
then INSERT 1000 rows,
MariaDB [test]> select * from tm limit 10;
|
|
|
| time | data |
|
|
|
| 1651378127 | 7447060 |
|
| 1651378187 | 6197231 |
|
| 1651378288 | 9090561 |
|
| 1651378390 | 9525601 |
|
| 1651378451 | 4827450 |
|
| 1651378511 | 4905942 |
|
| 1651378579 | 5260349 |
|
no tm.bop file shows up:
-rw-rw---- 1 mysql mysql 8000 Aug 19 14:31 tm.dat
|
-rw-rw---- 1 mysql mysql 565 Aug 19 14:31 tm.frm
|
Optimize fails as well:
MariaDB [test]> optimize table tm;
|
|
|
| Table | Op | Msg_type | Msg_text |
|
|
|
| test.tm | optimize | Error | Non matching Value types |
|
| test.tm | optimize | error | Unknown - internal error 122 during operation |
|
|
|
2 rows in set (0.000 sec)
|
Recreate table with signed
drop table tm; |
create table tm ( |
time INT4 not null DEFAULT 0 field_format='X' DISTRIB=sorted, |
data INT4 unsigned not null DEFAULT 0 field_format='X' |
) engine=CONNECT table_type=BIN block_size=128 file_name='tm.dat'; |
update tm set time=time-1 limit 1;
|
update tm set time=time+1 limit 1
|
Now we have tm.bop file:
-rw-rw---- 1 mysql mysql 80 Aug 19 14:33 tm.bop
|
-rw-rw---- 1 mysql mysql 8000 Aug 19 14:33 tm.dat
|
-rw-rw---- 1 mysql mysql 565 Aug 19 14:33 tm.frm
|
And also optimize works
MariaDB [test]> optimize table tm;
|
|
|
| Table | Op | Msg_type | Msg_text |
|
|
|
| test.tm | optimize | status | OK |
|
|
|
1 row in set (0.000 sec)
|
So there seems to be an issue with unsigned types (I tried short as well) and this DISTRIB sorted