DT
Drizzle Team•15mo ago
zej

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
zej
zejOP•15mo 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
Angelelz•15mo ago
I think the ability the name our oen FK is comming. This problem will be no more
zej
zejOP•15mo ago
awesome! ty
Radu
Radu•12mo ago
any fix for this?
baronnoraz
baronnoraz•12mo 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'
      })
    };
  },
);

Did you find this page helpful?