MySQL Bugs: #51566: add # columns to error 1136 (Column Count Doesn't Match Value Count at row 1)

Bug #51566	add # columns to error 1136 (Column Count Doesn't Match Value Count at row 1)
Submitted:	26 Feb 2010 22:04	Modified:	15 Dec 2010 13:33
Reporter:	ivo welch	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	error

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:

because you drop out with an error, you may as well tell the user exactly why.  here is:

ERROR 1136 (21S01) at line 1874: Column count doesn't match value count at row 1

How to repeat:

insert wrong number of data items

Suggested fix:

ERROR 1136 (21S01) at line 1874: Column count of 256 doesn't match value count of 257 at row 1

Thank you for the feature request.