greenlion

save_client_capabilities = thd->client_capabilities;
thd->client_capabilities |= CLIENT_MULTI_QUERIES;
save_vio = thd->net.vio;
thd->net.vio = 0;
for(table in tables) {
  dispatch_command(COM_QUERY, thd, buf, len);
}
thd->client_capabilities = save_client_capabilties;
thd->net.vio = save_vio;

greenlion

template<typename K, class D>
class PageManager {
  private:
  Node* first;
  Node* last;
  K nodecount = 0;
  K max_nodes = 0;  
  std::hash_set<K, Node*> page_table;
  void* flusher = NULL;  // The flusher is a callback function which is called when pages
                         // fall off the tail of the LRU maintained by the PageManager.

greenlion

mysql> select doc from json2 where match(flat) against ('last_name=Vembu')\G
*************************** 1. row ***************************
doc: { "_id" : { "$oid" : "52cdef7c4bab8bd675297d8b" }, "name" : "AdventNet", "permalink" : "abc3", "crunchbase_url" : "http://www.crunchbase.com/company/adventnet", "homepage_url" : "http://adventnet.com", "blog_url" : "", "blog_feed_url" : "", "twitter_username" : "manageengine", "category_code" : "enterprise", "number_of_employees" : 600, "founded_year" : 1996, "deadpooled_year" : 2, "tag_list" : "", "alias_list" : "Zoho ManageEngine ", "email_address" : "pr@adventnet.com", "phone_number" : "925-924-9500", "description" : "Server Management Software", "created_at" : { "$date" : 1180121062000 }, "updated_at" : "Wed Oct 31 18:26:09 UTC 2012", "overview" : "<p>AdventNet is now <a href=\"/company/zoho-manageengine\" title=\"Zoho ManageEngine\" rel=\"nofollow\">Zoho ManageEngine</a>.</p>\n\n<p>Founded in 1996, AdventNet has served a diverse range of enterprise IT, networkin

greenlion

/*
* Compile with: 
* g++ -std=c++11 -shared -I `mysql_config --include` `mysql_config --cxxflags` flatten_udf.cpp -o flatten_udf.so 
*/

#pragma GCC diagnostic ignored "-Wwrite-strings"
#include "presto.h"
#include <iostream>
#include <string>
#include "rapidjson/reader.h"

greenlion

#include "presto.h"
#include "myphp.h"
#include <iostream>
#include <string>

/* This function hooks PHP output to the error log*/ 
void php_log_output(const char *str){
 std::cerr << str;
}

greenlion

delimiter ;;
create database if not exists shard_query;;
use shard_query;;
drop procedure if exists sq_helper;;
drop procedure if exists sq_throw;;
create procedure sq_throw(v_err text) 
begin
  signal sqlstate '45000' set
    class_origin     = 'Fastbit_UDF',
    subclass_origin  = 'Fastbit_UDF',

greenlion

/*
FastBit UDF for MySQL (c) 2015 Justin Swanhart
Specification 1.0-DRAFT
*/

/*
fb_create(table_dir=>'/path/to/fastbit/data',colspec=>'c1:int,c2:int');
fb_load(table_dir=>'/path/to/fastbit/data', datafile=>'/path/to/file/to/load.txt');
fb_query(table_dir=>'/path/to/fastbit/data',query_string=>'select count(*) where c1 between 1 and 10', temp_dest=>'temporary_table_name');
fb_hits(table_dir=>'/path/to/fastbit/data',query_string=>'select count(*) where c1 between 1 and 10', temp_dest=>'temporary_table_name');

greenlion

<?php
/* a sample of traffic data from the real website, deduplicated and REST URLs digested */
$traffic = unserialize(file_get_contents('seed.dat')) or die('Could not unserialize seed.dat');

/* 20% chance by default */
function chance($greater_than=20, $bottom=1, $top = 100) {
  $toss = mt_rand($bottom, $top);
  if($greater_than >= $toss) return true; else return false;
}

greenlion

select count(*)    
  from ontime_fact   
  join dim_date on ontime_fact.date_id = dim_date.date_id
 where `Year` between 1990 and 1994 and `Quarter` = 1;
 
 select FlightDate, count(*)    
  from ontime_fact   
  join dim_date on ontime_fact.date_id = dim_date.date_id
  join dim_flight on ontime_fact.flight_id = dim_flight.flight_id
 where `Year` = 1998 and `Quarter` = 1

greenlion

// Generated by CoffeeScript 1.6.3
(function() {
  var avatar, blockPosErase, blockPosPlace, container, createGame, createPlayer, currentMaterial, defaults, extend, fly, game, generate, highlight, hl, makeFly, player, texturePath, voxel;

  generate = function(x, y, z) {
    if (x % 32 === 0 && z % 32 === 0) {
      return 3;
    }
    if (x % 32 === 0 && y % 32 === 0) {
      return 5;