Aug 2, 2022 · Aug 2, 2022
diff --git a/src/sqlParser.jison b/src/sqlParser.jison
 table_factor
  : identifier partitionOpt aliasOpt index_hint_list_opt { $$ = { type: 'TableFactor', value: $1, partition: $2, alias: $3.alias, hasAs: $3.hasAs, indexHintOpt: $4 } }
  | '(' selectClause ')' aliasOpt { $$ = { type: 'TableFactor', value: { type: 'SubQuery', value: $2 }, alias: $4.alias, hasAs: $4.hasAs} }
  | '(' unionClauseNotParenthesized ')' aliasOpt { $$ = { type: 'TableFactor', value: { type: 'SubQuery', value: $2 }, alias: $4.alias, hasAs: $4.hasAs} }
  | '(' table_references ')' { $$ = $2; $$.hasParentheses = true }
  ;
 place_holder
diff --git a/test/main.test.js b/test/main.test.js
  it('test IDENTIFIER', function () {
    testParser('select `aa#sfs`(a) as \'A A\' from z');
  });

  it('test from with union select', function (){
    testParser(`select
    (select min(actividad)
      from
      ( select client_id,
          (select code_description from m_code_value where code_id =61 and id=LActividadEconomica_cd_own_business_main_activity) actividad,
          estimated_amount_income_employer monto
        from m_clientDetalleNegocios
        union all
        select  client_id,
          (select code_description from m_code_value where code_id =47 and id=Ltipoingreso_cd_income_type) actividad , other_incomes_estimated_amount monto
        from m_clientDetalleOtrosIngresos
        union all
        select  client_id, case r.Lsector_cd_Sector when 154 then 755 else 754 end actividad,
        r.estimated_incomes_amount  monto
        from m_clientDetalleRelLaboral r
      )  actividades
      where monto =
      ( select max(monto)
        from
        (
          select client_id,
            (select code_description
            from m_code_value where code_id =61 and id=LActividadEconomica_cd_own_business_main_activity) actividad, estimated_amount_income_employer monto
          from m_clientDetalleNegocios
          union all
          select  client_id,
            (select code_description from m_code_value where code_id =47 and id=Ltipoingreso_cd_income_type) actividad , other_incomes_estimated_amount monto
          from m_clientDetalleOtrosIngresos
          union all
          select  client_id, case r.Lsector_cd_Sector when 154 then 755 else 754 end actividad, r.estimated_incomes_amount  monto
          from m_clientDetalleRelLaboral r
        ) maxact
        where client_id = actividades.client_id
      )
      and client_id =cli.id
    ) as c55017
    from m_client cli`)
  })

 });
Original file line number	Diff line number	Diff line change
Expand Up		@@ -587,6 +587,7 @@ index_hint
		table_factor
		: identifier partitionOpt aliasOpt index_hint_list_opt { $$ = { type: 'TableFactor', value: $1, partition: $2, alias: $3.alias, hasAs: $3.hasAs, indexHintOpt: $4 } }
		\| '(' selectClause ')' aliasOpt { $$ = { type: 'TableFactor', value: { type: 'SubQuery', value: $2 }, alias: $4.alias, hasAs: $4.hasAs} }
		\| '(' unionClauseNotParenthesized ')' aliasOpt { $$ = { type: 'TableFactor', value: { type: 'SubQuery', value: $2 }, alias: $4.alias, hasAs: $4.hasAs} }
		\| '(' table_references ')' { $$ = $2; $$.hasParentheses = true }
		;
		place_holder
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -436,4 +436,45 @@ describe('select grammar support', function () {
		it('test IDENTIFIER', function () {
		testParser('select `aa#sfs`(a) as \'A A\' from z');
		});

		it('test from with union select', function (){
		testParser(`select
		(select min(actividad)
		from
		( select client_id,
		(select code_description from m_code_value where code_id =61 and id=LActividadEconomica_cd_own_business_main_activity) actividad,
		estimated_amount_income_employer monto
		from m_clientDetalleNegocios
		union all
		select client_id,
		(select code_description from m_code_value where code_id =47 and id=Ltipoingreso_cd_income_type) actividad , other_incomes_estimated_amount monto
		from m_clientDetalleOtrosIngresos
		union all
		select client_id, case r.Lsector_cd_Sector when 154 then 755 else 754 end actividad,
		r.estimated_incomes_amount monto
		from m_clientDetalleRelLaboral r
		) actividades
		where monto =
		( select max(monto)
		from
		(
		select client_id,
		(select code_description
		from m_code_value where code_id =61 and id=LActividadEconomica_cd_own_business_main_activity) actividad, estimated_amount_income_employer monto
		from m_clientDetalleNegocios
		union all
		select client_id,
		(select code_description from m_code_value where code_id =47 and id=Ltipoingreso_cd_income_type) actividad , other_incomes_estimated_amount monto
		from m_clientDetalleOtrosIngresos
		union all
		select client_id, case r.Lsector_cd_Sector when 154 then 755 else 754 end actividad, r.estimated_incomes_amount monto
		from m_clientDetalleRelLaboral r
		) maxact
		where client_id = actividades.client_id
		)
		and client_id =cli.id
		) as c55017
		from m_client cli`)
		})

		});