my $data = parse($tr,
q[
CREATE TABLE orders (
- order_id integer NOT NULL auto_increment,
+ order_id integer NOT NULL comment ' ' auto_increment,
member_id varchar(255) comment 'fk to ''member''',
billing_address_id int,
shipping_address_id int,
is( $f1->default_value, undef, 'Default value is undefined' );
is( $f1->is_primary_key, 1, 'Field is PK' );
is( $f1->is_auto_increment, 1, 'Field is auto inc' );
+ is_deeply( [$f1->comments],[' '], 'Field comment OK' );
my $f2 = shift @fields;
is( $f2->name, 'member_id', 'Second field name is "member_id"' );