From: Maurício Linhares (linhares.mauriciogmail.com)
Date: Thu May 16 2013 - 08:40:31 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello everyone,

I'm sending a COM_EXECUTE_STMT message and the server returns an:

Error 1048 - #23000 - Column 'number_tinyint' cannot be null

The query is like this:

insert into numbers (
number_tinyint,
number_smallint,
number_mediumint,
number_int,
number_bigint,
number_decimal,
number_float,
number_double
) values
(
?, 679, 778, 875468, 100007654, 198.657809, 432.8, ?)

And what I send in is:

0: 18 00 00 00 17 01 00 00 . . . . . . . .
1: 00 00 01 00 00 00 00 00 . . . . . . . .
2: 01 01 05 0a 29 5c 8f c2 . . . . ) \ . .
3: f5 b0 58 40 . . X

18 00 00 00 - size
00 - sequence
17 - type
01 00 00 00 - statement id
00 - flags
01 00 00 00 - iteration-count
00 00 - null bitmap
01 - new params bound flag
01 - byte type
05 - double type
0a - byte value - 10
29 5c 8f c2 f5 b0 58 40 - double value

The statement parameters are 10 (for the tinyint column) and 98.765
(for the double column). From what I can see the message is encoded
correctly but it always fails for some reason.

Am I missing something in here?

-
Maurício Linhares
http://mauricio.github.io/ - http://twitter.com/#!/mauriciojr

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]