Bug #72134 Improve syntax for adding tables to shard mappings
Submitted: 26 Mar 2014 12:43 Modified: 6 Apr 2014 19:20
Reporter: Mats Kindahl Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Fabric Severity:S4 (Feature request)
Version:1.4.1 OS:Any
Assigned to: CPU Architecture:Any

[26 Mar 2014 12:43] Mats Kindahl
Description:
Currently, to add multiple tables to a shard mapping it is necessary to add them one by one using:

   mysqlfabric sharding add_mapping employees.salaries emp_no
   mysqlfabric sharding add_mapping employees.titles emp_no

When adding many tables it would be good to be able to provide several tables on the command line and also have a syntax that support wildcards.

How to repeat:
Try the command

Suggested fix:
Ensure that the column is not separate from the table and database name so that one can write things such as:

   mysqlfabric sharding add_mapping employees.salaries.emp_no \
                                    employees.tables.emp_no

to add multiple tables, or

   mysqlfabric sharding add_mapping employees.%.emp_no

to add all tables in the 'employees' database that have an "emp_no" column.
[6 Jul 2017 19:19] Bugs System
Status updated to 'Won't fix' (Fabric is now covered under Oracle Lifetime Sustaining Support)