money type can be inserted but not selected

[meowser]

I am running into an error when using money column types and rust_decimal::Decimal

If I create a table with money type column like so:

use sea_orm_migration::prelude::*;

#[derive(DeriveMigrationName)]
pub struct Migration;

#[async_trait::async_trait]
impl MigrationTrait for Migration {
    async fn up(&self, manager: &SchemaManager) -> Result<(), DbErr> {
        manager
            .create_table(
                Table::create()
                    .table(MoneyTest::Table)
                    .if_not_exists()
                    .col(
                        ColumnDef::new(MoneyTest::Id)
                            .integer()
                            .not_null()
                            .auto_increment()
                            .primary_key(),
                    )
                    .col(ColumnDef::new(MoneyTest::Name).string().not_null())
                    .col(ColumnDef::new(MoneyTest::Value).money().not_null())
                    .to_owned(),
            )
            .await
    }

    async fn down(&self, manager: &SchemaManager) -> Result<(), DbErr> {
        manager
            .drop_table(Table::drop().table(MoneyTest::Table).to_owned())
            .await
    }
}

#[derive(DeriveIden)]
enum MoneyTest {
    Table,
    Id,
    Name,
    Value
}

And then after generating the table, if I create an entity from it using sea-orm-cli I end up with something like this:

//! `SeaORM` Entity. Generated by sea-orm-codegen 0.12.2

use sea_orm::entity::prelude::*;

#[derive(Clone, Debug, PartialEq, DeriveEntityModel, Eq)]
#[sea_orm(table_name = "money_test")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    pub name: String,
    pub value: Decimal,
}

#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
pub enum Relation {}

impl ActiveModelBehavior for ActiveModel {}

Using this code below, when I try to insert a new row I have no issues, but when querying for rows I end up with an error due to the decimal type:

use futures::executor::block_on;
use sea_orm::{Database, DbErr, EntityTrait};
use sea_orm::ActiveValue::{NotSet, Set};
use rust_decimal::Decimal;

use entity::prelude::MoneyTest;
use entity::money_test;

const DATABASE_URL: &str = "postgres://eholmes@localhost/finance";

async fn run() -> Result<(), DbErr> {
    let db = Database::connect(DATABASE_URL).await?;
    let data = money_test::ActiveModel {
        id: NotSet,
        name: Set("foo".to_owned()),
        value: Set(Decimal::new(202, 2))
    };
    let insert_result = MoneyTest::insert(data).exec(&db).await?;
    let result = MoneyTest::find().all(&db).await;
    println!("{result:?}");
    Ok(())
}

fn main() {
    if let Err(err) = block_on(run()) {
        panic!("{}", err);
    }
}

The error I get is this:

Err(Query(SqlxError(ColumnDecode { index: "\"value\"", source: "mismatched types; Rust type `core::option::Option<rust_decimal::decimal::Decimal>` (as SQL type `NUMERIC`) is not compatible with SQL type `MONEY`" })))

I was wondering if I was missing something, or if this wasn't supported yet?

[schungx]

I wonder if there is a solution on this... I have bumped into this exact problem.