[24/24] asterixdb git commit: Documentation cleanup.

[buyingyi]

Documentation cleanup.

1. "record"->"object",
2. JSONify sqlpp/3_query.md.

Change-Id: Idcb2be81d1bfa37dd876cd36a7a5bb824bc3ab86
Reviewed-on: https://asterix-gerrit.ics.uci.edu/1295
Reviewed-by: Till Westmann <ti...@apache.org>
Sonar-Qube: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu>


Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo
Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/10351a74
Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/10351a74
Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/10351a74

Branch: refs/heads/master
Commit: 10351a747c5482d31250f6034fd6824b10df7fd9
Parents: 30c5959
Author: Yingyi Bu <yin...@couchbase.com>
Authored: Tue Oct 18 17:27:30 2016 -0700
Committer: Yingyi Bu <buyin...@gmail.com>
Committed: Tue Oct 18 19:30:24 2016 -0700

----------------------------------------------------------------------
 .../opentype-insert2/opentype-insert2.1.ddl.aql |    2 +-
 .../opentype-insert2.2.update.aql               |    2 +-
 .../opentype-insert2.3.query.aql                |    2 +-
 .../queries/objects/ObjectsQueries.xml          |  184 +++
 .../access-nested-fields.1.ddl.aql              |   78 ++
 .../access-nested-fields.10.query.aql           |   29 +
 .../access-nested-fields.11.query.aql           |   29 +
 .../access-nested-fields.12.query.aql           |   29 +
 .../access-nested-fields.2.update.aql           |   28 +
 .../access-nested-fields.3.query.aql            |   30 +
 .../access-nested-fields.4.query.aql            |   30 +
 .../access-nested-fields.5.query.aql            |   30 +
 .../access-nested-fields.6.query.aql            |   30 +
 .../access-nested-fields.7.query.aql            |   30 +
 .../access-nested-fields.8.query.aql            |   29 +
 .../access-nested-fields.9.query.aql            |   29 +
 ...closed-fieldname-conflict_issue173.1.ddl.aql |   25 +
 ...sed-fieldname-conflict_issue173.2.update.aql |   25 +
 ...osed-fieldname-conflict_issue173.3.query.aql |   27 +
 .../closed-nullable-fileds_issue1616.1.ddl.aql  |  862 ++++++++++++
 ...losed-nullable-fileds_issue1616.2.update.aql |   28 +
 ...closed-nullable-fileds_issue1616.3.query.aql |   29 +
 .../closed-record-constructor_01.1.ddl.aql      |   21 +
 .../closed-record-constructor_01.2.update.aql   |   18 +
 .../closed-record-constructor_01.3.query.aql    |   22 +
 .../closed-record-constructor_02.1.ddl.aql      |   20 +
 .../closed-record-constructor_02.2.update.aql   |   19 +
 .../closed-record-constructor_02.3.query.aql    |   22 +
 .../closed-record-constructor_03.1.ddl.aql      |   21 +
 .../closed-record-constructor_03.2.update.aql   |   18 +
 .../closed-record-constructor_03.3.query.aql    |   22 +
 .../objects/expFieldName/expFieldName.1.ddl.aql |   21 +
 .../expFieldName/expFieldName.2.update.aql      |   18 +
 .../expFieldName/expFieldName.3.query.aql       |   22 +
 .../field-access-by-index_01.1.ddl.aql          |   20 +
 .../field-access-by-index_01.2.update.aql       |   18 +
 .../field-access-by-index_01.3.query.aql        |   23 +
 .../field-access-on-open-field.1.ddl.aql        |   35 +
 .../field-access-on-open-field.2.update.aql     |   28 +
 .../field-access-on-open-field.3.query.aql      |   29 +
 .../documentation-example.1.query.aql           |   28 +
 .../documentation-example.2.query.aql           |   28 +
 .../documentation-example.3.query.aql           |   28 +
 .../highly-nested-open.1.ddl.aql                |   81 ++
 .../highly-nested-open.2.update.aql             |   27 +
 .../highly-nested-open.3.query.aql              |   29 +
 .../highly-nested-mixed.1.ddl.aql               |   77 ++
 .../highly-nested-mixed.2.update.aql            |   27 +
 .../highly-nested-mixed.3.query.aql             |   29 +
 .../highly-nested-open.1.ddl.aql                |   72 +
 .../highly-nested-open.2.update.aql             |   27 +
 .../highly-nested-open.3.query.aql              |   29 +
 .../tiny-social-example.1.ddl.aql               |   67 +
 .../tiny-social-example.2.ddl.aql               |   42 +
 .../tiny-social-example.3.update.aql            |   36 +
 .../tiny-social-example.4.query.aql             |   31 +
 .../documentation-example.1.query.aql           |   28 +
 ...ny-social-example-no-complex-types.1.ddl.aql |  101 ++
 ...ny-social-example-no-complex-types.2.ddl.aql |   56 +
 ...social-example-no-complex-types.3.update.aql |   79 ++
 ...-social-example-no-complex-types.4.query.aql |   28 +
 ...-social-example-no-complex-types.5.query.aql |   28 +
 ...-social-example-no-complex-types.6.query.aql |   28 +
 ...-social-example-no-complex-types.7.query.aql |   28 +
 ...-social-example-no-complex-types.8.query.aql |   28 +
 ...-social-example-no-complex-types.9.query.aql |   31 +
 .../tiny-social-example-only-lists.1.ddl.aql    |  103 ++
 .../tiny-social-example-only-lists.2.ddl.aql    |   56 +
 .../tiny-social-example-only-lists.3.update.aql |   81 ++
 .../tiny-social-example-only-lists.4.query.aql  |   28 +
 .../tiny-social-example-only-lists.5.query.aql  |   28 +
 .../tiny-social-example-only-lists.6.query.aql  |   28 +
 .../tiny-social-example-only-lists.7.query.aql  |   28 +
 .../tiny-social-example-only-lists.8.query.aql  |   28 +
 .../tiny-social-example-only-lists.9.query.aql  |   31 +
 .../tiny-social-example-only-records.1.ddl.aql  |  103 ++
 .../tiny-social-example-only-records.2.ddl.aql  |   56 +
 ...iny-social-example-only-records.3.update.aql |   81 ++
 ...tiny-social-example-only-records.4.query.aql |   28 +
 ...tiny-social-example-only-records.5.query.aql |   28 +
 ...tiny-social-example-only-records.6.query.aql |   28 +
 ...tiny-social-example-only-records.7.query.aql |   28 +
 ...tiny-social-example-only-records.8.query.aql |   28 +
 ...tiny-social-example-only-records.9.query.aql |   31 +
 .../tiny-social-example.1.ddl.aql               |   65 +
 .../tiny-social-example.2.ddl.aql               |   42 +
 .../tiny-social-example.3.update.aql            |   36 +
 .../tiny-social-example.4.query.aql             |   28 +
 .../tiny-social-example.5.query.aql             |   28 +
 .../tiny-social-example.6.query.aql             |   28 +
 .../tiny-social-example.7.query.aql             |   28 +
 .../tiny-social-example.8.query.aql             |   28 +
 .../tiny-social-example.9.query.aql             |   31 +
 .../documentation-example.1.query.aql           |   28 +
 .../documentation-example.2.query.aql           |   28 +
 .../documentation-example.3.query.aql           |   28 +
 .../highly-nested-open.1.ddl.aql                |   72 +
 .../highly-nested-open.2.update.aql             |   27 +
 .../highly-nested-open.3.query.aql              |   30 +
 .../tiny-social-example.1.ddl.aql               |   68 +
 .../tiny-social-example.2.ddl.aql               |   43 +
 .../tiny-social-example.3.update.aql            |   36 +
 .../tiny-social-example.4.query.aql             |   30 +
 .../documentation-example.1.query.aql           |   28 +
 .../documentation-example.2.query.aql           |   32 +
 .../documentation-example.3.query.aql           |   32 +
 .../highly-nested-open.1.ddl.aql                |   72 +
 .../highly-nested-open.2.update.aql             |   27 +
 .../highly-nested-open.3.query.aql              |   30 +
 .../tiny-social-example.1.ddl.aql               |   67 +
 .../tiny-social-example.2.ddl.aql               |   42 +
 .../tiny-social-example.3.update.aql            |   36 +
 .../tiny-social-example.4.query.aql             |   30 +
 .../documentation-example.1.query.aql           |   28 +
 .../documentation-example.2.query.aql           |   28 +
 .../documentation-example.3.query.aql           |   28 +
 .../highly-nested-open.1.ddl.aql                |   72 +
 .../highly-nested-open.2.update.aql             |   27 +
 .../highly-nested-open.3.query.aql              |   29 +
 .../tiny-social-example.1.ddl.aql               |   67 +
 .../tiny-social-example.2.ddl.aql               |   42 +
 .../tiny-social-example.3.update.aql            |   36 +
 .../tiny-social-example.4.query.aql             |   29 +
 ...closed-fieldname-conflict_issue173.1.ddl.aql |   34 +
 ...sed-fieldname-conflict_issue173.2.update.aql |   28 +
 ...osed-fieldname-conflict_issue173.3.query.aql |   28 +
 .../open-record-constructor_01.1.ddl.aql        |   20 +
 .../open-record-constructor_01.2.update.aql     |   18 +
 .../open-record-constructor_01.3.query.aql      |   22 +
 .../open-record-constructor_02.1.ddl.aql        |   21 +
 .../open-record-constructor_02.2.update.aql     |   18 +
 .../open-record-constructor_02.3.query.aql      |   22 +
 ...n-open-fieldname-conflict_issue173.1.ddl.aql |   34 +
 ...pen-fieldname-conflict_issue173.2.update.aql |   27 +
 ...open-fieldname-conflict_issue173.3.query.aql |   28 +
 .../queries/records/RecordsQueries.xml          |  184 ---
 .../access-nested-fields.1.ddl.aql              |   78 --
 .../access-nested-fields.10.query.aql           |   29 -
 .../access-nested-fields.11.query.aql           |   29 -
 .../access-nested-fields.12.query.aql           |   29 -
 .../access-nested-fields.2.update.aql           |   28 -
 .../access-nested-fields.3.query.aql            |   30 -
 .../access-nested-fields.4.query.aql            |   30 -
 .../access-nested-fields.5.query.aql            |   30 -
 .../access-nested-fields.6.query.aql            |   30 -
 .../access-nested-fields.7.query.aql            |   30 -
 .../access-nested-fields.8.query.aql            |   29 -
 .../access-nested-fields.9.query.aql            |   29 -
 ...closed-fieldname-conflict_issue173.1.ddl.aql |   25 -
 ...sed-fieldname-conflict_issue173.2.update.aql |   25 -
 ...osed-fieldname-conflict_issue173.3.query.aql |   27 -
 .../closed-nullable-fileds_issue1616.1.ddl.aql  |  862 ------------
 ...losed-nullable-fileds_issue1616.2.update.aql |   28 -
 ...closed-nullable-fileds_issue1616.3.query.aql |   29 -
 .../closed-record-constructor_01.1.ddl.aql      |   21 -
 .../closed-record-constructor_01.2.update.aql   |   18 -
 .../closed-record-constructor_01.3.query.aql    |   22 -
 .../closed-record-constructor_02.1.ddl.aql      |   20 -
 .../closed-record-constructor_02.2.update.aql   |   19 -
 .../closed-record-constructor_02.3.query.aql    |   22 -
 .../closed-record-constructor_03.1.ddl.aql      |   21 -
 .../closed-record-constructor_03.2.update.aql   |   18 -
 .../closed-record-constructor_03.3.query.aql    |   22 -
 .../records/expFieldName/expFieldName.1.ddl.aql |   21 -
 .../expFieldName/expFieldName.2.update.aql      |   18 -
 .../expFieldName/expFieldName.3.query.aql       |   22 -
 .../field-access-by-index_01.1.ddl.aql          |   20 -
 .../field-access-by-index_01.2.update.aql       |   18 -
 .../field-access-by-index_01.3.query.aql        |   23 -
 .../field-access-on-open-field.1.ddl.aql        |   35 -
 .../field-access-on-open-field.2.update.aql     |   28 -
 .../field-access-on-open-field.3.query.aql      |   29 -
 .../documentation-example.1.query.aql           |   28 -
 .../documentation-example.2.query.aql           |   28 -
 .../documentation-example.3.query.aql           |   28 -
 .../highly-nested-open.1.ddl.aql                |   81 --
 .../highly-nested-open.2.update.aql             |   27 -
 .../highly-nested-open.3.query.aql              |   29 -
 .../highly-nested-mixed.1.ddl.aql               |   77 --
 .../highly-nested-mixed.2.update.aql            |   27 -
 .../highly-nested-mixed.3.query.aql             |   29 -
 .../highly-nested-open.1.ddl.aql                |   72 -
 .../highly-nested-open.2.update.aql             |   27 -
 .../highly-nested-open.3.query.aql              |   29 -
 .../tiny-social-example.1.ddl.aql               |   67 -
 .../tiny-social-example.2.ddl.aql               |   42 -
 .../tiny-social-example.3.update.aql            |   36 -
 .../tiny-social-example.4.query.aql             |   31 -
 .../documentation-example.1.query.aql           |   28 -
 ...ny-social-example-no-complex-types.1.ddl.aql |  101 --
 ...ny-social-example-no-complex-types.2.ddl.aql |   56 -
 ...social-example-no-complex-types.3.update.aql |   79 --
 ...-social-example-no-complex-types.4.query.aql |   28 -
 ...-social-example-no-complex-types.5.query.aql |   28 -
 ...-social-example-no-complex-types.6.query.aql |   28 -
 ...-social-example-no-complex-types.7.query.aql |   28 -
 ...-social-example-no-complex-types.8.query.aql |   28 -
 ...-social-example-no-complex-types.9.query.aql |   31 -
 .../tiny-social-example-only-lists.1.ddl.aql    |  103 --
 .../tiny-social-example-only-lists.2.ddl.aql    |   56 -
 .../tiny-social-example-only-lists.3.update.aql |   81 --
 .../tiny-social-example-only-lists.4.query.aql  |   28 -
 .../tiny-social-example-only-lists.5.query.aql  |   28 -
 .../tiny-social-example-only-lists.6.query.aql  |   28 -
 .../tiny-social-example-only-lists.7.query.aql  |   28 -
 .../tiny-social-example-only-lists.8.query.aql  |   28 -
 .../tiny-social-example-only-lists.9.query.aql  |   31 -
 .../tiny-social-example-only-records.1.ddl.aql  |  103 --
 .../tiny-social-example-only-records.2.ddl.aql  |   56 -
 ...iny-social-example-only-records.3.update.aql |   81 --
 ...tiny-social-example-only-records.4.query.aql |   28 -
 ...tiny-social-example-only-records.5.query.aql |   28 -
 ...tiny-social-example-only-records.6.query.aql |   28 -
 ...tiny-social-example-only-records.7.query.aql |   28 -
 ...tiny-social-example-only-records.8.query.aql |   28 -
 ...tiny-social-example-only-records.9.query.aql |   31 -
 .../tiny-social-example.1.ddl.aql               |   65 -
 .../tiny-social-example.2.ddl.aql               |   42 -
 .../tiny-social-example.3.update.aql            |   36 -
 .../tiny-social-example.4.query.aql             |   28 -
 .../tiny-social-example.5.query.aql             |   28 -
 .../tiny-social-example.6.query.aql             |   28 -
 .../tiny-social-example.7.query.aql             |   28 -
 .../tiny-social-example.8.query.aql             |   28 -
 .../tiny-social-example.9.query.aql             |   31 -
 ...closed-fieldname-conflict_issue173.1.ddl.aql |   34 -
 ...sed-fieldname-conflict_issue173.2.update.aql |   28 -
 ...osed-fieldname-conflict_issue173.3.query.aql |   28 -
 ...n-open-fieldname-conflict_issue173.1.ddl.aql |   34 -
 ...pen-fieldname-conflict_issue173.2.update.aql |   27 -
 ...open-fieldname-conflict_issue173.3.query.aql |   28 -
 .../open-record-constructor_01.1.ddl.aql        |   20 -
 .../open-record-constructor_01.2.update.aql     |   18 -
 .../open-record-constructor_01.3.query.aql      |   22 -
 .../open-record-constructor_02.1.ddl.aql        |   21 -
 .../open-record-constructor_02.2.update.aql     |   18 -
 .../open-record-constructor_02.3.query.aql      |   22 -
 .../documentation-example.1.query.aql           |   28 -
 .../documentation-example.2.query.aql           |   28 -
 .../documentation-example.3.query.aql           |   28 -
 .../highly-nested-open.1.ddl.aql                |   72 -
 .../highly-nested-open.2.update.aql             |   27 -
 .../highly-nested-open.3.query.aql              |   30 -
 .../tiny-social-example.1.ddl.aql               |   68 -
 .../tiny-social-example.2.ddl.aql               |   43 -
 .../tiny-social-example.3.update.aql            |   36 -
 .../tiny-social-example.4.query.aql             |   30 -
 .../documentation-example.1.query.aql           |   28 -
 .../documentation-example.2.query.aql           |   32 -
 .../documentation-example.3.query.aql           |   32 -
 .../highly-nested-open.1.ddl.aql                |   72 -
 .../highly-nested-open.2.update.aql             |   27 -
 .../highly-nested-open.3.query.aql              |   30 -
 .../tiny-social-example.1.ddl.aql               |   67 -
 .../tiny-social-example.2.ddl.aql               |   42 -
 .../tiny-social-example.3.update.aql            |   36 -
 .../tiny-social-example.4.query.aql             |   30 -
 .../documentation-example.1.query.aql           |   28 -
 .../documentation-example.2.query.aql           |   28 -
 .../documentation-example.3.query.aql           |   28 -
 .../highly-nested-open.1.ddl.aql                |   72 -
 .../highly-nested-open.2.update.aql             |   27 -
 .../highly-nested-open.3.query.aql              |   29 -
 .../tiny-social-example.1.ddl.aql               |   67 -
 .../tiny-social-example.2.ddl.aql               |   42 -
 .../tiny-social-example.3.update.aql            |   36 -
 .../tiny-social-example.4.query.aql             |   29 -
 .../opentype-insert2.1.ddl.sqlpp                |    2 +-
 .../opentype-insert2.2.update.sqlpp             |    2 +-
 .../opentype-insert2.3.query.sqlpp              |    2 +-
 .../queries_sqlpp/objects/ObjectsQueries.xml    |  143 ++
 .../access-nested-fields.1.ddl.sqlpp            |   88 ++
 .../access-nested-fields.10.query.sqlpp         |   32 +
 .../access-nested-fields.11.query.sqlpp         |   32 +
 .../access-nested-fields.12.query.sqlpp         |   32 +
 .../access-nested-fields.2.update.sqlpp         |   29 +
 .../access-nested-fields.3.query.sqlpp          |   32 +
 .../access-nested-fields.4.query.sqlpp          |   32 +
 .../access-nested-fields.5.query.sqlpp          |   32 +
 .../access-nested-fields.6.query.sqlpp          |   32 +
 .../access-nested-fields.7.query.sqlpp          |   32 +
 .../access-nested-fields.8.query.sqlpp          |   32 +
 .../access-nested-fields.9.query.sqlpp          |   32 +
 ...osed-fieldname-conflict_issue173.1.ddl.sqlpp |   27 +
 ...d-fieldname-conflict_issue173.2.update.sqlpp |   24 +
 ...ed-fieldname-conflict_issue173.3.query.sqlpp |   28 +
 .../closed-record-constructor_01.1.ddl.sqlpp    |   22 +
 .../closed-record-constructor_01.2.update.sqlpp |   19 +
 .../closed-record-constructor_01.3.query.sqlpp  |   25 +
 .../closed-record-constructor_02.1.ddl.sqlpp    |   22 +
 .../closed-record-constructor_02.2.update.sqlpp |   19 +
 .../closed-record-constructor_02.3.query.sqlpp  |   25 +
 .../closed-record-constructor_03.1.ddl.sqlpp    |   22 +
 .../closed-record-constructor_03.2.update.sqlpp |   19 +
 .../closed-record-constructor_03.3.query.sqlpp  |   25 +
 .../expFieldName/expFieldName.1.ddl.sqlpp       |   22 +
 .../expFieldName/expFieldName.2.update.sqlpp    |   19 +
 .../expFieldName/expFieldName.3.query.sqlpp     |   25 +
 .../field-access-by-index_01.1.ddl.sqlpp        |   22 +
 .../field-access-by-index_01.2.update.sqlpp     |   19 +
 .../field-access-by-index_01.3.query.sqlpp      |   25 +
 .../field-access-on-open-field.1.ddl.sqlpp      |   38 +
 .../field-access-on-open-field.2.update.sqlpp   |   29 +
 .../field-access-on-open-field.3.query.sqlpp    |   31 +
 .../documentation-example.1.query.sqlpp         |   25 +
 .../documentation-example.2.query.sqlpp         |   25 +
 .../documentation-example.3.query.sqlpp         |   25 +
 .../highly-nested-open.1.ddl.sqlpp              |   92 ++
 .../highly-nested-open.2.update.sqlpp           |   29 +
 .../highly-nested-open.3.query.sqlpp            |   32 +
 .../highly-nested-mixed.1.ddl.sqlpp             |   88 ++
 .../highly-nested-mixed.2.update.sqlpp          |   29 +
 .../highly-nested-mixed.3.query.sqlpp           |   32 +
 .../highly-nested-open.1.ddl.sqlpp              |   83 ++
 .../highly-nested-open.2.update.sqlpp           |   29 +
 .../highly-nested-open.3.query.sqlpp            |   32 +
 .../tiny-social-example.1.ddl.sqlpp             |   76 ++
 .../tiny-social-example.2.ddl.sqlpp             |   43 +
 .../tiny-social-example.3.update.sqlpp          |   35 +
 .../tiny-social-example.4.query.sqlpp           |   34 +
 .../documentation-example.1.query.sqlpp         |   25 +
 ...-social-example-no-complex-types.1.ddl.sqlpp |  114 ++
 ...-social-example-no-complex-types.2.ddl.sqlpp |   51 +
 ...cial-example-no-complex-types.3.update.sqlpp |   51 +
 ...ocial-example-no-complex-types.4.query.sqlpp |   31 +
 ...ocial-example-no-complex-types.5.query.sqlpp |   31 +
 ...ocial-example-no-complex-types.6.query.sqlpp |   31 +
 ...ocial-example-no-complex-types.7.query.sqlpp |   31 +
 ...ocial-example-no-complex-types.8.query.sqlpp |   31 +
 ...ocial-example-no-complex-types.9.query.sqlpp |   34 +
 .../tiny-social-example-only-lists.1.ddl.sqlpp  |  116 ++
 .../tiny-social-example-only-lists.2.ddl.sqlpp  |   51 +
 ...iny-social-example-only-lists.3.update.sqlpp |   51 +
 ...tiny-social-example-only-lists.4.query.sqlpp |   31 +
 ...tiny-social-example-only-lists.5.query.sqlpp |   31 +
 ...tiny-social-example-only-lists.6.query.sqlpp |   31 +
 ...tiny-social-example-only-lists.7.query.sqlpp |   31 +
 ...tiny-social-example-only-lists.8.query.sqlpp |   31 +
 ...tiny-social-example-only-lists.9.query.sqlpp |   34 +
 ...tiny-social-example-only-records.1.ddl.sqlpp |  116 ++
 ...tiny-social-example-only-records.2.ddl.sqlpp |   51 +
 ...y-social-example-only-records.3.update.sqlpp |   51 +
 ...ny-social-example-only-records.4.query.sqlpp |   31 +
 ...ny-social-example-only-records.5.query.sqlpp |   31 +
 ...ny-social-example-only-records.6.query.sqlpp |   31 +
 ...ny-social-example-only-records.7.query.sqlpp |   31 +
 ...ny-social-example-only-records.8.query.sqlpp |   31 +
 ...ny-social-example-only-records.9.query.sqlpp |   34 +
 .../tiny-social-example.1.ddl.sqlpp             |   74 +
 .../tiny-social-example.2.ddl.sqlpp             |   43 +
 .../tiny-social-example.3.update.sqlpp          |   35 +
 .../tiny-social-example.4.query.sqlpp           |   31 +
 .../tiny-social-example.5.query.sqlpp           |   31 +
 .../tiny-social-example.6.query.sqlpp           |   31 +
 .../tiny-social-example.7.query.sqlpp           |   31 +
 .../tiny-social-example.8.query.sqlpp           |   31 +
 .../tiny-social-example.9.query.sqlpp           |   34 +
 .../object_pairs-2/object_pairs.1.ddl.sqlpp     |   30 +
 .../object_pairs-2/object_pairs.2.update.sqlpp  |   23 +
 .../object_pairs-2/object_pairs.3.query.sqlpp   |   25 +
 .../object_pairs/object_pairs.1.query.sqlpp     |   21 +
 ...osed-fieldname-conflict_issue173.1.ddl.sqlpp |   38 +
 ...d-fieldname-conflict_issue173.2.update.sqlpp |   29 +
 ...ed-fieldname-conflict_issue173.3.query.sqlpp |   30 +
 .../open-record-constructor_01.1.ddl.sqlpp      |   22 +
 .../open-record-constructor_01.2.update.sqlpp   |   19 +
 .../open-record-constructor_01.3.query.sqlpp    |   25 +
 .../open-record-constructor_02.1.ddl.sqlpp      |   22 +
 .../open-record-constructor_02.2.update.sqlpp   |   19 +
 .../open-record-constructor_02.3.query.sqlpp    |   25 +
 ...open-fieldname-conflict_issue173.1.ddl.sqlpp |   38 +
 ...n-fieldname-conflict_issue173.2.update.sqlpp |   29 +
 ...en-fieldname-conflict_issue173.3.query.sqlpp |   30 +
 .../queries_sqlpp/records/RecordsQueries.xml    |  143 --
 .../access-nested-fields.1.ddl.sqlpp            |   88 --
 .../access-nested-fields.10.query.sqlpp         |   32 -
 .../access-nested-fields.11.query.sqlpp         |   32 -
 .../access-nested-fields.12.query.sqlpp         |   32 -
 .../access-nested-fields.2.update.sqlpp         |   29 -
 .../access-nested-fields.3.query.sqlpp          |   32 -
 .../access-nested-fields.4.query.sqlpp          |   32 -
 .../access-nested-fields.5.query.sqlpp          |   32 -
 .../access-nested-fields.6.query.sqlpp          |   32 -
 .../access-nested-fields.7.query.sqlpp          |   32 -
 .../access-nested-fields.8.query.sqlpp          |   32 -
 .../access-nested-fields.9.query.sqlpp          |   32 -
 ...osed-fieldname-conflict_issue173.1.ddl.sqlpp |   27 -
 ...d-fieldname-conflict_issue173.2.update.sqlpp |   24 -
 ...ed-fieldname-conflict_issue173.3.query.sqlpp |   28 -
 .../closed-record-constructor_01.1.ddl.sqlpp    |   22 -
 .../closed-record-constructor_01.2.update.sqlpp |   19 -
 .../closed-record-constructor_01.3.query.sqlpp  |   25 -
 .../closed-record-constructor_02.1.ddl.sqlpp    |   22 -
 .../closed-record-constructor_02.2.update.sqlpp |   19 -
 .../closed-record-constructor_02.3.query.sqlpp  |   25 -
 .../closed-record-constructor_03.1.ddl.sqlpp    |   22 -
 .../closed-record-constructor_03.2.update.sqlpp |   19 -
 .../closed-record-constructor_03.3.query.sqlpp  |   25 -
 .../expFieldName/expFieldName.1.ddl.sqlpp       |   22 -
 .../expFieldName/expFieldName.2.update.sqlpp    |   19 -
 .../expFieldName/expFieldName.3.query.sqlpp     |   25 -
 .../field-access-by-index_01.1.ddl.sqlpp        |   22 -
 .../field-access-by-index_01.2.update.sqlpp     |   19 -
 .../field-access-by-index_01.3.query.sqlpp      |   25 -
 .../field-access-on-open-field.1.ddl.sqlpp      |   38 -
 .../field-access-on-open-field.2.update.sqlpp   |   29 -
 .../field-access-on-open-field.3.query.sqlpp    |   31 -
 .../documentation-example.1.query.sqlpp         |   25 -
 .../documentation-example.2.query.sqlpp         |   25 -
 .../documentation-example.3.query.sqlpp         |   25 -
 .../highly-nested-open.1.ddl.sqlpp              |   92 --
 .../highly-nested-open.2.update.sqlpp           |   29 -
 .../highly-nested-open.3.query.sqlpp            |   32 -
 .../highly-nested-mixed.1.ddl.sqlpp             |   88 --
 .../highly-nested-mixed.2.update.sqlpp          |   29 -
 .../highly-nested-mixed.3.query.sqlpp           |   32 -
 .../highly-nested-open.1.ddl.sqlpp              |   83 --
 .../highly-nested-open.2.update.sqlpp           |   29 -
 .../highly-nested-open.3.query.sqlpp            |   32 -
 .../tiny-social-example.1.ddl.sqlpp             |   76 --
 .../tiny-social-example.2.ddl.sqlpp             |   43 -
 .../tiny-social-example.3.update.sqlpp          |   35 -
 .../tiny-social-example.4.query.sqlpp           |   34 -
 .../documentation-example.1.query.sqlpp         |   25 -
 ...-social-example-no-complex-types.1.ddl.sqlpp |  114 --
 ...-social-example-no-complex-types.2.ddl.sqlpp |   51 -
 ...cial-example-no-complex-types.3.update.sqlpp |   51 -
 ...ocial-example-no-complex-types.4.query.sqlpp |   31 -
 ...ocial-example-no-complex-types.5.query.sqlpp |   31 -
 ...ocial-example-no-complex-types.6.query.sqlpp |   31 -
 ...ocial-example-no-complex-types.7.query.sqlpp |   31 -
 ...ocial-example-no-complex-types.8.query.sqlpp |   31 -
 ...ocial-example-no-complex-types.9.query.sqlpp |   34 -
 .../tiny-social-example-only-lists.1.ddl.sqlpp  |  116 --
 .../tiny-social-example-only-lists.2.ddl.sqlpp  |   51 -
 ...iny-social-example-only-lists.3.update.sqlpp |   51 -
 ...tiny-social-example-only-lists.4.query.sqlpp |   31 -
 ...tiny-social-example-only-lists.5.query.sqlpp |   31 -
 ...tiny-social-example-only-lists.6.query.sqlpp |   31 -
 ...tiny-social-example-only-lists.7.query.sqlpp |   31 -
 ...tiny-social-example-only-lists.8.query.sqlpp |   31 -
 ...tiny-social-example-only-lists.9.query.sqlpp |   34 -
 ...tiny-social-example-only-records.1.ddl.sqlpp |  116 --
 ...tiny-social-example-only-records.2.ddl.sqlpp |   51 -
 ...y-social-example-only-records.3.update.sqlpp |   51 -
 ...ny-social-example-only-records.4.query.sqlpp |   31 -
 ...ny-social-example-only-records.5.query.sqlpp |   31 -
 ...ny-social-example-only-records.6.query.sqlpp |   31 -
 ...ny-social-example-only-records.7.query.sqlpp |   31 -
 ...ny-social-example-only-records.8.query.sqlpp |   31 -
 ...ny-social-example-only-records.9.query.sqlpp |   34 -
 .../tiny-social-example.1.ddl.sqlpp             |   74 -
 .../tiny-social-example.2.ddl.sqlpp             |   43 -
 .../tiny-social-example.3.update.sqlpp          |   35 -
 .../tiny-social-example.4.query.sqlpp           |   31 -
 .../tiny-social-example.5.query.sqlpp           |   31 -
 .../tiny-social-example.6.query.sqlpp           |   31 -
 .../tiny-social-example.7.query.sqlpp           |   31 -
 .../tiny-social-example.8.query.sqlpp           |   31 -
 .../tiny-social-example.9.query.sqlpp           |   34 -
 .../object_pairs-2/object_pairs.1.ddl.sqlpp     |   30 -
 .../object_pairs-2/object_pairs.2.update.sqlpp  |   23 -
 .../object_pairs-2/object_pairs.3.query.sqlpp   |   25 -
 .../object_pairs/object_pairs.1.query.sqlpp     |   21 -
 ...osed-fieldname-conflict_issue173.1.ddl.sqlpp |   38 -
 ...d-fieldname-conflict_issue173.2.update.sqlpp |   29 -
 ...ed-fieldname-conflict_issue173.3.query.sqlpp |   30 -
 ...open-fieldname-conflict_issue173.1.ddl.sqlpp |   38 -
 ...n-fieldname-conflict_issue173.2.update.sqlpp |   29 -
 ...en-fieldname-conflict_issue173.3.query.sqlpp |   30 -
 .../open-record-constructor_01.1.ddl.sqlpp      |   22 -
 .../open-record-constructor_01.2.update.sqlpp   |   19 -
 .../open-record-constructor_01.3.query.sqlpp    |   25 -
 .../open-record-constructor_02.1.ddl.sqlpp      |   22 -
 .../open-record-constructor_02.2.update.sqlpp   |   19 -
 .../open-record-constructor_02.3.query.sqlpp    |   25 -
 .../resources/runtimets/repeatedtestsuite.xml   |    2 +-
 .../access-nested-fields.10.adm                 |    4 +
 .../access-nested-fields.11.adm                 |    4 +
 .../access-nested-fields.12.adm                 |    4 +
 .../access-nested-fields.3.adm                  |    4 +
 .../access-nested-fields.4.adm                  |    4 +
 .../access-nested-fields.5.adm                  |    4 +
 .../access-nested-fields.6.adm                  |    4 +
 .../access-nested-fields.7.adm                  |    4 +
 .../access-nested-fields.8.adm                  |    4 +
 .../access-nested-fields.9.adm                  |    4 +
 .../closed-nullable-fields_issue1616.1.adm      |    2 +
 .../closed-record-constructor_01.1.adm          |    1 +
 .../closed-record-constructor_02.1.adm          |    1 +
 .../closed-record-constructor_03.1.adm          |    1 +
 .../objects/expFieldName/expFieldName.1.adm     |    2 +
 .../field-access-by-index_01.1.adm              |    1 +
 .../field-access-on-open-field.1.adm            |    1 +
 .../documentation-example.1.adm                 |    1 +
 .../documentation-example.2.adm                 |    1 +
 .../documentation-example.3.adm                 |    1 +
 .../highly-nested-closed.3.adm                  |    4 +
 .../highly-nested-mixed.3.adm                   |    4 +
 .../highly-nested-open/highly-nested-open.3.adm |    4 +
 .../tiny-social-example.4.adm                   |   24 +
 .../documentation-example.1.adm                 |    1 +
 .../tiny-social-example-no-complex-types.4.adm  |    1 +
 .../tiny-social-example-no-complex-types.5.adm  |   10 +
 .../tiny-social-example-no-complex-types.6.adm  |   15 +
 .../tiny-social-example-no-complex-types.7.adm  |    4 +
 .../tiny-social-example-no-complex-types.8.adm  |   12 +
 .../tiny-social-example-no-complex-types.9.adm  |    4 +
 .../tiny-social-example-only-lists.4.adm        |    1 +
 .../tiny-social-example-only-lists.5.adm        |   10 +
 .../tiny-social-example-only-lists.6.adm        |   15 +
 .../tiny-social-example-only-lists.7.adm        |    4 +
 .../tiny-social-example-only-lists.8.adm        |   12 +
 .../tiny-social-example-only-lists.9.adm        |    5 +
 .../tiny-social-example-only-records.4.adm      |    1 +
 .../tiny-social-example-only-records.5.adm      |   10 +
 .../tiny-social-example-only-records.6.adm      |   15 +
 .../tiny-social-example-only-records.7.adm      |    4 +
 .../tiny-social-example-only-records.8.adm      |   12 +
 .../tiny-social-example-only-records.9.adm      |    5 +
 .../tiny-social-example.4.adm                   |    1 +
 .../tiny-social-example.5.adm                   |   10 +
 .../tiny-social-example.6.adm                   |   15 +
 .../tiny-social-example.7.adm                   |    4 +
 .../tiny-social-example.8.adm                   |   12 +
 .../tiny-social-example.9.adm                   |    6 +
 .../documentation-example.1.adm                 |    1 +
 .../documentation-example.2.adm                 |    1 +
 .../documentation-example.3.adm                 |    1 +
 .../highly-nested-open/highly-nested-open.3.adm |    4 +
 .../tiny-social-example.4.adm                   |   10 +
 .../documentation-example.1.adm                 |    1 +
 .../documentation-example.2.adm                 |    1 +
 .../documentation-example.3.adm                 |    1 +
 .../highly-nested-open/highly-nested-open.3.adm |    4 +
 .../tiny-social-example.4.adm                   |  180 +++
 .../documentation-example.1.adm                 |    1 +
 .../documentation-example.2.adm                 |    1 +
 .../documentation-example.3.adm                 |    1 +
 .../highly-nested-open/highly-nested-open.3.adm |    4 +
 .../tiny-social-example.4.adm                   |   12 +
 .../objects/object_pairs-2/object_pairs-2.1.adm |    3 +
 .../objects/object_pairs/object_pairs.1.adm     |    3 +
 .../open-record-constructor_01.1.adm            |    1 +
 .../open-record-constructor_02.1.adm            |    1 +
 .../access-nested-fields.10.adm                 |    4 -
 .../access-nested-fields.11.adm                 |    4 -
 .../access-nested-fields.12.adm                 |    4 -
 .../access-nested-fields.3.adm                  |    4 -
 .../access-nested-fields.4.adm                  |    4 -
 .../access-nested-fields.5.adm                  |    4 -
 .../access-nested-fields.6.adm                  |    4 -
 .../access-nested-fields.7.adm                  |    4 -
 .../access-nested-fields.8.adm                  |    4 -
 .../access-nested-fields.9.adm                  |    4 -
 .../closed-nullable-fields_issue1616.1.adm      |    2 -
 .../closed-record-constructor_01.1.adm          |    1 -
 .../closed-record-constructor_02.1.adm          |    1 -
 .../closed-record-constructor_03.1.adm          |    1 -
 .../records/expFieldName/expFieldName.1.adm     |    2 -
 .../field-access-by-index_01.1.adm              |    1 -
 .../field-access-on-open-field.1.adm            |    1 -
 .../documentation-example.1.adm                 |    1 -
 .../documentation-example.2.adm                 |    1 -
 .../documentation-example.3.adm                 |    1 -
 .../highly-nested-closed.3.adm                  |    4 -
 .../highly-nested-mixed.3.adm                   |    4 -
 .../highly-nested-open/highly-nested-open.3.adm |    4 -
 .../tiny-social-example.4.adm                   |   24 -
 .../documentation-example.1.adm                 |    1 -
 .../tiny-social-example-no-complex-types.4.adm  |    1 -
 .../tiny-social-example-no-complex-types.5.adm  |   10 -
 .../tiny-social-example-no-complex-types.6.adm  |   15 -
 .../tiny-social-example-no-complex-types.7.adm  |    4 -
 .../tiny-social-example-no-complex-types.8.adm  |   12 -
 .../tiny-social-example-no-complex-types.9.adm  |    4 -
 .../tiny-social-example-only-lists.4.adm        |    1 -
 .../tiny-social-example-only-lists.5.adm        |   10 -
 .../tiny-social-example-only-lists.6.adm        |   15 -
 .../tiny-social-example-only-lists.7.adm        |    4 -
 .../tiny-social-example-only-lists.8.adm        |   12 -
 .../tiny-social-example-only-lists.9.adm        |    5 -
 .../tiny-social-example-only-records.4.adm      |    1 -
 .../tiny-social-example-only-records.5.adm      |   10 -
 .../tiny-social-example-only-records.6.adm      |   15 -
 .../tiny-social-example-only-records.7.adm      |    4 -
 .../tiny-social-example-only-records.8.adm      |   12 -
 .../tiny-social-example-only-records.9.adm      |    5 -
 .../tiny-social-example.4.adm                   |    1 -
 .../tiny-social-example.5.adm                   |   10 -
 .../tiny-social-example.6.adm                   |   15 -
 .../tiny-social-example.7.adm                   |    4 -
 .../tiny-social-example.8.adm                   |   12 -
 .../tiny-social-example.9.adm                   |    6 -
 .../records/object_pairs-2/object_pairs-2.1.adm |    3 -
 .../records/object_pairs/object_pairs.1.adm     |    3 -
 .../open-record-constructor_01.1.adm            |    1 -
 .../open-record-constructor_02.1.adm            |    1 -
 .../documentation-example.1.adm                 |    1 -
 .../documentation-example.2.adm                 |    1 -
 .../documentation-example.3.adm                 |    1 -
 .../highly-nested-open/highly-nested-open.3.adm |    4 -
 .../tiny-social-example.4.adm                   |   10 -
 .../documentation-example.1.adm                 |    1 -
 .../documentation-example.2.adm                 |    1 -
 .../documentation-example.3.adm                 |    1 -
 .../highly-nested-open/highly-nested-open.3.adm |    4 -
 .../tiny-social-example.4.adm                   |  180 ---
 .../documentation-example.1.adm                 |    1 -
 .../documentation-example.2.adm                 |    1 -
 .../documentation-example.3.adm                 |    1 -
 .../highly-nested-open/highly-nested-open.3.adm |    4 -
 .../tiny-social-example.4.adm                   |   12 -
 .../access-nested-fields.1.ast                  |   58 +
 .../access-nested-fields.10.ast                 |   26 +
 .../access-nested-fields.11.ast                 |   23 +
 .../access-nested-fields.12.ast                 |   20 +
 .../access-nested-fields.2.ast                  |    1 +
 .../access-nested-fields.3.ast                  |   44 +
 .../access-nested-fields.4.ast                  |   44 +
 .../access-nested-fields.5.ast                  |   41 +
 .../access-nested-fields.6.ast                  |   38 +
 .../access-nested-fields.7.ast                  |   35 +
 .../access-nested-fields.8.ast                  |   32 +
 .../access-nested-fields.9.ast                  |   29 +
 ...sed-closed-fieldname-conflict_issue173.1.ast |    0
 ...sed-closed-fieldname-conflict_issue173.2.ast |    0
 ...sed-closed-fieldname-conflict_issue173.3.ast |   14 +
 .../closed-record-constructor_01.1.ast          |    0
 .../closed-record-constructor_01.2.ast          |    0
 .../closed-record-constructor_01.3.ast          |   15 +
 .../closed-record-constructor_02.1.ast          |    0
 .../closed-record-constructor_02.2.ast          |    0
 .../closed-record-constructor_02.3.ast          |   37 +
 .../closed-record-constructor_03.1.ast          |    0
 .../closed-record-constructor_03.2.ast          |    0
 .../closed-record-constructor_03.3.ast          |   59 +
 .../objects/expFieldName/expFieldName.1.ast     |    0
 .../objects/expFieldName/expFieldName.2.ast     |    0
 .../objects/expFieldName/expFieldName.3.ast     |   17 +
 .../field-access-by-index_01.1.ast              |    0
 .../field-access-by-index_01.2.ast              |    0
 .../field-access-by-index_01.3.ast              |   30 +
 .../field-access-on-open-field.1.ast            |    8 +
 .../field-access-on-open-field.2.ast            |    1 +
 .../field-access-on-open-field.3.ast            |   19 +
 .../documentation-example.1.ast                 |   41 +
 .../documentation-example.2.ast                 |   41 +
 .../documentation-example.3.ast                 |   41 +
 .../highly-nested-open.1.ast                    |   62 +
 .../highly-nested-open.2.ast                    |    1 +
 .../highly-nested-open.3.ast                    |   23 +
 .../highly-nested-mixed.1.ast                   |   58 +
 .../highly-nested-mixed.2.ast                   |    1 +
 .../highly-nested-mixed.3.ast                   |   23 +
 .../highly-nested-open/highly-nested-open.1.ast |   53 +
 .../highly-nested-open/highly-nested-open.2.ast |    1 +
 .../highly-nested-open/highly-nested-open.3.ast |   23 +
 .../tiny-social-example.1.ast                   |   50 +
 .../tiny-social-example.2.ast                   |    5 +
 .../tiny-social-example.3.ast                   |    1 +
 .../tiny-social-example.4.ast                   |   37 +
 .../documentation-example.1.ast                 |   40 +
 .../tiny-social-example-no-complex-types.1.ast  |   88 ++
 .../tiny-social-example-no-complex-types.2.ast  |    9 +
 .../tiny-social-example-no-complex-types.3.ast  |    1 +
 .../tiny-social-example-no-complex-types.4.ast  |   21 +
 .../tiny-social-example-no-complex-types.5.ast  |   19 +
 .../tiny-social-example-no-complex-types.6.ast  |   19 +
 .../tiny-social-example-no-complex-types.7.ast  |   19 +
 .../tiny-social-example-no-complex-types.8.ast  |   19 +
 .../tiny-social-example-no-complex-types.9.ast  |   71 +
 .../tiny-social-example-only-lists.1.ast        |   92 ++
 .../tiny-social-example-only-lists.2.ast        |    9 +
 .../tiny-social-example-only-lists.3.ast        |    1 +
 .../tiny-social-example-only-lists.4.ast        |   21 +
 .../tiny-social-example-only-lists.5.ast        |   19 +
 .../tiny-social-example-only-lists.6.ast        |   19 +
 .../tiny-social-example-only-lists.7.ast        |   19 +
 .../tiny-social-example-only-lists.8.ast        |   19 +
 .../tiny-social-example-only-lists.9.ast        |   71 +
 .../tiny-social-example-only-records.1.ast      |   90 ++
 .../tiny-social-example-only-records.2.ast      |    9 +
 .../tiny-social-example-only-records.3.ast      |    1 +
 .../tiny-social-example-only-records.4.ast      |   21 +
 .../tiny-social-example-only-records.5.ast      |   19 +
 .../tiny-social-example-only-records.6.ast      |   19 +
 .../tiny-social-example-only-records.7.ast      |   19 +
 .../tiny-social-example-only-records.8.ast      |   19 +
 .../tiny-social-example-only-records.9.ast      |   71 +
 ...pen-closed-fieldname-conflict_issue173.1.ast |    8 +
 ...pen-closed-fieldname-conflict_issue173.2.ast |    1 +
 ...pen-closed-fieldname-conflict_issue173.3.ast |   26 +
 .../open-record-constructor_01.1.ast            |    0
 .../open-record-constructor_01.2.ast            |    0
 .../open-record-constructor_01.3.ast            |   15 +
 .../open-record-constructor_02.1.ast            |    0
 .../open-record-constructor_02.2.ast            |    0
 .../open-record-constructor_02.3.ast            |   37 +
 .../open-open-fieldname-conflict_issue173.1.ast |    8 +
 .../open-open-fieldname-conflict_issue173.2.ast |    1 +
 .../open-open-fieldname-conflict_issue173.3.ast |   27 +
 .../access-nested-fields.1.ast                  |   58 -
 .../access-nested-fields.10.ast                 |   26 -
 .../access-nested-fields.11.ast                 |   23 -
 .../access-nested-fields.12.ast                 |   20 -
 .../access-nested-fields.2.ast                  |    1 -
 .../access-nested-fields.3.ast                  |   44 -
 .../access-nested-fields.4.ast                  |   44 -
 .../access-nested-fields.5.ast                  |   41 -
 .../access-nested-fields.6.ast                  |   38 -
 .../access-nested-fields.7.ast                  |   35 -
 .../access-nested-fields.8.ast                  |   32 -
 .../access-nested-fields.9.ast                  |   29 -
 ...sed-closed-fieldname-conflict_issue173.1.ast |    0
 ...sed-closed-fieldname-conflict_issue173.2.ast |    0
 ...sed-closed-fieldname-conflict_issue173.3.ast |   14 -
 .../closed-record-constructor_01.1.ast          |    0
 .../closed-record-constructor_01.2.ast          |    0
 .../closed-record-constructor_01.3.ast          |   15 -
 .../closed-record-constructor_02.1.ast          |    0
 .../closed-record-constructor_02.2.ast          |    0
 .../closed-record-constructor_02.3.ast          |   37 -
 .../closed-record-constructor_03.1.ast          |    0
 .../closed-record-constructor_03.2.ast          |    0
 .../closed-record-constructor_03.3.ast          |   59 -
 .../records/expFieldName/expFieldName.1.ast     |    0
 .../records/expFieldName/expFieldName.2.ast     |    0
 .../records/expFieldName/expFieldName.3.ast     |   17 -
 .../field-access-by-index_01.1.ast              |    0
 .../field-access-by-index_01.2.ast              |    0
 .../field-access-by-index_01.3.ast              |   30 -
 .../field-access-on-open-field.1.ast            |    8 -
 .../field-access-on-open-field.2.ast            |    1 -
 .../field-access-on-open-field.3.ast            |   19 -
 .../documentation-example.1.ast                 |   41 -
 .../documentation-example.2.ast                 |   41 -
 .../documentation-example.3.ast                 |   41 -
 .../highly-nested-open.1.ast                    |   62 -
 .../highly-nested-open.2.ast                    |    1 -
 .../highly-nested-open.3.ast                    |   23 -
 .../highly-nested-mixed.1.ast                   |   58 -
 .../highly-nested-mixed.2.ast                   |    1 -
 .../highly-nested-mixed.3.ast                   |   23 -
 .../highly-nested-open/highly-nested-open.1.ast |   53 -
 .../highly-nested-open/highly-nested-open.2.ast |    1 -
 .../highly-nested-open/highly-nested-open.3.ast |   23 -
 .../tiny-social-example.1.ast                   |   50 -
 .../tiny-social-example.2.ast                   |    5 -
 .../tiny-social-example.3.ast                   |    1 -
 .../tiny-social-example.4.ast                   |   37 -
 .../documentation-example.1.ast                 |   40 -
 .../tiny-social-example-no-complex-types.1.ast  |   88 --
 .../tiny-social-example-no-complex-types.2.ast  |    9 -
 .../tiny-social-example-no-complex-types.3.ast  |    1 -
 .../tiny-social-example-no-complex-types.4.ast  |   21 -
 .../tiny-social-example-no-complex-types.5.ast  |   19 -
 .../tiny-social-example-no-complex-types.6.ast  |   19 -
 .../tiny-social-example-no-complex-types.7.ast  |   19 -
 .../tiny-social-example-no-complex-types.8.ast  |   19 -
 .../tiny-social-example-no-complex-types.9.ast  |   71 -
 .../tiny-social-example-only-lists.1.ast        |   92 --
 .../tiny-social-example-only-lists.2.ast        |    9 -
 .../tiny-social-example-only-lists.3.ast        |    1 -
 .../tiny-social-example-only-lists.4.ast        |   21 -
 .../tiny-social-example-only-lists.5.ast        |   19 -
 .../tiny-social-example-only-lists.6.ast        |   19 -
 .../tiny-social-example-only-lists.7.ast        |   19 -
 .../tiny-social-example-only-lists.8.ast        |   19 -
 .../tiny-social-example-only-lists.9.ast        |   71 -
 .../tiny-social-example-only-records.1.ast      |   90 --
 .../tiny-social-example-only-records.2.ast      |    9 -
 .../tiny-social-example-only-records.3.ast      |    1 -
 .../tiny-social-example-only-records.4.ast      |   21 -
 .../tiny-social-example-only-records.5.ast      |   19 -
 .../tiny-social-example-only-records.6.ast      |   19 -
 .../tiny-social-example-only-records.7.ast      |   19 -
 .../tiny-social-example-only-records.8.ast      |   19 -
 .../tiny-social-example-only-records.9.ast      |   71 -
 ...pen-closed-fieldname-conflict_issue173.1.ast |    8 -
 ...pen-closed-fieldname-conflict_issue173.2.ast |    1 -
 ...pen-closed-fieldname-conflict_issue173.3.ast |   26 -
 .../open-open-fieldname-conflict_issue173.1.ast |    8 -
 .../open-open-fieldname-conflict_issue173.2.ast |    1 -
 .../open-open-fieldname-conflict_issue173.3.ast |   27 -
 .../open-record-constructor_01.1.ast            |    0
 .../open-record-constructor_01.2.ast            |    0
 .../open-record-constructor_01.3.ast            |   15 -
 .../open-record-constructor_02.1.ast            |    0
 .../open-record-constructor_02.2.ast            |    0
 .../open-record-constructor_02.3.ast            |   37 -
 .../src/test/resources/runtimets/testsuite.xml  |    6 +-
 .../resources/runtimets/testsuite_sqlpp.xml     |    2 +-
 .../runtimets/testsuite_sqlpp_parser.xml        |    2 +-
 .../src/main/markdown/builtins/0_toc.md         |    2 +-
 .../src/main/markdown/builtins/11_type.md       |    4 +-
 .../src/main/markdown/builtins/12_misc.md       |    2 +-
 .../src/main/markdown/builtins/8_record.md      |   80 +-
 .../src/main/markdown/sqlpp/2_expr.md           |   20 +-
 .../src/main/markdown/sqlpp/3_query.md          | 1278 +++++++++---------
 .../src/main/markdown/sqlpp/5_ddl.md            |   44 +-
 .../src/site/markdown/aql/externaldata.md       |   64 +-
 .../src/site/markdown/aql/filters.md            |    2 +-
 .../asterix-doc/src/site/markdown/aql/manual.md |   71 +-
 .../asterix-doc/src/site/markdown/aql/primer.md |   44 +-
 .../src/site/markdown/aql/similarity.md         |    4 +-
 asterixdb/asterix-doc/src/site/markdown/csv.md  |   30 +-
 .../asterix-doc/src/site/markdown/datamodel.md  |   12 +-
 .../src/site/markdown/feeds/tutorial.md         |   16 +-
 .../src/site/markdown/sqlpp/primer-sqlpp.md     |   62 +-
 asterixdb/asterix-doc/src/site/markdown/udf.md  |   12 +-
 .../lang/common/util/CommonFunctionMapUtil.java |   12 +-
 .../om/functions/AsterixBuiltinFunctions.java   |   22 +-
 813 files changed, 12918 insertions(+), 12911 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.1.ddl.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.1.ddl.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.1.ddl.aql
index 9e7e50c..8a77067 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.1.ddl.aql
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.1.ddl.aql
@@ -19,7 +19,7 @@
 /*
  * Test case Name  : opentype-insert2.aql
  * Description     : verify that the case where SetClosedRecordRule should not 
rewrite
- *                    the plan to use closed-record-descriptor
+ *                    the plan to use closed-object-descriptor
  * Expected Result : Success
  */
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.2.update.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.2.update.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.2.update.aql
index aa59e11..ba7fc30 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.2.update.aql
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.2.update.aql
@@ -19,7 +19,7 @@
 /*
  * Test case Name  : opentype-insert2.aql
  * Description     : verify that the case where SetClosedRecordRule should not 
rewrite
- *                    the plan to use closed-record-descriptor
+ *                    the plan to use closed-object-descriptor
  * Expected Result : Success
  */
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.3.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.3.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.3.query.aql
index a6e3185..e67a7f6 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.3.query.aql
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/dml/opentype-insert2/opentype-insert2.3.query.aql
@@ -19,7 +19,7 @@
 /*
  * Test case Name  : opentype-insert2.aql
  * Description     : verify that the case where SetClosedRecordRule should not 
rewrite
- *                    the plan to use closed-record-descriptor
+ *                    the plan to use closed-object-descriptor
  * Expected Result : Success
  */
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/ObjectsQueries.xml
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/ObjectsQueries.xml
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/ObjectsQueries.xml
new file mode 100644
index 0000000..d558c66
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/ObjectsQueries.xml
@@ -0,0 +1,184 @@
+<!--
+ ! Licensed to the Apache Software Foundation (ASF) under one
+ ! or more contributor license agreements.  See the NOTICE file
+ ! distributed with this work for additional information
+ ! regarding copyright ownership.  The ASF licenses this file
+ ! to you under the Apache License, Version 2.0 (the
+ ! "License"); you may not use this file except in compliance
+ ! with the License.  You may obtain a copy of the License at
+ !
+ !   http://www.apache.org/licenses/LICENSE-2.0
+ !
+ ! Unless required by applicable law or agreed to in writing,
+ ! software distributed under the License is distributed on an
+ ! "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ ! KIND, either express or implied.  See the License for the
+ ! specific language governing permissions and limitations
+ ! under the License.
+ !-->
+<test-group name="records">
+  <test-case FilePath="records">
+    <compilation-unit name="access-nested-fields">
+      <output-dir compare="Text">access-nested-fields</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="closed-object-constructor_01">
+      <output-dir compare="Text">closed-object-constructor_01</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="closed-object-constructor_02">
+      <output-dir compare="Text">closed-object-constructor_02</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="closed-object-constructor_03">
+      <output-dir compare="Text">closed-object-constructor_03</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="expFieldName">
+      <output-dir compare="Text">expFieldName</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="field-access-by-index_01">
+      <output-dir compare="Text">field-access-by-index_01</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="field-access-on-open-field">
+      <output-dir compare="Text">field-access-on-open-field</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-fields">
+    <compilation-unit name="documentation-example">
+      <output-dir compare="Text">documentation-example</output-dir>
+    </compilation-unit>
+  </test-case>
+  <!--test-case FilePath="records/get-object-fields">
+      <compilation-unit name="tiny-social-example">
+          <output-dir compare="Text">tiny-social-example</output-dir>
+      </compilation-unit>
+  </test-case!-->
+  <test-case FilePath="records/get-object-fields">
+    <compilation-unit name="tiny-social-example-no-complex-types">
+      <output-dir 
compare="Text">tiny-social-example-no-complex-types</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-fields">
+    <compilation-unit name="tiny-social-example-only-lists">
+      <output-dir compare="Text">tiny-social-example-only-lists</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-fields">
+    <compilation-unit name="tiny-social-example-only-records">
+      <output-dir compare="Text">tiny-social-example-only-records</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-field-value">
+    <compilation-unit name="documentation-example">
+      <output-dir compare="Text">documentation-example</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-field-value">
+    <compilation-unit name="highly-nested-closed">
+      <output-dir compare="Text">highly-nested-closed</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-field-value">
+    <compilation-unit name="highly-nested-mixed">
+      <output-dir compare="Text">highly-nested-mixed</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-field-value">
+    <compilation-unit name="highly-nested-open">
+      <output-dir compare="Text">highly-nested-open</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/get-object-field-value">
+    <compilation-unit name="tiny-social-example">
+      <output-dir compare="Text">tiny-social-example</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="open-object-constructor_01">
+      <output-dir compare="Text">open-object-constructor_01</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="open-object-constructor_02">
+      <output-dir compare="Text">open-object-constructor_02</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="closed-closed-fieldname-conflict_issue173">
+      <output-dir 
compare="Text">closed-closed-fieldname-conflict_issue173</output-dir>
+      <expected-error>java.lang.IllegalStateException: Closed fields 0 and 1 
have the same field name "name"</expected-error>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="open-closed-fieldname-conflict_issue173">
+      <output-dir 
compare="Text">open-closed-fieldname-conflict_issue173</output-dir>
+      <expected-error>org.apache.hyracks.api.exceptions.HyracksDataException: 
Open field "name" has the same field name as closed field at index 
0</expected-error>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="open-open-fieldname-conflict_issue173">
+      <output-dir 
compare="Text">open-open-fieldname-conflict_issue173</output-dir>
+      <expected-error>org.apache.hyracks.api.exceptions.HyracksDataException: 
Open fields 0 and 1 have the same field name "name"</expected-error>
+    </compilation-unit>
+  </test-case>
+  <!-- RECORD MANIPULATION TESTS -->
+  <test-case FilePath="records/object-merge">
+    <compilation-unit name="documentation-example">
+      <output-dir compare="Text">documentation-example</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-merge">
+    <compilation-unit name="tiny-social-example-only-records">
+      <output-dir compare="Text">tiny-social-example-only-records</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-merge">
+    <compilation-unit name="highly-nested-open">
+      <output-dir compare="Text">highly-nested-open</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-add-fields">
+    <compilation-unit name="documentation-example">
+      <output-dir compare="Text">documentation-example</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-add-fields">
+    <compilation-unit name="tiny-social-example-only-records">
+      <output-dir compare="Text">tiny-social-example-only-records</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-add-fields">
+    <compilation-unit name="highly-nested-open">
+      <output-dir compare="Text">highly-nested-open</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-remove-fields">
+    <compilation-unit name="documentation-example">
+      <output-dir compare="Text">documentation-example</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-remove-fields">
+    <compilation-unit name="tiny-social-example-only-records">
+      <output-dir compare="Text">tiny-social-example-only-records</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records/object-remove-fields">
+    <compilation-unit name="highly-nested-open">
+      <output-dir compare="Text">highly-nested-open</output-dir>
+    </compilation-unit>
+  </test-case>
+  <test-case FilePath="records">
+    <compilation-unit name="closed-nullable-fields_issue1616">
+      <output-dir compare="Text">closed-nullable-fields_issue1616</output-dir>
+    </compilation-unit>
+  </test-case>
+</test-group>

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.1.ddl.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.1.ddl.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.1.ddl.aql
new file mode 100644
index 0000000..9ecc1f4
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.1.ddl.aql
@@ -0,0 +1,78 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+drop dataverse test if exists;
+create dataverse test;
+
+use dataverse test;
+
+create type S as open{
+    id: int64
+}
+
+create type GS as closed{
+    id: int64,
+    Genus: string,
+    lower: S
+}
+
+create type FGS as open{
+    id: int64,
+    Family: string
+}
+
+create type OFGS as closed{
+    id: int64,
+    Order: string,
+    lower: FGS
+}
+
+create type COFGS as closed{
+    id: int64,
+    Class: string,
+    lower: OFGS
+}
+
+create type PCOFGS as closed{
+    id: int64,
+    Phylum: string,
+    lower: COFGS
+}
+
+create type KPCOFGS as open{
+    id: int64,
+    Kingdom: string
+}
+
+create type Classification as closed{
+    id: int64,
+    fullClassification:KPCOFGS
+}
+
+create type Animal as open{
+    id: int64
+}
+
+create dataset Animals(Animal)
+primary key id;
+

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.10.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.10.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.10.query.aql
new file mode 100644
index 0000000..5a3a064
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.10.query.aql
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test.class.fullClassification
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.11.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.11.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.11.query.aql
new file mode 100644
index 0000000..9cac28c
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.11.query.aql
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test.class
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.12.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.12.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.12.query.aql
new file mode 100644
index 0000000..969ca11
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.12.query.aql
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.2.update.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.2.update.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.2.update.aql
new file mode 100644
index 0000000..75973db
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.2.update.aql
@@ -0,0 +1,28 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+
+use dataverse test;
+
+load dataset Animals using localfs
+(("path"="asterix_nc1://data/classifications/animals.adm"),("format"="adm"));

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.3.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.3.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.3.query.aql
new file mode 100644
index 0000000..b69d5ed
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.3.query.aql
@@ -0,0 +1,30 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+
+use dataverse test;
+
+for $test in dataset Animals
+let $result := 
$test.class.fullClassification.lower.lower.lower.lower.lower.lower.Species
+order by $result
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.4.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.4.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.4.query.aql
new file mode 100644
index 0000000..07cdf87
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.4.query.aql
@@ -0,0 +1,30 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+
+use dataverse test;
+
+for $test in dataset Animals
+let $result := 
$test.class.fullClassification.lower.lower.lower.lower.lower.lower
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.5.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.5.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.5.query.aql
new file mode 100644
index 0000000..007c1ef
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.5.query.aql
@@ -0,0 +1,30 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test.class.fullClassification.lower.lower.lower.lower.lower
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.6.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.6.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.6.query.aql
new file mode 100644
index 0000000..bd48bb3
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.6.query.aql
@@ -0,0 +1,30 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test.class.fullClassification.lower.lower.lower.lower
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.7.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.7.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.7.query.aql
new file mode 100644
index 0000000..ef7324e
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.7.query.aql
@@ -0,0 +1,30 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test.class.fullClassification.lower.lower.lower
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.8.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.8.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.8.query.aql
new file mode 100644
index 0000000..b88ed8b
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.8.query.aql
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test.class.fullClassification.lower.lower
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.9.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.9.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.9.query.aql
new file mode 100644
index 0000000..7b055fe
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/access-nested-fields/access-nested-fields.9.query.aql
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Access a records nested records at each level.
+* Expected Res : Success
+* Date         : 04 Jun 2015
+*/
+use dataverse test;
+
+for $test in dataset Animals
+let $result := $test.class.fullClassification.lower
+order by $result.id
+return $result;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.1.ddl.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.1.ddl.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.1.ddl.aql
new file mode 100644
index 0000000..540d649
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.1.ddl.aql
@@ -0,0 +1,25 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+ * Description    : Tests whether a conflict between two closed field names 
are detected
+ * Expected Result: An error reporting that there is a duplicate field name 
"name"
+ * Author: zheilbron
+ */
+drop dataverse test if exists;
+create dataverse test;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.2.update.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.2.update.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.2.update.aql
new file mode 100644
index 0000000..859b0b3
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.2.update.aql
@@ -0,0 +1,25 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+ * Description    : Tests whether a conflict between two closed field names 
are detected
+ * Expected Result: An error reporting that there is a duplicate field name 
"name"
+ * Author: zheilbron
+ */
+
+// no inserts, deletes

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/10351a74/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.3.query.aql
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.3.query.aql
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.3.query.aql
new file mode 100644
index 0000000..bf5a986
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries/objects/closed-closed-fieldname-conflict_issue173/closed-closed-fieldname-conflict_issue173.3.query.aql
@@ -0,0 +1,27 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+ * Description    : Tests whether a conflict between two closed field names 
are detected
+ * Expected Result: An error reporting that there is a duplicate field name 
"name"
+ * Author: zheilbron
+ */
+use dataverse test;
+
+let $x := {"name": "john", "name": "smith"}
+return $x