Skip to content

disallow comma in transaction identifiers #511

@dustymc

Description

@dustymc

From ArctosDB/arctos#9466

There are currently no commas in loan numbers transaction identifiers. Can we set up rules to keep it that way, so that we can safely use commas as list delimiters?



select guid_prefix, loan_number from collection inner join trans on collection.collection_id=trans.transaction_id
inner join loan on trans.transaction_id=loan.transaction_id where loan_number ilike '%,%';



select guid_prefix, accn_number from collection inner join trans on collection.collection_id=trans.transaction_id
inner join accn on trans.transaction_id=accn.transaction_id where accn_number ilike '%,%';



select guid_prefix, borrow_number from collection inner join trans on collection.collection_id=trans.transaction_id
inner join borrow on trans.transaction_id=borrow.transaction_id where borrow_number ilike '%,%';

Metadata

Metadata

Assignees

No one assigned

    Labels

    EnhancementI think this would make Arctos even awesomer!

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions