shuzijun / leetcode-editor

Do Leetcode exercises in IDE, support leetcode.com and leetcode-cn.com, to meet the basic needs of doing exercises.Support theoretically: IntelliJ IDEA PhpStorm WebStorm PyCharm RubyMine AppCode CLion GoLand DataGrip Rider MPS Android Studio
https://plugins.jetbrains.com/plugin/12132-leetcode-editor
Apache License 2.0
3.74k stars 402 forks source link

SQL未格式化导致提交失败 #609

Closed jia9iZhang closed 1 year ago

jia9iZhang commented 1 year ago

Describe the bug Leetcode-183的SQL答案在本地提交控制台报错,在LeetCode官网提交显示成功. > 2022/12/30 14:19:42 运行失败: Line 1: error: class, interface, enum, or record expected select Customers.Name as 'Customers' ^ Line 1: error: unclosed character literal select Customers.Name as 'Customers' ^ Line 1: error: illegal line end in character literal select Customers.Name as 'Customers' ^ 3 errors

To Reproduce Steps to reproduce the behavior:

  1. 打开SQL提
  2. 输入SQL回答 select Customers.Name as 'Customers' from Customers where Customers.Id not in ( select CustomerId from Orders)
  3. 点击运行按钮
  4. 控制台提示报错: > 2022/12/30 14:19:42 运行失败: Line 1: error: class, interface, enum, or record expected select Customers.Name as 'Customers' ^ Line 1: error: unclosed character literal select Customers.Name as 'Customers' ^ Line 1: error: illegal line end in character literal select Customers.Name as 'Customers' ^ 3 errors image

Software versions(Help -> About)

shuzijun commented 1 year ago

代码里应该提示了//There is no code of Go type for this problem 如果要提交其他类型的代码,需要先在配置里修改代码类型

jia9iZhang commented 1 year ago

是的 需要先配置代码类型