[jira] [Created] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-02 Thread james601232 (Jira)
james601232 created CALCITE-3471:


 Summary: Only return 10 records use jdbc:calcite method
 Key: CALCITE-3471
 URL: https://issues.apache.org/jira/browse/CALCITE-3471
 Project: Calcite
  Issue Type: Bug
  Components: jdbc-adapter
Reporter: james601232


Hi

Recently I  ticked in to a problem that use jdbc:calcite method get connection 
and execute query mysql elasticssearch storage.  the results only return 10 
records.  checked calcite codes and not found the problems. hope get help to 
fixed my problems

Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-02 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16965557#comment-16965557
 ] 

james601232 commented on CALCITE-3471:
--

Ok. can u send me the dev mailing list address

Thank u in advance

> Only return 10 records use jdbc:calcite method
> --
>
> Key: CALCITE-3471
> URL: https://issues.apache.org/jira/browse/CALCITE-3471
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Reporter: james601232
>Priority: Blocker
>
> Hi
> Recently I  ticked in to a problem that use jdbc:calcite method get 
> connection and execute query mysql elasticssearch storage.  the results only 
> return 10 records.  checked calcite codes and not found the problems. hope 
> get help to fixed my problems
> Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Issue Comment Deleted] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-02 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3471:
-
Comment: was deleted

(was: Ok. can u send me the dev mailing list address

Thank u in advance)

> Only return 10 records use jdbc:calcite method
> --
>
> Key: CALCITE-3471
> URL: https://issues.apache.org/jira/browse/CALCITE-3471
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Reporter: james601232
>Priority: Blocker
>
> Hi
> Recently I  ticked in to a problem that use jdbc:calcite method get 
> connection and execute query mysql elasticssearch storage.  the results only 
> return 10 records.  checked calcite codes and not found the problems. hope 
> get help to fixed my problems
> Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-02 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16965558#comment-16965558
 ] 

james601232 commented on CALCITE-3471:
--

can u send me the dev mailing list address?

Thank u in adance

> Only return 10 records use jdbc:calcite method
> --
>
> Key: CALCITE-3471
> URL: https://issues.apache.org/jira/browse/CALCITE-3471
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Reporter: james601232
>Priority: Blocker
>
> Hi
> Recently I  ticked in to a problem that use jdbc:calcite method get 
> connection and execute query mysql elasticssearch storage.  the results only 
> return 10 records.  checked calcite codes and not found the problems. hope 
> get help to fixed my problems
> Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-02 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16965568#comment-16965568
 ] 

james601232 commented on CALCITE-3471:
--

Hi [~sereda]

At present our project use calcite 1.17.0 version.

yesterday i checked the code and not found the 10 recoreds limit. i want to 
known where set the 10 recoreds limit of code so that i can clear this problem. 
can u help me?

 

Best  wishes for u 

 

 

> Only return 10 records use jdbc:calcite method
> --
>
> Key: CALCITE-3471
> URL: https://issues.apache.org/jira/browse/CALCITE-3471
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Reporter: james601232
>Priority: Blocker
>
> Hi
> Recently I  ticked in to a problem that use jdbc:calcite method get 
> connection and execute query mysql elasticssearch storage.  the results only 
> return 10 records.  checked calcite codes and not found the problems. hope 
> get help to fixed my problems
> Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-04 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966534#comment-16966534
 ] 

james601232 commented on CALCITE-3471:
--

can anyone reply me the problem?

> Only return 10 records use jdbc:calcite method
> --
>
> Key: CALCITE-3471
> URL: https://issues.apache.org/jira/browse/CALCITE-3471
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Reporter: james601232
>Priority: Blocker
>
> Hi
> Recently I  ticked in to a problem that use jdbc:calcite method get 
> connection and execute query mysql elasticssearch storage.  the results only 
> return 10 records.  checked calcite codes and not found the problems. hope 
> get help to fixed my problems
> Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-04 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3471:
-
Affects Version/s: 1.17.0

> Only return 10 records use jdbc:calcite method
> --
>
> Key: CALCITE-3471
> URL: https://issues.apache.org/jira/browse/CALCITE-3471
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Blocker
>
> Hi
> Recently I  ticked in to a problem that use jdbc:calcite method get 
> connection and execute query mysql elasticssearch storage.  the results only 
> return 10 records.  checked calcite codes and not found the problems. hope 
> get help to fixed my problems
> Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3471) Only return 10 records use jdbc:calcite method

2019-11-04 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967160#comment-16967160
 ] 

james601232 commented on CALCITE-3471:
--

Dear [~sereda] 

why mysql datasource also return 10 rows?

> Only return 10 records use jdbc:calcite method
> --
>
> Key: CALCITE-3471
> URL: https://issues.apache.org/jira/browse/CALCITE-3471
> Project: Calcite
>  Issue Type: Bug
>  Components: elasticsearch-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Blocker
> Fix For: 1.18.0
>
>
> Hi
> Recently I  ticked in to a problem that use jdbc:calcite method get 
> connection and execute query mysql elasticssearch storage.  the results only 
> return 10 records.  checked calcite codes and not found the problems. hope 
> get help to fixed my problems
> Thank in advance



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (CALCITE-3741) duplicate ‘ordre by‘ key work generate in select

2020-01-15 Thread james601232 (Jira)
james601232 created CALCITE-3741:


 Summary: duplicate ‘ordre by‘ key work generate in select
 Key: CALCITE-3741
 URL: https://issues.apache.org/jira/browse/CALCITE-3741
 Project: Calcite
  Issue Type: Bug
  Components: mongodb-adapter
Affects Versions: 1.17.0
Reporter: james601232
 Attachments: image-2020-01-16-14-28-57-662.png

Hi

   I encoutner a problem use calcite query mongodb.  my select sql is "select * 
from products order by score". unfortunatly.  calcite analysis sql concat 
redundant 'order by score'  in sql.

debug screenshot as following:

!image-2020-01-16-14-28-57-662.png!

could you help me what wrong happen. 

Tks 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-15 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3741:
-
Summary: duplicate ‘ordre by‘ key word generate in select  (was: duplicate 
‘ordre by‘ key work generate in select)

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17016698#comment-17016698
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~danny0405]   

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Issue Comment Deleted] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3741:
-
Comment: was deleted

(was: Dear [~danny0405]   )

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17016699#comment-17016699
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~danny0405]

        my sql is “select * from products order by score”.  after calcite 
analsys found duplicate order by in sql 

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017630#comment-17017630
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~amaliujia] 

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Issue Comment Deleted] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3741:
-
Comment: was deleted

(was: Dear [~amaliujia])

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017631#comment-17017631
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~amaliujia]

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Issue Comment Deleted] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3741:
-
Comment: was deleted

(was: Dear [~amaliujia] )

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017638#comment-17017638
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~amaliujia]

        we  have a open project quicksql. it's use jdbc:calcite method query 
mongodb. type sql "select * from products order by score". calcite analysis and 
optimistc the sql found more than one “order by  score” key word in sql.  eg. 
“select * from products {color:#FF}order by score  order by score{color}” 
{color:#172b4d}. I tried debug codes and found SqlValidatorImpl class deal 
order by logic.  but i don't known how to cope it. hopeful getting help. thank 
u so much {color}

{color:#172b4d}!image-2020-01-17-09-40-47-906.png!{color}

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png, 
> image-2020-01-17-09-40-47-906.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3741:
-
Attachment: image-2020-01-17-09-40-47-906.png

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png, 
> image-2020-01-17-09-40-47-906.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


 [ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

james601232 updated CALCITE-3741:
-
Attachment: image-2020-01-17-10-43-28-765.png

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png, 
> image-2020-01-17-09-40-47-906.png, image-2020-01-17-10-43-28-765.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017668#comment-17017668
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~icshuo] 

        type sql is "select * from products {color:#ff}order by 
score{color}". but debug pic show two order by score words in 
{color:#de350b}node{color} and {color:#de350b}orderBy{color} struct. 

why node and orderBy have more than one order by score word. do it normally?

!image-2020-01-17-10-43-28-765.png!

 

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png, 
> image-2020-01-17-09-40-47-906.png, image-2020-01-17-10-43-28-765.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-16 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017679#comment-17017679
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~danny0405]

 yes. ur right. could you give  me a temporary soulation fixed the order by 
issue not upgrade calcite version. for us upgrade calcite is a very large 
project. 

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png, 
> image-2020-01-17-09-40-47-906.png, image-2020-01-17-10-43-28-765.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-19 Thread james601232 (Jira)


[ 
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17018879#comment-17018879
 ] 

james601232 commented on CALCITE-3741:
--

Dear [~danny0405]

       I check this PR 
[https://github.com/apache/calcite/commit/fe0a2fe7dde4a4a342cfc50f2f9da983cc60c479]
 and merge the changes. Unfortunately. the error still exists.

> duplicate ‘ordre by‘ key word generate in select
> 
>
> Key: CALCITE-3741
> URL: https://issues.apache.org/jira/browse/CALCITE-3741
> Project: Calcite
>  Issue Type: Bug
>  Components: mongodb-adapter
>Affects Versions: 1.17.0
>Reporter: james601232
>Priority: Major
> Attachments: image-2020-01-16-14-28-57-662.png, 
> image-2020-01-17-09-40-47-906.png, image-2020-01-17-10-43-28-765.png
>
>
> Hi
>    I encoutner a problem use calcite query mongodb.  my select sql is "select 
> * from products order by score". unfortunatly.  calcite analysis sql concat 
> redundant 'order by score'  in sql.
> debug screenshot as following:
> !image-2020-01-16-14-28-57-662.png!
> could you help me what wrong happen. 
> Tks 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)