N1QL watson++ branch merge to 4.6.1

This is tracking task

1. 1. 1. 1. 60ed4ed MB-22273 encoded_plan usage causes incorrect evaluation of cover filter
         2. 30f3d45 MB-22936 accept and ignore result fields in test
         3. 60857d5 MB-22872. Fix covering of META for index JOINs.
         4. bd4623f MB-22936 ignore certain result fields
         5. 9c3236a MB-22936 - add an ignore field to filestore and multistore
         6. 86d131f MB-22858. Corruption in memory allocation leads to panics.
         7. 2e44b83 MB-22884. PAIRS(SELF) returns all pairs.
         8. 280c745 MB-22858. Nil derefence panic in DNF.
         9. bce903a MB-22808. Normalize NOT unknowns for dynamic indexing.
         10. 02f735d MB-22536 Fix DATE_RANGE_STR and DATE_RANGE_MILLIS to give correct results for larger dates
         11. c685148 MB-22817. META is only covered by META.
         12. d2d911e MB-22831 Fix number representation when performing insert/update/upsert
         13. 3618e80 MB-22808. Dynamic indexing for NOT.
         14. 6364e5f MB-22760 Add bucketType parameter to bucket_create script.
         15. 881922c MB-22757. Handle mix of covering and non-covering child scans.
         16. b3108c4 MB-22750. Add CONTAINS_TOKEN_LIKE() and CONTAINS_TOKEN_REGEXP().
         17. 4bedb38 MB-22740 Subquery FROM term must have an alias
         18. 534708e MB-22735. Update diagrams with subquery / expression FROM terms.
         19. 2b68699 MB-22651. Use dynamic index for implicit truth predicates.
         20. bb6c9ca MB-22646. Arbitrary variable names in array index selection.
         21. 2e4cc41 MB-22645. Handle simple syntax for array indexing.
         22. b200a54 MB-22644. Make CONTAINS() use SUFFIXES() index.
         23. 92467b1 MB-22606. Allow differing formats in DATE_RANGE_STR().
         24. 6f08de7 MB-22417. Add WEEKDAY functions. Update docs.
         25. b41c297 MB-22629 Make CONTAINS_TOKEN() faster. Push down to Value.
         26. 1cbf8e1 MB-22577. Restore ability to produce array by ranging over objects. Add test case for same.
         27. d675a10 MB-22570. Report errors in date functions. Fix negative diff.
         28. b0961d5 MB-22578. UNNEST index selection considers WHEN clause.
         29. 2356214 MB-22530. Make range / capacity bound a defined constant.
         30. 4546f37 MB-22550. Add OBJECT_RENAME and OBJECT_REPLACE functions.
         31. abf8912 MB-22530. Enforce range / capacity bounds.
         32. 44c8cbc MB-22520. Selective fields / expressions for dynamic index.
         33. 8c57077 MB-22470. Alias HAS_TOKEN() to CONTAINS_TOKEN().
         34. d75566a MB-22430. Fold single term.
         35. 824fab4 MB-22430. Fold redundant AND and OR terms for dynamic index.
         36. 08bf7bd MB-22429 IntersectScan handle the no child terminated case
         37. b53de9c MB-22412. Do not skip aggregate keys in ORDER BY.
         38. afd3cfb MB-22412. Skip fixed order terms.
         39. 411b6b3 MB-22419. Correctly handle LIMIT pushdown. Fix method naming.
         40. a046add MB-22398. Count all fullBits.
         41. 951f860 MB-22414. Push down LIMIT for dynamic and array indexes.
         42. cd52a26 MB-22362. LET can set to MISSING.
         43. dbd6ce3 MB-22398 Performance improvment with Ordered Intersect Scan + limit
         44. f291dc1 MB-22398. Relax pushdown of limit.
         45. a228aa5 MB-22398. Fix early termination issues.
         46. 3d71811 MB-22398. Fix line placement.
         47. 3d4cce5 MB-22398. Performance and correctness of ordered and intersect scans.
         48. 10bbed3 MB-22321. Flatten children of Ordered and Intersect scans.
         49. b936995 MB-22321. Terminate Ordered and Intersect scans when first child scan terminates. Honor LIMIT.
         50. 838c53a MB-22321. Terminate Ordered and Intersect scans when first child scan terminates.
         51. 2c1e881 MB-22332. Skip LIMIT operator when pushing down MIN().
         52. 540df94 MB-22332. Push down ORDER, COUNT(), and MIN() to covering UNNEST index.
         53. 310e713 MB-22332. Push down ORDER, COUNT(), and MIN() to covering UNNEST index.
         54. a1a9419 MB-22321. Add OrderedIntersectScan for pagination.
         55. fe05f9f MB-22315. Push down LIMIT to IntersectScan and UnionScan.
         56. 24d11e0 MB-22309. Push down LIMIT to DistinctScan.
         57. 0f96d15 MB-22313. Panic on IN [ NULL ].
         58. cef9c39 MB-22285. Infer IS NOT MISSING predicates for INNER UNNESTs.
         59. 14652e7 MB-22285. Infer IS NOT MISSING predicates for INNER UNNESTs.
         60. 2c77b14 MB-22223, MB-22195, MB-22107. Planner reorg to support combinations of intersection and union scans.
         61. 53e9876 MB-22223. First capture variable sarg lengths.
         62. 8fc6119 MB-22107. Fix infinite recursion in dynamic index.
         63. 776118b MB-22107. Dynamic indexing for data platforms.
         64. 6212b73 MB-22190. IntersectScan only forwards satisfying items. Store only counts, not values.
         65. 111f1ed MB-22190. IntersectScan only forwards satisfying items.
         66. 34e12b6 MB-22190. IntersectScan only forwards satisfying items.
         67. 3997351 MB-22195. Intersect AND terms for dynamic index.
         68. 7e8854f MB-22195. Intersect AND terms for dynamic index.
         69. ffeec74 MB-22190. Undo this change. Logic error. The indexes return items in different order, so all items must be forwarded.
         70. 2b919e6 MB-22190. IntersectScan only forwards satisfying items.
         71. c09b3ad MB-22143, MB-22148. Fix another bug in query planning for OR predicates with aggregates.
         72. ba8ff7f MB-22143, MB-22148. Fix query planning for OR predicates with aggregate pushdowns.
         73. 1c41ecc MB-19215, MB-20626. Avoid full index scan with IN predicates.
         74. 44907ea MB-22148. Variable-length sarging for OR predicates.
         75. 660d4c1 MB-20677 regexp_like accepts invalid patterns
         76. f424895 MB-22143, MB-22146. Index scans for OR predicates on disjoint terms. Fix test cases for new year 2017.
         77. a73eb90 MB-22142. Optimize sequencing of LET and predicate.
         78. ed59a36 MB-22141. Improve memory mgmt. Use stack instead of heap when possible. Reduce allocations.
         79. 5244707 MB-22129. Streamline LET/LETTING covering indexing, handled implicitly because LET variables do not depend on first FROM term. Add UNNEST aliases to predicate. Improve memory allocation.
         80. abc99ef MB-22129. LET and LETTING do not affect index selection.
         81. 8c660bf MB-22124. NOT IN and NOT WITHIN queries should use secondary indexes.
         82. 3864b9a MB-22119. Rare panic when allocating slice.
         83. cb09320 MB-22111. Do not use DistinctScan for covering UNNEST scan.
         84. 4b679d6 MB-22107. PAIRS() function for dynamic indexing.
         85. 15619cd MB-22087. Fix regression in intersect scan.
         86. 8da8bfc MB-22047. Simplify planner visitors. Sarg visitors.
         87. 72e90ae MB-22060 subquery expression returns error it panics
         88. 8b051c0 MB-22047. Simplify planner visitors. Sargable visitors.
         89. 60a10af MB-22047. Simplify planner visitors. Start with subset.
         90. 24c4862 MB-21770, MB-21619. Array index covers UNNEST. Use only first index key.
         91. a40e731 MB-21770, MB-21619. Array index covers UNNEST without including the whole array as index key.
         92. 4a903dc MB-21998. For now, retain array index index key in covers.
         93. b55b6c0 MB-21988 JOIN with expression in from clause panics
         94. 697d8d0 MB-21770. Covering array index for ANY predicate. Not yet done for UNNEST.
         95. 3515899 MB-21969. Improve efficient of intersect scan.
         96. b624e6e MB-15495 Do not include Go-specific error in user error message.
         97. 34668be MB-19078 : Fix batch mode in \SET.
         98. fb5c56d MB-19078, MB-21215 : Allow -q to disable echoing queries in the source file. Also add a quiet predefined parameter to be able to set quiet flag during a shell session.
         99. a83a001 MB-21191. Subquery expression is Identifier and not an alias in parent treat as keyspace
         100. 95a2ac1 MB-21284. Improve parser error message.
         101. 2ad1e29 MB-19916 SUBQ on nested collections