[MCOL-1825] When performing specific left join using non integer keys, I get an error (Internal error On clause filter...) Created: 2018-10-19  Updated: 2023-10-25  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.6
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Matias Gorfinkiel Assignee: Roman
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

Several

Attachments: File MCOL-1825 bug scenario.sql    

 Description   

first things first: this is the first time I submit a bug, please forgive me if anything is wrong or not clear enough
I'm attaching a file with the full test in order to reproduce the bug. You can see the full picture there. Let me know if I can be of any help. We were trying to debug the cpp files, and got to line 2611 in jlf_tuplejoblist.cpp but nobody around here has any experience with cpp... sorry. BTW, this was performed both on an old Debian package and on a fresh install from the git repository.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-10-21 ]

Many thanks for the bug report. Very interesting. The SELECT will set the min/max values for the first column and that appears to be what is making the difference. Easily reproducible even on 1.2.0 alpha.

Comment by David Hall (Inactive) [ 2020-07-10 ]

Confirmed still a problem in 1.5

Generated at Thu Feb 08 02:31:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.