You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/03/05 10:59:12 UTC
[GitHub] [incubator-shardingsphere] fantacy2001 opened a new issue #4619:
only sharding db, use pagehelper,
report error: Must have sharding column with subquery
fantacy2001 opened a new issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619
sharding version:
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] maojing123 commented on issue #4619:
only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
maojing123 commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-610478329
> We are doing the subquery now, so I just pending this issue after we finish the subquery.
Has the problem been solved?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] fantacy2001 removed a comment on issue
#4619: only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
fantacy2001 removed a comment on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-597432805
> We are doing the subquery now, so I just pending this issue after we finish the subquery.
pagehelper use subquery , when i upgrade to 4.0.0-release, the exception not have reported
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] maojing123 commented on issue #4619:
only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
maojing123 commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-610478565
> > We are doing the subquery now, so I just pending this issue after we finish the subquery.
>
> pagehelper use subquery , when i upgrade to 4.0.0-release, this exception is not reported, but the sql find wrong route(default route) ,this is Not expected.
> sql:
> select count(1) count from (select DISTINCT
> m.id,
> m.receipt_no,
> m.customs_no,
> m.receipt_type,
> m.owner_no,
> m.owner_name,
> m.supplier_no,
> m.supplier_name,
> m.order_time,
> m.source_no,
> m.source,
> m.carrier_no,
> m.carrier_name,
> m.print_times,
> m.status,
> m.remark,
> m.tenant_id,
> m.org_no,
> m.distribute_no,
> m.warehouse_no,
> m.create_time,
> m.update_time,
> m.create_user,
> m.update_user,
> m.is_delete,
> m.total_sku_qty,
> m.total_sku_sort,
> m.version,
> m.bill_type,
> m.is_cross_docking,
> m.order_no,
> m.order_amount,
> m.isv_order_no,
> m.isv_source_no,
> m.loadteam_no,
> m.grade
> from ib_receipt_task_m m left join ib_receipt_task_d d
> on m.receipt_no = d.receipt_no
> and m.warehouse_no = d.warehouse_no
> and m.tenant_id = d.tenant_id
> where m.is_delete = 0
> AND m.tenant_id = ?
> AND m.warehouse_no = ?
> and m.create_time >= CONCAT(?,' 00:00:00')
> and m.create_time < CONCAT(?,' 23:59:59')
> and m.receipt_type = ?
> order by m.id desc ) t
Has the problem been solved?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [shardingsphere] terrymanu closed issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4619:
URL: https://github.com/apache/shardingsphere/issues/4619
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-shardingsphere] fantacy2001 commented on issue #4619:
only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
fantacy2001 commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-597997364
> We are doing the subquery now, so I just pending this issue after we finish the subquery.
pagehelper use subquery , when i upgrade to 4.0.0-release, this exception is not reported, but the sql find wrong route(default route) ,this is Not expected.
sql:
select count(1) count from (select DISTINCT
m.id,
m.receipt_no,
m.customs_no,
m.receipt_type,
m.owner_no,
m.owner_name,
m.supplier_no,
m.supplier_name,
m.order_time,
m.source_no,
m.source,
m.carrier_no,
m.carrier_name,
m.print_times,
m.status,
m.remark,
m.tenant_id,
m.org_no,
m.distribute_no,
m.warehouse_no,
m.create_time,
m.update_time,
m.create_user,
m.update_user,
m.is_delete,
m.total_sku_qty,
m.total_sku_sort,
m.version,
m.bill_type,
m.is_cross_docking,
m.order_no,
m.order_amount,
m.isv_order_no,
m.isv_source_no,
m.loadteam_no,
m.grade
from ib_receipt_task_m m left join ib_receipt_task_d d
on m.receipt_no = d.receipt_no
and m.warehouse_no = d.warehouse_no
and m.tenant_id = d.tenant_id
where m.is_delete = 0
AND m.tenant_id = ?
AND m.warehouse_no = ?
and m.create_time >= CONCAT(?,' 00:00:00')
and m.create_time < CONCAT(?,' 23:59:59')
and m.receipt_type = ?
order by m.id desc ) t
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] fantacy2001 commented on issue #4619:
only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
fantacy2001 commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-595215163
> which column is the databases sharding key ?
i have no column as sharding key. each database has different table name , i Force routing in my configuration
Here is part of my configuration:
spring.shardingsphere.sharding.tables.au_data_rule.actual-data-nodes=center.au_data_rule
spring.shardingsphere.sharding.tables.au_module.actual-data-nodes=center.au_module
spring.shardingsphere.sharding.tables.ib_book_task_d.actual-data-nodes=inbound.ib_book_task_d
spring.shardingsphere.sharding.tables.ib_book_task_m.actual-data-nodes=inbound.ib_book_task_m
spring.shardingsphere.sharding.tables.b2b_locate_batch.actual-data-nodes=outbound.b2b_locate_batch
spring.shardingsphere.sharding.tables.b2b_locate_d.actual-data-nodes=outbound.b2b_locate_d
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4619: only
sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-596181121
We are doing the subquery now, so I just pending this issue after we finish the subquery.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] fantacy2001 commented on issue #4619:
only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
fantacy2001 commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-597432805
> We are doing the subquery now, so I just pending this issue after we finish the subquery.
pagehelper use subquery , when i upgrade to 4.0.0-release, the exception not have reported
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4619: only
sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-595207502
which column is the databases sharding key ?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] fantacy2001 removed a comment on issue
#4619: only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
fantacy2001 removed a comment on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-597996388
> We are doing the subquery now, so I just pending this issue after we finish the subquery.
pagehelper use subquery , when i upgrade to 4.0.0-release, this exception is not reported, but the sql find wrong route(default route) ,this is Not expected
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [shardingsphere] terrymanu commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4619:
URL: https://github.com/apache/shardingsphere/issues/4619#issuecomment-927247879
The `5.0.0-beta` version supports federation engine which can process subquery, please try it, thank you.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-shardingsphere] fantacy2001 commented on issue #4619:
only sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
fantacy2001 commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-597996388
> We are doing the subquery now, so I just pending this issue after we finish the subquery.
pagehelper use subquery , when i upgrade to 4.0.0-release, this exception is not reported, but the sql find wrong route(default route) ,this is Not expected
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4619: only
sharding db, use pagehelper,
report error: Must have sharding column with subquery
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4619: only sharding db, use pagehelper, report error: Must have sharding column with subquery
URL: https://github.com/apache/incubator-shardingsphere/issues/4619#issuecomment-595612496
Oh...
what is your database-strategy，table-strategy ？
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services