missing divide by zero error

Adam Baratz <[email protected]> Wed, 14 Sep 2016 16:50:08 -0400
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CADxrgCMW3J8xn7Sht8iVPhSKzG8OUOum_k5=zO50jhFVWLC3iQ@mail.gmail.com>
I'm running into an issue where a "SELECT 1/0" query returns a NULL result
instead of an error. I attached the relevant snippet from the TDSDUMP
output (the packet continues with some host information). The result is
coming back as TDS7_RESULT instead of ERROR, but part of it includes the
error message. I took a look at the appropriate spec[1], but I'm having
trouble understanding the format. Does anyone have thoughts on what's going
on? I'm using MSSQL with TDS 7.2.

Thanks,
Adam

---
[1] http://www.freetds.org/tds.html#t129

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
div0.log (application/octet-stream, 1 KB)
util.c:165:Changed query state from IDLE to WRITING
util.c:165:Changed query state from WRITING to PENDING
packet.c:741:Sending packet
0000 01 01 00 32 00 00 01 00-16 00 00 00 12 00 00 00 |...2.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 53 00 |........ ......S.|
0020 45 00 4c 00 45 00 43 00-54 00 20 00 31 00 2f 00 |E.L.E.C. T. .1./.|
0030 30 00                  -                        |0.|

dblib.c:4637:dbsqlok(0x1e81e10)
dblib.c:4666:dbsqlok() not done, calling tds_process_tokens()
token.c:525:tds_process_tokens(0x1e82690, 0x7fffffffa598, 0x7fffffffa59c, 0x6914)
util.c:165:Changed query state from PENDING to READING
packet.c:639:Received packet
0000 04 01 00 7c 01 7f 01 00-81 01 00 00 00 00 00 21 |...|.... .......!|
0010 00 26 04 00 d1 00 ab 56-00 17 0e 00 00 00 00 1a |.&.....V ........|
0020 00 44 00 69 00 76 00 69-00 73 00 69 00 6f 00 6e |.D.i.v.i .s.i.o.n|
0030 00 20 00 62 00 79 00 20-00 7a 00 65 00 72 00 6f |. .b.y.  .z.e.r.o|
0040 00 20 00 6f 00 63 00 63-00 75 00 72 00 72 00 65 |. .o.c.c .u.r.r.e|