Bug #39795 Falcon: Online add index does not support index with non-null columns

Description:
By design, Falcon online add/drop index does not support indexes having non-null columns or primary keys. This restriction is no longer necessary and should be removed.

How to repeat:
CREATE TABLE t1 (s1 INT NOT NULL) ENGINE=FALCON;
ALTER ONLINE TABLE t1 ADD INDEX i1 (s1);

You will receive this error:

ERROR 1235 (42000): This version of MySQL doesn't yet support 'alter online table t1 add index i1 (s1)'

Suggested fix:
Remove explicit check for non-nullable columns and primary key in StorageEngine::check_if_supported_alter(), ha_falcon.cpp.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54992

2845 Christopher Powers	2008-10-01
      Bug#39711 "Running falcon_bug_34351_C shows increasing memory usage"
      Bug#39795 "Falcon: Online add index does not support index with non-null columns"
      Bug#39796 "Falcon: Reference count decrement not atomic"

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54993

2845 Christopher Powers	2008-10-01
      Bug#39711 "Running falcon_bug_34351_C shows increasing memory usage"
      Bug#39795 "Falcon: Online add index does not support index with non-null columns"
      Bug#39796 "Falcon: Reference count decrement not atomic"

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54994

2845 Christopher Powers	2008-10-01
      Bug#39711 "Running falcon_bug_34351_C shows increasing memory usage"
      Bug#39795 "Falcon: Online add index does not support index with non-null columns"
      Bug#39796 "Falcon: Reference count decrement not atomic"

Patch not approved, regression test falcon_online_index needs to be updated according to changed specifications/restrictions.

See http://lists.mysql.com/commits/54997

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/55169

2851 Christopher Powers	2008-10-03
      Bug#39795 "Falcon: Online add index does not support index with non-null columns"
      
      Lift restriction on adding online indexes having non-null columns.

A note has been added to the 6.0.8 changelog: 

Falcon did not support online add/drop index creation on tables using a NOT NULL column.