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/17 11:49:50 UTC

[GitHub] [incubator-shardingsphere] phoema opened a new issue #4810: Abount Exception [Can not find owner from table.]

phoema opened a new issue #4810: Abount Exception [Can not find owner from table.]
URL: https://github.com/apache/incubator-shardingsphere/issues/4810
 
 
   Version
   5.0.0-RC1-SNAPSHOT from master branch
   
   ## Question
   sorry, ref #4806 was closed timely
   may be no user can see new message in it , so I open a new issue.
   
   My 
           HintManager.clear();
           HintManager hintManager = HintManager.getInstance();
           hintManager.setDatabaseShardingValue(user.getTenantId());
   it means 
          databaseShardingOnly = true;
   
   if every table must be config，if not config then exception。
   but my temp table name Alias will be not config in xml file.
   like RES
   it can be exception with 【Can not find owner from table.】
   org.apache.shardingsphere.sql.parser.binder.segment.select.projection.engine.ProjectionsContextEngine
   
   is this the same question with #4806 question ？
   
   SELECT DISTINCT
   RES.*
   FROM
   (
   SELECT
   SELF.*,
   DEF.NAME_,
   DEF.VERSION_
   FROM
   ACT_HI_PROCINST SELF
   LEFT JOIN ACT_RE_PROCDEF DEF ON SELF.PROC_DEF_ID_ = DEF.ID_
   WHERE
   ( 1 = 1 AND SELF.PROC_INST_ID_ = ? )
   ) RES
   ORDER BY
   RES.ID_ ASC
   LIMIT ? OFFSET ?
   
   
   
   

----------------------------------------------------------------
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] 2241101100 removed a comment on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
2241101100 removed a comment on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-851845805


   5.0.0-alpha has the same problem


-- 
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

[GitHub] [shardingsphere] ChinaJeckXu commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
ChinaJeckXu commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-644664983


   I met the current problem, the impact of this problem is huge, I hope to fix it soon!


----------------------------------------------------------------
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

[GitHub] [shardingsphere] chenziwucodeing commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
chenziwucodeing commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-644579616


   同样问题的案例 代码地址：
   https://github.com/chenziwucodeing/test_code_for_spring


----------------------------------------------------------------
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

[GitHub] [incubator-shardingsphere] phoema commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4810: Abount Exception [Can not find owner from table.]
URL: https://github.com/apache/incubator-shardingsphere/issues/4810#issuecomment-600062490
 
 
   I run many subquery wiht new version from master and it works well.
   now I see subquery  is still developing in the git reop   
   may be some special case is not support now like this sql.
   I will wait for.
   Thanks very much.
   
   

----------------------------------------------------------------
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] chenziwucodeing commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
chenziwucodeing commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-645868665


   我只用了读写分离功能出现。没用分库分表功能。


----------------------------------------------------------------
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

[GitHub] [shardingsphere] miaogr86 commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
miaogr86 commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-645863736


   版本4.1.1也碰到这个问题


----------------------------------------------------------------
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

[GitHub] [shardingsphere] terrymanu closed issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810


   


-- 
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] phoema commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4810: Abount Exception [Can not find owner from table.]
URL: https://github.com/apache/incubator-shardingsphere/issues/4810#issuecomment-600554584
 
 
   SQL parse throws NullPointerException
   may be it can be a test case.
   
   SELECT
           RES.*,
           ( 
     case
   	  when
         RES.TASK_ID_ is not null
         and RES.EXECUTION_ID_ is not null
   	  then EXECUTION.ACT_INST_ID_
   
       when
         RES.CASE_EXECUTION_ID_ is not null
       then RES.CASE_EXECUTION_ID_
   
       
   	  when
   	    EXECUTION.PARENT_ID_ is null
         and RES.IS_CONCURRENT_LOCAL_ = 0
   	  then EXECUTION.ID_
   
       
   	  when
   	    EXECUTION.IS_SCOPE_ = 1
   	    and EXECUTION.PARENT_ID_ is not null
         and RES.IS_CONCURRENT_LOCAL_ = 0
   	  then PARENT_EXECUTION.ACT_INST_ID_
   
   	  else EXECUTION.ACT_INST_ID_
   	end
      ) ACT_INST_ID_
       FROM
           ACT_RU_VARIABLE RES
   
       LEFT JOIN
           ACT_RU_EXECUTION EXECUTION
       ON
           RES.EXECUTION_ID_ = EXECUTION.ID_
   
       LEFT JOIN
           ACT_RU_EXECUTION PARENT_EXECUTION
       ON
           EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_
   
       WHERE
           TASK_ID_ = ?

----------------------------------------------------------------
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] chenziwucodeing edited a comment on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
chenziwucodeing edited a comment on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-644579616


   同样问题的案例 代码地址：
   Cases of the same problem，code url:
   https://github.com/chenziwucodeing/test_code_for_spring


----------------------------------------------------------------
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

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4810: Abount Exception [Can not find owner from table.]
URL: https://github.com/apache/incubator-shardingsphere/issues/4810#issuecomment-600048700
 
 
   Can not support subquery now. I just set the issue as pending.

----------------------------------------------------------------
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] strongduanmu commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-851881828


   > 请问这个问题该如何解决
   
   @418545106 You can try the master branch code, it has been fixed by PR #10363.


-- 
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

[GitHub] [shardingsphere] terrymanu commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-927248176


   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] [shardingsphere] 2241101100 commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
2241101100 commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-851845805


   5.0.0-alpha has the same problem


-- 
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

[GitHub] [shardingsphere] 418545106 commented on issue #4810: Abount Exception [Can not find owner from table.]

Posted by GitBox <gi...@apache.org>.
418545106 commented on issue #4810:
URL: https://github.com/apache/shardingsphere/issues/4810#issuecomment-655323904


   请问这个问题该如何解决


----------------------------------------------------------------
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