Skip to Content.
Sympa Menu

freetds - Boolean data problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Tom Moore" <nospam AT spatial.ca>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Boolean data problem
  • Date: Tue, 15 May 2001 15:27:47 -0400


Hi I am trying to read a boolean data field from a MS SQLServer 2000
database.

I am using the current FreeTDS 'snapshot' source code that has
modifications as recent as 8/4/2001.

If I include a boolean field in a query I get numerous errors on stderr
that look similar to "Unknown marker: 0!!", where the numeric value varies
between 0, 10, 78, 101, 105 etc.

If I use the trick suggested previously "cast(BoolField as int) BoolField"
the query works fine.

I created a tdsdump file, and the first are attached at the bottom.

I am willing to help debug and fix this problem, but I don't know where to
start and I'll need lots of pointers.

Regards,

Tom

---- TDSDUMP output ---------

2001-05-16 04:23:27 Connecting addr x.x.x.x port 1433
Sending packet @ 2001-05-16 04:23:27
0000 10 01 00 de 00 00 01 00 d6 00 00 00 00 00 00 70 |...Þ....Ö......p|
0010 00 00 00 00 00 00 00 06 83 f2 f8 ff 00 00 00 00 |.........òøÿ....|
0020 e0 03 00 00 88 ff ff ff 36 04 00 00 56 00 00 00 |à....ÿÿÿ6...V...|
0030 56 00 08 00 66 00 07 00 74 00 0a 00 88 00 05 00 |V...f...t.......|
snip!
0090 63 00 6f 00 66 00 66 00 73 00 43 00 54 00 2d 00 |c.o.f.f.s.C.T.-.|
00a0 4c 00 69 00 62 00 72 00 61 00 72 00 79 00 4e 54 |L.i.b.r.a.r.y.NT|
00b0 4c 4d 53 53 50 00 01 00 00 00 06 82 00 00 00 00 |LMSSP...........|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00d0 00 00 30 00 00 00 00 00 00 00 30 00 00 00 |..0.......0...|


2001-05-16 04:23:27 inside tds_process_login_tokens()
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is e3
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is ab
2001-05-16 04:23:27 Msg 5701, Level 0, State 2, Server SMS_COFFS, Line 0
Changed database context to 'HPTracking'.
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is e3
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is ab
2001-05-16 04:23:27 Msg 5703, Level 0, State 1, Server SMS_COFFS, Line 0
Changed language setting to us_english.
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is e3
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is e3
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is e3
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is e3
2001-05-16 04:23:27 increasing block size from 4096 to 4096
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is fd
2001-05-16 04:23:27 leaving tds_process_login_tokens() returning 1
2001-05-16 04:23:27 leaving ct_connect() returning 1
2001-05-16 04:23:27 inside ct_options()
2001-05-16 04:23:27 inside ct_cmd_alloc()
2001-05-16 04:23:27 inside ct_command()
2001-05-16 04:23:27 inside ct_send()
Sending packet @ 2001-05-16 04:23:27
0000 01 01 00 c0 00 00 01 00 73 00 65 00 6c 00 65 00 |...À....s.e.l.e.|
0010 63 00 74 00 20 00 43 00 6f 00 6e 00 74 00 72 00 |c.t. .C.o.n.t.r.|
0020 61 00 63 00 74 00 6f 00 72 00 49 00 44 00 2c 00 |a.c.t.o.r.I.D.,.|
0030 43 00 6f 00 6e 00 74 00 72 00 61 00 63 00 74 00 |C.o.n.t.r.a.c.t.|
0040 6f 00 72 00 4e 00 61 00 6d 00 65 00 2c 00 53 00 |o.r.N.a.m.e.,.S.|
0050 74 00 61 00 74 00 75 00 73 00 20 00 66 00 72 00 |t.a.t.u.s. .f.r.|
0060 6f 00 6d 00 20 00 75 00 74 00 43 00 6f 00 6e 00 |o.m. .u.t.C.o.n.|
0070 74 00 72 00 61 00 63 00 74 00 6f 00 72 00 20 00 |t.r.a.c.t.o.r. .|
0080 63 00 20 00 6f 00 72 00 64 00 65 00 72 00 20 00 |c. .o.r.d.e.r. .|
0090 62 00 79 00 20 00 63 00 2e 00 52 00 43 00 2c 00 |b.y. .c...R.C.,.|
00a0 63 00 2e 00 43 00 6f 00 6e 00 74 00 72 00 61 00 |c...C.o.n.t.r.a.|
00b0 63 00 74 00 6f 00 72 00 4e 00 61 00 6d 00 65 00 |c.t.o.r.N.a.m.e.|


2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 81
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 74
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 74
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 61
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 61
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 74
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 74
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 75
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 75
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 73
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 73
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is a9
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is a9
2001-05-16 04:23:27 processing result tokens. marker is d1
2001-05-16 04:23:27 processing result tokens. marker is 8
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 8
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 74
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 74
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 65
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 65
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 73
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 73
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 0
2001-05-16 04:23:27 inside tds_process_default_tokens() marker is 0
2001-05-16 04:23:27 inside ct_results()
2001-05-16 04:23:27 processing result tokens. marker is 74




Archive powered by MHonArc 2.6.24.

Top of Page