Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

after closing parentheses parsing bug #447

Open
sangho-shin opened this issue Oct 30, 2023 · 0 comments
Open

after closing parentheses parsing bug #447

sangho-shin opened this issue Oct 30, 2023 · 0 comments

Comments

@sangho-shin
Copy link

sangho-shin commented Oct 30, 2023

  1. expected table, result where column
 select 		
		a.pt_dept_cd
		,a.sts_cls
		,a.pt_no
  from
		manst a,
		(
		select
			  rcd_id,
			  max(release_number)  release_number
		from
			  manst
		where
				 pt_no       = :p1
		  and    rcd_patt_id = :p2
		) b,
		manst c,
		typmt d,
		reqst e

result
tables = ["manst"]
columns_dict = {'select': ['manst.pt_dept_cd', 'manst.sts_cls', 'manst.pt_no', 'rcd_id', 'release_number'], 'where': ['pt_no', 'rcd_patt_id', 'manst', 'c', 'typmt', 'd', 'reqst', 'e', 'rcd_id']}

  1. expected select column, result where column
select a.pt_no
	   ,b.pt_name
	   ,(select dept_name
		   from depart d
		   where a.dept_cd = d.dept_cd)
		,a.c_no
		,a.cls
from clinmt a,
	 tbamv b

result
columns_dict = {'select': ['clinmt.pt_no', 'tbamv.pt_name', 'dept_name'], 'where': ['clinmt.dept_cd', 'depart.dept_cd', 'clinmt.c_no', 'clinmt.cls']}

maybe after closing parentheses directly previous used keyword

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant