search

cweijan / vscode-database-client

Database Client For Visual Studio Code
https://database-client.com
MIT License
2.39k stars 264 forks source link

[BUG]Setting default value error #1175

Closed SoFTCureOrigin closed 2 weeks ago

SoFTCureOrigin commented 3 weeks ago

setting CURRENT_TIMESTAMP to datetime using ix is set like this : "current_timestamp()" --> (conn:32, no: 1067, SQLState: 42000) Invalid default value for ....

Sould be "CURRENT_TIMESTAMP"

MariaDB 10.11.6

cweijan commented 2 weeks ago

This is not a client problem, you need to change the "current_timestamp()" in your SQL to "CURRENT_TIMESTAMP"