4.1.2 > 4.1.3 break indexedDB queries

[dougroutledge]

It seems every working query is now broken with the last update. Most used the DATE() operator against iso js dates.

[mathiasrw]

Oh no!

Can you help identify an example of something that was working before that is returning something different now?

[dougroutledge]

Here is an example.

SELECT 
	userDisplayName AS Name, COUNT(*) AS Val FROM callhistory 

WHERE 
	callType='ucap_in' 
	AND DATE(startDateTime) > DATE('" + today.toISOString().split('T')[0] +"') 

GROUP BY userDisplayName

[paulrutter]

@dougroutledge not a solution, but you can now also use CURRENT_DATE() so you no longer need the js code to extract the date without time.

Since 4.5.0