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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
