[PS8QA] handle_fatal_signal (sig=6) in compression_dict::cols_table_delete_low | sql/sql_zip_dict.cc:765

Description

Testcase

GDB Info

Environment

None

Smart Checklist

Activity

Show:

Marcelo Altmann April 3, 2019 at 1:56 AM

Analyzes.

Engine support validation for compressed columns is not performed when creating tables with partition. Partitioned tables allow multiple combinations of storage engines, which is syntactically correct. When omitting table SE on non partition table, @@default_storage_engine will be used as default. But for partitioned tables, you can omit default SE, and pass a SE on partition clause. In this case, instead of using @@default_storage_engine as table SE, the SE passed on partition clause will be passed as table SE.
Current 8.0 is missing the check on partitioned tables.

Ramesh Sivaraman January 16, 2019 at 11:40 AM

Could not reproduce the issue with 5.7 build.

Satya Bodapati January 11, 2019 at 2:11 PM

heh, compressed columns is supported by RocksDB? I don't think so.

create table should have failed.

can you please verify in 5.7?

Peter Schwaller December 19, 2018 at 1:19 PM

8.0 triage:  Agreed, but in this case we're willing to take the risk that valid SQL also leads down the same path as this unsupported scenario.  Root cause analysis will be done after GA.

roel.vandepaar December 19, 2018 at 2:35 AM
Edited

Triage, as I mentioned elsewhere, QA logs one testcase per particular crash, then filters the issue. There may be many other SQL's that can lead to a particular bug, and this issue may very well be more significant as a single testcase/situation. Please provide proper core issue analysis first before triaging.

Done

Details

Assignee

Reporter

Time tracking

2d 4h 21m logged

Fix versions

Affects versions

Priority

Smart Checklist

Created December 18, 2018 at 7:22 AM
Updated March 6, 2024 at 12:33 PM
Resolved June 18, 2019 at 4:36 PM