ForbiddenPatterns validation failed for SELECT last_update FROM sakila.staff #1307
Description
I have following code:
@Test fun testJdbc() { val conn = pgConnection() conn.readDataFrame("SELECT last_update FROM sakila.staff", dbType = PostgreSql).print() }After execution, and I have the following error:
SQL query should start from SELECT and contain one query for reading data without any manipulation. Also it should not contain any separators like `;`. I think it's from containsForbiddenPatterns:
// Validate against forbidden patterns if (containsForbiddenPatterns(normalizedSqlQuery)) { return false }