About the db<>fiddle TopAnswers Community - db<>fiddle

TopAnswers db<>fiddle

Meta

Databases

TeX

Code Golf

APL

C++

.net

db<>fiddle

Java

*nix

PHP

PowerShell

Python

Rust

टेक्-मराठी

Typst

Web Client Dev

Web Server Dev

About the db<>fiddle TopAnswers Community

Blog

add tag

Jack Douglas

This TopAnswers community is for [db<>fiddle](https://dbfiddle.uk), for:

* [documentation](/fiddle?search=%7Bdocumentation%7D)
* concrete feature requests
* bug reports 

To post a bug report or feature request:

1. Join TopAnswers (sign up is one-click and PII free)
1. Click 'Ask'

comments

transcript

Anonymous 12828

Is it possible to get current TimescaleDB 2.13?  
Just tried use dbfiddle to report a daylight savings bug that only occurs  on 2.13.

Jack Douglas

I haven't tested with 8.1 / 8.2 / 8.3 to see if they are the same

Jack Douglas

looking at the 'type' it's coming back as 252 which is TINYBLOB - maybe this is by design, no idea why

Jack Douglas

I don't know why they are set for this column - I guess a bug somewhere but I don't know at what level and haven't found anything useful on Google

Jack Douglas

if both BLOB_FLAG and BINARY_FLAG are set db<>fiddle will convert to hex before outputing

Jack Douglas replying to Anonymous 12331

I'm using these flags to determine if a column contains binary data: https://github.com/google/mysql/blob/master/include/mysql_com.h#L133

Anonymous 12331

Running the same locally, I get  the actual types, as expected

mysql> show columns from test;  
+-------------+-----------------+------+-----+---------+----------------+  
| Field       | Type            | Null | Key | Default | Extra          |  
+-------------+-----------------+------+-----+---------+----------------+  
| aint        | int unsigned    | NO   |     | NULL    |                |  
| atinyint    | tinyint         | YES  |     | NULL    |                |  
| asmallint   | smallint        | YES  |     | NULL    |                |  
| amediumint  | mediumint       | YES  |     | NULL    |                |  
| abigint     | bigint          | YES  |     | NULL    |                |  
| aserial     | bigint unsigned | NO   | PRI | NULL    | auto_increment |  
| achar100    | char(100)       | YES  |     | NULL    |                |  
| avarchar100 | varchar(100)    | YES  |     | NULL    |                |  
| atext       | text            | YES  |     | NULL    |                |  
+-------------+-----------------+------+-----+---------+----------------+

Anonymous 12331 replying to Anonymous 11902

Yes, really strange these COLUMN_TYPE values displayed as hex hashes instead of the actual textual representation - https://dbfiddle.uk/bowmYFq6 (works fine with MySQL 5.x, problem only occurs with 8.0

Anonymous 11902

https://dbfiddle.uk/u74tlw8_  it has type = 626967696e74  ??? should that not be `BIGINT(20)` ?

Anonymous 11440

```  
DECLARE
    num NUMBER := 10;    num2 NUMBER := 10;

BEGIN
    DBMS_OUTPUT.put_line('The value of num is: ' || num);
DBMS_OUTPUT.put_line('The value of num is: ' || num2);
END;
-- running this on oracle without this comment causes it to error
`

Anonymous 10648

You deserve sainthood for such an amazing service. Thankss from the bottom of my heart ❤️

Anonymous 10252

deleted

Anonymous 10252

deleted

Jack Douglas replying to Anonymous 9130

thanks there seems to be an issue I haven't seen before - I'm trying to resolve it but it's a bit of trial and error I'm afraid

Jack Douglas replying to Anonymous 8668

not possible, sorry - we don't want external dependancies

Anonymous 8668

AWS postgresql (Redshift) behaves differently, such as not having the pg_sleep() function.

I would like it to be included in the DB if possible.

Jack Douglas replying to Anonymous 6128

It's had a few notifications of downtime today which I ignored as they didn't last long - but I just took a closer look and have given the VM a reboot - it looks much healthier now.

Anonymous 6128

hello! is dbfiddle for postgresql version 14 down at the moment? I keep getting failed runs on pages that worked well yesterday

Jack Douglas replying to Anonymous 5863

ctrl+Z might work for you if this happens again

Anonymous 5863

Oh nevermind. A miracle happened and my page refreshed with the cell. If someone did it on purpose, thank you

Anonymous 5863

I have just deleted a very important cell containing a huge procedure and i'm searching a way to undo the action

Anonymous 5863

Good evening, is there a way to undo a cell action?

Jack Douglas

see the instructions in the post opposite!

Jack Douglas replying to Anonymous 5500

for db<>fiddle? You can add a feature request on this site

Anonymous 5500

Please consider adding Dark Mode if possible. Thank you

Jack Douglas replying to Anonymous 4411

sure, see [this fiddle](https://staging.dbfiddle.uk/9BSK6nMa) for example

Anonymous 4411

Hi, is there a way to use PL/SQL?

Anonymous 4378

Добрый вечер!  только присоединилась к изучению SQL. Попыталась создать запрос, выдает ошибку: Msg 208 Level 16 State 1 Line 1
Invalid object name 'skill_countries'.

Jack Douglas replying to Anonymous 4114

thanks, now fixed

Anonymous 4114

Just another report that all engines are down.  Run just spins, then reports "run failed".

Anonymous 4081

Seems like all engines are not working on DBFiddle?

Anonymous 4048

The Oracle database 21c is not working already for several days

Jack Douglas replying to Anonymous 3586

Thanks - I really need to get my monitoring fixed after the recent rewrite. All the Windows SQL Server backends are now working again now.

Anonymous 3586

Is the backend down? Getting "run failed" errors on all requests today. Tried different PC, OS, and browser to rule out a client side problem. Console shows 500 Internal Server Error coming back from the POST. Was working fine yesterday.

Jack Douglas replying to Anonymous 2523

can you post a link to the fiddle, I'm having trouble working out what this relates to?

Anonymous 2523

@Jack, re: [your question](#question), Msg 207, Level 16, State 1, Line 23
Invalid column name 'Level'.
Msg 207, Level 16, State 1, Line 18
Invalid column name 'Level'.
Msg 205, Level 16, State 1, Line 1
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

Bergi replying to depesz

I just filed [bug 2119](https://topanswers.xyz/fiddle?q=2119) on this issue

Skillmon replying to Jack Douglas

sounds good to me :)

Jack Douglas replying to Skillmon

I've discovered I can't easily add an http->http redirect on AWS HTTP Gateway - I'd need to rearchitect things with CloudFront in front. What I've done instead is add HSTS headers that mean that if you visit the https page once at least it will switch to https automatically from then on. My reading of the tea leaves makes me think browsers will all start auto-upgrading to https in the near future anyway so I'm not too bothered about this.

Jack Douglas replying to Vérace

Each fiddle gets a random binary string and that's converted to base64url (a variant of base64)

Jack Douglas replying to Vérace

The load on the servers isn't really an issue, especially with more of the engines on Firecracker now. It's very kind of you to offer to donate but we aren't taking donations - you are welcome to donate to a charity I help run (https://www.justgiving.com/maidenheadcentre) but please don't feel in any way obliged. If you work for a company that might be interested in advertising on db<>fiddle that's what we are looking for in the long term!

Jack Douglas

I will look into fixing that

Jack Douglas

oh I see, the http redirect doesn't work anymore, try https

Jack Douglas replying to Skillmon

which engine are you trying to use? it looks ok to me

Skillmon

@Jack dbfiddle.uk seems down.

Vérace replying to Jack Douglas

And this absolutely great - it means I can write War and Peace after my URL if I want to! :-) Probably an edge(-ish) case (not War and Peace - but including server and/or version with fiddle URL) but potentially handy for comparing servers and versions - anonymous strings are easily confused! What's the encoding that you're using for the strings?

Vérace replying to Jack Douglas

Great stuff - I forgot about those little widgets to the top left - exactly what I was looking for!

Jack Douglas replying to Vérace

about the optional string, db<>fiddle currently ignores parts of the query string that it doesn't recognise, so you can already do this for example: https://dbfiddle.uk/Ho4tsJ0s?pg14-mydemo

Jack Douglas

produces:  
![blob](/image?hash=e7f34971ec4cc4f4b76dd03d9c1f7a325eaf52c6b736b7553ffd0b1668d1e2f0)

Jack Douglas replying to Vérace

![blob](/image?hash=100263cb8f89bcae2415b2f68a583c7b48ee9a08e1fe754c8fc456da9fe6001a)