Major Description
1. SELECT orderlines[1], count
AS count FROM orders where test_id = "agg_func" GROUP BY orderlines[1] ORDER BY count
produces entries with key "*" instead of "$1"
2. select `between`(10,5,15),`between`(10,15,25) FROM scratch
Syntax error from the between function
3. SELECT atan(unitPrice/10) as uP FROM product where test_id = "numberfunc" ORDER BY uP ASC limit 20
Results incorrect, looks very suspicious (two spurious 0.0 at the beginning?)
4. select LOWER(ccInfo) as cclo FROM customer where test_id="str_func" ORDER by firstName limit 5
null vs missing problem again that needs analysis (or possibly an ordering problem)
5. select REGEXP_CONTAINS("Thisisabigsubquery","query") as regex FROM scratch
Syntax error at FROM? Weird
6. SELECT REPLACE('SQL SQL SQL', 'S', 'N1', -1) as negative_n, REPLACE('SQL SQL SQL', 'S', 'N1', 2) as replace_2, REPLACE('SQL SQL SQL', 'S', 'N1') as replace_all FROM scratch
No replace function? Syntax error at Replace
7. select IS_ARRAY(null) FROM scratch
Should return null, but returns false? It seems like Server is actually expecting IS to use the 4 value logic as well UGHHHHH