The Heap™ – Consultancy ©®

12:13 AM

0

SQL, 18 Demonstration with PostgreSQL SELECT b-a FROM t; You can create the dataset with CREATE TABLE t AS SELECT a::time,b::time FROM(VALUES('0:00','0:01'),('0:55','1:00'),('1:45','3:15'))ASt(a,b);

hot2use

6:22 AM

@ypercubeᵀᴹ Meta: Flagging question that has open bounty? A: ...This is clearly off-topic, but I cannot VtC; can the bounty be removed and the question closed please?

McNets

6:49 AM

G.Morning

hot2use

7:10 AM

and a good morning to you too.

Paul White

7:23 AM

ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications (PDF) via Jeremiah Peschka.

> users can buy a single gift card, then spend it an unlimited number of times by concurrently issuing checkout requests.

Jack Douglas

→ 1 message moved to Trash

Philᵀᴹ

8:06 AM

Schoolboy error, that. I remember (back in the day) a site that stored prices in-page when you went to checkout an order. You could just edit the HTML of the page and submit! Got fixed pretty sharpish

ypercubeᵀᴹ

I think there was some bitcoin operator that had a similar issue.

One could double spend his bitcoins

Philᵀᴹ

Yeah, read about that on HN a few weeks ago

Tom V

@ypercubeᵀᴹ That one didn't get eventually consistent

dezso

@ypercubeᵀᴹ it's actually mentioned in the article

dezso

8:40 AM

@JackDouglas did someone point marc_s to Aaron's meta post you were referring to?

ypercubeᵀᴹ

@TomV the bitcoin algorithm was ok. But they had implemented their wallet handling in PHP and Mongo, or something similar.

@dezso ah thnx, I didn't find time to read that one yet.

McNets

washingtonpost.com/news/wonk/wp/2017/03/28/…

Starving?

Tom V

8:58 AM

@ypercubeᵀᴹ They overdrew the accounts before the balance was updated or something similar

Paul White

9:21 AM

> As a result of this attack, all Bitcoins stored in the Flexcoin exchange were stolen, all users lost their stored Bitcoins, and the exchange was forced to shut down.

@dezso We've asked him to slow down a bit.

dezso

@PaulWhite very good, thank you

hot2use

10:50 AM

I commented on the following Question: dba.stackexchange.com/q/167452/15356

Doesn't help much that Brent's Pastetheplan links have an expiration date.

McNets

It's a 11 day old question. How many days can a plan be saved?

hot2use

@McNets I haven't the foggiest. I asked Brent via online form.

Andriy M

11:30 AM

@hot2use The OP replaced the link an hour ago. The old link works for me.

Looks like they just removed a couple of characters from the middle of the ID.

Tom V

I wish I didn't click that link

Andriy M

For plans like that a ▲ button is not enough, there should be a ◄ one as well.

hot2use

11:51 AM

@AndriyM Strange. Brent just mailed to let me know that the link is still in the short form in the question.

I went into edit history and the old link works.

Tom V

@hot2use the link in the question is working now :)

Andriy M

@hot2use It was. I wasn't very clear, sorry. You noticed the issue after the OP changed the link. Their new link didn't work, the old one (which Tom has just restored) did.

hot2use

@AndriyM thumbs-up

Andriy M

My guess is they deliberately corrupted it, although if they wished to remove it from the question, they could have done just that.

Philᵀᴹ

0

Q: import csv in SAP HANA

I am trying to push my crawled data in HANA. So far, when I do the import, I can't find how I can map each value I have with a separate column. What is the proper way to map those records in HANA table? do I have to do a software for the mapping ? -I already created a table in HANA and have name...

It's taken the OP a week to get that far (see previous question)

I'd just give in

hot2use

12:04 PM

@TomV and of course for redacting the question thumbs-up

Tom V

@hot2use You'll soon be able to do that yourself

hot2use

@TomV I know. I'm doing my best to achieve brilliance. (Top 4% this quarter)

2

"When the going get's tough, the tough get going"

hot2use

12:38 PM

@TomV I know what you mean

Joe Obbish

1:26 PM

I can write up an answer to that question tonight, hopefully

Tom V

@JoeObbish The HANA one? Maybe you should post a stub and delete it before the question gets closed

Joe Obbish

@TomV No, the one where the plan expired

Master Database

2:27 PM

0

Q: Questions posed by brand-new members that are abandoned

First post on meta so, if i'm "doin' it wrong", I apologize. I wanted to ask about the handling of questions with the following conditions: - Question raised by brand new member ( < 10 reputation? ) - Answers provided that address issue - New member never bothers accepting an answer and closing ...

discussion

McNets

2:50 PM

Every time I use dbfiddle, I wonder what a new surprise I'll find.

Microsoft SQL Server 2005 XML Showplan

Master Database

3:00 PM

0

Q: Closure reason - "RDBMS Not Specified"

Day after day we see many questions that do not have a RDBMS tagged, which got me thinking (a miracle, I know) - Why don't we have a custom closure reason of "RDBMS Not Specified" added?

feature-request

Paul White

Is there a special badge for asking meta questions today or something?

billinkc

Maybe you should ask that of meta and find out

2

Paul White

3:29 PM

Apr 25 '14 at 16:48, by Andriy M

Meta²

Philᵀᴹ

Metaception

billinkc

And thus it was recorded, the Immaculate Metaception occurred in year of our lord, twenty and seventeen

McNets

Amen

Paul White

@billinkc The year 37?

Joe Obbish

Jesus reappeared in 1980

billinkc

3:41 PM

@PaulWhite Filthy bad at maths kangaroo lover

Joe Obbish

had to start counting again

Paul White

Ah that explains it.

@billinkc You pasted your password by mistake.

4

billinkc

SOMEONE CALL THE PARAMEDICS. PAUL HAS MADE A MODERN POP CULTURE REFERENCE AND MY HEART ... CAN'T TAKE IT

Joe Obbish

is xkcd considered pop culture?

billinkc

In kookaburra land, it is. Or will be once they get internets

Philᵀᴹ

4:03 PM

Reminds me of bash.org/?244321

6

Jack Douglas

6:30 PM

Pretty SQL Server plans, courtesy of the same library PTP uses: dbfiddle.uk/…

6

Max Vernon

@JackDouglas NICE!

billinkc

> Hebrew and Arabic are both written Right to Left, however when I do a substring for the first character in Arabic I get the leftmost one, but Hebrew gives me the rightmost one

McNets

@JackDouglas I've commented it before, nice.

billinkc

1

Q: Moving to Unicode - Questions about how it works

I've been tasked with getting us ready for to go to Unicode for various character sets including Chinese, Russian, and Korean. One of the things that I'm focusing on is SSIS. I've tested a simple lookup, and it works fine. But now I'm running into questions about these languages. Can you do an ...

sql-server ssis

Oh happy days of being a dumb merican

Lamak

@JackDouglas you need to use set statistics xml on; to make it appear?

Jack Douglas

6:59 PM

@Lamak yes, does that seem strange?

@McNets so you have :)

Lamak

@JackDouglas nope

Jack Douglas

good :)

McNets

Help will be appreciated. Can't I use MAX / MIN on a CTE results? dbfiddle.uk/…

It's a counting consecutive days solution.

There is a missing ,

Jack Douglas

^^^ this is comedy gold

@JackDouglas it's fantastic! good job. Line numbering is useful if the error message may report the line causing the error. — McNets Feb 24 at 16:53

you were entirely correct about the line numbering, as it turns out ;)

McNets

7:16 PM

@JackDouglas yes, but sometimes I'm not able to see a single ',' ;)

Jack Douglas

@McNets you could commit heresy and put them at the start: dbfiddle.uk/…

Joe Obbish

@JackDouglas Paul White being chatty in the comments? Someone should flag those!

Paul White

Meta is different.

Joe Obbish

that was quick

McNets

@JackDouglas this is what usually do...at work!! But I've adopted the most usual format (IMO) on dba.se

Paul White

7:20 PM

I lurk

Lamak

@McNets my opinion of you just changed

;)

Paul White

Meta is all about discussion.

McNets

@Lamak to better I hope...

;)

Paul White

@JackDouglas Relatively few people will know the command. Almost everyone will be used to using a keyboard shortcut or toolbar icon

Lamak

@McNets commas at the start of the line?, that's how satan writes his code

Joe Obbish

7:25 PM

I know. I still think that there is some humor to be had since you crack down on comments pretty hard on the main site

Paul White

On mobile so I haven't checked it out yet

@JoeObbish Totally fair

😎

ypercubeᵀᴹ

@JoeObbish will you provide the query in that question?

Joe Obbish

@ypercubeᵀᴹ I'm not able to provide the query. Can provide snippets if it would be helpful.

I think that it's not needed but I can see why people would ask. if I was answering someone's question I would probably ask

Max Vernon

@PaulWhite honestly, I for one, have never typed in the command. I am aware of it, but hey [CTRL-M].

Paul White

It's not one I find easy to remember. Too many similar options.

Joe Obbish

7:36 PM

I click the little button every time

Paul White

I'm surprised my CTRL and L keys haven't worn out 😀

Joe Obbish

that's why they give us two CTRL keys

3

Lamak

and no ANY key

Max Vernon

@Lamak I'm gonna write a SQL formatter that always puts the commas at the beginning of the line. And turns spaces into tabs.

2

Paul White

Noooooooooo

Lamak

7:39 PM

@MaxVernon that's just evil

To start press any key. The Simpsons

►

2

Max Vernon

21

Q: Stop expanding tabs into four spaces

Do we need to change all tabs into four spaces? A while back I proposed a code golf specific feature request. I now come to this community to discuss how this feature may be interesting to many sites throughout the network. In sites that are not technologically oriented tabulation may present a...