Drizzle Team•13mo ago

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

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! ❤️

5 Replies

zejOP•13mo ago

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'
}

Angelelz•13mo ago

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

zejOP•13mo ago

awesome! ty

Radu•10mo ago

any fix for this?

baronnoraz•10mo ago

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'
      })
    };
  },
);

Gaming

Programming

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