Unable to create an index on the AdventureWorks sample database 1
bug
2 years ago Paul White
NULL rowversion displayed as 0x 8 3
bug
(edited, 2 years ago) 2 years ago Paul White
2 This is still not fixed despite installing all available Windows updates.
2 years ago Jack Douglas
Code collapsing issue 7 2
bug
2 years ago Akina
0 Updating CodeMirror to the latest version has fixed this issue.
2 years ago Jack Douglas
Multiple space characters truncated to one space character in results pane 1 3
bug
(edited, 2 years ago) 2 years ago Anonymous 2508
0 This is now fixed with white-space: pre;
2 years ago Jack Douglas
Embedded fiddles no longer work 8 3
bug
2 years ago PeterVandivier
rdbms url parameter is no longer working 2
bug
(edited, 2 years ago) 2 years ago Bergi
1 I’ve tweaked the new UI so existing bookmarks like this will now work.
2 years ago Jack Douglas
DB<>Fiddle is down - Error 500 2
bug
3 years ago User 1791
1 It must have been a short or localised outage.
3 years ago Jack Douglas
Results with columns using a custom object type are not displayed (Oracle) 2 2
bug
(edited, 3 years ago) 3 years ago Truilus
1 Another option might be to use the Oracle 21c fiddle, instead of 18c, since 21c has the JSON_OBJECT function:
(edited, 3 years ago) 3 years ago User 1791
1 Would it help to display the object name?
(edited, 3 years ago) 3 years ago User 1791
db<>fiddle's markdown formatting
bug
3 years ago User 1791
All Oracle 21c fiddles are failing: "Run failed" 1
bug fixed
(edited, 3 years ago) 3 years ago User 1791
1 All working again now, the engine VM needed a reboot.
3 years ago Jack Douglas
chat
transcript
2 days
Jack Douglas — Last Monday 18:16

I’ve switched it back as the current behavious isn’t very helpful either

2 hours
Jack Douglas — Last Monday 16:11

I agree the current behavious is also odd though

Jack Douglas — Last Monday 16:11

I could reverse this - but I wonder how many people found it hard to insert a tab char

2 months
Anonymous 13704 — Wednesday, 15th Jan 2025 21:01

When I say “advances the line by a tab” - it does this even when the cursor is at the end of the line - it’s weird!

a day
Anonymous 13704 — Tuesday, 14th Jan 2025 12:21

Hi - there appears to be a change in the behaviour of the tab key - now it doesn’t bring you to the next snippet, but rather it advances the line by a tab. Not sure about anyone else, but I really like keyboard navigation and it’s handy to tab through snippets! This happens at least with PostgreSQL and also with MySQL - haven’t tested other servers, but it looks like a page/site issue rather than anything to do with any particular RDBMS.

4 months
PeterVandivier — Friday, 20th Sep 2024 19:20

i’ve been getting “Run Failed” trying to create new fiddles from yesterday

a month
Anonymous 13589 — Monday, 19th Aug 2024 16:49

Tried to reproduce - but can’t. Will keep an eye on it - sorry to have bothered you!

2 hours
Anonymous 13589 — Monday, 19th Aug 2024 14:42

There appears to be a problem with (at least) the PostgreSQL fiddles - I make changes but they appear to keep reverting back to previous versions - https://dbfiddle.uk/UkakOPQr - I tried labelling one of the snippets (Snippet 8) to demonstrate, but even that won’t stay in the fiddle - try changing LIKE to = in the first SQL query - or try changing the LIMIT from 10 to 5 - doesn’t persist either - my SQL has become all messed up with some changes apparently persisting and others not!

3 months
John K N — Tuesday, 14th May 2024 14:36

https://dbfiddle.uk/YuAX1REn

John K N — Tuesday, 14th May 2024 14:36

Msg 1101 Level 17 State 12 Line 1 Could not allocate a new page for database ‘fiddle_18db0a5382d849b2a8cf9f9addf716f8’ because of insufficient disk space in filegroup ‘PRIMARY’. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

John K N — Tuesday, 14th May 2024 14:35

Hi Jack. Was trying to repro something on dbfiddle.uk and got an error message.

a year
Andriy M — Friday, 16th Jun 2023 10:19

hi

Anonymous 7711 — Friday, 16th Jun 2023 10:11

hi~

a year
kus — Monday, 18th Jul 2022 14:24

Good morning, have you guys ever been so sure that there is a bug but then you try to create an scccccccce (can never remember the number of c’s in there) and you cannot reproduce the bug that you were so sure of 😄

3 hours
Paul White — Monday, 18th Jul 2022 11:01

spatial never worked in db<>fiddle afaik

Paul White — Monday, 18th Jul 2022 11:00

@Jack Run failed message for any query on SQL Server 2019 (Windows) using the AdventureWorks sample db

6 days
PeterVandivier — Tuesday, 12th Jul 2022 17:53

nbd on either, thanks for the reply on both 😄

21 minutes
Jack Douglas replying to PeterVandivier — Tuesday, 12th Jul 2022 17:32

yes, I wasn’t sure anyone used that so I got rid of it — the idea was to add some documentation posts here with examples of how best to show stats for the different engines. I haven’t got round to that though. It’s on my list now!

Jack Douglas replying to PeterVandivier — Tuesday, 12th Jul 2022 17:30

I can’t remember about spatial results tbh, Paul might know

15 hours
PeterVandivier — Tuesday, 12th Jul 2022 02:31

been trying to find a fiddle example on and off for a few weeks when i think about it but figured i’d be better off just asking

PeterVandivier replying to Jack Douglas — Tuesday, 12th Jul 2022 02:31

@Jack am i misremembering or did there used to be a little “gear” icon for fiddle batches that would set stats io, time for sql server and enable explain for postgres or something along those lines?

5 days
PeterVandivier — Wednesday, 6th Jul 2022 20:35

am i misremembering or did db<>fiddle used to render spatial results for SQL server? https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=89fbead71bffc811affd33786ae76084

trying the query from http://slavasql.blogspot.com/2015/09/draw-american-flag-in-ssms-using.html

14 days
PeterVandivier — Wednesday, 22nd Jun 2022 19:43

👍

34 minutes
Jack Douglas replying to PeterVandivier — Wednesday, 22nd Jun 2022 19:09

yes, and I don’t think there is any need to exclude them anywhere any more, it was just when we were getting a lot on meta - I’ve tweaked so they are now showing, thanks!

12 minutes
PeterVandivier — Wednesday, 22nd Jun 2022 18:58

I remembered they were excluded for the meta channel. I figured the db<>fiddle channel was mainly for feature-requests though

Jack Douglas — Wednesday, 22nd Jun 2022 18:50

The search is @+ {}{code golf}{blog}[!bug][!feature-request]

Jack Douglas — Wednesday, 22nd Jun 2022 18:46

I will check 😃

Jack Douglas — Wednesday, 22nd Jun 2022 18:46

I can’t remember what the driteria are for showing on the home page

Jack Douglas replying to PeterVandivier — Wednesday, 22nd Jun 2022 18:46

ahhhh

a day
PeterVandivier — Tuesday, 21st Jun 2022 20:42

this is what i see on the home page (logged in). Qs 2039 & 2045 are visible. Qs 2038 & 2040 are not, despite sorting higher by last modification date

blob

24 minutes
Jack Douglas — Tuesday, 21st Jun 2022 20:18

If you wat to see them on dba.ta etc you can use cross-community feeds

Jack Douglas replying to PeterVandivier — Tuesday, 21st Jun 2022 20:18

I can see them both logged in and anonymously. Do you mean the main feed on this page?

a day
PeterVandivier — Monday, 20th Jun 2022 16:46

looks like feature-request tagged posts here are excluded from the main feed, possibly an oversight?

3 days
Jack Douglas — Friday, 17th Jun 2022 17:16

I enabled stars on regular questions here

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.