You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nlpcraft.apache.org by "Sergey Kamov (Jira)" <ji...@apache.org> on 2020/12/25 09:08:00 UTC
[jira] [Closed] (NLPCRAFT-208) SQL example invalid SQL generation.
[ https://issues.apache.org/jira/browse/NLPCRAFT-208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Kamov closed NLPCRAFT-208.
---------------------------------
Resolution: Fixed
> 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)