swanhart-tools

swanhart-tools copied to clipboard

mysqlbinog (mariadb-binlog) output on MariaDB 10.4+ changes BEGIN to START TRANSACTION. This is not a problem with MySQL 5.8 or MySQL 5.8.

greenlion

I have created a materialized view to be a view of a single table (using a nested set model) that joins onto itself a couple of times. The resulting view...

mvincent

UDF in where clause

3

executing: echo "select smiles from products_structure_query where match_substructure(screen, molecule, 'CCC');" | sudo php run_query --ini=bootstrap.ini results in: ERRORS RETURNED BY OPERATION: Array ( [0] => While getting coordinator columns: 1054Unknown...

integerx

COMPLETE refresh bugs? enable(), disable(), add_expr() does not work properly

1

Hello! I've found lot of weirdnesses when trying to use COMPLETE refresh views: 1. enable() actually does not enable mview: it does not set flexviews.mview.mview_enabled flag 2. disable() actually does...

andrews812

PHP 5.5: PHP Strict Standards: Only variables should be passed by reference

2

PHP Strict Standards: Only variables should be passed by reference in /home/users/klarka/wc/2/libs/shard-query/include/shard-query.php on line 2115. What about some refactoring to support strict PHP 5.5 + a coding standard? http://www.php-fig.org/psr/psr-2/ I...

vojta

Can't use a separate schema for aggregate tables

6

I have a schema called "archive" (shard1), where are the large tables I want to query. I don't want to create any temporary tables in this schema (because it's replicated),...

vojta

Need to assign a query_id to each query. Before starting execution, each worker thread should check a table to see if query is killed Queries sent to shards should have...

greenlion

Problem with table joining order on incremental view refresh.

2

There is a possibility for situation in which you can enable a incremental view, but cannot refresh it due to wrong order of tables being joined and 'unknown column' exception....

50karol

Flexviews: UTIL_API/refresh Documentation Problem

1

The synopsis of [UTIL_API/refresh](http://greenlion.github.io/swanhart-tools/flexviews/manual.html#UTIL5fAPI2frefresh) is missing arguments: ``` SYNOPSIS flexviews.refresh(v_mview_id, FUNCTION ```

jamiejackson

PHP Notice: Undefined index: database_nametable_namenumber in /path/to/swanhart-tools-master/flexviews/consumer/include/flexcdc.php on line 393

greenlion