Support of UUID as Key (FHCA-4195)

Description

Currently the IDs are defined as NUMERIC(10) in the database and as int in the java code.

The idea of this ticket is to explore the possibility to support a new type LongID which would be defined as NUMERIC(19) in the database and long in java code.

Evaluate too the support of UUID as key for new tables.

NOTE: The requirement comes from a project that potentially can consume very soon the int ID sequence in a table.

Environment

None

causes

is blocked by

relates to

testing discovered

Activity

Carlos Ruiz 
September 14, 2024 at 3:05 PM

Reopening for some improvements - pull request 2455:

  • allow generating permalink also for multi-key tables using UUID

  • use TableName instead of AD_Table_ID for permalink

  • add zoom condition to role for access tables on non-system tenants

  • on copy select, prefer to generate using ID than UUID when possible - is easier when copying a select that is needed to search also for children

Carlos Ruiz 
July 31, 2024 at 3:00 PM

reopening as found an issue with discovering the right zoom window in some cases

Nicolas Micoud 
February 6, 2024 at 12:58 PM

Carlos Ruiz 
February 6, 2024 at 12:27 PM

Hi

Please check pull request 2228

The problem is caused because oracle treats empty strings '' as NULL.

Nicolas Micoud 
February 6, 2024 at 11:32 AM

Hi,
Not sure if a patch is needed but while testing migration from v10 to v11 (Oracle), I faced some issues while applying 202304060001_IDEMPIERE-5567.sql (eg ora-01758 table must be empty to add mandatory column) ; I had to execute DELETE FROM t_selection; before the script. Then it went fine.




Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created February 8, 2023 at 2:40 PM
Updated April 25, 2025 at 9:55 AM
Resolved September 18, 2024 at 10:02 AM