27713http://bugs.mysql.com/bug.php?id=27713VerifiedServer: ViewsINSERTs fail for empty table using WITH_CHECK_OPTIONReported as Debian bug on http://bugs.debian.org/418248 -------------------------------------------------------------------- From: Stephan Peijnik <sp@sp.or.at> When trying to INSERT into a view using "WITH_CHECK_OPTION" fails while the view is empty. INSERT'ing also fails after a row has been inserted into the underlying table and works once one has inserted a row into the underlying table and SELECTs from the view. More information including error messages and an SQL dump can be found at http://paste.lisp.org/display/39398/. I'm unsure about if this is really a bug, but the behaviour (having to SELECT before INSERT works) makes me believe it is one. Version: 5.0.38 Architecture: i386 (i686) Kernel: Linux 2.6.18-4-686 --------------------------------------------------------------------- I ask the user for a simpler test case. bye, -christian-16744117611747811761907135.0.38, 5.1, 5.2AnyAnyS3 (Non-critical)