load("jstests/aggregation/extras/utils.js");        // For assertErrorCode and assertErrMsgContains.
load("jstests/libs/sbe_assert_error_override.js");  // Override error-code-checking APIs.

(function() {
"use strict";

const coll = db.date_from_string;

/* --------------------------------------------------------------------------------------- */
/* Normal format tests. */

coll.drop();
assert.commandWorked(coll.insert({_id: 0}));

let testCases = [
    {
        expect: "2017-07-04T11:56:02Z",
        inputString: "2017-07-04T11:56:02Z",
        format: "%Y-%m-%dT%H:%M:%SZ"
    },
    {
        expect: "2017-07-04T11:56:02.813Z",
        inputString: "2017-07-04T11:56:02.813Z",
        format: "%Y-%m-%dT%H:%M:%S.%LZ"
    },
    {
        expect: "2017-07-04T11:56:02.810Z",
        inputString: "2017-07-04T11:56:02.81Z",
        format: "%Y-%m-%dT%H:%M:%S.%LZ"
    },
    {
        expect: "2017-07-04T11:56:02.800Z",
        inputString: "2017-07-04T11:56:02.8Z",
        format: "%Y-%m-%dT%H:%M:%S.%LZ"
    },
    {
        expect: "2017-07-04T11:56:02Z",
        inputString: "2017-07-04T11:56.02",
        format: "%Y-%m-%dT%H:%M.%S"
    },
    {
        expect: "2017-07-04T11:56:02.813Z",
        inputString: "2017-07-04T11:56.02.813",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
    {
        expect: "2017-07-04T11:56:02.810Z",
        inputString: "2017-07-04T11:56.02.81",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
    {
        expect: "2017-07-04T11:56:02.800Z",
        inputString: "2017-07-04T11:56.02.8",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
];
testCases.forEach(function(testCase) {
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({$project: {date: {$dateFromString: {dateString: testCase.inputString}}}})
            .toArray(),
        tojson(testCase));
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({
                $project: {
                    date: {
                        $dateFromString: {dateString: testCase.inputString, format: testCase.format}
                    }
                }
            })
            .toArray(),
        tojson(testCase));
});

/* --------------------------------------------------------------------------------------- */
/* Normal format tests with timezone. */

coll.drop();
assert.commandWorked(coll.insert({_id: 0}));

testCases = [
    {
        expect: "2017-07-04T10:56:02Z",
        inputString: "2017-07-04T11:56.02",
        format: "%Y-%m-%dT%H:%M.%S"
    },
    {
        expect: "2017-07-04T10:56:02.813Z",
        inputString: "2017-07-04T11:56.02.813",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
    {
        expect: "2017-07-04T10:56:02.810Z",
        inputString: "2017-07-04T11:56.02.81",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
    {
        expect: "2017-07-04T10:56:02.800Z",
        inputString: "2017-07-04T11:56.02.8",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
];
testCases.forEach(function(testCase) {
    assert.eq([{_id: 0, date: ISODate(testCase.expect)}],
              coll.aggregate({
                      $project: {
                          date: {
                              $dateFromString:
                                  {dateString: testCase.inputString, timezone: "Europe/London"}
                          }
                      }
                  })
                  .toArray(),
              tojson(testCase));
    assert.eq([{_id: 0, date: ISODate(testCase.expect)}],
              coll.aggregate({
                      $project: {
                          date: {
                              $dateFromString: {
                                  dateString: testCase.inputString,
                                  timezone: "Europe/London",
                                  format: testCase.format
                              }
                          }
                      }
                  })
                  .toArray(),
              tojson(testCase));
});

/* --------------------------------------------------------------------------------------- */
/* Normal format tests with UTC offset. */

coll.drop();
assert.commandWorked(coll.insert({_id: 0}));

testCases = [
    {
        expect: "2017-07-04T10:56:02Z",
        inputString: "2017-07-04T11:56.02",
        format: "%Y-%m-%dT%H:%M.%S"
    },
    {
        expect: "2017-07-04T10:56:02.813Z",
        inputString: "2017-07-04T11:56.02.813",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
    {
        expect: "2017-07-04T10:56:02.810Z",
        inputString: "2017-07-04T11:56.02.81",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
    {
        expect: "2017-07-04T10:56:02.800Z",
        inputString: "2017-07-04T11:56.02.8",
        format: "%Y-%m-%dT%H:%M.%S.%L"
    },
];
testCases.forEach(function(testCase) {
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({
                $project: {
                    date: {$dateFromString: {dateString: testCase.inputString, timezone: "+01:00"}}
                }
            })
            .toArray(),
        tojson(testCase));
    assert.eq([{_id: 0, date: ISODate(testCase.expect)}],
              coll.aggregate({
                      $project: {
                          date: {
                              $dateFromString: {
                                  dateString: testCase.inputString,
                                  timezone: "+01:00",
                                  format: testCase.format
                              }
                          }
                      }
                  })
                  .toArray(),
              tojson(testCase));
});

/* --------------------------------------------------------------------------------------- */
/* Normal format tests from data. */

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0, dateString: "2017-07-06T12:35:37Z", format: "%Y-%m-%dT%H:%M:%SZ"},
    {_id: 1, dateString: "2017-07-06T12:35:37.513Z", format: "%Y-%m-%dT%H:%M:%S.%LZ"},
    {_id: 2, dateString: "2017-07-06T12:35:37", format: "%Y-%m-%dT%H:%M:%S"},
    {_id: 3, dateString: "2017-07-06T12:35:37.513", format: "%Y-%m-%dT%H:%M:%S.%L"},
    {_id: 4, dateString: "1960-07-10T12:10:37.448", format: "%Y-%m-%dT%H:%M:%S.%L"},
]));

let expectedResults = [
    {"_id": 0, "date": ISODate("2017-07-06T12:35:37Z")},
    {"_id": 1, "date": ISODate("2017-07-06T12:35:37.513Z")},
    {"_id": 2, "date": ISODate("2017-07-06T12:35:37Z")},
    {"_id": 3, "date": ISODate("2017-07-06T12:35:37.513Z")},
    {"_id": 4, "date": ISODate("1960-07-10T12:10:37.448Z")},
];
assert.eq(expectedResults,
          coll.aggregate([
                  {
                      $project: {date: {$dateFromString: {dateString: "$dateString"}}},
                  },
                  {$sort: {_id: 1}}
              ])
              .toArray());

// Repeat the test with an explicit format specifier string.
assert.eq(
    expectedResults,
    coll.aggregate([
            {
                $project: {date: {$dateFromString: {dateString: "$dateString", format: "$format"}}},
            },
            {$sort: {_id: 1}}
        ])
        .toArray());

expectedResults = [
    {"_id": 0, "date": new Date(1499344537000)},
    {"_id": 1, "date": new Date(1499344537513)},
    {"_id": 2, "date": new Date(1499344537000)},
    {"_id": 3, "date": new Date(1499344537513)},
    {"_id": 4, "date": new Date(-299072962552)},
];
assert.eq(expectedResults,
          coll.aggregate([
                  {
                      $project: {date: {$dateFromString: {dateString: "$dateString"}}},
                  },
                  {$sort: {_id: 1}}
              ])
              .toArray());

// Repeat the test with an explicit format specifier string.
assert.eq(
    expectedResults,
    coll.aggregate([
            {
                $project: {date: {$dateFromString: {dateString: "$dateString", format: "$format"}}},
            },
            {$sort: {_id: 1}}
        ])
        .toArray());

/* --------------------------------------------------------------------------------------- */
/* Normal format tests from data, with time zone. */

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0, dateString: "2017-07-06T12:35:37.513", timezone: "GMT"},
    {_id: 1, dateString: "2017-07-06T12:35:37.513", timezone: "UTC"},
    {_id: 2, dateString: "1960-07-10T12:35:37.513", timezone: "America/New_York"},
    {_id: 3, dateString: "1960-07-10T12:35:37.513", timezone: "Europe/London"},
    {_id: 4, dateString: "2017-07-06T12:35:37.513", timezone: "America/Los_Angeles"},
    {_id: 5, dateString: "2017-07-06T12:35:37.513", timezone: "Europe/Paris"},
    {_id: 6, dateString: "2017-07-06T12:35:37.513", timezone: "+04:00"},
]));

expectedResults = [
    {"_id": 0, "date": ISODate("2017-07-06T12:35:37.513Z")},
    {"_id": 1, "date": ISODate("2017-07-06T12:35:37.513Z")},
    {"_id": 2, "date": ISODate("1960-07-10T16:35:37.513Z")},
    {"_id": 3, "date": ISODate("1960-07-10T11:35:37.513Z")},
    {"_id": 4, "date": ISODate("2017-07-06T19:35:37.513Z")},
    {"_id": 5, "date": ISODate("2017-07-06T10:35:37.513Z")},
    {"_id": 6, "date": ISODate("2017-07-06T08:35:37.513Z")},
];

assert.eq(
    expectedResults,
    coll.aggregate([
            {
                $project:
                    {date: {$dateFromString: {dateString: "$dateString", timezone: "$timezone"}}},
            },
            {$sort: {_id: 1}}
        ])
        .toArray());

// Repeat the test with an explicit format specifier string.
assert.eq(expectedResults,
          coll.aggregate([
                  {
                      $project: {
                          date: {
                              $dateFromString: {
                                  dateString: "$dateString",
                                  timezone: "$timezone",
                                  format: "%Y-%m-%dT%H:%M:%S.%L"
                              }
                          }
                      },
                  },
                  {$sort: {_id: 1}}
              ])
              .toArray());

/* --------------------------------------------------------------------------------------- */
/* dateString from data with timezone as constant */

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0, dateString: "2017-07-06T12:35:37"},
]));

assert.eq(
    [
        {"_id": 0, "date": ISODate("2017-07-06T03:35:37Z")},
    ],
    coll.aggregate([
            {
                $project:
                    {date: {$dateFromString: {dateString: "$dateString", timezone: "Asia/Tokyo"}}},
            },
            {$sort: {_id: 1}}
        ])
        .toArray());

/* --------------------------------------------------------------------------------------- */
/* dateString from constant with timezone from data */

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0, timezone: "Europe/London"},
    {_id: 1, timezone: "America/New_York"},
    {_id: 2, timezone: "-05:00"},
]));

assert.eq(
    [
        {"_id": 0, "date": ISODate("2017-07-19T17:52:35.199Z")},
        {"_id": 1, "date": ISODate("2017-07-19T22:52:35.199Z")},
        {"_id": 2, "date": ISODate("2017-07-19T23:52:35.199Z")},
    ],
    coll.aggregate([
            {
                $project: {
                    date: {
                        $dateFromString:
                            {dateString: "2017-07-19T18:52:35.199", timezone: "$timezone"}
                    }
                },
            },
            {$sort: {_id: 1}}
        ])
        .toArray());

/* --------------------------------------------------------------------------------------- */
/* BI format tests. */

coll.drop();
assert.commandWorked(coll.insert({_id: 0}));

let pipelines = [
    {
        expect: "2017-01-01T00:00:00Z",
        pipeline: {$project: {date: {$dateFromString: {dateString: "2017-01-01 00:00:00"}}}}
    },
    {
        expect: "2017-07-01T00:00:00Z",
        pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-01 00:00:00"}}}}
    },
    {
        expect: "2017-07-06T00:00:00Z",
        pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06"}}}}
    },
    {
        expect: "2017-07-06T00:00:00Z",
        pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 00:00:00"}}}}
    },
    {
        expect: "2017-07-06T11:00:00Z",
        pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:00:00"}}}}
    },
    {
        expect: "2017-07-06T11:36:00Z",
        pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:36:00"}}}}
    },
    {
        expect: "2017-07-06T11:36:54Z",
        pipeline: {$project: {date: {$dateFromString: {dateString: "2017-07-06 11:36:54"}}}}
    },
];
pipelines.forEach(function(pipeline) {
    assert.eq([{_id: 0, date: ISODate(pipeline.expect)}],
              coll.aggregate(pipeline.pipeline).toArray(),
              tojson(pipeline));
});

/* --------------------------------------------------------------------------------------- */
/* Tests with additional timezone information . */

coll.drop();
assert.commandWorked(coll.insert({_id: 0}));

testCases = [
    // GMT based variants
    {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT"},
    {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+00"},
    {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+00:00"},
    {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+02"},
    {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 GMT+02:00"},
    {expect: "2017-07-14T09:02:44.771Z", inputString: "2017-07-14T12:02:44.771+03"},
    {expect: "2017-07-14T08:32:44.771Z", inputString: "2017-07-14T12:02:44.771+0330"},
    {expect: "2017-07-14T08:32:44.771Z", inputString: "2017-07-14T12:02:44.771+03:30"},
    // With timezone abbreviations
    {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 UTC"},
    {expect: "2017-07-14T10:02:44.771Z", inputString: "2017-07-14T12:02:44.771 CEST"},
    {expect: "2017-07-14T17:02:44.771Z", inputString: "2017-07-14T12:02:44.771 EST"},
    {expect: "2017-07-14T19:02:44.771Z", inputString: "2017-07-14T12:02:44.771 PDT"},
    // A-I,K-Z are military time zones:
    // https://en.wikipedia.org/wiki/List_of_military_time_zones
    {expect: "2017-07-14T11:02:44.771Z", inputString: "2017-07-14T12:02:44.771 A"},
    {expect: "2017-07-14T01:02:44.771Z", inputString: "2017-07-14T12:02:44.771 L"},
    {expect: "2017-07-14T15:02:44.771Z", inputString: "2017-07-14T12:02:44.771 P"},
    {expect: "2017-07-14T12:02:44.771Z", inputString: "2017-07-14T12:02:44.771 Z"},
];
testCases.forEach(function(testCase) {
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({$project: {date: {$dateFromString: {dateString: testCase.inputString}}}})
            .toArray(),
        tojson(testCase));
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({
                $project: {
                    date: {
                        $dateFromString:
                            {dateString: testCase.inputString, format: "%Y-%m-%dT%H:%M:%S.%L%z"}
                    }
                }
            })
            .toArray(),
        tojson(testCase));
});

/* --------------------------------------------------------------------------------------- */
/* BI format tests from data. */

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0, dateString: "2017-01-01 00:00:00"},
    {_id: 1, dateString: "2017-07-01 00:00:00"},
    {_id: 2, dateString: "2017-07-06"},
    {_id: 3, dateString: "2017-07-06 00:00:00"},
    {_id: 4, dateString: "2017-07-06 11:00:00"},
    {_id: 5, dateString: "2017-07-06 11:36:00"},
    {_id: 6, dateString: "2017-07-06 11:36:54"},
]));

assert.eq(
    [
        {"_id": 0, "date": ISODate("2017-01-01T00:00:00Z")},
        {"_id": 1, "date": ISODate("2017-07-01T00:00:00Z")},
        {"_id": 2, "date": ISODate("2017-07-06T00:00:00Z")},
        {"_id": 3, "date": ISODate("2017-07-06T00:00:00Z")},
        {"_id": 4, "date": ISODate("2017-07-06T11:00:00Z")},
        {"_id": 5, "date": ISODate("2017-07-06T11:36:00Z")},
        {"_id": 6, "date": ISODate("2017-07-06T11:36:54Z")}
    ],
    coll.aggregate([
            {
                $project: {date: {$dateFromString: {dateString: "$dateString"}}},
            },
            {$sort: {_id: 1}}
        ])
        .toArray());

/* --------------------------------------------------------------------------------------- */
/* Wacky format tests from data. */

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0, dateString: "July 4th, 2017"},
    {_id: 1, dateString: "July 4th, 2017 12:39:30 BST"},
    {_id: 2, dateString: "July 4th, 2017 11am"},
    {_id: 3, dateString: "July 4th, 2017 12pm"},
    {_id: 4, dateString: "7/4/17"},
    {_id: 5, dateString: "04-07-2017"},
    {_id: 6, dateString: "2017-Jul-04 noon"},
    {_id: 7, dateString: "2017-07-04 12:48:07 GMT+0545"},
    {_id: 8, dateString: "2017-07-04 12:48:07 GMT-0200"},
]));

assert.eq(
    [
        {"_id": 0, "date": ISODate("2017-07-04T00:00:00Z")},
        {"_id": 1, "date": ISODate("2017-07-04T11:39:30Z")},
        {"_id": 2, "date": ISODate("2017-07-04T11:00:00Z")},
        {"_id": 3, "date": ISODate("2017-07-04T12:00:00Z")},
        {"_id": 4, "date": ISODate("2017-07-04T00:00:00Z")},
        {"_id": 5, "date": ISODate("2017-07-04T00:00:00Z")},
        {"_id": 6, "date": ISODate("2017-07-04T12:00:00Z")},
        {"_id": 7, "date": ISODate("2017-07-04T07:03:07Z")},
        {"_id": 8, "date": ISODate("2017-07-04T14:48:07Z")},
    ],
    coll.aggregate([
            {
                $project: {date: {$dateFromString: {dateString: "$dateString"}}},
            },
            {$sort: {_id: 1}}
        ])
        .toArray());

/* --------------------------------------------------------------------------------------- */
/* Tests formats that aren't supported with the normal $dateFromString parser. */

coll.drop();
assert.commandWorked(coll.insert({_id: 0}));

testCases = [
    {inputString: "05 12 1988", format: "%d %m %Y", expect: "1988-12-05T00:00:00Z"},
    {inputString: "1992 04 26", format: "%Y %m %d", expect: "1992-04-26T00:00:00Z"},
    {inputString: "05*12*1988", format: "%d*%m*%Y", expect: "1988-12-05T00:00:00Z"},
    {inputString: "1992/04/26", format: "%Y/%m/%d", expect: "1992-04-26T00:00:00Z"},
    {inputString: "1992 % 04 % 26", format: "%Y %% %m %% %d", expect: "1992-04-26T00:00:00Z"},
    {
        inputString: "Day: 05 Month: 12 Year: 1988",
        format: "Day: %d Month: %m Year: %Y",
        expect: "1988-12-05T00:00:00Z"
    },
    {inputString: "Date: 1992/04/26", format: "Date: %Y/%m/%d", expect: "1992-04-26T00:00:00Z"},
    {inputString: "4/26/1992:+0445", format: "%m/%d/%Y:%z", expect: "1992-04-25T19:15:00Z"},
    {inputString: "4/26/1992:+285", format: "%m/%d/%Y:%Z", expect: "1992-04-25T19:15:00Z"},
];
testCases.forEach(function(testCase) {
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({
                $project: {
                    date: {
                        $dateFromString: {dateString: testCase.inputString, format: testCase.format}
                    }
                }
            })
            .toArray(),
        tojson(testCase));
});

/* --------------------------------------------------------------------------------------- */
/* Tests for ISO year, week of year, and day of the week. */

testCases = [
    {inputString: "2017", format: "%G", expect: "2017-01-02T00:00:00Z"},
    {inputString: "2017, Week 53", format: "%G, Week %V", expect: "2018-01-01T00:00:00Z"},
    {inputString: "2017, Day 5", format: "%G, Day %u", expect: "2017-01-06T00:00:00Z"},
    {inputString: "53.7.2017", format: "%V.%u.%G", expect: "2018-01-07T00:00:00Z"},
    {inputString: "1.1.1", format: "%V.%u.%G", expect: "0001-01-01T00:00:00Z"},
    {inputString: "2017, Day 5", format: "%Y, Day %j", expect: "2017-01-06T00:00:00Z"},
];
testCases.forEach(function(testCase) {
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({
                $project: {
                    date: {
                        $dateFromString: {dateString: testCase.inputString, format: testCase.format}
                    }
                }
            })
            .toArray(),
        tojson(testCase));
});

/* --------------------------------------------------------------------------------------- */
/* Tests for textual month. */

testCases = [
    {inputString: "2017, July 4", format: "%Y, %B %d", expect: "2017-07-04T00:00:00Z"},
    {inputString: "oct 20 2020", format: "%b %d %Y", expect: "2020-10-20T00:00:00Z"},
];
testCases.forEach(function(testCase) {
    assert.eq(
        [{_id: 0, date: ISODate(testCase.expect)}],
        coll.aggregate({
                $project: {
                    date: {
                        $dateFromString: {dateString: testCase.inputString, format: testCase.format}
                    }
                }
            })
            .toArray(),
        tojson(testCase));
});

/* --------------------------------------------------------------------------------------- */
/* Testing whether it throws the right assert for missing elements of a date/time string. */

coll.drop();

assert.commandWorked(coll.insert([
    {_id: 0},
]));

pipelines = [
    [{'$project': {date: {$dateFromString: {dateString: "July 4th"}}}}],
    [{'$project': {date: {$dateFromString: {dateString: "12:50:53"}}}}],
];

pipelines.forEach(function(pipeline) {
    assertErrCodeAndErrMsgContains(coll,
                                   pipeline,
                                   ErrorCodes.ConversionFailure,
                                   "an incomplete date/time string has been found");
});

/* --------------------------------------------------------------------------------------- */
/* Testing whether it throws the right assert for broken date/time strings. */

coll.drop();

assert.commandWorked(coll.insert([
    {_id: 0},
]));

pipelines = [
    [{'$project': {date: {$dateFromString: {dateString: "2017, 12:50:53"}}}}],
    [{'$project': {date: {$dateFromString: {dateString: "60.Monday1770/06:59"}}}}],
];

pipelines.forEach(function(pipeline) {
    assertErrCodeAndErrMsgContains(
        coll, pipeline, ErrorCodes.ConversionFailure, "Error parsing date string");
});

/* --------------------------------------------------------------------------------------- */
/* NULL returns. */

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0, date: new ISODate("2017-06-19T15:13:25.713Z")},
    {_id: 1, date: new ISODate("2017-06-19T15:13:25.713Z"), tz: null},
    {_id: 2, date: new ISODate("2017-06-19T15:13:25.713Z"), tz: undefined},
]));

pipelines = [
    [{$project: {date: {$dateFromString: {dateString: "$tz"}}}}, {$sort: {_id: 1}}],
    [
        {
            $project:
                {date: {$dateFromString: {dateString: "2017-07-11T17:05:19Z", timezone: "$tz"}}}
        },
        {$sort: {_id: 1}}
    ],
];
pipelines.forEach(function(pipeline) {
    assert.eq([{_id: 0, date: null}, {_id: 1, date: null}, {_id: 2, date: null}],
              coll.aggregate(pipeline).toArray(),
              tojson(pipeline));
});

coll.drop();
assert.commandWorked(coll.insert([
    {_id: 0},
    {_id: 1, format: null},
    {_id: 2, format: undefined},
]));

assert(anyEq(
    [{_id: 0, date: null}, {_id: 1, date: null}, {_id: 2, date: null}],
    coll.aggregate({
            $project:
                {date: {$dateFromString: {dateString: "2017-07-11T17:05:19Z", format: "$format"}}}
        })
        .toArray()));

/* --------------------------------------------------------------------------------------- */
/* Parse errors. */

let pipeline = [{$project: {date: {$dateFromString: "no-object"}}}];
assertErrCodeAndErrMsgContains(
    coll, pipeline, 40540, "$dateFromString only supports an object as an argument");

pipeline = [{$project: {date: {$dateFromString: {"unknown": "$tz"}}}}];
assertErrCodeAndErrMsgContains(coll, pipeline, 40541, "Unrecognized argument");

pipeline = [{$project: {date: {$dateFromString: {dateString: 5}}}}];
assertErrCodeAndErrMsgContains(coll,
                               pipeline,
                               ErrorCodes.ConversionFailure,
                               "$dateFromString requires that 'dateString' be a string");

/* --------------------------------------------------------------------------------------- */
/* Passing in time zone with date/time string. */

pipeline = {
    $project: {
        date: {
            $dateFromString:
                {dateString: "2017-07-12T22:23:55 GMT+02:00", timezone: "Europe/Amsterdam"}
        }
    }
};
assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure);

pipeline = {
    $project: {
        date: {$dateFromString: {dateString: "2017-07-12T22:23:55Z", timezone: "Europe/Amsterdam"}}
    }
};
assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure);

pipeline = {
    $project: {
        date: {
            $dateFromString:
                {dateString: "2017-07-12T22:23:55 America/New_York", timezone: "Europe/Amsterdam"}
        }
    }
};
assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure);

pipeline = {
    $project: {date: {$dateFromString: {dateString: "2017-07-12T22:23:55 Europe/Amsterdam"}}}
};
assertErrorCode(coll, pipeline, ErrorCodes.ConversionFailure);

/* --------------------------------------------------------------------------------------- */
/* Error cases for $dateFromString with format specifier string. */

// Test umatched format specifier string.
pipeline = [{$project: {date: {$dateFromString: {dateString: "2018-01", format: "%Y-%m-%d"}}}}];
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Not enough data");

pipeline = [{$project: {date: {$dateFromString: {dateString: "2018-01", format: "%Y"}}}}];
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Trailing data");

// Test missing specifier prefix '%'.
pipeline = [{$project: {date: {$dateFromString: {dateString: "1992-26-04", format: "Y-d-m"}}}}];
assertErrCodeAndErrMsgContains(
    coll, pipeline, ErrorCodes.ConversionFailure, "Format literal not found");

pipeline = [{$project: {date: {$dateFromString: {dateString: "1992", format: "%n"}}}}];
assertErrCodeAndErrMsgContains(coll, pipeline, 18536, "Invalid format character");

pipeline = [{
    $project: {
        date: {
            $dateFromString:
                {dateString: "4/26/1992:+0445", format: "%m/%d/%Y:%z", timezone: "+0500"}
        }
    }
}];
assertErrCodeAndErrMsgContains(
    coll,
    pipeline,
    ErrorCodes.ConversionFailure,
    "you cannot pass in a date/time string with GMT offset together with a timezone argument");

pipeline = [{$project: {date: {$dateFromString: {dateString: "4/26/1992", format: 5}}}}];
assertErrCodeAndErrMsgContains(
    coll, pipeline, 40684, "$dateFromString requires that 'format' be a string");

pipeline = [{$project: {date: {$dateFromString: {dateString: "4/26/1992", format: {}}}}}];
assertErrCodeAndErrMsgContains(
    coll, pipeline, 40684, "$dateFromString requires that 'format' be a string");

pipeline = [{$project: {date: {$dateFromString: {dateString: "ISO Day 6", format: "ISO Day %u"}}}}];
assertErrCodeAndErrMsgContains(
    coll, pipeline, ErrorCodes.ConversionFailure, "The parsed date was invalid");

pipeline =
    [{$project: {date: {$dateFromString: {dateString: "ISO Week 52", format: "ISO Week %V"}}}}];
assertErrCodeAndErrMsgContains(
    coll, pipeline, ErrorCodes.ConversionFailure, "The parsed date was invalid");

pipeline = [{
    $project: {date: {$dateFromString: {dateString: "ISO Week 1, 2018", format: "ISO Week %V, %Y"}}}
}];
assertErrCodeAndErrMsgContains(coll,
                               pipeline,
                               ErrorCodes.ConversionFailure,
                               "Mixing of ISO dates with natural dates is not allowed");

pipeline = [{$project: {date: {$dateFromString: {dateString: "12/31/2018", format: "%m/%d/%G"}}}}];
assertErrCodeAndErrMsgContains(coll,
                               pipeline,
                               ErrorCodes.ConversionFailure,
                               "Mixing of ISO dates with natural dates is not allowed");

pipeline =
    [{$project: {date: {$dateFromString: {dateString: "Dece 31 2018", format: "%b %d %Y"}}}}];
assertErrCodeAndErrMsgContains(
    coll, pipeline, ErrorCodes.ConversionFailure, "Error parsing date string");

// Test embedded null bytes in the 'dateString' and 'format' fields.
pipeline =
    [{$project: {date: {$dateFromString: {dateString: "12/31\0/2018", format: "%m/%d/%Y"}}}}];
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Not enough data");

pipeline =
    [{$project: {date: {$dateFromString: {dateString: "12/31/2018", format: "%m/%d\0/%Y"}}}}];
assertErrCodeAndErrMsgContains(coll, pipeline, ErrorCodes.ConversionFailure, "Trailing data");
})();