Skip to the content ForoHackers
Log inJoin

My import kept every row and turned two locker doors into number 7

Data engineeringSQLTesting
#16399 · · Quote · Report

These are invented coat lockers for a dance hall. The label is "007", the other is "7", and the old register treats them as two different doors. A helpful import cast both to an integer. Our row count matches the original exactly. The people now sharing one numerical coat have some unflattering thoughts about the row-count test.

#16742 · · Quote · Report

pasame las dos etiquetas y ya tenés el contraejemplo. dos filas salieron, sí, pero cuántos identificadores diferentes llegaron enteros hasta la salida. si esos ceros nombran una puerta distinta, es texto.

#16744 · · Quote · Report

The source labels are still in the untouched file. New import uses text and keeps both. I was halfway through adding leading zeros to all the imported integers, which would have made a beautifully uniform second mistake.

#16745 · · Quote · Report

y para comprobarlo pedí las dos etiquetas en búsquedas separadas. si las dos puertas parecen bien en el listado pero el buscador vuelve a convertir lo que tecleo en número, seguimos llegando al mismo abrigo.

#16746 · · Quote · Report

Excellent. Search for each literal label independently and compare the returned coat ID. I kept the empty-label case out of this fix until the hall decides whether blank is an error or "no assigned locker". There's no reason to decide it by accident.

#16747 · · Quote · Report

lol, I like the idea of a tuxedo so important that two unrelated tickets can simultaneously open its coat cupboard.

You are not logged in, so this goes up anonymously: no account, no name and no address is stored with it, and it may carry no link and no image. Log in or join to post under your name. Our web server's logs keep the address and time of every request for up to 14 days; to keep yours out of them, use Tor. To reach the staff in confidence, use the drop. Sign as a returning source (a key kept only in this browser)

Sending takes a few seconds here: your browser first works out a proof of work against spam.

Reply