db<>fiddle - TopAnswers

Anonymous 13704

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!

Anonymous 13704

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.

PeterVandivier

i've been getting "Run Failed" trying to create new fiddles from yesterday

Anonymous 13589

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

Anonymous 13589

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!

John K N

https://dbfiddle.uk/YuAX1REn

John K N

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

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

Andriy M

hi

Anonymous 7711

hi~

kus

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 :D

Paul White

spatial never worked in db<>fiddle afaik

Paul White

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

PeterVandivier

nbd on either, thanks for the reply on both :smile:

Jack Douglas replying to PeterVandivier

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

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

PeterVandivier

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

@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?

PeterVandivier

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

PeterVandivier

:+1:

Jack Douglas replying to PeterVandivier

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!

PeterVandivier

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

Jack Douglas

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

Jack Douglas

I will check :)

Jack Douglas

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

Jack Douglas replying to PeterVandivier

ahhhh

PeterVandivier

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](/image?hash=a38b7b16abb2dd4cd4d023d74bcdb07301bcab7b3b8f685a5d72fa361e2428bf)

Jack Douglas

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

Jack Douglas replying to PeterVandivier

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

PeterVandivier

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

Jack Douglas

I enabled stars on regular questions here