postgres page err

[lontten]

serde = { version = "1", features = ["derive"] }
rbs = { version = "4.5" }
rbatis = { version = "4.5" }
rbdc-pg = { version = "4.5" }

    let page_param = PageRequest::new(1, 10);
    let data = BookActive::select_page_by_name(db.as_ref(), &page_param,   & "a").await;

impl_select_page!(BookActive{select_page_by_name(book_name:&str) =>"
     if book_name != null && book_name != '':
       `where book_name like #{book_name}`
       "},"t_book");

 INFO  rbatis::plugin::intercept_log > [rbatis] [631024663232778246] => `select count(1) as count from t_book where book_name like ?` ["a"]
 INFO  rbatis::plugin::intercept_log > [rbatis] [631024663232778246] <= len=1
 INFO  rbatis::plugin::intercept_log > [rbatis] [631024664600121352] => `select * from t_book where book_name like ? limit 0,10` ["a"]
 INFO  rbatis::plugin::intercept_log > [rbatis] [631024664600121352] <= db:Notice { storage: b"SERROR\0VERROR\0C42601\0MLIMIT #,# syntax is not supported\0HUse separate LIMIT and OFF

[zhuxiujia]

postgres not support limit sql,
you need use Intercept edit sql limit to other

see https://github.com/rbatis/rbatis/blob/master/example/src/plugin_intercept_returing_id.rs

or, use your limit param

impl_select_page!(BookActive{select_page_by_name(book_name:&str,limit_sql:&str) =>"
     if book_name != null && book_name != '':
       `where book_name like #{book_name}`
       "},"t_book");