Skip to content

Instantly share code, notes, and snippets.

@kylebrandt
Created October 15, 2025 14:39
Show Gist options
  • Save kylebrandt/5a19aa0f8e36f533a0fcf6b14ff4d260 to your computer and use it in GitHub Desktop.
Save kylebrandt/5a19aa0f8e36f533a0fcf6b14ff4d260 to your computer and use it in GitHub Desktop.
SQL Expressions Tests for Panics to address
func TestWhereOnNullNumber(t *testing.T) {
	f := &data.Frame{
		RefID: "a",
		Name:  "a",
		Fields: []*data.Field{
			//data.NewField("d", nil, []*float64{p(2.35), p(math.NaN())}),
			data.NewField("d", nil, []float64{2.35, math.NaN()}),
		},
	}

	db := DB{}
	qry := `SELECT * FROM a WHERE d > 0.2`

	_, err := db.QueryFrames(context.Background(), &testTracer{}, "b", qry, []*data.Frame{f})
	require.NoError(t, err)
}

func TestZeroRowFrame(t *testing.T) {
	f := &data.Frame{
		RefID: "a",
		Name:  "a",
		Fields: []*data.Field{
			data.NewField("d", nil, []float64{}),
		},
	}

	db := DB{}
	qry := `SELECT SUM(1) AS s FROM A`

	_, err := db.QueryFrames(context.Background(), &testTracer{}, "b", qry, []*data.Frame{f})
	require.NoError(t, err)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment