Uploaded image for project: 'NLPCraft'
  1. NLPCraft
  2. NLPCRAFT-208

SQL example invalid SQL generation.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.7.3
    • Examples
    • None

    Description

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

      Attachments

        Activity

          People

            sergeykamov Sergey Kamov
            sergeykamov Sergey Kamov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: