Does D1 support `ALTER TABLE RENAME COLUMN`? It seems to be failing with `not authorized to use func

Does D1 support

ALTER TABLE RENAME COLUMN

ALTER TABLE RENAME COLUMN

ALTER TABLE RENAME COLUMN

ALTER TABLE RENAME COLUMN? It seems to be failing with

not authorized to use function: sqlite_rename_test

not authorized to use function: sqlite_rename_test

not authorized to use function: sqlite_rename_test

not authorized to use function: sqlite_rename_test...

itsmatteomanfOP•6/3/23, 10:21 AM

You should also be able to do .schema my_table.schema my_table, but it returns a syntax error, at least in the console.

lokiwind•6/3/23, 10:35 AM

Hello.
I created a table. And this table will have three headers
key-time-value
a key will be recorded in this table as follows:
TESTKEY123-00:00:30-0
Is it possible to make the time value automatically change the value value to 1 after 30 seconds

lokiwind•6/3/23, 10:37 AM

After 30 seconds, the line will look like this.
TESTKEY123-00:00:00-1

MMatt Silverlock If you run into any other limits (we revised them all) let me know - they aren't...

Jason Hostetter•6/3/23, 11:25 AM

Are there any plans to increase the maximum expression depth of 20? I am refactoring to try and get around that limit but will wait if it’s going to change

Iitsmatteomanf You should also be able to do `.schema my_table`, but it returns a syntax error,...

Max (@rozenmd)•6/3/23, 2:20 PM

console as in the dashboard console?

MMax (@rozenmd)console as in the dashboard console?

Max (@rozenmd)•6/3/23, 2:20 PM

if so I can add it

MMax (@rozenmd)console as in the dashboard console?

itsmatteomanfOP•6/3/23, 2:20 PM

Yes…

itsmatteomanfOP•6/3/23, 2:20 PM

Not sure how that would work in the JS API given the weird formatting of the result.

Iitsmatteomanf Yes…

Max (@rozenmd)•6/3/23, 2:21 PM

(i want to add the same console into wrangler)

MMax (@rozenmd)(i want to add the same console into wrangler)

itsmatteomanfOP•6/3/23, 2:21 PM

That’s be nice, especially if you need to copy things.

Iitsmatteomanf Does D1 support `ALTER TABLE RENAME COLUMN`? It seems to be failing with `not au...

itsmatteomanfOP•6/3/23, 2:23 PM

I think you missed this, @rozenmd

that’s the bigger issue, but I’m not sure what’s the version of SQLite that D1 is based upon

Iitsmatteomanf I think you missed this, @rozenmd 🙂 that’s the bigger issue, but I’m not sure w...

Max (@rozenmd)•6/3/23, 2:24 PM

might be another function we didn't whitelist, do you mind adding an issue to workerd?

MMax (@rozenmd)might be another function we didn't whitelist, do you mind adding an issue to wo...

itsmatteomanfOP•6/3/23, 2:24 PM

Will do

Iitsmatteomanf Will do 🙂

itsmatteomanfOP•6/3/23, 2:32 PM

Done, https://github.com/cloudflare/workerd/issues/729

GitHub

🐛 Bug Report — Runtime APIs: : D1 Does Not Allow `ALTER TABLE RENAM...

The Experimental Backend doesn't allow using ALTER TABLE RENAME COLUMN which should be supported in latest SQLite.

Iitsmatteomanf Done, https://github.com/cloudflare/workerd/issues/729

Matt Silverlock•6/3/23, 3:18 PM

d1-database

MMatt Silverlock https://discord.com/channels/595317990191398933/992060581832032316/1109973517182...

itsmatteomanfOP•6/3/23, 3:18 PM

Oh, sorry… I tried searching, but resulted in nothing NotLikeThis

itsmatteomanfOP•6/3/23, 3:19 PM

Discord search is so bad

Llokiwind Hello. I created a table. And this table will have three headers **key-time-va...

lokiwind•6/3/23, 3:36 PM

I need some help with this. MeowHeartCloudflare

Llokiwind I need some help with this. <:MeowHeartCloudflare:897193652089155645> 🤔

itsmatteomanfOP•6/3/23, 3:36 PM

In which sense "automatically" change?

lokiwind•6/3/23, 3:37 PM

I want a saved data to update itself after 30 seconds

itsmatteomanfOP•6/3/23, 3:38 PM

Oh yeah, then that's not possible.

itsmatteomanfOP•6/3/23, 3:38 PM

You need to do a query to update it.

itsmatteomanfOP•6/3/23, 3:38 PM

It's SQLite after all...

lokiwind•6/3/23, 3:39 PM

How can I make a query for this?
Can you give advice

lokiwind•6/3/23, 3:41 PM

The time of recording the data are all different from each other

lokiwind•6/3/23, 3:41 PM

When I send a request every 30 seconds this will not work some data will change earlier

Zzszszsz I don't understand the problem. And I don't understand why.

lokiwind•6/3/23, 3:43 PM

Are you talking to me?

Llokiwind After 30 seconds, the line will look like this. **TESTKEY123-00:00:00-1**

lokiwind•6/3/23, 3:44 PM

I explained in detail here

lokiwind•6/3/23, 3:47 PM

I will explain in a simple way

lokiwind•6/3/23, 3:48 PM

Let's say I saved data with a value of 1 in a table with D1

lokiwind•6/3/23, 3:49 PM

I want this 1 value to be updated to 0 after 30 seconds

lokiwind•6/3/23, 3:50 PM

Required for my project

lokiwind•6/3/23, 3:50 PM

To set a key time

lokiwind•6/3/23, 3:51 PM

I just want to replace the expired value, that's all.

lokiwind•6/3/23, 3:53 PM

Hmm

lokiwind•6/3/23, 3:54 PM

Thank you, I will try

Zzszszsz hmm is it really what you want ?

lokiwind•6/3/23, 4:06 PM

If he can do what I want him to do.

yeehow•6/3/23, 5:16 PM

Running into this error (using Drizzle ORM)

Error: D1_ERROR
    at D1Database._send (index.js:2874:13)
    at async D1PreparedStatement.raw (index.js:2945:7)
    at async PreparedQuery2.all (index.js:2367:18)
    at async index.js:2761:18
    at async Object.handle [as fetch] (index.js:21:30) {
  stack: Error: D1_ERROR
    at D1Database._send (index.js:…t async Object.handle [as fetch] (index.js:21:30),
  message: D1_ERROR,
  cause: Error: Error: too many arguments on function json_array
    at D1Database._send (index.js:2875:16)
…
}

Error: D1_ERROR
    at D1Database._send (index.js:2874:13)
    at async D1PreparedStatement.raw (index.js:2945:7)
    at async PreparedQuery2.all (index.js:2367:18)
    at async index.js:2761:18
    at async Object.handle [as fetch] (index.js:21:30) {
  stack: Error: D1_ERROR
    at D1Database._send (index.js:…t async Object.handle [as fetch] (index.js:21:30),
  message: D1_ERROR,
  cause: Error: Error: too many arguments on function json_array
    at D1Database._send (index.js:2875:16)
…
}

Works fine when running locally, but gives this error when running remotely or deployed.

Leads me to believe D1 has a lower

json_array()

json_array()

argument limit than standard SQLite?
From my testing it seams to only work with up to 8 arguments.

Just a theory. Don't really know what I'm doing

Yyeehow Running into this error (using Drizzle ORM) ``` Error: D1_ERROR at D1Databas...

Matt Silverlock•6/3/23, 5:21 PM

https://developers.cloudflare.com/d1/platform/limits/

(Function arguments are being bumped to 32 in the next week)

Limits · Cloudflare D1 docs

Many of these limits will increase during D1’s public alpha. Join the #d1-open-alpha channel in the Cloudflare Developer Discord to keep up to date …

Does D1 support `ALTER TABLE RENAME COLUMN`? It seems to be failing with `not authorized to use func

Similar Threads

Similar Threads

Similar Threads