CRITICAL
Rule Definition
To preserve code functionality and avoid mistakes with regard to column handling, always explicitly use the column name.
Remediation
Check the statement and if so, add columns in INSERT clause.
Violation Code Sample
The following procedure should be reviewed:
CREATE PROCEDURE INSERT_VALUES
BEGIN
INSERT INTO Persons VALUES ('Last', 'First', 'Add', 'City');
END;
Fixed Code Sample
The following procedure should be reviewed:
CREATE PROCEDURE INSERT_VALUES
BEGIN
INSERT INTO Persons VALUES ('Last', 'First', 'Add', 'City');
END;
Add columns in INSERT clause:
CREATE PROCEDURE INSERT_VALUES
BEGIN
INSERT INTO Persons (LastName, FirstName, Address, City) VALUES ('Last', 'First', 'Add', 'City');
END;
Related Technologies
Technical Criterion
Programming Practices - Unexpected Behavior
About CAST Appmarq
CAST Appmarq is by far the biggest repository of data about real IT systems. It's built on thousands of analyzed applications, made of 35 different technologies, by over 300 business organizations across major verticals. It provides IT Leaders with factual key analytics to let them know if their applications are on track.