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/23 16:22:00 UTC
[jira] [Created] (NLPCRAFT-208) SQL example invalid SQL generation.
Sergey Kamov created NLPCRAFT-208:
-------------------------------------
Summary: 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
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)