Skip Menu |

This queue is for tickets about the DBIx-Class-Schema-Loader CPAN distribution.

Report information
The Basics
Id: 68734
Status: open
Priority: 0/
Queue: DBIx-Class-Schema-Loader

Owner: Nobody in particular
Requestors: michael.du-pont [...]

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

Subject: Text fields cannot be indexed without truncation in mysql
Download (untitled) / with headers
text/plain 771b
This table cannot be round tripped via the CREATE TABLE GOOD ( sometext text NOT NULL, UNIQUE KEY sometext2 ( sometext(150)) ) dbicdump -o dump_directory=./lib -o components='["InflateColumn::DateTime"]' DFL::Schema::TEST "dbi:mysql:database=$1:host=dbslave2" UID PWD '{ overwrite_modifications => 1, quote_char => "`" }' Produces : __PACKAGE__->add_unique_constraint("sometext2", [ "sometext"]); This produces bad sql when deployed: my $schema = Test::Schema::TEST->connect("dbi:mysql:dbname=${db}", $user, $pass); $schema->create_ddl_dir(['MySQL', 'SQLite', 'PostgreSQL'], '0.1', './sql/' ); $schema->deploy({ add_drop_table => 1}); ############ CREATE TABLE BAD ( sometext text NOT NULL, UNIQUE KEY sometext2 ( sometext) )
Download (untitled) / with headers
text/plain 151b
Adding dependency on the sqlt support ticket - without having an sqlt infrastructure to consume index lengths, there's no point of adding this to dbic.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to