VALUES clause cardinality
Reports situations when a number of parameters in VALUES does not match a number of columns in a target table.
Example (MySQL):
CREATE TABLE foo(a INT, b INT, c INT);
INSERT INTO foo VALUES (1,2,3,4)
The foo table has three columns but in the INSERT INTO statement we pass four.
Inspection Details | |
|---|---|
Available in: | AppCode 2023.3, CLion 2023.3, DataGrip 2023.3, DataSpell 2023.3, GoLand 2023.3, IntelliJ IDEA 2023.3, JetBrains Rider 2023.1, PhpStorm 2023.3, PyCharm 2023.3, Qodana for .NET 2023.1, Qodana for JVM 2023.3, Qodana for PHP 2023.3, Qodana for Ruby 2023.3, RubyMine 2023.3 |
Plugin: | Database Tools and SQL, 233.SNAPSHOT |
Last modified: 13 July 2023