Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-10530

Comment on: "manual/reference/sql-comparison"

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Works as Designed
    • Icon: Major - P3 Major - P3
    • Server_Docs_20231030
    • None
    • manual, Server

    Description

      Page Error: Typo

      Section: Comparing SQL Statements to MongoDB find() Statements

      Issue: The MongoDB find() examples for "SELECT id, user_id, status" and "SELECT user_id, status" are swapped in the table.

      From the Page:

      SELECT id,
      user_id,
      status
      FROM people

      Compares to:

      db.people.find(
          { },
          { user_id: 1, status: 1 }
      )
      

      Where it should compare to:

      db.people.find(
          { },
          { user_id: 1, status: 1, _id: 0 }
      )
      

      Likewise:

      SELECT user_id, status
      FROM people

      Is compared to:

      db.people.find(
          { },
          { user_id: 1, status: 1, _id: 0 }
      )
      

      and should be compared to:

      db.people.find(
          { },
          { user_id: 1, status: 1 }
      )
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            xgen-internal-docs Docs Collector User (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              5 years, 29 weeks ago