Skip to content

Instantly share code, notes, and snippets.

@maddyblue

maddyblue/original

Created July 23, 2019 02:22
Show Gist options
  • Save maddyblue/2dd12626f8a1f875eb1117bc0ea17a26 to your computer and use it in GitHub Desktop.
Save maddyblue/2dd12626f8a1f875eb1117bc0ea17a26 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
original
CREATE TABLE table0 (
col0 DATE NULL, col1 INT2 NULL, col2 NAME NOT NULL, col3 REGTYPE, col4 OID NULL, col5 REGPROC, col6 UUID NOT NULL, col7 BIT(15), col8 TIME,
FAMILY fam0 (col3),
FAMILY fam1 (col6, col1, col7),
FAMILY fam2 (col5),
FAMILY fam3 (col0),
FAMILY fam4 (col8, col2),
FAMILY fam5 (col4),
PRIMARY KEY (col3 ASC),
UNIQUE (col2),
UNIQUE (col1 DESC, col0 DESC, col7 ASC, col8, col2 ASC, col6 ASC, col4 ASC, col5 DESC),
INDEX (col6 ASC, col0 ASC, col8 ASC, col7 DESC, col5 DESC, col2 ASC, col1 ASC, col3 ASC, col4),
UNIQUE (col6 ASC),
INDEX (col7, col4 ASC)
);
CREATE TABLE table1 (
col0 BIT(21) NOT NULL, col1 INT2 NOT NULL,
FAMILY fam0 (col0, col1),
PRIMARY KEY (col1 DESC),
UNIQUE (col0),
UNIQUE (col1 DESC, col0 DESC),
INDEX (col1 DESC, col0 ASC),
UNIQUE (col0, col1 ASC),
UNIQUE (col1),
INDEX (col0 ASC, col1),
UNIQUE (col0 ASC, col1),
UNIQUE (col0, col1 DESC),
UNIQUE (col0, col1 DESC)
);
WITH
with_3076 (col_37991, col_37992)
AS (
SELECT
(-0.23543492061407323):::FLOAT8 AS col_37991,
((-1612223451104563004):::INT8, 3057335360:::OID, e'T( \x1b\n"I':::STRING) AS col_37992
FROM
defaultdb.public.table0 AS tab_13461
WHERE
EXISTS(
WITH
with_3073 (col_37971, col_37972, col_37973, col_37974, col_37978)
AS (
SELECT
e'\x1a\x7f\x13{~':::STRING AS col_37971,
'3000-01-01 00:00:00+00:00':::TIMESTAMPTZ AS col_37972,
statement_timestamp():::TIMESTAMPTZ::TIMESTAMPTZ AS col_37973,
'':::STRING AS col_37974,
(
CASE
WHEN true
THEN div(
(
WITH
with_3072 (col_37975, col_37976)
AS (
SELECT
*
FROM
(
VALUES
(
ARRAY[
8654536697831235396:::INT8,
(-3418190800414505179):::INT8,
1:::INT8
],
current_timestamp():::DATE::DATE
),
(ARRAY[]:::INT2[], '1980-06-05':::DATE),
(ARRAY[6549216833783549193:::INT8], NULL)
)
AS tab_13463 (col_37975, col_37976)
)
SELECT
2.684558917611454:::FLOAT8 AS col_37977
FROM
with_3072,
defaultdb.public.table0 AS tab_13464
CROSS JOIN defaultdb.public.table0 AS tab_13465,
defaultdb.public.table1 AS tab_13466
FULL JOIN defaultdb.public.table0 AS tab_13467 ON NULL
INNER JOIN defaultdb.public.table1 AS tab_13468 ON false,
defaultdb.public.table1 AS tab_13469
ORDER BY
tab_13464.col8, tab_13465.col5 DESC
LIMIT
1:::INT8
)::FLOAT8,
(-1.0):::FLOAT8::FLOAT8
)::FLOAT8
ELSE (-0.3832399393455538):::FLOAT8
END::FLOAT8
+ (-0.16400022324740526):::FLOAT8::FLOAT8
)::FLOAT8
AS col_37978
FROM
defaultdb.public.table1 AS tab_13462
WHERE
false
),
with_3074 (col_37979, col_37980)
AS (
SELECT
*
FROM
(
VALUES
((-1):::INT8, NULL),
(8769692239972550742:::INT8, e'\x12R1\x07\x16ge?z':::STRING),
(618681231202674417:::INT8, e'_E]\x07\x05YW|>':::STRING),
((-2206589211038013670):::INT8, '2oJKN':::STRING)
)
AS tab_13470 (col_37979, col_37980)
),
with_3075 (col_37981, col_37982, col_37983, col_37984, col_37985, col_37986, col_37987)
AS (
SELECT
*
FROM
(
VALUES
(
0.08260682791791846:::FLOAT8,
NULL,
NULL,
'1970-01-02 09:14:36.000595+00:00':::TIMESTAMP,
e'\x16\x05':::STRING,
ARRAY[2259155414:::OID, 3924120422:::OID, 1196142917:::OID],
NULL
),
(
(-0.08536630641673909):::FLOAT8,
'1991-04-19':::DATE,
B'10011011101111111100011011000000110',
NULL,
NULL,
ARRAY[2194426505:::OID, 3341294501:::OID, 3822059030:::OID, 726463209:::OID],
NULL
),
(
(-0.33077760657662547):::FLOAT8,
'1996-04-27':::DATE,
B'11111011100111001011100000001011010',
'0001-01-01 00:00:00+00:00':::TIMESTAMP,
e'Q\n&':::STRING,
ARRAY[1557387025:::OID, 1113525840:::OID, 1791430795:::OID, 2936953121:::OID],
'38b5aac7-c617-406a-992b-f7dfca76de77':::UUID
),
(
NULL,
NULL,
B'11000001010110110010010110010100000',
'1970-01-05 16:00:11.000345+00:00':::TIMESTAMP,
NULL,
ARRAY[3071662002:::OID, 1865157658:::OID, 1371923840:::OID, 1899527651:::OID, 3738231566:::OID],
'b4202cbb-bddc-4e9e-b128-e71b6615639d':::UUID
),
(
(-1.0):::FLOAT8,
'1974-06-26':::DATE,
B'00001001110111001000011100000001010',
'1970-01-11 03:29:56.000585+00:00':::TIMESTAMP,
e'{*@\x02\x13\x14;':::STRING,
NULL,
'e48f75b7-194d-4195-a470-45e8ed3bd504':::UUID
),
(
(-0.8973068217810425):::FLOAT8,
'1971-08-20':::DATE,
B'00101100011000111010100010000001100',
'3000-01-01 00:00:00+00:00':::TIMESTAMP,
NULL,
ARRAY[2895834563:::OID, 486532601:::OID, 2668251978:::OID, 2875412300:::OID],
NULL
)
)
AS tab_13471 (col_37981, col_37982, col_37983, col_37984, col_37985, col_37986, col_37987)
)
SELECT
NULL AS col_37988, tab_13461.col3 AS col_37989, tab_13461.col4 AS col_37990
FROM
with_3074, defaultdb.public.table1 AS tab_13472, defaultdb.public.table1 AS tab_13473
)
)
SELECT
326410872:::OID AS col_37993,
'89a03b26-7046-4e19-aecc-956070094382':::UUID AS col_37994,
NULL AS col_37995,
B'01000000110010100010011001110000100' AS col_37996,
4258465173:::OID AS col_37997,
NULL AS col_37998,
(
ARRAY[(-4865154862105501288):::INT8, 4892961168387526772:::INT8],
ARRAY[1264716318287234947:::INT8, (-3961367602248381900):::INT8, 2735177505176033214:::INT8],
B'0110111100100011100'
)
AS col_37999,
1.2648547507658425:::FLOAT8 AS col_38000,
NULL AS col_38001,
tab_13474.col0 AS col_38002
FROM
defaultdb.public.table1 AS tab_13474
WHERE
true
ORDER BY
tab_13474.col1;
Raw
reduced
CREATE TABLE c (col3 REGTYPE, col4 TIME);
CREATE TABLE table1 ();
WITH
e
AS (
SELECT
0
FROM
c AS tab_13461
WHERE
EXISTS(
WITH
f AS (SELECT ''::STRING AS col_37974, 0::FLOAT8 AS col_37978 FROM defaultdb.public.table1 AS tab_13462 WHERE false),
with_3074 AS (SELECT * FROM (VALUES (0::INT8, NULL), (2::INT8, ''::STRING)) AS tab_13470),
with_3075
AS (
SELECT
*
FROM
(
VALUES
(
0.08260682791791846::FLOAT8,
NULL,
NULL,
'00010101 '::TIMESTAMP,
''::STRING,
ARRAY[5::OID, 0::OID, 5::OID, 1::OID],
'38b5aac7-c617-406a-992b-e71b6615639d'::UUID
),
(
0::FLOAT8,
'19740626'::DATE,
B'',
'19700129'::TIMESTAMP,
''::STRING,
NULL,
'e48f75b7-194d-4195-a470-45e8ed3bd504'::UUID
),
(
0::FLOAT8,
'19710820'::DATE,
B'',
'30000101 '::TIMESTAMP,
NULL,
ARRAY[3::OID, 1::OID, 8::OID, 0::OID],
NULL
)
)
AS tab_13471
)
SELECT
NULL AS col_37988, tab_13461.col3 AS col_37989, tab_13461.col4 AS col_37990
FROM
with_3074, defaultdb.public.table1 AS tab_13472, defaultdb.public.table1 AS tab_13473
)
)
SELECT
2::OID AS col_37993, '';
Raw
stats
(0.0 %, 18200 bytes)
...
(72.5 %, 5004 bytes)
===================== done ====================
pass statistics:
method pass_indent :: final worked 1 times and failed 0 times
method pass_blank :: 0 worked 1 times and failed 0 times
method pass_balanced :: parens-inside worked 1 times and failed 70 times
method pass_clex :: rm-toks-14 worked 2 times and failed 295 times
method pass_indent :: regular worked 2 times and failed 1 times
method pass_lines :: 6 worked 4 times and failed 24 times
method pass_lines :: 2 worked 4 times and failed 24 times
method pass_lines :: 8 worked 4 times and failed 24 times
method pass_lines :: 3 worked 4 times and failed 24 times
method pass_lines :: 0 worked 4 times and failed 24 times
method pass_lines :: 10 worked 4 times and failed 24 times
method pass_lines :: 4 worked 4 times and failed 24 times
method pass_lines :: 1 worked 4 times and failed 24 times
method pass_clex :: rename-toks worked 6 times and failed 84 times
method pass_clex :: rm-toks-6 worked 7 times and failed 323 times
method pass_clex :: rm-toks-4 worked 7 times and failed 440 times
method pass_balanced :: parens worked 8 times and failed 73 times
method pass_balanced :: parens-to-zero worked 10 times and failed 125 times
method pass_clex :: rm-toks-3 worked 15 times and failed 468 times
method pass_clex :: rm-toks-5 worked 15 times and failed 365 times
method pass_clex :: rm-tok-pattern-4 worked 16 times and failed 2000 times
method pass_peep :: a worked 32 times and failed 547 times
method pass_clex :: rm-toks-2 worked 53 times and failed 513 times
method pass_clex :: rm-toks-1 worked 136 times and failed 619 times
method pass_ints :: a worked 142 times and failed 0 times
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment