Chris Demmings
Chris Demmings
The method names of the class are sorted to a point, then it starts over again. (unless this is intended behavior). You can see in this example, it is sorted...
So ``` =gsSQL("select * from booksales where Date > '5/3/2022' ", "booksales", BookSales!A1:H) ``` is including records with TEXT CHARACTERS in the Date column. My comparisons to mySQL don't have...
In order for my tests to always work, I added this as a test for dateDiff() so that it would always return '7'. There is something wrong with the ROUNDING....
* Getting a warning about a regex used to extract ORDER BY * Not currently causing any problems, other than a warning. ``` Make sure the regex used here, which...
Although I have some end to end tests which I run in SHEETS after making changes, they are limited and don't check things which might be going wrong - but...
* An enhancement over the Google Sheets QUERY() function. * All common SQL SELECT syntax is supported. * For more information about using: https://github.com/demmings/gsSQL * Basic use: ``` =gsSQL( SelectSqlStatement,...
If there is only ONE stock in the range of stock tickers as input, it returns an error. Although there is CACHEFINANCE() was was meant to handle only one stock,...
The SUM() aggregate fields will return the correct values if used as the single source of info for the select field, but it fails when a calculation is done using...
``` =gsSQL("select sum(net_income_from_taxable) as 'Net Income from Taxable', sum(gross_taxable_income) as 'Total Gross Income' from income where age > ?1 and age
Implicit SELF JOIN is not supported. `select A.name as custname1, B.name as custname2 from customers as A, customers as B where A.id B.id ` This statement does not work with...