JIRA: Searching for all issues with a given link type

You can use Script Runner plugin – Edit: It unfortunately is no longer free. The last version before 4.0 still is, though. Details here https://www.adaptavist.com/doco/display/SFJ/Downgrade+ScriptRunner It sports a ton of incredibly useful functions, one of these is hasLinks() Usage example: issueFunction in hasLinks(“blocks”) OR issueFunction in hasLinks(“is blocked by”)

Iterative deepening vs depth-first search

In a depth-first search, you begin at some node in the graph and continuously explore deeper and deeper into the graph while you can find new nodes that you haven’t yet reached (or until you find the solution). Any time the DFS runs out of moves, it backtracks to the latest point where it could … Read more

Implementation of Levenshtein distance for mysql/fuzzy search?

In order to efficiently search using levenshtein distance, you need an efficient, specialised index, such as a bk-tree. Unfortunately, no database system I know of, including MySQL, implements bk-tree indexes. This is further complicated if you’re looking for full-text search, instead of just a single term per row. Off-hand, I can’t think of any way … Read more

Fast Algorithm to Quickly Find the Range a Number Belongs to in a Set of Ranges?

After running various benchmarks, I came to the conclusion that only a tree like structure can work here. A sorted list shows of course good lookup performance – O(log n) – but it shows horribly update performance (inserts and removals are slower by more than the factor 10 compared to trees!). A balanced binary tree … Read more

How to include an additional CMakeLists.txt

That can be done with include, here’s some simple example: Content of A/CMakeLists.txt function(foo) message(STATUS “heya”) endfunction() Content of B/CMakeLists.txt cmake_minimum_required(VERSION 2.8) include(${CMAKE_CURRENT_SOURCE_DIR}/../A/CMakeLists.txt) foo() Now, including another CMakeLists.txt will also run everything in that file, so you may want to avoid doing that if there are targets in B/CMakeLists.txt If you can modify your code, … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)