az sql db update doesn't work if --edition Basic --service-objective Basic

[francesco1119]

Type of issue

Code doesn't work

Reference command name

I use az sql db update quite a lot as I have a script that scale databases.

I have no problem running it and scale Azure SQL Database to whatever tier like:

az sql db update -s MyServer -g MyResourceGroup -n MyDatabase --edition Standard --service-objective S2 --subscription "MySubscription"

Problems arrive when I run something like:

az sql db update -s MyServer -g MyResourceGroup -n MyDatabase --edition Basic --service-objective Basic --subscription "MySubscription"

In that case the database won't scale and returns the error:

Error | ERROR: (InvalidMaxSizeTierCombination) The tier 'Basic' does not support the database max size '268435456000'.

But then I scale from S0 to Basic form the Portal and everything works fine.

You don't believe it?

Look at this picture

Feedback

There is a bug in the AZ SQL module when scaling to Basic.
For all other edition and tier there is no problem

Page URL

https://learn.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-update

Content source URL

https://github.com/MicrosoftDocs/azure-docs-cli/blob/main/docs-ref-autogen/Latest-version/latest/sql/db.yml

Author

@mikefrobbins

Document Id

4c91220f-45c6-84de-2473-07c1cd296beb

[yonzhan]

Thank you for opening this issue, we will look into it.

[francesco1119]

FYI, I'm running Az 13.4.0.
I've been scaling SQL Databases to Basic tier for 3 years now with the same script and I've never seen the problem.
As you can see from the picture the error also appears in the Portal.
This makes me think that something might have changed in the backend.

[francesco1119]

The command works if you add:

--edition Basic --capacity 5 --max-size 2GB

At the end of the command.

Weird. It wasn't like that before.