Dear all,
by doing some tests, I found there is a limit to the number of fields used
in GRPOUPING SETS.
For example, in the code below, we can only get null value for key44~key50.
In addition, if we change the order of the keys, we can always get null
value for the last several keys.
Can anyone give some more details about this limit? Thanks!
――――――――――――――――――――――――――――――――――――
SELECT
key1,key2,key3,key4,key5,key6,key7,key8,key9,key10
,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20
,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30
,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40
,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50
FROM table1
GROUP BY
key1,key2,key3,key4,key5,key6,key7,key8,key9,key10
,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20
,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30
,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40
,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50
grouping sets
(
(
key1,key2,key3,key4,key5,key6,key7,key8,key9,key10
,key11,key12,key13,key14,key15,key16,key17,key18,key19,key20
,key21,key22,key23,key24,key25,key26,key27,key28,key29,key30
,key31,key32,key33,key34,key35,key36,key37,key38,key39,key40
,key41,key42,key43,key44,key45,key46,key47,key48,key49,key50
)
)
――――――――――――――――――――――――――――――――
Regards,
孙志禹(Zhiyu Sun)
