Skip to content

Instantly share code, notes, and snippets.

View benesch's full-sized avatar

Nikhil Benesch benesch

197 followers · 0 following
View GitHub Profile
@benesch
benesch / array_dims.patch
Created June 4, 2023 22:32
diff --git a/src/backend/utils/adt/arrayfuncs.c b/src/backend/utils/adt/arrayfuncs.c
index 9000f83a83..09d3f9267d 100644
--- a/src/backend/utils/adt/arrayfuncs.c
+++ b/src/backend/utils/adt/arrayfuncs.c
@@ -477,6 +477,7 @@ ArrayCount(const char *str, int *dim, char typdelim, Node *escontext)
bool in_quotes = false;
bool eoArray = false;
bool empty_array = true;
+ bool seen_level_completed = false;
const char *ptr;
@benesch
benesch / buildkite.sql
Created June 28, 2021 02:59
--
-- PostgreSQL database dump
--
-- Dumped from database version 10.17 (Ubuntu 10.17-0ubuntu0.18.04.1)
-- Dumped by pg_dump version 10.17 (Ubuntu 10.17-0ubuntu0.18.04.1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
@benesch
benesch / 00-shell-session.txt
Last active February 10, 2021 18:57
[~/Sites/materialize/materialize] (f32 *$%)
benesch@marmoset$ cd src/sql-parser
[~/Sites/materialize/materialize/src/sql-parser] (f32 *$%)
benesch@marmoset$ cargo out-dir
/home/benesch/Sites/materialize/materialize/target/debug/build/sql-parser-89e065596d8d4a8f/out
[~/Sites/materialize/materialize/src/sql-parser] (f32 *$%)
benesch@marmoset$ cat /home/benesch/Sites/materialize/materialize/target/debug/build/sql-parser-89e065596d8d4a8f/out/fold.rs
@benesch
benesch / incremental-sync.log
Created January 13, 2021 07:24
2021-01-12 16:08:21.849 EST [3843280] postgres@fivetran LOG: execute <unnamed>: SET extra_float_digits = 3
2021-01-12 16:08:21.868 EST [3843280] postgres@fivetran LOG: execute <unnamed>: SET application_name = 'fivetran'
2021-01-12 16:08:21.887 EST [3843280] postgres@fivetran LOG: execute <unnamed>: SELECT 1
2021-01-12 16:08:22.038 EST [3843281] postgres@fivetran LOG: execute <unnamed>: SET extra_float_digits = 3
2021-01-12 16:08:22.054 EST [3843281] postgres@fivetran LOG: execute <unnamed>: SET application_name = 'fivetran'
2021-01-12 16:08:22.082 EST [3843281] postgres@fivetran LOG: execute <unnamed>: SET ssl_renegotiation_limit = 0
2021-01-12 16:08:22.264 EST [3843282] postgres@fivetran LOG: execute <unnamed>: SET extra_float_digits = 3
2021-01-12 16:08:22.280 EST [3843282] postgres@fivetran LOG: execute <unnamed>: SET application_name = 'fivetran'
2021-01-12 16:08:22.310 EST [3843282] postgres@fivetran LOG: execute <unnamed>: /*Fivetran*/SELECT version()
2021-01-12 16:37:32.183 EST [3894983] post
@benesch
benesch / gox.diff
Created October 13, 2020 04:33
$ diff -ua net.gox net.gox.bak
--- net.gox 2020-10-13 04:27:20.425046028 +0000
+++ net.gox.bak 2020-10-13 04:26:16.998686918 +0000
@@ -1,4 +1,4 @@
-ELFN@@v3;
+ELF>N@@v3;
package net
pkgpath net
import context context "context"
@@ -22,7 +22,7 @@
@benesch
benesch / netbsd-sigtramp-unwind.patch
Created October 12, 2020 04:22
Index: arch/x86_64/sys/__sigtramp2.S
===================================================================
RCS file: /cvsroot/src/lib/libc/arch/x86_64/sys/__sigtramp2.S,v
retrieving revision 1.7
diff -u -r1.7 __sigtramp2.S
--- arch/x86_64/sys/__sigtramp2.S 2 Dec 2019 01:38:54 -0000 1.7
+++ arch/x86_64/sys/__sigtramp2.S 12 Oct 2020 04:22:11 -0000
@@ -36,14 +36,40 @@
*/
@benesch
benesch / compile.sh
Last active November 11, 2023 03:33
Cross-compiling Materialize for ARM on x64 Ubuntu
sudo apt-get install -qy binutils-aarch64-linux-gnu gcc-aarch64-linux-gnu g++-aarch64-linux-gnu
export CMAKE_SYSTEM_NAME=Linux
export TARGET=aarch64-linux-gnu
export TARGET_AR=aarch64-linux-gnu-ar
export TARGET_CC=aarch64-linux-gnu-gcc
export TARGET_CXX=aarch64-linux-gnu-g++
export TARGET_RANLIB=aarch64-linux-gnu-ranlib
export TARGET_CPP=aarch64-linux-gnu-cpp
export TARGET_LD=aarch64-linux-gnu-ld
export CARGO_TARGET_AARCH64_UNKNOWN_LINUX_GNU_LINKER=$TARGET_CC
@benesch
benesch / gist:fa0e884118c2081022c45e48cf337ef2
Created July 24, 2020 19:52
(VALUES (
1 < ALL(SELECT * FROM (VALUES (1)) WHERE false),
1 < ALL(VALUES (0)),
1 < ALL(VALUES (1)),
1 < ALL(VALUES (2)),
1 < ALL(VALUES (0), (NULL)),
1 < ALL(VALUES (1), (NULL)),
1 < ALL(VALUES (2), (NULL)),
NULL < ALL(SELECT * FROM (VALUES (1)) WHERE false),
@benesch
benesch / gist:404eacaacd4e0f7fb10b3131f2950f96
Created July 24, 2020 19:42
(VALUES (
1 < ALL(SELECT * FROM (VALUES (1)) WHERE false),
1 < ALL(VALUES (0)),
1 < ALL(VALUES (1)),
1 < ALL(VALUES (2)),
1 < ALL(VALUES (0), (NULL)),
1 < ALL(VALUES (1), (NULL)),
1 < ALL(VALUES (2), (NULL)),
NULL < ALL(SELECT * FROM (VALUES (1)) WHERE false),
NULL < ALL(VALUES (0)),
@benesch
benesch / gist:288674bae2fcd6376ceaa2714547ed03
Last active July 24, 2020 15:14
select * from generate_series(100,200) g,
lateral (select * from int8_tbl a where g = q1 union all
select * from int8_tbl b where g = q2) ss
building:
%0 =
| Constant (100) (101) (102) (103) (104) (105) (106) (107) (108) (109) (110) (111) (112) (113) (114) (115) (116) (117) (118) (119) (120) (121) (122) (123) (124) (125) (126) (127) (128) (129) (130) (131) (132) (133) (134) (135) (136) (137) (138) (139) (140) (141) (142) (143) (144) (145) (146) (147) (148) (149) (150) (151) (152) (153) (154) (155) (156) (157) (158) (159) (160) (161) (162) (163) (164) (165) (166) (167) (168) (169) (170) (171) (172) (173) (174) (175) (176) (177) (178) (179) (180) (181) (182) (183) (184) (185) (186) (187) (188) (189) (190) (191) (192) (193) (194) (195) (196) (197) (198) (199) (200)
%1 =