Informix/informix troubleshooting
SQUARED BRACKET "[]", LIKE WITH WILDCARD
@ipajama
2011. 9. 5. 21:30
728x90
IC69181: SQUARED BRACKET "[]" SUBSTRING OPERATION CREATES WORSE QUERY PLAN THAN CORRESPONDING SUBSTR() FUNCTION
https://www-304.ibm.com/support/docview.wss?uid=swg1IC69181
IC73640: WRONG RESULTS POSSIBLE FOR SQL QUERY WITH JOIN, LIKE WITH WILDCARD AND A SPECIFIC INDEX USED
IC62817: SELECT on INDEX WITH LIKE, UNDERSCORE AND LEADING OR FILTER RETURNS INCORRECT RESULTS
728x90