Function Test_MultilineSQLStatement

contrib/drivers/dm/dm_z_unit_issue_test.go:78–163

Test_MultilineSQLStatement tests that multi-line SQL statements are properly supported. This test verifies that newlines and tabs in SQL queries are preserved, which is essential for readability and proper SQL statement handling.

(t *testing.T)

// This test verifies that newlines and tabs in SQL queries are preserved,
// which is essential for readability and proper SQL statement handling.
func Test_MultilineSQLStatement(t *testing.T) {
	table := "A_tables"
	createInitTable(table)
	defer dropTable(table)

	gtest.C(t, func(t *gtest.T) {
		// Test multi-line SELECT statement with newlines and indentation
		multilineSql := `
		SELECT 
			id,
			account_name,
			attr_index
		FROM A_tables
		WHERE id = ?
		AND account_name = ?
		`
		result, err := db.GetAll(ctx, multilineSql, 1, "name_1")
		t.AssertNil(err)
		t.Assert(len(result), 1)
		t.Assert(result[0]["ID"].Int(), 1)
		t.Assert(result[0]["ACCOUNT_NAME"].String(), "name_1")
	})

	gtest.C(t, func(t *gtest.T) {
		// Test multi-line SELECT with tabs
		multilineSql := `SELECT
			id,
			account_name,
			attr_index
		FROM A_tables
		WHERE id IN (?, ?)
		ORDER BY id`
		result, err := db.GetAll(ctx, multilineSql, 2, 3)
		t.AssertNil(err)
		t.Assert(len(result), 2)
		t.Assert(result[0]["ID"].Int(), 2)
		t.Assert(result[1]["ID"].Int(), 3)
	})

	gtest.C(t, func(t *gtest.T) {
		// Test that newlines in values don't cause issues
		multilineSql := `
		SELECT * 
		FROM A_tables 
		WHERE id = ?`
		result, err := db.GetAll(ctx, multilineSql, 5)
		t.AssertNil(err)
		t.Assert(len(result), 1)
		t.Assert(result[0]["ID"].Int(), 5)
		t.Assert(result[0]["ACCOUNT_NAME"].String(), "name_5")
	})

	gtest.C(t, func(t *gtest.T) {
		// Test multi-line INSERT with newlines
		multilineSql := `
		INSERT INTO A_tables
		(ID, ACCOUNT_NAME, ATTR_INDEX, CREATED_TIME, UPDATED_TIME)
		VALUES