yahonda’s gists

yahonda / gist:3220c859c5c9cd6ec9cee17602f84ee9

Created March 23, 2026 23:23

	#4 Patched PostgreSQL : NOT ENFORCED -> ENFORCED restires pg_trigger tgdeferrable and tginitdeferred value to t


	```
	postgres=# select version();
	version
	--------------------------------------------------------------------
	PostgreSQL 19devel on x86_64-linux, compiled by gcc-15.2.1, 64-bit
	(1 row)

yahonda / gist:8d0b62b591055072dab78adf39ea0023

Created March 23, 2026 14:43

	#3 NOT ENFORCED -> ENFORCED resets pg_trigger tgdeferrable and tginitdeferred value to f

	```
	postgres=# select version();
	version
	-----------------------------------------------------------------------------------------------------------------------------
	PostgreSQL 18.3 (Homebrew) on aarch64-apple-darwin25.2.0, compiled by Apple clang version 17.0.0 (clang-1700.6.3.2), 64-bit
	(1 row)
	postgres=# CREATE TABLE parent (
	id INT PRIMARY KEY

yahonda / gist:34ca1e096fb2a7571354eb96c83dc729

Created March 23, 2026 14:26

	#2 It raises "ERROR: insert or update on table "child" violates foreign key constraint "child_parent_fk"

	```
	postgres=# select version();
	version
	-----------------------------------------------------------------------------------------------------------------------------
	PostgreSQL 18.3 (Homebrew) on aarch64-apple-darwin25.2.0, compiled by Apple clang version 17.0.0 (clang-1700.6.3.2), 64-bit
	(1 row)

	postgres=# CREATE TABLE parent (

yahonda / gist:aa137f2c86a83bd4468628b8b1cc1496

Last active March 23, 2026 14:42

	#1 It should raise "ERROR: insert or update on table "child" violates foreign key constraint "child_parent_fk" but does not

	```sql
	postgres=# select version();
	version
	-----------------------------------------------------------------------------------------------------------------------------
	PostgreSQL 18.3 (Homebrew) on aarch64-apple-darwin25.2.0, compiled by Apple clang version 17.0.0 (clang-1700.6.3.2), 64-bit
	(1 row)
	postgres=# CREATE TABLE parent (
	id INTEGER PRIMARY KEY,

yahonda / gist:d142fc7e03fc7c854a9ac7e45c09f1e9

Created December 16, 2025 08:12

	$ RUBY_IMAGE=rubylang/ruby:master docker compose -f .buildkite/docker-compose.yml build base
	docker tag buildkite-base buildkite_base
	[+] Building 585.2s (27/27) FINISHED
	=> [internal] load local bake definitions 0.0s
	=> => reading from stdin 610B 0.0s
	=> [internal] load build definition from Dockerfile 0.0s
	=> => transferring dockerfile: 6.72kB 0.0s
	=> [internal] load metadata for docker.io/rubylang/ruby:master 2.3s
	=> [auth] rubylang/ruby:pull token for registry-1.docker.io 0.0s
	=> [internal] load .dockerignore

yahonda / gist:3dbe3ea523223dc6a1bd0486689e17a0

Created December 16, 2025 08:11

	$ RUBY_IMAGE=ruby:3.4 docker compose -f .buildkite/docker-compose.yml build base
	docker tag buildkite-base buildkite_base
	[+] Building 403.2s (27/27) FINISHED
	=> [internal] load local bake definitions 0.0s
	=> => reading from stdin 598B 0.0s
	=> [internal] load build definition from Dockerfile 0.0s
	=> => transferring dockerfile: 6.72kB 0.0s
	=> [internal] load metadata for docker.io/library/ruby:3.4 2.5s
	=> [auth] library/ruby:pull token for registry-1.docker.io 0.0s
	=> [internal] load .dockerignore

yahonda / gist:304a82326fd65f6ef5450edacf76ab97

Created December 8, 2025 06:58

Not installing bundler


	```
	% RUBY_IMAGE=rubylang/ruby:master docker compose -f .buildkite/docker-compose.yml build --pull base
	docker tag buildkite-base buildkite_base
	CI=1 docker compose -f .buildkite/docker-compose.yml run -e PRE_STEPS -e RACK --rm railties runner railties 'rake test'
	[+] Building 243.8s (26/26) FINISHED
	=> [internal] load local bake definitions 0.0s
	=> => reading from stdin 632B 0.0s
	=> [internal] load build

yahonda / gist:5b53381bd7446606e2c9e977f011793c

Created December 8, 2025 06:29

	~/src/github.com/rails/rails % RUBY_IMAGE=rubylang/ruby:master docker compose -f .buildkite/docker-compose.yml build --pull base
	docker tag buildkite-base buildkite_base
	CI=1 docker compose -f .buildkite/docker-compose.yml run -e PRE_STEPS -e RACK --rm railties runner railties 'rake test'
	[+] Building 543.5s (26/26) FINISHED
	=> [internal] load local bake definitions 0.0s
	=> => reading from stdin 632B 0.0s

yahonda / gist:7e61f3f71681cfa03111fed55714b0b4

Created December 19, 2024 01:38

not valid

	test=# CREATE TABLE "posts" ("id" bigserial primary key, "title" character varying);
	CREATE TABLE
	test=# ALTER TABLE "posts" ADD CONSTRAINT posts_const CHECK (char_length(title) >= 5) NOT VALID;
	ALTER TABLE
	test=# CREATE TABLE "comments" ("id" bigserial primary key, "body" text, CONSTRAINT comments_const CHECK (char_length(body) >= 5) NOT VALID);
	CREATE TABLE
	test=# SELECT conname, convalidated FROM pg_constraint WHERE contype = 'c'
	and conname in('posts_const','comments_const');
	conname \| convalidated
	----------------+--------------

yahonda / gist:4ab5ae661d02b10912f3e3242b16aa3d

Created December 3, 2024 14:59

https://github.com/rails/buildkite-config/pull/134

	$ git clone https://github.com/rails/rails
	cd rails
	git clone https://github.com/yahonda/buildkite-config -b disable_innodb_snapshot_isolation .buildkite/
	RUBY_IMAGE=ruby:3.3 docker-compose -f .buildkite/docker-compose.yml build base &&
	CI=1 MYSQL_IMAGE=mariadb:latest docker-compose -f .buildkite/docker-compose.yml run mariadb runner activerecord 'rake db:mysql:rebuild test:mysql2'
	Cloning into 'rails'...
	remote: Enumerating objects: 892424, done.
	remote: Counting objects: 100% (915/915), done.
	remote: Compressing objects: 100% (495/495), done.
	remote: Total 892424 (delta 574), reused 656 (delta 417), pack-reused 891509 (from 1)

Yasuo Honda yahonda