Details
-
Type:
Task
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Fix Version/s: 10.2
-
Component/s: None
-
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
