Turn off ".returning() is not supported by mysql and will not have any effect."

[facku]

Hi. I'm using Adonis v4.1 with mysql (MariaDb). How i can disable/turn off the following message in console when I run migrations and seeders:

.returning() is not supported by mysql and will not have any effect.´

Thanks a lot.

[benknight]

I'm also seeing this issue. It appears to be happening in node_modules/@adonis/lucid/src/Model/index.js line 644 (@adonis/lucid@6.2.0). The insert query is always chains a .returning call a knex insert query which knex triggers a warning for if you're using mysql. Unfortunately just have to ignore it but it's polluting my console with hundreds of warnings which is quite frustrating.

[thetutlage]

Mind sharing a PR for the fix?

[benknight]

Sure I'll give it a swing

[benknight]

I tried and failed to fix this.

adonisjs/lucid#571 (comment)

[woodgates]

I don't know why but I started receiving this message on almost every query. This happened this month after doing a npm install . Very annoying.

[Agilulfo1820]

Same problem. Very annoying and I'm also filling CloudWatch logs basically only with this warning.

[benknight]

Update - this has been fixed as of v6.2.1

[benknight]

@facku @Agilulfo1820 @woodgates fyi ^

[Agilulfo1820]

Do you refer to lucid version 6.2.1? Because I downloaded that version of lucid but still have this issue :(

EDIT: Everything works perfectly! Thank you guys!

[woodgates]

@benknight thanks for heads up! I updated lucid and for the first minutes I don't get the error

[mritg]

@benknight For me still i am getting warnings about either 6.2.1 or, the latest