Uploaded image for project: 'Couchbase Lite'
  1. Couchbase Lite
  2. CBL-2176

meta().id wrong when "id" is also used as column alias.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 3.0
    • None
    • LiteCore
    • Security Level: Public
    • Jianmin 53
    • 2

    Description

      From couchbase-lite-C, issue#149

      [INFO] | CBL | query: {Query#6}==> litecore::SQLiteQuery SELECT META().id AS id WHERE META().id = $ID @0x7fbb676188b0
      [INFO] | CBL | query: {Query#6} Compiling N1QL query: SELECT META().id AS id WHERE META().id = $ID
      [INFO] | CBL | query: {Query#6} Compiled as SELECT fl_result(_doc.key) AS id FROM kv_default AS _doc WHERE (id.key = $_ID) AND (_doc.flags & 1 = 0)
      [SEVERE] | CBL | database: SQLite error (code 1): no such column: id.key in "SELECT fl_result(_doc.key) AS id FROM kv_default AS _doc WHERE (id.key = $_ID) AND (_doc.flags & 1 = 0)"
      [SEVERE] | CBL | all: no such column: id.key (1/1)
      [WARNING] | CBL | database: {DB#3} SQLite error compiling statement "SELECT fl_result(_doc.key) AS id FROM kv_default AS _doc WHERE (id.key = $_ID) AND (_doc.flags & 1 = 0)": no such column: id.key

      Attachments

        Activity

          People

            jianmin.zhao Jianmin Zhao
            jianmin.zhao Jianmin Zhao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty