This issue is in NB 6.5.1 as well.

A syntax error will occur when adding a new VARCHAR column to a table and no size is provided in the 'Add Column' 
dialog.

E.g. The generated query 'alter table "FOO"."BAR" add FUBAR VARCHAR' results in error 'Syntax error: 
Encountered "<EOF>" at line 1, column 46'.

This happens because no size was provided and Derby/Java DB somehow requires a size to be provided, no default size is 
used. The way I see it is that there are two solutions:

1. Default to a value if no size is provided.
2. Force the user to supply a size.

In case of option 1 the max allowed size could be used where the generated 'VARCHAR' in the query above becomes 'VARCHAR
(32672)'. Pro: no need to supply the size; con: the user might not expect the default chosen size.

In case of option 2 the user isn't allowed to continue to execute the query if no size is provided. Con: the user is 
forced to supply a size; Pro: the user knows what the size will become.

I would slightly prefer option 1. At least both options prevent the user from being presented with a useless error.