Function TestIsPureDataQuery

main_test.go:88–154

(t *testing.T)

}

func TestIsPureDataQuery(t *testing.T) {
	harness := harness.NewDefaultDuckHarness()
	harness.Setup(
		setup.MydbData,
		[]setup.SetupScript{
			{
				"CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(255))",
				"CREATE table xy (x int primary key, y int, unique index y_idx(y));",
				"CREATE view myview as select * from users",
			},
		})
	engine, err := harness.NewEngine(t)
	require.NoError(t, err)
	tests := []struct {
		name     string
		query    string
		expected bool
	}{
		{
			name:     "Simple SELECT query",
			query:    "SELECT * FROM users",
			expected: true,
		},
		{
			name:     "Query from mysql system table",
			query:    "SELECT * FROM mysql.user",
			expected: false,
		},
		{
			name:     "Query with system function",
			query:    "SELECT DATABASE()",
			expected: false,
		},
		{
			name:     "Query with subquery from system table",
			query:    "SELECT u.name, (SELECT COUNT(*) FROM mysql.user) FROM users u",
			expected: false,
		},
		{
			name:     "Query from information_schema",
			query:    "SELECT * FROM information_schema.tables",
			expected: false,
		},
		{
			name:     "Query with subquery",
			query:    "select * from xy where x in (select 1 having false);",
			expected: true,
		},
		{
			name:     "Date parse query",
			query:    "SELECT STR_TO_DATE('Jan 3, 2000', '%b %e, %Y')",
			expected: false,
		},
		{
			name:     "View query",
			query:    "SELECT * FROM myview WHERE id = 1",
			expected: true,
		},