Why ejabberd_sql does not support dynamic table name insertion

[skrleo]

I tried spool sub-table processing, and found that ejabberd_sql can't? SQL_INSERT, the following is my code

insert_into_spool({LUser, LServer, LStatus, XML}) ->
    {Year, Month, _} = erlang:timestamp(),
    TableName = lists:concat(["spool_", integer_to_list(Year), "_", integer_to_list(Month)]),
    ?INFO_MSG("TableName == ~s", [TableName]),
    case ejabberd_sql:sql_query(
        LServer,
        ?SQL_INSERT(
        TableName,
        ["username=%(LUser)s",
        "server_host=%(LServer)s",
            "status=%(LStatus)s",
        "xml=%(XML)s"])) of
    {updated, _} ->
        ok;
    _ ->
        {error, db_failure}
    end.

[prefiks]

Those ?SQL* macros are converted to erlang code, that's why they only accept literals - this needs to be expanded to code, before rest of that code is run. You will probably need to switch to using literal string in this case.