ALTER TABLE UPDATE statement run without default database #750

Activity

1. zhicwu commented on Oct 21, 2021

   

   zhicwu

   on Oct 21, 2021

   Contributor

   More actions

   Sorry about the inconvenience. Currently no option for this - I can think of two workarounds: 1) use full qualified name in your query; 2) multi-statement script(e.g. use yourdb; alert table update...)
2. zhicwu

   added

   bug

   on Nov 28, 2021
3. zhicwu

   added this to the 0.3.2 Release milestone on Nov 28, 2021
4. zhicwu commented on Nov 28, 2021

   

   zhicwu

   on Nov 28, 2021

   Contributor

   More actions

   This has been fixed in develop branch. Make sure you use the new JDBC driver com.clickhouse.jdbc.ClickHouseDriver.

   alter table test_date update ndate='2021-11-10' where ndate is null;
   
   -- same as alter table test_date update ndate='2021-11-11' where no = 0 settings mutations_sync=1
   update test_date set ndate='2021-11-11' where no = 0
5. zhicwu

   linked a pull request that will close this issueNew JDBC driver #747on Nov 28, 2021
6. zhicwu

   self-assigned this

   on Nov 28, 2021
7. welyss commented on Nov 29, 2021

   

   welyss

   on Nov 29, 2021

   Author

   More actions

   thanks!I will check it on 0.3.2 release.
8. zhicwu

   closed this as completedon Dec 10, 2021