sp_updateEnglishBasic123 (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

No parameters.

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDUREspupdateEnglishBasic123'._

Narrative

Business context: Throwaway scratch variant of sp_updateEnglishBasic — the 123 suffix is a convention in this codebase for one-off debugging artefacts. Confined to a single basic-data table (sisboxtype).

What it does: Creates a temp tmp_sisproductclassify (note: misnamed) snapshotting sisboxtype (sId, sBoxType, sBoxTypeenglish), then swaps the two columns with UPDATE sisboxtype JOIN tmp_sisproductclassify SET sBoxTypeenglish=sBoxType, sBoxType=sBoxTypeenglish. Has the same self-cancelling property as the parent — running twice restores the original values.

Invocation: Status: appears orphaned. No caller found in any channel — no form-master, no gdsmodule hook, no other routine, no xly-src grep. Test/scratch artefact; candidate for deletion after maintainer audit.