[MDEV-4579] SQL PARSER - Add Ignore to SET SQL command Created: 2013-05-24  Updated: 2015-11-17

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: roberto spadim Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

hi guys , could we have a SET IGNORE to change errors to warnings?
example...

SET sql_mode='ALLOW_INVALID_DATES,IPES_AS_CONCAT',character_set_client='latin1',
    character_set_connection='latin1',character_set_database='latin1',
    character_set_results='latin1',character_set_server='latin1',
    @@session.query_cache_strip_comAments=on

since the "@@session.query_cache_strip_comAments" doesn't exists

/* Error SQL (1193): Unknown system variable 'query_cache_strip_comAments' */

the SET isn't executed, but i want to execute it no problem about this unknown variable...

like INSERT IGNORE INTO , with duplicate rows

the IGNORE will only change variables that exists, and report warnings about variables that don't exists


Generated at Thu Feb 08 06:57:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.