Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
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