Anyone else getting this when trying to use the experimental backend for new D1 databases? `not aut

Anyone else getting this when trying to use the experimental backend for new D1 databases?

not authorized to use function: strftime

not authorized to use function: strftime

Murder ChickenOP•5/30/23, 7:54 PM

Works locally and worked with old DBs. Tried to create a copy of my DB with the experimental backend and I'm now getting this error.

MMurder Chicken Anyone else getting this when trying to use the experimental backend for new D1 ...

Max (@rozenmd)•5/30/23, 8:01 PM

can you file an issue against workerd? https://github.com/cloudflare/workerd/issues
we're gradually allow-listing functions and may have missed a few

MMax (@rozenmd)can you file an issue against workerd? https://github.com/cloudflare/workerd/iss...

Murder ChickenOP•5/30/23, 8:02 PM

Will do that right now!

MMax (@rozenmd)can you file an issue against workerd? https://github.com/cloudflare/workerd/iss...

Murder ChickenOP•5/30/23, 8:07 PM

Any expectation on how long that'll take to make it in? Curious if I should roll back to my old DB and write batching functions instead (which is why I was trying a move to the new backend).

itsmatteomanf•5/30/23, 8:12 PM

Any specific reasoning why

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

works when using it as the default for a column in the schema, but fails when used in any kind of statement (with a "not authorized")?

itsmatteomanf•5/30/23, 8:14 PM

To note, a works fine in the statement.

MMurder Chicken Any expectation on how long that'll take to make it in? Curious if I should rol...

Max (@rozenmd)•5/30/23, 8:17 PM

it depends if it's a standard thing we missed - CC: @elithrar

MMurder Chicken Any expectation on how long that'll take to make it in? Curious if I should rol...

Matt Silverlock•5/30/23, 9:11 PM

No faster than a week.

kian•5/30/23, 9:36 PM

A random guess is that the D1 shim seems to do some ArrayBuffer conversions of it's own (https://github.com/cloudflare/workers-sdk/blob/main/packages/wrangler/templates/d1-beta-facade.js#L112-L149)

itsmatteomanf•5/31/23, 7:36 AM

Are foreign keys actually supported? It accepts them in the schema, but it doesn't enforce them, at all.

itsmatteomanf•5/31/23, 10:06 AM

Yeah, I know SQLite supports that, but they specifically state that the command is supported in the docs.

itsmatteomanf•5/31/23, 10:07 AM

https://developers.cloudflare.com/d1/platform/client-api/#pragma-statements

Iitsmatteomanf Any specific reasoning why `CURRENT_TIMESTAMP` works when using it as the defaul...

itsmatteomanf•5/31/23, 10:09 AM

I saw your

, @rozenmd, can I expect it to work at some point or not? Just to design the schema and Workers accordingly.

Iitsmatteomanf I saw your 🤔, @rozenmd, can I expect it to work at some point or not? Just to d...

Max (@rozenmd)•5/31/23, 10:12 AM

let me ask internally, I'm not sure

Iitsmatteomanf Any specific reasoning why `CURRENT_TIMESTAMP` works when using it as the defaul...

Max (@rozenmd)•5/31/23, 12:20 PM

can you file a github issue for this in workerd? https://github.com/cloudflare/workerd/issues

Ttobias I was trying to run a migration with following content. ```sql CREATE VIRTUAL TA...

Max (@rozenmd)•5/31/23, 12:23 PM

can you rerun it with

fts5

fts5

instead of

FTS5

FTS5

? looks like a bug

MMax (@rozenmd)can you file a github issue for this in workerd? https://github.com/cloudflare/w...

itsmatteomanf•5/31/23, 12:31 PM

https://github.com/cloudflare/workerd/issues/718

GitHub

🐛 Bug Report — Runtime APIs: D1 Does Not Allow `CURRENT_TIMESTAMP` ...

The Experimental Backend doesn't allow using CURRENT_TIMESTAMP when running any type of query. It's supported perfectly when it's set as default value for a column.

Lleonhma does anyone know whether D1 supports the unixepoch expression? (`createdAt integ...

Matt Silverlock•5/31/23, 1:07 PM

unixepoch

unixepoch

is supported. Does that create table statement work outside of D1? Usually you can’t have functions like that.

Matt Silverlock•5/31/23, 1:14 PM

https://github.com/cloudflare/workerd/blob/bc3fc4cdd309dccc553e18240ef432a39f53d5eb/src/workerd/util/sqlite.c%2B%2B#L171 (the function is typo’ed on the allowlist)

GitHub

workerd/sqlite.c++ at bc3fc4cdd309dccc553e18240ef432a39f53d5eb · cl...

The JavaScript / Wasm runtime that powers Cloudflare Workers - workerd/sqlite.c++ at bc3fc4cdd309dccc553e18240ef432a39f53d5eb · cloudflare/workerd

Lleonhma can you not in sqlite? I am quite new to this database stuff but I swear I saw s...

Matt Silverlock•5/31/23, 1:14 PM

Not at my computer so asking, otherwise I’d test.

Lleonhma does anyone know whether D1 supports the unixepoch expression? (`createdAt integ...

Max (@rozenmd)•5/31/23, 1:21 PM

what are you using to insert btw?

a basic example seems to work:

Lleonhma okay so i tested this again this time using the wrangler cli and a small repro d...

Max (@rozenmd)•5/31/23, 1:46 PM

default backend or experimental btw?

Max (@rozenmd)•5/31/23, 1:47 PM

ah okay I'll try again on the default, I just tested on the experimental one

Max (@rozenmd)•5/31/23, 1:53 PM

oh ok

Lleonhma okay it works now too on cf pages. No idea why it suddenly works. Sorry to waste...

Max (@rozenmd)•5/31/23, 2:05 PM

not a waste, always worth double checking these things

lokiwind•5/31/23, 2:24 PM

@elithrar @rozenmd I wrote a code for D1. However, this code gives the following error when there are too many requests:

{
    "message": "Error while checking rows: Error: D1_ERROR\n    at D1Database._send (worker.js:149:13)\n    at async D1PreparedStatement.all (worker.js:215:7)\n    at async Object.fetch (worker.js:11:18)"
}

{
    "message": "Error while checking rows: Error: D1_ERROR\n    at D1Database._send (worker.js:149:13)\n    at async D1PreparedStatement.all (worker.js:215:7)\n    at async Object.fetch (worker.js:11:18)"
}

Can I send the code via pm?
NOT:*It works with few users. but it does not work when there are many instant requests.