I'm not sure what the problem is, but I made sure to check the documentation and this seems like weird behavior

[MillerVictor]

dependencies

dependencies
# @link https://docs.rs/sqlx/0.8.3/sqlx/
sqlx ={ version =  "0.8" }

# @link https://docs.rs/sea-query/0.32.3/sea_query/
sea-query = {version = "0.32.3",features = ["derive","backend-mysql"]}

# @link https://docs.rs/sea-query-binder/0.7.0/sea_query_binder/
sea-query-binder = {version = "0.7.0" ,features = ["sqlx-mysql","sqlx-any"]}

rust version

rustc 1.84.1 (e71f9a9a9 2025-01-27)

database

CREATE TABLE IF NOT EXISTS `access_user` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name`            VARCHAR(255) NOT NULL UNIQUE  COMMENT '用户名字',
  `nickname`        VARCHAR(255) NOT NULL COMMENT '用户昵称',
  `passwd`          VARCHAR(255) NOT NULL COMMENT '用户密码',
  `email`           VARCHAR(255) NOT NULL COMMENT '用户email',
  `phone`           VARCHAR(15)  NOT NULL COMMENT '手机号码',
  
  -- 账户状态:ON为启用状态,OFF停用状态
  `user_state`      ENUM('ON', 'OFF') NOT NULL DEFAULT 'ON' COMMENT '账户状态',
  
  -- 其他认证方式的字符串,主要标注google 2fa认证的字符串
  `auth_string`     VARCHAR(255) NOT NULL DEFAULT '' COMMENT '新增认证字符串',

  -- 后台登录联合认证方式,默认为:PASSWD
  -- PASSWD             密码认证
  -- G2FA               2FA认证
  -- PHONE              短信认证
  -- PASSWD+G2FA        密码认证+2FA认证
  -- PASSWD+PHONE       密码认证+短信认证
  -- PASSWD+G2FA+PHONE  密码认证+2FA认证+短信认证
  `auth_enum`       ENUM('PASSWD','G2FA','PHONE', 'PASSWD+G2FA', 'PASSWD+PHONE', 'PASSWD+G2FA+PHONE') NOT NULL DEFAULT 'PASSWD' COMMENT '认证方式',

  `create_at`       DATETIME COMMENT '创建时间',
  `update_at`       DATETIME COMMENT '更新时间',
  PRIMARY KEY `access_user_id`(`id`) 
) ENGINE = InnoDB;


INSERT INTO `access_user` (`name`,`nickname`,`passwd`,`email`,`phone`,`create_at`) VALUES ('admin','超级管理员','F59BD65F7EDAFB087A81D4DCA06C4910','[email protected]','123456789100','2023-03-31 15:30:00') ;

the rust code

#[enum_def]
#[derive(sqlx::FromRow, Debug)]
pub struct User {
    id: u32,
    name: String,
    nickname: String,
    passwd: String,
    email: String,
    phone: String,
    // #[sqlx(flatten)]
    // user_state: UserState,
    auth_string: String,
    // #[sqlx(flatten)]
    // auth_enum: AuthEnum,
    create_at: String,
    update_at: String,
}
 async fn page(&self, poll:AnyPool,next: u64) -> Vec<Self::Model> {
        let connect_ops = poll.acquire().await;
        if connect_ops.is_err() {
            error!("暂无空闲连接池");
            return Vec::new();
        }
        let mut pool = connect_ops.unwrap();

        let builder = MysqlQueryBuilder {};
        let (sql, values) = Query::select()
            .columns([
                UserIden::Id,
                UserIden::Name,
                UserIden::Nickname,
                UserIden::Email,
                UserIden::Phone,
                // UserIden::UserState,
                UserIden::AuthString,
                // UserIden::AuthEnum,
            ])
            .from(UserIden::Table)
            .offset(next)
            .limit(MAX_PAGE_SIZE)
            .build_sqlx(builder);
        let rows = sqlx::query_as_with::<_,User, _>(&sql, values);
        todo!()

Error in

error[E0283]: type annotations needed
--> common/src/database/access/user.rs:134:44
|
134 | let rows = sqlx::query_as_with::<,User, >(&sql, values);
| ^^^^ cannot infer type for type parameter R
|
= note: multiple impls satisfying &str: ColumnIndex<_> found in the following crates: sqlx_core, sqlx_mysql:
- impl ColumnIndex for &str;
- impl ColumnIndex<MySqlStatement<'>> for &str;
- impl<'i> ColumnIndex for &'i str;
- impl<'i> ColumnIndex<AnyStatement<'>> for &'i str;
note: required for User to implement for<'r> FromRow<'r, _>
--> common/src/database/access/user.rs:70:10
|
70 | #[derive(sqlx::FromRow, Debug)]
| ^^^^^^^^^^^^^ unsatisfied trait bound introduced in this derive macro
71 | pub struct User {
| ^^^^
note: required by a bound in sqlx::query_as_with
--> /home/victor/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sqlx-core-0.8.3/src/query_as.rs:364:8
|
360 | pub fn query_as_with<'q, DB, O, A>(sql: &'q str, arguments: A) -> QueryAs<'q, DB, O, A>
| ------------- required by a bound in this function
...
364 | O: for<'r> FromRow<'r, DB::Row>,
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ required by this bound in query_as_with
= note: this error originates in the derive macro sqlx::FromRow (in Nightly builds, run with -Z macro-backtrace for more info)

What happened here