Skip Menu |
 

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 87731
Status: open
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: STUIFZAND [...] cpan.org
Cc:
AdminCc:

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



Subject: No way to specify quoting of names of tables and fields in Schema::Versioned diff
Download (untitled) / with headers
text/plain 520b
I can specify quote_identifiers in create_ddl_dir, but this option isn't used when creating a diff. It's only used for the complete the schema. $schema->create_ddl_dir(['MySQL'], undef, './sql', $preversion, {quote_identifiers => 1}); It seems SQL::Translator::schema_diff expects producer_args that specify special options for quoting fields and table names. These options aren't passed in. This means there is a difference in the quoting of the complete SQL file for a version and the diff file between verions.
Subject: ::Producer::MySQL diffing does not respect quote_identifiers (was: No way to specify quoting of names of tables and fields in Schema::Versioned diff)
Download (untitled) / with headers
text/plain 396b
Part of the problem with used to lie in DBIC, and has been fixed as of However the real issue is that SQLT::Producer::MySQL does not respect qupte_identifiers in ::Diff code, and even when forced via quote_table_names - it still does not DTRT when it comes to DROP statements e.g. Therefore I am reassigning this ticket to the SQLT queue, where the rest of the fixes need to take place. Chers
Subject: ::Producer::MySQL diffing does not respect quote_identifiers (was: No way to specify quoting of names of tables and fields in Schema::Versioned diff)
Download (untitled) / with headers
text/plain 446b
Part of the problem used to lie in DBIC, and has been fixed as of https://github.com/dbsrgits/dbix-class/commit/08ac7648 However the real issue is that SQLT::Producer::MySQL does not respect quote_identifiers in ::Diff code, and even when forced via quote_table_names - it still does not DTRT when it comes to e.g. DROP statements. Therefore I am reassigning this ticket to the SQLT queue, where the rest of the fixes need to take place. Chers


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

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.