[MCOL-5217] sql_mode=NO_AUTO_VALUE_ON_ZERO cause Columnstore Query Stats - fatal error runing mysql_real_query() in libmysql_client lib (1062) (Duplicate entry '0' for key 'PRIMARY') | Created: 2022-09-13  Updated: 2022-10-25

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 6.4.4-dompe
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

sql_mode=NO_AUTO_VALUE_ON_ZERO

cause

Columnstore Query Stats - fatal error runing mysql_real_query() in libmysql_client lib (1062)(Duplicate entry '0' for key 'PRIMARY')

error.

utils/querystats/querystats.cpp

shows, that '0' is used.

    ostringstream insert;
    insert << "insert into querystats values (0, ";
    insert << fSessionID << ", ";
    insert << "'" << fHost << "', ";


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