github: issues: 2 rows where "created_at" is on date 2019-10-17 and user = 2448579 sorted by updated

2 rows where "created_at" is on date 2019-10-17 and user = 2448579 sorted by updated_at descending

Search:

descending

id	node_id	number	title	user	state	locked	assignee	milestone	comments	created_at	updated_at ▲	closed_at	author_association	active_lock_reason	draft	pull_request	body	reactions	performed_via_github_app	state_reason	repo	type
508167922	MDU6SXNzdWU1MDgxNjc5MjI=	3409	test failure with upstream-dev	dcherian 2448579	closed	0			12	2019-10-17T00:34:32Z	2019-11-19T14:06:46Z	2019-11-19T14:06:46Z	MEMBER				https://dev.azure.com/xarray/xarray/_build/results?buildId=1101&view=logs ``` =================================== FAILURES =================================== ____ testdatetime_reduce[False] ______ dask = False `@arm_xfail @pytest.mark.parametrize("dask", [False, True]) def test_datetime_reduce(dask): time = np.array(pd.date_range("15/12/1999", periods=11)) time[8:11] = np.nan da = DataArray(np.linspace(0, 365, num=11), dims="time", coords={"time": time}) if dask and has_dask: chunks = {"time": 5} da = da.chunk(chunks) actual = da["time"].mean()` `assert not pd.isnull(actual)` E AssertionError: assert not True E + where True = <function isna at 0x7f2475449ae8>(<xarray.DataArray 'time' ()>\narray('NaT', dtype='datetime64[ns]')) E + where <function isna at 0x7f2475449ae8> = pd.isnull xarray/tests/test_duck_array_ops.py:288: AssertionError ____ test_datetime_reduce[True] ______ dask = True `@arm_xfail @pytest.mark.parametrize("dask", [False, True]) def test_datetime_reduce(dask): time = np.array(pd.date_range("15/12/1999", periods=11)) time[8:11] = np.nan da = DataArray(np.linspace(0, 365, num=11), dims="time", coords={"time": time}) if dask and has_dask: chunks = {"time": 5} da = da.chunk(chunks) actual = da["time"].mean()` `assert not pd.isnull(actual)` E AssertionError: assert not True E + where True = <function isna at 0x7f2475449ae8>(<xarray.DataArray 'time' ()>\narray('NaT', dtype='datetime64[ns]')) E + where <function isna at 0x7f2475449ae8> = pd.isnull xarray/tests/test_duck_array_ops.py:288: AssertionError =============================== warnings summary ```	{ "url": "https://api.github.com/repos/pydata/xarray/issues/3409/reactions", "total_count": 1, "+1": 1, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0 }		completed	xarray 13221727	issue
508499635	MDExOlB1bGxSZXF1ZXN0MzI5MjgwODQ4	3412	Test that Dataset and DataArray resampling are identical	dcherian 2448579	closed	0			0	2019-10-17T14:04:22Z	2019-10-22T19:42:12Z	2019-10-22T19:42:09Z	MEMBER		0	pydata/xarray/pulls/3412	[x] Closes #2362 [x] Tests added [x] Passes `black . && mypy . && flake8`	{ "url": "https://api.github.com/repos/pydata/xarray/issues/3412/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0 }			xarray 13221727	pull

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [issues] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [number] INTEGER,
   [title] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [state] TEXT,
   [locked] INTEGER,
   [assignee] INTEGER REFERENCES [users]([id]),
   [milestone] INTEGER REFERENCES [milestones]([id]),
   [comments] INTEGER,
   [created_at] TEXT,
   [updated_at] TEXT,
   [closed_at] TEXT,
   [author_association] TEXT,
   [active_lock_reason] TEXT,
   [draft] INTEGER,
   [pull_request] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [state_reason] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [type] TEXT
);
CREATE INDEX [idx_issues_repo]
    ON [issues] ([repo]);
CREATE INDEX [idx_issues_milestone]
    ON [issues] ([milestone]);
CREATE INDEX [idx_issues_assignee]
    ON [issues] ([assignee]);
CREATE INDEX [idx_issues_user]
    ON [issues] ([user]);