Skip to content

Instantly share code, notes, and snippets.

@briancline
Created May 4, 2018 03:03
Show Gist options
  • Save briancline/e74dfce4e064ae165122c0b32120f1c5 to your computer and use it in GitHub Desktop.
Save briancline/e74dfce4e064ae165122c0b32120f1c5 to your computer and use it in GitHub Desktop.
Extra flair for CRDB bug report
--
-- PostgreSQL database dump
--
-- Dumped from database version 10.3 (Ubuntu 10.3-1.pgdg16.04+1)
-- Dumped by pg_dump version 10.3 (Ubuntu 10.3-1.pgdg16.04+1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'LATIN1';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
-- I added this line to avoid pkey constraint errors during my own crdb testing
DELETE FROM public.node_stat_20180420 WHERE true;
--
-- Data for Name: node_stat_20180420; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.node_stat_20180420 (node_stat_id, node_id, stat_id, report_date, create_date, data) FROM stdin;
226164271 37 5 2018-04-20 23:02:07.519465-05 2018-04-20 23:02:07.519477-05 .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XYZ8192.one.one.two..three...five.....eight........thirteen.............twenty-one.....................end transmission
\.
--
-- PostgreSQL database dump complete
--
CREATE TABLE node_stat_20180420 (
node_stat_id BIGINT NOT NULL,
node_id BIGINT NULL,
stat_id BIGINT NULL,
report_date TIMESTAMP WITH TIME ZONE NULL,
create_date TIMESTAMP WITH TIME ZONE NULL,
data STRING NULL,
CONSTRAINT "primary" PRIMARY KEY (node_stat_id ASC),
UNIQUE INDEX node_stat_20180420_node_stat_id_key (node_stat_id ASC),
FAMILY cf1 (node_stat_id, node_id, stat_id, report_date, create_date),
FAMILY cf2 (data)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment