Fixed CI test failure because env variable value contains |
Different CI have different env variable settings. Previous commit works
on some platforms, however failed on others.
For test cases robustness, here I don't seperate 'variable=value' to 2
columns, just process the whole row as one column.
@@ -112,9 +112,9 @@ drop external table check_env;
-- end_ignore
CREATE EXTERNAL WEB TABLE table_env (name TEXT, val TEXT )
- EXECUTE E'env | sed ''s/=/|/''' ON SEGMENT 0
- FORMAT 'TEXT' (DELIMITER '|');
-SELECT name, val FROM table_env WHERE name LIKE 'GP_QUERY%' ORDER BY name ASC;
+ EXECUTE E'env' ON SEGMENT 0
+ FORMAT 'TEXT';
+SELECT * FROM table_env WHERE val LIKE 'GP_QUERY%' ORDER BY val ASC;
-- --------------------------------------
-- some negative tests
