saurabhd336 opened a new pull request, #11502: URL: https://github.com/apache/pinot/pull/11502
TPCH's query 24 https://github.com/apache/pinot/blob/master/pinot-integration-tests/src/test/resources/tpch/24.sql fails due to pinot's `substring` definition being different from standard sql definition. As per https://www.postgresql.org/docs/15/functions-string.html ``` substring ( string text [ FROM start integer ] [ FOR count integer ] ) → text Extracts the substring of string starting at the start'th character if that is specified, and stopping after count characters if that is specified. Provide at least one of start and count. substring('Thomas' from 2 for 3) → hom substring('Thomas' from 3) → omas substring('Thomas' for 2) → Th ``` This change fixes the tpch query, but introduces a backward-incopatible change. Will wait for reviews. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
