When I use spring boot framework to write spock testing,this is my appliction.yml setting datasource: password: sa url: jdbc:h2:mem:agile_service;DB_CLOSE_DELAY=-1;MODE=Mysql;TRACE_LEVEL_SYSTEM_OUT=2; username: sa [image: image] <https://user-images.githubusercontent.com/20722776/43579673-764c0c6c-9685-11e8-859f-7b2ed7060853.png>
and then I get a error : [image: image] <https://user-images.githubusercontent.com/20722776/43579215-d8353ff4-9683-11e8-99b7-c3776b1ea511.png> So I read h2 document to solve this problem,then I create a ALIAS like this: [image: image] <https://user-images.githubusercontent.com/20722776/43579735-acc78b36-9685-11e8-8f66-f8e561c7fe55.png> this is ifFunction: [image: image] <https://user-images.githubusercontent.com/20722776/43579765-bdde761e-9685-11e8-98e8-60d3ffd23a8e.png> So far I solve this problem.But I discover param、paramTwo and return value may be not Boolean like this: IF(a=1,"a","b") I change param、paramTwo and return value to Object ,but it didn't work and return a conver error [image: image] <https://user-images.githubusercontent.com/20722776/43579578-2a119380-9685-11e8-9e7d-32d819afc686.png> what should I do? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.