Postgres giving the error Unsupported type: Instance of 'UuidValue' when using where clause. about drift

[Leylan24]

I will test if the other CustomSqlTypes also work. I did see a closed issue where it says use the latest drift.

My packages are as follows:
drift 2.16.0
drift_postgres 1.2.0
postgres 3.1.2
uuid 4.3.3

[Leylan24]

Using PgDate also gives an error:

this was the code used:

      final result = await (srcDb.select(srcDb.posTrnTransactionHeader)
            ..where((tbl) => tbl.trnHdrStartDateTime
                .equals(PgDateTime(DateTime.parse('2024-03-20')))))
          .get();

SELECT * FROM pos_trn.transaction_header WHERE "trn_hdr_start_date_time" = $1; with args [2024-03-20 00:00:00.000]
package:drift_postgres/src/pg_database.dart 176:16                           new _BoundArguments.ofDartArgs.<fn>
dart:core                                                                    new _List.generate
package:drift_postgres/src/pg_database.dart 164:24                           new _BoundArguments.ofDartArgs
package:drift_postgres/src/pg_database.dart 137:36                           _PgDelegate.runSelect
package:drift/src/runtime/executor/helpers/engines.dart 77:19                _BaseExecutor.runSelect.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 57:22                _BaseExecutor._synchronized.<fn>
dart:async                                                                   new Future.sync
package:drift/src/utils/synchronized.dart 17:21                              Lock.synchronized.callBlockAndComplete
package:drift/src/utils/synchronized.dart 23:14                              Lock.synchronized
package:drift/src/runtime/executor/helpers/engines.dart 55:20                _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 74:26                _BaseExecutor.runSelect
package:pepkor_db/src/base_postgres.dart 52:18                               InterceptedPgDatabase.runSelect
package:drift/src/runtime/query_builder/statements/select/select.dart 81:16  SimpleSelectStatement._getRaw.<fn>
package:drift/src/runtime/api/connection_user.dart 162:64                    DatabaseConnectionUser.doWhenOpened.<fn>
===== asynchronous gap ===========================
package:drift/src/runtime/query_builder/statements/select/select.dart 90:3   SimpleSelectStatement._mapResponse
===== asynchronous gap ===========================
test\database_tests\database_tests.dart 86:22                                main.<fn>.<fn>

Invalid argument (value): Unsupported type: Instance of 'PgDateTime'


Process finished with exit code 1

[Leylan24]

@simolus3 https://github.com/simolus3/drift/blob/develop/drift/lib/src/runtime/query_builder/helpers.dart#L58 The code here when building the expression goes to the default switch instead of assigning a customType.

I tested and checked if I replace the variable with

Variable(value, driftSqltypes.overrides[SqlDialect.postgres] as CustomSqlType<T>)

then the expression seems to correctly evaluate however I am not sure to get the GenerationContext so the Dialect can be mapped dynamically.

[simolus3]

This might have been fixed in e423157, which hasn't been released yet. Could you try using the current state from get to verify that it fixes the problem? You can add this to your pubspec to use it:

dependency_overrides:
  drift:
    git:
      url: https://github.com/simolus3/drift.git
      ref: develop
      path: drift

[Leylan24]

@simolus3 that worked, will close the issue thank you 👍