Skip to content

join search crashed when using string not int #3233

Description

@shellphy

Bug Description:

docker compose config:

manticore:
    container_name: manticore
    image: manticoresearch/manticore:7.4.6
    environment:
      - EXTRA=1
      - searchd_binlog_path=
    restart: always
    ports:
      - 9306:9306
      - 9308:9308
    ulimits:
      nproc: 65535
      nofile:
        soft: 65535
        hard: 65535
      memlock:
        soft: -1
        hard: -1
    volumes:
      - manticore_data:/var/lib/manticore
create table products (name string, info text, price integer) morphology = 'stem_en';
insert into products (id, name, info, price) values (1, 'Product 1', 'First demo product, small', 10);

create table basket (user_id integer, product_code integer, product_name string, count integer);
insert into basket (user_id, product_code, product_name, count) values (1, 1, 'Product 1', 1);

select name, info, price, basket.count, basket.user_id 
from products left join basket on basket.product_name = products.name;

Manticore Search Version:

7.4.6 b2ff82920@25022808

Operating System Version:

Ubuntu 16.04.6 LTS

Have you tried the latest development version?

None

Internal Checklist:

To be completed by the assignee. Check off tasks that have been completed or are not applicable.

Details
  • Implementation completed
  • Tests developed
  • Documentation updated
  • Documentation reviewed
  • Changelog updated

Metadata

Metadata

Assignees

Labels

Type

Fields

No fields configured for Bug.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions