Saltar al contenido ForoHackers

SQLite 3.47 can tell me WHICH attendance figure offended it. May I keep the adjectives?

Código abiertoSQLPruebas
#16382 · · Citar · Denunciar

My toy attendance sheet accepts zero through eight players. A trigger used to raise the literal message 'out of range'. Today's SQLite 3.47.0 permits an expression for the RAISE error message. I gave it nine and would like it to say 'count 9 exceeds 8'. My older test copy objected to the expression before any player had had a chance to exceed anything.

#16638 · · Citar · Denunciar

What value would somebody at the till need to correct the entry? In our payroll imports it's often just the offending quantity and allowed range. Including the entire row would make a much livelier privacy problem.

#16639 · · Citar · Denunciar

Count and maximum. No team names, no names of players. The team's nine-year-old looking over my shoulder has requested the adjective preposterous. The nine adults have declined.

#16640 · · Citar · Denunciar

Para la prueba positiva intenta también 8, que sí cabe. No vaya a ser que se pasen la tarde celebrando un mensaje muy bueno que se carga al octavo jugador legítimo.

#16641 · · Citar · Denunciar

Yes: eight accepted, nine refused. The expression is 'count ' || NEW.n || ' exceeds 8' as the error message in the high-end branch. Low-end branch can still have the perfectly serviceable literal 'negative count'.

#16642 · · Citar · Denunciar

Is there a test for zero? Here at the Society of People Waiting For The Other Seven Players we've developed a strong interest.

#16643 · · Citar · Denunciar

Zero accepted. We're counting attendees; nobody coming is terribly realistic. It would be less helpful to forbid the only number I've personally verified by looking at an entirely empty room.

#16644 · · Citar · Denunciar

The feature was added in 3.47.0. Keep a literal-string fallback or require that version where you deploy it. The release notes are short enough to read during halftime: https://www.sqlite.org/releaselog/3_47_0.html

No has iniciado sesión, así que esto se publica como anónimo: no se guarda con ello ninguna cuenta, nombre ni dirección, y no puede llevar enlaces ni imágenes. Inicia sesión o únete para publicar con tu nombre. Los registros de nuestro servidor web guardan la dirección y la hora de cada petición hasta 14 días; para que la tuya no quede en ellos, usa Tor. Para escribir al equipo de forma confidencial, usa el buzón. Firmar como fuente habitual (una clave guardada solo en este navegador)

Enviar tarda unos segundos aquí: tu navegador resuelve antes una prueba de trabajo contra el spam.

Responder