ChatGPT is now finding bugs in databases • Hacker News Board

Re: ChatGPT is now finding bugs in databases

#31

Post by Juliate » Fri, Mar 10, 2023, 2:17 AM UTC

ramraj07 wrote: post #15

endisneigh wrote: post #10

Earlier quoted context omitted.

> I just cant believe how much better it made my day. Wait until how great your day will become when you’re unnecessary ;).

People are always made unnecessary. The smart ones then find other ways in which they are. Not sure how this is any different.

Not necessarily different, but the day software tech people get treated as disposable rather than rare (as they are very much today), it’s gonna be a rather … peculiar cultural shift to experience (for people, the industry, states).

Re: ChatGPT is now finding bugs in databases

#32

Post by creatonez » Fri, Mar 10, 2023, 2:18 AM UTC

swatcoder wrote: post #9

crazysim wrote: post #3

ChatGPT can't access the external internet. The example ChatGPT instruction where they "teach it" just has the user giving it a URL to their docs and ChatGPT is like "oh ok got it" (Figure 3). I'm not sure if the blog post writers are aware it's hallucinating what the JSON implementation is and hasn't actually read the documentation at all.

Hah. Of course the authors are not aware. OpenAI handed this tool to people with effectively no guidance or instructions so that they can trade on the glow of misconceptions and harvest user data. The whole point of giving the thing away for free these last few months is to let people make fools of themselves like this while pumping up OpenAI’s value as a technology firm. It’s no accident that they don’t engage to cl…

This is baseless speculation

Re: ChatGPT is now finding bugs in databases

#33

Post by grej » Fri, Mar 10, 2023, 2:18 AM UTC

ChatGPT did something today I had never thought to do.

I needed to extract info out of a page with quick and dirty js. I always just copy and paste the data after console log. But this time, I used ChatGPT. Gave it an example of the html and told it how I wanted the csv.

It wrote code that made the csv, but then also created a Blob with the right mime from it and an anchor element, appended the anchor element to the document and called the click() to download the csv direct! Mind blown. Makes me wonder how many other simple things I just have never thought to do but ChatGPT will uncover.

Re: ChatGPT is now finding bugs in databases

#34

Post by buglungtung » Fri, Mar 10, 2023, 2:19 AM UTC

ldjkfkdsjnv wrote: post #5

Today at work I hadnt used apache spark in a long time. I needed to do some quick and dirty data analytics on large datasets. Rather than read documentation, I just put the queries i needed in english into chatGPT, and it spit out perfectly working code. The queries werent that complex, but it saved me hours googling a bunch of random spark SQL syntax. The old school way is google sends you links, and through those c…

Really like your idea because sometime I just want a "just work" solution to verify my idea. Then I can optimize it later if I need

Re: ChatGPT is now finding bugs in databases

#35

Post by HideousKojima » Fri, Mar 10, 2023, 2:20 AM UTC

goatlover wrote: post #17

swatcoder wrote: post #9

Earlier quoted context omitted.

Hah. Of course the authors are not aware. OpenAI handed this tool to people with effectively no guidance or instructions so that they can trade on the glow of misconceptions and harvest user data. The whole point of giving the thing away for free these last few months is to let people make fools of themselves like this while pumping up OpenAI’s value as a technology firm. It’s no accident that they don’t engage to cl…

The concern is the increasing number of anecdotes where people are taking ChatGPT's output at face value, even though everyone knows by now that it does sometimes get stuff wrong and does hallucinate. I thought it would take longer.

A very annoying trend I've already started noticing on some forums (including here unfortunately) is someone asking a question and one of the replies is someone saying "I put your question into ChatGPT and it said..."

Re: ChatGPT is now finding bugs in databases

#36

Post by [deleted] » Fri, Mar 10, 2023, 2:21 AM UTC

swatcoder wrote: post #9

crazysim wrote: post #3

ChatGPT can't access the external internet. The example ChatGPT instruction where they "teach it" just has the user giving it a URL to their docs and ChatGPT is like "oh ok got it" (Figure 3). I'm not sure if the blog post writers are aware it's hallucinating what the JSON implementation is and hasn't actually read the documentation at all.

Hah. Of course the authors are not aware. OpenAI handed this tool to people with effectively no guidance or instructions so that they can trade on the glow of misconceptions and harvest user data. The whole point of giving the thing away for free these last few months is to let people make fools of themselves like this while pumping up OpenAI’s value as a technology firm. It’s no accident that they don’t engage to cl…

[deleted]

Re: ChatGPT is now finding bugs in databases

#37

Post by endisneigh » Fri, Mar 10, 2023, 2:22 AM UTC

ramraj07 wrote: post #15

endisneigh wrote: post #10

Earlier quoted context omitted.

> I just cant believe how much better it made my day. Wait until how great your day will become when you’re unnecessary ;).

People are always made unnecessary. The smart ones then find other ways in which they are. Not sure how this is any different.

What we are discussing is something that removes the need for problem solving. What will the supposed smart do if there’s a magical machine that can solve all problems that can be represented as text?

Re: ChatGPT is now finding bugs in databases

#38

Post by jahsome » Fri, Mar 10, 2023, 2:23 AM UTC

ceejayoz wrote: post #4

crazysim wrote: post #3

ChatGPT can't access the external internet. The example ChatGPT instruction where they "teach it" just has the user giving it a URL to their docs and ChatGPT is like "oh ok got it" (Figure 3). I'm not sure if the blog post writers are aware it's hallucinating what the JSON implementation is and hasn't actually read the documentation at all.

> The example ChatGPT instruction where they "teach it" just has the user giving it a URL to their docs and ChatGPT is like "oh ok got it". Yep. I asked it to summarize a URL. It happily invented something completely fabricated and convincing sounding (until you go to the URL) based of the domain name and article slug.

I asked it to generate me documentation for a handful Bicep definitions and include links to the official Microsoft Docs. It generated about 50% erroneous links, but once I updated my prompt and fed it the "root" of the MS docs I wanted it to use, it was able to correct all the urls.

At the time it _seemed_ like it wasn't just doing a mindless string replace, because different parts of the url changed on most of the erroneous links. I figured it wasn't going out and spidering the link I gave, but it led me to believe maybe there was _some_ form of index that it simply hadn't prioritized prior, but was able to do with the additional context.

Re: ChatGPT is now finding bugs in databases

#39

Post by rhaway84773 » Fri, Mar 10, 2023, 2:23 AM UTC

taberiand wrote: post #26

micromacrofoot wrote: post #6

Earlier quoted context omitted.

we’ve made the startling discovery that we’re rather predictable

My hypothesis is that we will soon see the emergence of a super-human artificial intelligence, not because of some astounding breakthroughs in our understanding of intelligence, but because of irrefutable proof that humans just aren't all that complicated to surpass.

I think this is right.

Setting aside the creativity aspect (ie where do brand new ideas come from), which is a minuscule fraction of human thought, I suspect we are good pattern matching machines with the ability of extrapolation.

I think with sufficient data that computers can understand, this is eminently replicable.

Re: ChatGPT is now finding bugs in databases

#40

Post by honeybadger1 » Fri, Mar 10, 2023, 2:24 AM UTC

nextaccountic wrote: post #13

crazysim wrote: post #3

ChatGPT can't access the external internet. The example ChatGPT instruction where they "teach it" just has the user giving it a URL to their docs and ChatGPT is like "oh ok got it" (Figure 3). I'm not sure if the blog post writers are aware it's hallucinating what the JSON implementation is and hasn't actually read the documentation at all.

> ChatGPT can't access the external internet. ChatGPT by itself can't but if you build a product on top of its API, you can fetch the url itself and send the data in the ChatGPT's prompt

It also can be prompted to read the contents of a webpage, I have used it to help me craft a regex expression for removing junk utilizing invoke-webrequest to parse out CPU models compatible with 22H2 upgrades from Microsoft(that page did not exist in 2021).