View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003708||SymmetricDS||Bug||public||2018-09-05 15:56||2018-09-13 14:27|
|Target Version||Fixed in Version|
|Summary||0003708: Wildcard does not work when there is no wildcard at the beginning or the end of the text|
|Description||When you setup a wildcard selection in sym_trigger under the source_table_name column in the following format bu*_roadways,bu*_railways,bu*_waterways,bu*_boundaries,bu*_cities|
This will not pull the tables with that name format.
If the format is
The pull will work.
|Steps To Reproduce||Ran sync with the trigger setup as the first example and the tables represented by the wildcards did not work.|
Changed the format to the second format and re-run the sync and the tables were populated.
In both cases I started with and empty destination database
Confirmed. Tested on SQL Server and H2. Patterns with only a star in the middle don't match correctly. It appears that the algorithm requires a star at the beginning or a star at the end, never just a star in the middle. Seems like a bug to me.
For example, these match to the tables bu1_railways, bu2_railways, etc.
bu*railways does not.
|2018-09-05 15:56||FutureChalk||New Issue|
|2018-09-05 15:56||FutureChalk||Tag Attached: Wildcards|
|2018-09-13 09:48||hanes||Note Added: 0001235|
|2018-09-13 09:48||hanes||Status||new => confirmed|
|2018-09-13 14:27||hanes||Summary||Wildcard does not work => Wildcard does not work when there is no wildcard at the beginning or the end of the text|