FK identifier will be truncated... how to specify my own?

enzo · 2023-10-29T05:45:41.300Z

Im running into a warning because the FK constraint identifier is too long and will be automatically truncated. I would prefer to specify my own indentifier instead of it getting truncated... Is there a way to achieve this? any help is appreciated! ❤️

E

enzoOP•10/29/23, 5:50 AM

Here is the exact warning:

{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "very_long_id_fk" will be truncated to "very_lon"',
  where: 'SQL statement ...',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}

{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "very_long_id_fk" will be truncated to "very_lon"',
  where: 'SQL statement ...',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}

{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "very_long_id_fk" will be truncated to "very_lon"',
  where: 'SQL statement ...',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}

{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "very_long_id_fk" will be truncated to "very_lon"',
  where: 'SQL statement ...',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}

A

Angelelz•10/29/23, 5:55 AM

I think the ability the name our oen FK is comming. This problem will be no more

E

enzoOP•10/29/23, 5:56 AM

awesome! ty

R

Radu•2/1/24, 7:10 PM

any fix for this?

B

baronnoraz•2/2/24, 3:24 AM

This works for me using MySQL and Drizzle...

export const userAccount = mysqlTable(
  'user_account',
  {
    id: bigint('id', { mode: 'number' }).primaryKey().autoincrement(),
    userId: bigint('user_id', { mode: 'number' }).notNull(),
    type: varchar('type', { length: 255 }).notNull(),
    salt: varchar('salt', { length: 128 }).notNull(),
    password: varchar('password', { length: 255 }).notNull(),
    createdAt: timestamp('created_at').notNull().defaultNow(),
  },
  (ua) => {
    return {
      userIdIndex: index('ix_user_account_user_id').on(ua.userId),
      typeIndex: index('ix_user_account_type').on(ua.type),
      userIdTypeIndex: uniqueIndex('ux_user_account_user_id_type').on(ua.userId, ua.type),
      userForeignKey: foreignKey({
        columns: [ua.userId],
        foreignColumns: [user.id],
        name: 'fk_user_account_user_id'
      })
    };
  },
);

export const userAccount = mysqlTable(
  'user_account',
  {
    id: bigint('id', { mode: 'number' }).primaryKey().autoincrement(),
    userId: bigint('user_id', { mode: 'number' }).notNull(),
    type: varchar('type', { length: 255 }).notNull(),
    salt: varchar('salt', { length: 128 }).notNull(),
    password: varchar('password', { length: 255 }).notNull(),
    createdAt: timestamp('created_at').notNull().defaultNow(),
  },
  (ua) => {
    return {
      userIdIndex: index('ix_user_account_user_id').on(ua.userId),
      typeIndex: index('ix_user_account_type').on(ua.type),
      userIdTypeIndex: uniqueIndex('ux_user_account_user_id_type').on(ua.userId, ua.type),
      userForeignKey: foreignKey({
        columns: [ua.userId],
        foreignColumns: [user.id],
        name: 'fk_user_account_user_id'
      })
    };
  },
);

export const userAccount = mysqlTable(
  'user_account',
  {
    id: bigint('id', { mode: 'number' }).primaryKey().autoincrement(),
    userId: bigint('user_id', { mode: 'number' }).notNull(),
    type: varchar('type', { length: 255 }).notNull(),
    salt: varchar('salt', { length: 128 }).notNull(),
    password: varchar('password', { length: 255 }).notNull(),
    createdAt: timestamp('created_at').notNull().defaultNow(),
  },
  (ua) => {
    return {
      userIdIndex: index('ix_user_account_user_id').on(ua.userId),
      typeIndex: index('ix_user_account_type').on(ua.type),
      userIdTypeIndex: uniqueIndex('ux_user_account_user_id_type').on(ua.userId, ua.type),
      userForeignKey: foreignKey({
        columns: [ua.userId],
        foreignColumns: [user.id],
        name: 'fk_user_account_user_id'
      })
    };
  },
);

export const userAccount = mysqlTable(
  'user_account',
  {
    id: bigint('id', { mode: 'number' }).primaryKey().autoincrement(),
    userId: bigint('user_id', { mode: 'number' }).notNull(),
    type: varchar('type', { length: 255 }).notNull(),
    salt: varchar('salt', { length: 128 }).notNull(),
    password: varchar('password', { length: 255 }).notNull(),
    createdAt: timestamp('created_at').notNull().defaultNow(),
  },
  (ua) => {
    return {
      userIdIndex: index('ix_user_account_user_id').on(ua.userId),
      typeIndex: index('ix_user_account_type').on(ua.type),
      userIdTypeIndex: uniqueIndex('ux_user_account_user_id_type').on(ua.userId, ua.type),
      userForeignKey: foreignKey({
        columns: [ua.userId],
        foreignColumns: [user.id],
        name: 'fk_user_account_user_id'
      })
    };
  },
);

FK identifier will be truncated... how to specify my own?

Similar Threads

Similar Threads

Similar Threads