Setup fails when adding very first view due to faulty SQL query. (includes a patch)

[GoogleCodeExporter]

What steps will reproduce the problem?

1. Install system to new database.
2. Create tables.
3. Try to add a view.

The setup page reported an error.  I saw it was occurring during a SQL query.  
I debugged, and discovered the query was:

insert into blackboxviews set template= 'template-view2.html' , viewname= 
'view2', position= (select max(v.position)+1 from blackboxviews v)

Running this query manually, mysql reports:

ERROR 1048 (23000): Column 'position' cannot be null

I fixed the query by adding coalesce() like so:

insert into blackboxviews set template= 'template-view2.html' , viewname= 
'view2', position= (select coalesce(max(v.position),0)+1 from blackboxviews v)

I'm attaching a one-line patch that implements this fix.

Original issue reported on code.google.com by [email protected] on 2 Aug 2015 at 11:02

Attachments:

• patch.txt