Public bug reported:
Ubuntu 12.04 is running on Travis.ci with sqlite 3.7.9 and that's where
we ran into this bug.
On sqlite3 3.6.20 (and likely the version on Travis, which is 3.7.9, but
not on 3.7.17):
```
sqlite> SELECT * FROM ingests;
id ingest_id bag_id ingested
created_at
---------- ------------------------------------ ---------- ----------
--------------------------
1 99bb3c9c-79b8-4fb4-bd16-91273a9485c4 1 f
2016-08-03 22:39:37.173484
2 06ac1f23-73a0-4185-9ce8-a3bb33079e68 1 t
2016-08-03 19:39:56.164517
3 308d53c9-a30d-403e-b7d9-182cdd22b33a 2 f
2016-08-03 18:40:20.198619
4 03f98430-c9b7-4500-aae8-4e3fcecdd56b 2 t
2016-08-02 20:40:38.293054
sqlite> SELECT * FROM ingests GROUP BY bag_id HAVING created_at =
max(created_at);
sqlite> # wtf?
```
When using sqlite 3.13.0 it returns results, i.e.
```
sqlite> SELECT * FROM ingests GROUP BY bag_id HAVING created_at =
max(created_at);
id ingest_id bag_id ingested
created_at
---------- ------------------------------------ ---------- ----------
--------------------------
1 99bb3c9c-79b8-4fb4-bd16-91273a9485c4 1 f
2016-08-03 22:39:37.173484
3 308d53c9-a30d-403e-b7d9-182cdd22b33a 2 f
2016-08-03 18:40:20.198619
```
** Affects: sqlite3 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Touch seeded packages, which is subscribed to sqlite3 in Ubuntu.
https://bugs.launchpad.net/bugs/1609557
Title:
GROUP BY / HAVING fails to return results
Status in sqlite3 package in Ubuntu:
New
Bug description:
Ubuntu 12.04 is running on Travis.ci with sqlite 3.7.9 and that's
where we ran into this bug.
On sqlite3 3.6.20 (and likely the version on Travis, which is 3.7.9,
but not on 3.7.17):
```
sqlite> SELECT * FROM ingests;
id ingest_id bag_id ingested
created_at
---------- ------------------------------------ ---------- ----------
--------------------------
1 99bb3c9c-79b8-4fb4-bd16-91273a9485c4 1 f
2016-08-03 22:39:37.173484
2 06ac1f23-73a0-4185-9ce8-a3bb33079e68 1 t
2016-08-03 19:39:56.164517
3 308d53c9-a30d-403e-b7d9-182cdd22b33a 2 f
2016-08-03 18:40:20.198619
4 03f98430-c9b7-4500-aae8-4e3fcecdd56b 2 t
2016-08-02 20:40:38.293054
sqlite> SELECT * FROM ingests GROUP BY bag_id HAVING created_at =
max(created_at);
sqlite> # wtf?
```
When using sqlite 3.13.0 it returns results, i.e.
```
sqlite> SELECT * FROM ingests GROUP BY bag_id HAVING created_at =
max(created_at);
id ingest_id bag_id ingested
created_at
---------- ------------------------------------ ---------- ----------
--------------------------
1 99bb3c9c-79b8-4fb4-bd16-91273a9485c4 1 f
2016-08-03 22:39:37.173484
3 308d53c9-a30d-403e-b7d9-182cdd22b33a 2 f
2016-08-03 18:40:20.198619
```
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/1609557/+subscriptions
--
Mailing list: https://launchpad.net/~touch-packages
Post to : touch-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~touch-packages
More help : https://help.launchpad.net/ListHelp
