search

fukamachi / cl-dbi

Database independent interface for Common Lisp
202 stars 28 forks source link

unexpected behaviour in insert-into #72

Closed jnc-nj closed 3 years ago

jnc-nj commented 3 years ago

#<SXQL-STATEMENT: INSERT INTO `assets` (`content`, `history`, `description`, `tags`, `callsign`, `asset_id`, `create_time`, `update_time`) VALUES (1, '', '', '', 'test', 'khzjAW+3tId6g6lm8AK0Qw==', '2021-08-13T14:02:21.550229+08:00', '2021-08-13T14:02:21.550229+08:00') ON DUPLICATE KEY UPDATE `id` = `id`> the above, when processed with dbi:prepare and dbi:execute does not insert into the database as expected i'm getting munged row of

id, asset_id, callsign, history, content, tags, description, create_time, update_time
472, , , 2021-08-13T14:02:21.550229+08:00, 2021-08-13T14:02:21.550229+08:00, test, khzjAW+3tId6g6lm8AK0Qw==, , 1

i'll see if there's a fix in the afternoon, seems to be an issue with how the sql statement is being sent to the client