ct/bmc_hub
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
bmc_hub/MDfile/RELEASE_NOTES_v2.2.3.md
Christian a604a3cc44 Add comprehensive test suite for vTiger integration and ticket module 
- Implemented test scripts for vTiger account retrieval, contact data, and modules.
- Created a detailed test suite for the ticket module, covering database schema validation, ticket number generation, prepaid card constraints, and service logic.
- Added tests for vTiger field inspection and various queries related to accounts and sales orders.
- Introduced SQL migration scripts for the ALSO Cloud Billing foundation, including import jobs, lines, and mapping tables with necessary constraints and indices.
- Enhanced workflow columns in the import lines table to support matching and validation timestamps.
2026-06-20 03:29:51 +02:00

688 B
Raw Permalink Blame History

BMC Hub v2.2.3 - Migration Hotfix

Release Date: 22. februar 2026

🛠️ Hotfix

Migration 138 compatibility fix

  • Fixed migrations/138_customers_economic_unique_constraint.sql for environments where customers.economic_customer_number is numeric (integer).
  • Removed unconditional btrim(...) usage on non-text columns.
  • Added type-aware normalization logic that only applies trimming for text-like column types.

✅ Impact

  • Migration 138_customers_economic_unique_constraint.sql now runs on both numeric and text column variants without function btrim(integer) does not exist errors.
  • Unique index safety behavior and duplicate detection are unchanged.