sqlite-bug.go

package main

import (
	"database/sql"
	_ "github.com/mattn/go-sqlite3"
)

var query string = `
with
	foo as (select
		count(*) over (order by aa_),
		count(*) over (order by ab_),
		count(*) over (order by ac_),
		count(*) over (order by ad_),
		count(*) over (order by ae_),
		count(*) over (order by af_),
		count(*) over (order by ag_),
		count(*) over (order by ah_),
		count(*) over (order by ai_),
		count(*) over (order by aj_),
		count(*) over (order by ak_),
		count(*) over (order by al_),
		count(*) over (order by am_),
		count(*) over (order by an_),
		count(*) over (order by ao_),
		count(*) over (order by ap_),
		count(*) over (order by aq_),
		count(*) over (order by ar_),
		count(*) over (order by as_),
		count(*) over (order by at_),
		count(*) over (order by au_),
		count(*) over (order by av_),
		count(*) over (order by aw_),
		count(*) over (order by ax_),
		count(*) over (order by ay_),
		count(*) over (order by az_),
		count(*) over (order by ba_),
		count(*) over (order by bb_),
		count(*) over (order by bc_),
		count(*) over (order by bd_),
		count(*) over (order by be_),
		count(*) over (order by bf_),
		count(*) over (order by bg_),
		count(*) over (order by bh_),
		count(*) over (order by bi_),
		count(*) over (order by bj_),
		count(*) over (order by bk_),
		count(*) over (order by bl_),
		count(*) over (order by bm_),
		count(*) over (order by bn_),
		count(*) over (order by bo_),
		count(*) over (order by bp_),
		count(*) over (order by bq_),
		count(*) over (order by br_),
		count(*) over (order by bs_),
		count(*) over (order by bt_),
		count(*) over (order by bu_),
		count(*) over (order by bv_),
		count(*) over (order by bw_)
	from data)
select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
union all select null from foo
`

func main() {
	db, err := sql.Open("sqlite3", ":memory:")
	if err != nil { panic(err) }
	defer db.Close()
	db.Exec("create table data(aa_, ab_, ac_, ad_, ae_, af_, ag_, ah_, ai_, aj_, ak_, al_, am_, an_, ao_, ap_, aq_, ar_, as_, at_, au_, av_, aw_, ax_, ay_, az_, ba_, bb_, bc_, bd_, be_, bf_, bg_, bh_, bi_, bj_, bk_, bl_, bm_, bn_, bo_, bp_, bq_, br_, bs_, bt_, bu_, bv_, bw_);")
	go func() { db.Exec(query) }()
	for {}
}