typeCast and prepared statement

[LMnet]

I found that typeCast parameter in query didn't work with prepared statements.
Here is my example:

mysql.query(
    'SELECT * FROM `editions_schedule` WHERE `edition_id` = 1', 
    function(err, result){
        console.log(result); //works fine
});

mysql.query(
    'SELECT * FROM `editions_schedule` WHERE `edition_id` = ?', 
    [1], 
    function(err, result){
        console.log(result); //works fine
});

mysql.query(
    {
        sql: 'SELECT * FROM `editions_schedule` WHERE `edition_id` = 1', 
        typeCast: false
    }, 
    function(err, result){
        console.log(result); //works fine
});

mysql.query(
    {
        sql: 'SELECT * FROM `editions_schedule` WHERE `edition_id` = ?', 
        typeCast: false
    }, 
    [1], 
    function(err, result){
        console.log(result);
        //error:
        // TypeError: Object 1 has no method 'apply'
        // at Query.Sequence.end (/mydir/node_modules/mysql/lib/protocol/sequences/Sequence.js:66:24)
        // at Query._handleFinalResultPacket (/mydir/node_modules/mysql/lib/protocol/sequences/Query.js:139:8)
        // at Query.EofPacket (/mydir/node_modules/mysql/lib/protocol/sequences/Query.js:123:8)
        // at Protocol._parsePacket (/mydir/node_modules/mysql/lib/protocol/Protocol.js:169:24)
        // at Parser.write (/mydir/node_modules/mysql/lib/protocol/Parser.js:62:12)
        // at Protocol.write (/mydir/node_modules/mysql/lib/protocol/Protocol.js:36:16)
        // at Socket.ondata (stream.js:38:26)
        // at Socket.EventEmitter.emit (events.js:93:17)
        // at TCP.onread (net.js:396:14)
});

[dougwilson]

You'll want to invoke it as the following:

mysql.query(
  {
    sql: 'SELECT * FROM `editions_schedule` WHERE `edition_id` = ?',
    values: [1],
    typeCast: false
  }, 
  function(err, result){
    console.log(result); //works fine
});

[LMnet]

Thanks for that, but I think, at least, it must be in the manual.

[dresende]

Actually, it should be possible to do the way you wrote. I'm going to change .query() to allow it.

[dresende]

Please try the latest git commit.

[LMnet]

It works fine, thanks for help.