Previous x Days but got an error for now() function

Get Help
1

I got an error while using Previous x Days to create chart on Apache Doris using MySQL driver to connect Metabase.
It cause by using now() function , added a number as a parameter : now(6)

Here's the error details
errCode = 2, detailMessage = No matching function with signature: now(tinyint(4)).

Here's the sql metabase parse:

    SELECT `token_price_daily_all`.`day` AS `day`, `token_price_daily_all`.`on_date` AS `on_date`, `token_price_daily_all`.`token_address` AS `token_address`, `token_price_daily_all`.`chain` AS `chain`, `token_price_daily_all`.`token_symbol` AS `token_symbol`, `token_price_daily_all`.`price` AS `price`
FROM `token_price_daily_all`
WHERE (`token_price_daily_all`.`day` >= date(date_add(now(6), INTERVAL -3 day))
   AND `token_price_daily_all`.`day` < date(now(6)))
LIMIT 1048575

day column is Date type.

1650188305610
16501883056102646×1192 250 KB

thanks in adavance for any idea how to deal with it ?

2

Hi @Wade
Post "Diagnostic Info" from Admin > Troubleshooting.

3

{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.79 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "4.19.91-25.6.al7.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"bigquery-cloud-sdk",
"h2",
"mongo",
"postgres",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.18"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {},
"settings": {
"report-timezone": null
}
}
}

4

@Wade I have no idea which version of Metabase you are using, but it's some custom build. Try using an official release.
If you need Metabase to function with some dialect version of MySQL, then you might need to create your own custom driver instead.

5

I'm using 0.41.5

6

it related to these few lines
and it seems we need to modify them as new driver

7

When I changed the following code, I found that this case can be applied, and the result changed from now(6) to now().

origin:
(hsql/call :now 6))

changed:
(hsql/call :now))