Investigate SQL92 aggregation
Reported by Ben Hood | September 30th, 2011 @ 07:55 PM | in 0.9-series (closed)
It could be possible to craft a portable group by select statement to aggregate unmatched diffs.
Comments and changes to this ticket
-
Ben Hood September 30th, 2011 @ 08:04 PM
(from [5c44946c3bf443b9b9bbde687a5de71e2122b148]) [#371] Recorded SQL that works in Oracle and Postgres as savepoint https://github.com/lshift/diffa/commit/5c44946c3bf443b9b9bbde687a5d...
-
Ben Hood October 2nd, 2011 @ 08:39 PM
(from [acf75d3a4020bcb5264baa88ef04a367d2b8d138]) [#371] Swap to HSQL to be able to group by extracted date components https://github.com/lshift/diffa/commit/acf75d3a4020bcb5264baa88ef04...
-
-
-
Ben Hood October 2nd, 2011 @ 10:21 PM
(from [797b52c9ca209423186b091abd46a45ac1156332]) [#371] Removed further Derby references https://github.com/lshift/diffa/commit/797b52c9ca209423186b091abd46...
-
Ben Hood October 2nd, 2011 @ 11:59 PM
(from [493dc57bba91b6b479bf246fcf28c67e10aac009]) [#371] Expanded DB aggregation test cases for each zoom level https://github.com/lshift/diffa/commit/493dc57bba91b6b479bf246fcf28...
-
Ben Hood October 3rd, 2011 @ 12:06 AM
(from [cf3334adbeb8bd259b38102795774b10d49ec340]) [#371] Documented the code a bit https://github.com/lshift/diffa/commit/cf3334adbeb8bd259b3810279577...
-
Ben Hood October 3rd, 2011 @ 01:54 AM
(from [eced0260074eb8781cd3b004ce3569baf1e7d80c]) [#371] Workaround for non-portable SQL bool type https://github.com/lshift/diffa/commit/eced0260074eb8781cd3b004ce35...
-
Ben Hood October 3rd, 2011 @ 02:02 AM
(from [49a6c9100be08e87e4fe951b3ffe71355224596d]) [#371] Switch zoom cache population over to DB aggregation https://github.com/lshift/diffa/commit/49a6c9100be08e87e4fe951b3ffe...
-
Ben Hood October 3rd, 2011 @ 02:13 AM
(from [1fd7dbc11735d7f601fcd3d0f7dd0aaed0df832e]) [#371] Added a bit of documentation https://github.com/lshift/diffa/commit/1fd7dbc11735d7f601fcd3d0f7dd...
-
Ben Hood October 3rd, 2011 @ 02:19 AM
- State changed from “new” to “resolved”
This looks like it could be ready for QA - so I've raised a pull request.
I'm going to deploy it to a production environment to see how it works with another DB.
-
Ben Hood October 3rd, 2011 @ 08:39 AM
(from [2e0f2de7b4a088bb896cc1fbca3b1815cdd269cf]) [#371] Read correct number type on Oracle https://github.com/lshift/diffa/commit/2e0f2de7b4a088bb896cc1fbca3b...
-
Ben Hood October 3rd, 2011 @ 11:13 AM
- Assigned user changed from “Ben Hood” to “Paul Jones”
I've deployed this to a prod environment on Oracle and it appears to be behaving OK, so I've merged this into master, but this should remain as post-QA.
-
Ben Hood October 3rd, 2011 @ 07:01 PM
(from [8f988f103754c8335b6f3114e938686d1d3638ca]) [#371] Split out the static routines into a separate static class https://github.com/lshift/diffa/commit/8f988f103754c8335b6f3114e938...
-
Paul Jones October 13th, 2011 @ 02:07 AM
- State changed from “resolved” to “closed”
This looks to be generally ok - the main comment I've raised is that we should codegen the hbm files - I've raised that as #383.
-
Ben Hood November 14th, 2011 @ 05:35 PM
- Milestone set to “0.9-series”
- Milestone order changed from “113” to “0”
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
A Real Time Differencing Tool.
People watching this ticket
Ben Hood
Tags
Referenced by
-
362
Investigate DB aggregation
This ticket has been superseded by #371
-
361
Experiment with Bone CP
HSQL has been implemented as part of #371, so this
now on...
-
383
Generate hbm configs for mismatch aggregation
The mismatch aggregation SQL introduced in #371 seems to
...