一、该问题的重现步骤是什么?
再pom里面添加sharding jar包
2. 在配置文件application-dev.yml 里面添加sharding的配置
3. 数据权限页面添加
4、访问代码生成后的分页接口,sql如下
SELECT
*
FROM
(
SELECT
id,
source_goods_no,
source_goods_status,
shipper_id,
shipper_user_id,
is_sign_shipper,
goods_insert_datetime,
shipper_name,
contact_name,
personal_identity_type_code,
personal_identity_document,
telephone_number,
mobile_telephone_number,
deliver_province_code,
deliver_province_name,
deliver_city_code,
deliver_city_name,
deliver_area_code,
deliver_area_name,
deliver_detail_address,
place_of_loading,
load_transport_station_code,
load_transport_station_name,
resquested_load_start_datetime,
resquested_load_end_datetime,
consignee_id,
consignee,
consignee_pert_number,
consi_contact_name,
consi_telephone_number,
consi_mobile_telephone_number,
arrival_province_code,
arrival_province_name,
arrival_city_code,
arrival_city_name,
arrival_area_code,
arrival_area_name,
arrival_detail_address,
goods_receipt_place,
receipt_transport_station_code,
receipt_transport_station_name,
requested_unloaded_datetime,
taketicket_flag,
price_type,
total_monetary_amount,
vehicle_type_requirement,
vehicle_length_requirement,
goods_price,
contract_number,
payment_type,
service_amount,
insurance_company,
insurance_company_code,
insurance_bill_code,
insurance_access_address,
insurance_amount,
deliver_settlement_name,
deliver_settlement_telephone_number,
synchronization_time,
is_exception,
business_type_code,
business_type_name,
statistics_type,
remark,
estimated_arrival_datetime,
transport_type_code,
version,
tenant_id,
create_user,
create_dept,
create_time,
update_user,
update_time,
STATUS,
is_deleted
FROM
t_invoice
WHERE
is_deleted = 0
AND tenant_id = '000000'
ORDER BY
create_time DESC
) scope
WHERE
scope.create_dept IN ( 1123598813738675201, 1123598813738675202, 1123598813738675203, 1381449354410323969 )
LIMIT 10
二、你期待的结果是什么?实际看到的又是什么?
应该正常显示,但是界面出现了报错截图
三、你正在使用的是什么产品,什么版本?在什么操作系统上?
bladex, windows
四、请提供详细的错误堆栈信息,这很重要。
五、若有更多详细信息,请在下面提供。
扫一扫访问 Blade技术社区 移动端