Uploaded image for project: 'WsSQL'
  1. WsSQL
  2. WSSQL-84

Query with USE INDEX fails if LIMIT nn is not provided

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Not specified
    • Resolution: Fixed
    • None
    • None
    • ECLEngine
    • None

    Description

      I sent a query:

      select * from tutorial::yn::tutorialperson USE INDEX (tutorial::yn::peoplebyzipindex) WHERE zip= '33442'

      and it failed. But, the following query works:

      select * from tutorial::yn::tutorialperson USE INDEX (tutorial::yn::peoplebyzipindex) WHERE zip= '33442' LIMIT 100

      Attachments

        Activity

          People

            rpastrana Rodrigo Pastrana
            jamesdefabia Jim DeFabia
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: