Window function fails with many-to-one relationship

SELECT    `table1`.`id`,
          `table1_table2`.`data` AS `table2`
FROM      `table1`
LEFT JOIN lateral
          (
                 SELECT coalesce(json_arrayagg(json_array(`table1_table2`. `id`, `table1_table2`.`id_tbl1`, `table1_table2`.`my_number`, sum(`table1_table2`.`my_number`) over(partition BY `table1_table2`.`id`))), json_array()) AS `data`
                 FROM   `table2` `table1_table2`
                 WHERE  `table1_table2`.`id_tbl1` = `table1`.`id`) `table1_table2`
ON        TRUE

export const table1 = mysqlTable('table1', {
  id: int('id').primaryKey().autoincrement()
});

export const table2 = mysqlTable('table2', {
  id: int('id').primaryKey().autoincrement(),
  table1Id: int('id_tbl1').notNull(),
  myNumber: int('my_number')
});


export const table1Relations = relations(table1, ({one, many}) => ({
    table2: many(table2),
}));

export const table2Relations = relations(table2, ({one}) => ({
  table1: one(table1, {
    fields: [table2.table1Id],
    references: [table1.id]
  })
}));

const qb = db.query.table1.findMany({
    with: {
        table2: {
            extras: {
                sumNumber: sql<number>`SUM(${schema.table2.myNumber}) OVER(partition by ${schema.table2.id})`.as('sumNumber')
            }
        }
    }
}).prepare().execute();