[
https://issues.apache.org/jira/browse/NLPCRAFT-208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17254787#comment-17254787
]
Sergey Kamov commented on NLPCRAFT-208:
---------------------------------------
fixed in master
> SQL example invalid SQL generation.
> -----------------------------------
>
> Key: NLPCRAFT-208
> URL: https://issues.apache.org/jira/browse/NLPCRAFT-208
> Project: NLPCraft
> Issue Type: Bug
> Components: examples
> Reporter: Sergey Kamov
> Assignee: Sergey Kamov
> Priority: Major
> Fix For: 0.7.3
>
>
> {{SELECT}}
> {{ suppliers.company_name,}}
> {{ suppliers.supplier_id,}}
> {{ employees.birth_date}}
> {{FROM}}{{ suppliers}}
> {{WHERE}}
> {{ suppliers.company_name IN (?)}}{{ AND }}
> {{ employees.birth_date >= ?}}{{ AND }}
> {{ employees.birth_date <= ?}}
> {{ORDER BY }}{{suppliers.supplier_id DESC}}
> {{LIMIT }}{{1000}}
>
> {{generated for }}
>
> {{+====================================================================================================================================================================================================================================+}}
> {{| idx | origtext | lemma | pos | quoted | stopword | freeword | wordindexes
> | direct | sparsity | token data |}}
> {{+====================================================================================================================================================================================================================================+}}
> {{| 0 | last year | last year | --- | false | false | false | [0,1] | true |
> 0 | <<nlpcraft:date>> range=2019/01/01:2020/01/01, periods=y,:,y |}}
> {{| 1 | Exotic Liquids | exotic liquids | --- | false | false | false | [2,3]
> | true | 0 | <<condition:value>> id=condition:value, parts=[id=col:val,
> parts=[id=col:suppliers_company_name, aliases='colVal']] |}}
> {{| 2 | orders | order | NNS | false | false | false | [4] | true | 0 |
> <<nlpcraft:sort>> subjnotes=condition:value, subjindexes=[1] |}}
> {{+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
