Drizzle Team•2mo ago

UnsupportedResultException: The result contains the unsupported data type regclass

getting this error when i try to run drizzle-kit push I am using sst ion to deploy my rds instance. drizzle-kit version: 0.24.0 drizzle-orm version: 0.33.0

UnsupportedResultException: The result contains the unsupported data type regclass.
    at de_UnsupportedResultExceptionRes (/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:1015:21)
    at de_CommandError (/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:820:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async /node_modules/@aws-sdk/client-rds-data/node_modules/@smithy/middleware-serde/dist-cjs/index.js:35:20
    at async /node_modules/drizzle-kit/bin.cjs:60485:22
    at async /node_modules/drizzle-kit/bin.cjs:60243:42
    at async /node_modules/drizzle-kit/bin.cjs:54055:26
    at AwsDataApiPreparedQuery.values (/node_modules/src/aws-data-api/pg/session.ts:111:18)
    at AwsDataApiPreparedQuery.execute (/node_modules/src/aws-data-api/pg/session.ts:61:18)
    at AwsDataApiPreparedQuery.all (/node_modules/src/aws-data-api/pg/session.ts:94:18) {
  '$fault': 'client',
  '$metadata': {
    httpStatusCode: 400,
    requestId: '2c2bbff6-7d38-4c4a-ba7f-180a3d90dabe',
    extendedRequestId: undefined,
    cfId: undefined,
    attempts: 1,
    totalRetryDelay: 0
  }
}

UnsupportedResultException: The result contains the unsupported data type regclass.
    at de_UnsupportedResultExceptionRes (/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:1015:21)
    at de_CommandError (/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:820:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async /node_modules/@aws-sdk/client-rds-data/node_modules/@smithy/middleware-serde/dist-cjs/index.js:35:20
    at async /node_modules/drizzle-kit/bin.cjs:60485:22
    at async /node_modules/drizzle-kit/bin.cjs:60243:42
    at async /node_modules/drizzle-kit/bin.cjs:54055:26
    at AwsDataApiPreparedQuery.values (/node_modules/src/aws-data-api/pg/session.ts:111:18)
    at AwsDataApiPreparedQuery.execute (/node_modules/src/aws-data-api/pg/session.ts:61:18)
    at AwsDataApiPreparedQuery.all (/node_modules/src/aws-data-api/pg/session.ts:94:18) {
  '$fault': 'client',
  '$metadata': {
    httpStatusCode: 400,
    requestId: '2c2bbff6-7d38-4c4a-ba7f-180a3d90dabe',
    extendedRequestId: undefined,
    cfId: undefined,
    attempts: 1,
    totalRetryDelay: 0
  }
}

local storage json:

{
  "drizzle-playground": {
    "state": {
      "editorHight": 300,
      "currentFile": "sql",
      "drizzleValue": null,
      "sqlValue": null,
      "showRecordsAsJson": false,
      "drizzleResult": "{\"json\":null}",
      "sqlResult": "{\"json\":null}"
    },
    "version": 0
  },
  "drizzle-version": "2.0.1",
  "drizzle-global": {
    "state": {
      "showCounts": true,
      "flatSchemas": false
    },
    "version": 0
  },
  "drizzle-custom-theme-ids": []
}

{
  "drizzle-playground": {
    "state": {
      "editorHight": 300,
      "currentFile": "sql",
      "drizzleValue": null,
      "sqlValue": null,
      "showRecordsAsJson": false,
      "drizzleResult": "{\"json\":null}",
      "sqlResult": "{\"json\":null}"
    },
    "version": 0
  },
  "drizzle-version": "2.0.1",
  "drizzle-global": {
    "state": {
      "showCounts": true,
      "flatSchemas": false
    },
    "version": 0
  },
  "drizzle-custom-theme-ids": []
}

` I reproduced this using the sst ion guide: https://ion.sst.dev/docs/start/aws/drizzle/

5 Replies

Lukas•2mo ago

Thought this was just me, started a GitHub issue for this https://github.com/drizzle-team/drizzle-kit-mirror/issues/544

GitHub

UnsupportedResultException: The result contains the unsupported dat...

Seemingly after drizzle-kit version 0.22.8 running drizzle-kit push results in UnsupportedResultException: The result contains the unsupported data type regclass Using sst ion with Postgres and dri...

rphlmr ⚡•2mo ago

👋 cc @Andrew Sherman

Andrii Sherman•2mo ago

will try to reproduce did you use the same schema as in ion guide?

Nick•2mo ago

yea, same schema

Lukas•4w ago

@Andrew Sherman Were you been able to reproduce? Seems I’m still having this issue on latest fwiw changing

pg_get_serial_sequence('"${tableSchema}"."${tableName}"', a.attname)::regclass as seq_name, INFORMATION_SCHEMA.COLUMNS.column_name,

pg_get_serial_sequence('"${tableSchema}"."${tableName}"', a.attname) as seq_name, INFORMATION_SCHEMA.COLUMNS.column_name,

seems to fix this, not sure of further consequences https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-kit/src/serializer/pgSerializer.ts#L743

Gaming

Programming

UnsupportedResultException: The result contains the unsupported data type regclass