lordgamez commented on a change in pull request #1238:
URL: https://github.com/apache/nifi-minifi-cpp/pull/1238#discussion_r783767943
##########
File path: docker/test/integration/features/sql.feature
##########
@@ -32,6 +32,21 @@ Feature: Executing SQL operations from MiNiFi-C++
When all instances start up
Then at least one flowfile with the content
'[{"int_col":2,"text_col":"banana"},{"int_col":1,"text_col":"apple"}]' is
placed in the monitored directory in less than 120 seconds
+ Scenario: A MiNiFi instance can query to test table containing mixed case
column names with ExecuteSQL processor
+ Given a GenerateFlowFile processor with the "File Size" property set to
"0B"
+ And a UpdateAttribute processor with the "sql.args.1.value" property set
to "ApPlE"
+ And the "sql.args.2.value" property of the UpdateAttribute processor is
set to "BaNaNa"
+ And a ExecuteSQL processor with the "SQL select query" property set to
"SELECT * FROM test_table2 WHERE "tExT_Col" = ? OR "tExT_Col" = ? ORDER BY
int_col DESC"
Review comment:
We could add a comment that PostgreSQL's quoted columns marking case
sensitive queries just to be clear.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
